65
See all 65 photos
$5,774,000
Est. payment /mo
6 Beds
6,362 SqFt
Price Dropped by $250K
15516 N Friant RD 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 advisor will contact you to discuss available opportunities.
In-PersonVirtual Tour
UPDATED:
Key Details
Property Type Commercial
Sub Type Commercial
Listing Status Active
Purchase Type For Sale
Square Footage 6,362 sqft
Price per Sqft $907
MLS Listing ID 631539
Bedrooms 6
Full Baths 5
HOA Y/N No
Year Built 1997
Lot Size 6.440 Acres
Property Sub-Type Commercial
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
Interior
Cooling Central Heat/Cool
Exterior
Parking Features 10 - 20 Spaces
Roof Type Other
Building
Sewer Septic Tank
Water Private, Well
Listed by Sarah Hedrick Realty Concepts, Ltd. - Fresno