64
See all 64 photos
$5,774,000
Est. payment /mo
6 Beds
6.5 Baths
6,362 SqFt
Price Dropped by $250K
15516 N Friant Road Friant, CA 93626
REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.
In-PersonVirtual Tour
UPDATED:
Key Details
Property Type Multi-Family
Sub Type Detached
Listing Status Active
Purchase Type For Sale
Square Footage 6,362 sqft
Price per Sqft $907
MLS Listing ID SC25061273
Bedrooms 6
Full Baths 5
Half Baths 1
Year Built 1997
Property Sub-Type Detached
Property Description
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.
Location
State CA
County Fresno
Zoning AE20
Direction From Friant Rd. and Willow, continue on Friant to property. Private Gate.
Interior
Heating Forced Air Unit
Cooling Central Forced Air
Fireplaces Type Bonus Room, FP in Living Room
Fireplace No
Appliance Dishwasher, Disposal, Microwave, Refrigerator, Gas Range
Exterior
Garage Spaces 14.0
Pool Private
View Y/N Yes
Water Access Desc Private
View Lake/River, Pasture, Bluff
Building
Story 1
Sewer Unknown
Water Private
Level or Stories 1
Others
Tax ID 30031045S
Special Listing Condition Standard
Listed by Sarah Hedrick Realty Concepts, Ltd