See all 64 photos

$5,774,000

Est. payment - /mo

Save

6 Beds

6 Baths

6,362 SqFt

Price Dropped by $250K

15516 N Friant RD Friant, CA 93626

Save

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

Sun

Jun

Mon

Jun

Tue

Jul

Chris Mardelli

Upside

chris@therealupside.com +1(310) 571-5761

UPDATED:

Key Details

Property Type Single Family Home

Sub Type Single Family Residence

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

HOA Y/N No

Year Built 1997

Lot Size 7.258 Acres

Property Sub-Type Single Family Residence

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

Rooms

Main Level Bedrooms 6

Interior

Heating Central

Cooling Central Air

Fireplaces Type Bonus Room, Living Room, Primary Bedroom

Fireplace Yes

Appliance Built-In Range, Dishwasher, Disposal, Gas Range, Microwave, Refrigerator

Laundry Inside, Laundry Room

Exterior

Garage Spaces 14.0

Garage Description 14.0

Pool Private

Community Features Foothills

View Y/N Yes

View Bluff, Pasture, River

Total Parking Spaces 14

Private Pool Yes

Building

Lot Description Bluff, Pasture, Sprinkler System

Dwelling Type House

Story 1

Entry Level One

Sewer Septic Type Unknown

Water Private

Level or Stories One

New Construction No

Schools

School District Clovis Unified

Others

Senior Community No

Tax ID 30031045S

Acceptable Financing Cash, Conventional, Owner May Carry

Listing Terms Cash, Conventional, Owner May Carry

Special Listing Condition Standard

Listed by Sarah Hedrick Realty Concepts, Ltd SarahHedrickRealtor@gmail.com

Quick Search Links

There are 32 quick searches