Features & Amenities

Interior

  • Total Bedrooms

    6

  • Bathrooms

    5

  • 1/2 Bathrooms

    1

  • Cooling YN

    YES

  • Cooling

    N/A

  • Fireplace YN

    YES

  • Heating YN

    YES

  • Heating

    Central

  • Main Level Bedrooms

    6

Exterior

  • Garage

    Yes

  • Garage spaces

    14

  • Parking

    Attached

  • Pool

    Yes

  • Pool Features

    Private

  • View

    Pasture, River

Area & Lot

  • Lot Features

    Bluff, Pasture

  • Lot Size(acres)

    7.258

  • Property Type

    Residential

  • Property Sub Type

    Single Family Residence

Price

  • Sales Price

    $5,774,000

  • Sq. Footage

    6, 362

  • Price/SqFt

    $907

HOA

  • Association

    NO

School District

  • Elementary School

    N/A

  • Middle School

    N/A

  • High School

    N/A

Property Features

  • Stories

    1

  • Senior Community YN

    NO

  • Sewer

    Septic Tank

Schedule a Showing

Showing scheduled successfully.

<
>
IN PERSON
VIA CHAT

Change time

Mortgage calculator

Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.

Your payment

Principal and Interest:

$

Property taxes:

$

HOA fees:

$

Total loan payment:

$

Total interest amount:

$

Location

County

Fresno

Elementary School

Middle School

High School

Listing Courtesy of Sarah Hedrick , Realty Concepts, Ltd

RealHub Information is provided exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RealHub website owner shall not be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

Agent LinaMirza

FOUNDER

LinaMirza

Call Lina today to schedule a private showing.


* Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request.© 2024 FMLS.
This extraordinary estate offers 360-degree views of Table Mountain, Sierra foothills, Friant Dam, & the San Joaquin Valley. A masterpiece of craftsmanship, it blends timeless finishes w/refined architectural detail. Saltillo tile flooring, hand-troweled walls, & soaring ceilings enhance the space. The living room features a gas fireplace, custom cabinetry, & double sliders opening to a resort-style pool. The formal dining rm has a built-in buffet & glass doors leading outside.The chef's kitchen boasts travertine counters, a Wolf range w/six burners, three ovens, a warming drawer, Subzero fridge, dual copper sinks, a mini wine fridge, ice maker, & two pantries. The primary suite offers a fireplace, sauna/steam shower, jetted tub, cedar-lined closets, & double sliders to the outdoors.A flexible living space serves as a soundproofed home theater/office/guest quarters w/courtyard access.A 1,600-bottle wine cellar w/a tasting area is accessible by elevator. The laundry room includes a Subzero fridge/freezer & a dog-friendly yard. The 3,000 sq. ft. garage holds up to 14 vehicles w/additional overhead parking. Amenities include tennis, pickleball, basketball, an in-ground jacuzzi, outdoor fireplace, BBQ, putting green, observation deck, & two independent guest homes w/a gym/shop. Secured by reinforced fencing, the estate also features owned solar, generators, a 5,000-gallon water tank, & a helipad. A rare retreat offering luxury, privacy, & premier amenities.

15516 N Friant Road

Message successfully sent.

What would you like to know?

Related Properties

An unparalleled +/-700-acre property offering a rare combination of stunning natural beauty, multiple residences, and versatile amenities. This remarkable estate comprises three parcels approximately 545 acres, 80 acres, and 75 acres with breathtaking views and diverse terrain.



The primary residence, designed by renowned architect Gene Zellmer, spans approx. 4,100 square feet and showcases stunning views, an infinity pool, and majestic native oak trees surrounding the home. The second home is a spacious +/-1,888-square-foot, 4-bedroom, 2-bathroom residence with a 2-car garage, nestled among oak trees and surrounded by picturesque grazing land. The third home is a charming +/-710-square-foot cottage, complete with a kitchen, bathroom, 2 bedrooms, and living room. Nearby, you'll find a second swimming pool and an approx. 2,420-square-foot barn equipped with its own bathroom, as well as a chicken coop, horse/cattle pens, and a garden.



The property offers captivating views of Millerton Lake from various hilltops and features Cottonwood Creek meandering through its expansive acreage, adding to the tranquil, picturesque setting.



This one-of-a-kind estate is an exceptional opportunity for those seeking privacy, natural beauty, and the ultimate rural lifestyle.
#SC25145378

Friant

19623 Road 211

3 Beds

3 Baths

4,100 Sq.Ft.

$4,950,800

MLS#: SC25145378

 - property

Send a message

Message successfully sent.

Your message

Reason for contacting?

Sign Out

Virtual Assistant

Would you like to receive some additional information on this specific property or similar properties?

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

Already have an account ? Login here