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.<span style=font-size: 10pt;=>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.</span>
For sale
$4,500,000
15516 N Friant Rd, Friant, CA 93626
6beds
6baths
6,362sqft
Est.:
Residential, Single Family Residence
Built in 1997
6.44 Acres Lot
$4,020,300 Zestimate®
$707/sqft
$-- HOA
What's special
Outdoor fireplaceDog-friendly yardSubzero fridgePutting greenIn-ground jacuzziMini wine fridgeCustom cabinetry
- 125 days |
- 1,882 |
- 57 |
Zillow last checked: 8 hours ago
Listing updated: February 03, 2026 at 02:10pm
Listed by:
Sarah Hedrick DRE #01371742 559-681-2111,
Realty Concepts, Ltd. - Fresno
Source: Fresno MLS,MLS#: 639256Originating MLS: Fresno MLS
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 6
Primary bedroom
- Area: 0
- Dimensions: 0 x 0
Bedroom 1
- Area: 0
- Dimensions: 0 x 0
Bedroom 2
- Area: 0
- Dimensions: 0 x 0
Bedroom 3
- Area: 0
- Dimensions: 0 x 0
Bedroom 4
- Area: 0
- Dimensions: 0 x 0
Bathroom
- Features: Tub/Shower, Shower
Dining room
- Features: Formal
- Area: 0
- Dimensions: 0 x 0
Family room
- Area: 0
- Dimensions: 0 x 0
Kitchen
- Features: Other
- Area: 0
- Dimensions: 0 x 0
Living room
- Area: 0
- Dimensions: 0 x 0
Basement
- Area: 0
Heating
- Ductless or Split
Cooling
- Central Air, Ductless or Split
Appliances
- Included: Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Refrigerator, Wine Refrigerator
- Laundry: Inside, Utility Room
Features
- Isolated Bedroom, Isolated Bathroom, Built-in Features, Great Room, Office, Family Room, Den/Study, Game Room, Wine Room
- Flooring: Tile
- Windows: Double Pane Windows
- Number of fireplaces: 5
Interior area
- Total structure area: 6,362
- Total interior livable area: 6,362 sqft
Property
Parking
- Total spaces: 14
- Parking features: RV Access/Parking, Work/Shop Area, Garage Door Opener, Circular Driveway
- Attached garage spaces: 14
- Has uncovered spaces: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered
- Exterior features: Tennis Court(s)
- Has private pool: Yes
- Pool features: Private, In Ground
- Spa features: Bath, In Ground
- Fencing: Fenced
- Has view: Yes
- View description: Bluff View
Lot
- Size: 6.44 Acres
- Dimensions: 320 x 988
- Features: Rural, Pasture, Horses Allowed, Sprinklers In Front, Sprinklers In Rear, Sprinklers Auto, Mature Landscape, Garden, Drip System
Details
- Additional structures: Workshop, Shed(s)
- Parcel number: 30031045S
- Zoning: A1
- Horses can be raised: Yes
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Residential, Single Family Residence
Materials
- Stucco
- Foundation: Concrete
- Roof: Other
Condition
- Year built: 1997
Utilities & green energy
- Electric: Electric Meter
- Gas: Gas Meter
- Sewer: Septic Tank
- Water: Private
- Utilities for property: Public Utilities, Propane
Green energy
- Energy generation: Solar
Community & HOA
Community
- Security: Security System
Location
- Region: Friant
Financial & listing details
- Price per square foot: $707/sqft
- Tax assessed value: $1,015,503
- Annual tax amount: $11,854
- Date on market: 10/30/2025
- Cumulative days on market: 309 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Conventional,Cash,Owner May Carry
- Total actual rent: 0
Estimated market value
$4,020,300
$3.78M - $4.22M
$6,855/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 10/31/2025 | Listed for sale | $4,500,000-22.1%$707/sqft |
Source: Fresno MLS #639256 Report a problem | ||
| 9/14/2025 | Listing removed | $5,774,000+11%$908/sqft |
Source:  SDMLS #SC25061273 Report a problem | ||
| 8/19/2025 | Price change | $5,200,000-9.9%$817/sqft |
Source: Fresno MLS #626185 Report a problem | ||
| 6/5/2025 | Price change | $5,774,000-4.2%$908/sqft |
Source: Fresno MLS #626185 Report a problem | ||
| 3/14/2025 | Listed for sale | $6,024,500$947/sqft |
Source: Fresno MLS #626185 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $11,854 +2% | $1,015,503 +2% |
| 2024 | $11,623 +2% | $995,592 +2% |
| 2023 | $11,399 +1.4% | $976,072 +2% |
| 2022 | $11,245 +2.9% | $956,934 +2% |
| 2021 | $10,927 +0.4% | $938,172 +1% |
| 2020 | $10,884 +2% | $928,553 +2% |
| 2019 | $10,670 +2.3% | $910,347 +2% |
| 2018 | $10,434 +1.8% | $892,498 +2% |
| 2017 | $10,253 +3.5% | $874,999 +2% |
| 2016 | $9,902 +1.6% | $857,843 +1.5% |
| 2015 | $9,749 +1.9% | $844,958 +2% |
| 2014 | $9,566 | $828,408 +0.5% |
| 2013 | -- | $824,665 +2% |
| 2012 | -- | $808,496 +2% |
| 2011 | -- | $792,644 +14.1% |
| 2010 | -- | $694,643 -0.2% |
| 2009 | -- | $696,294 +5.8% |
| 2008 | -- | $658,356 +2% |
| 2007 | -- | $645,448 +2% |
| 2006 | -- | $632,793 +2% |
| 2005 | -- | $620,386 +2% |
| 2004 | -- | $608,222 +1.9% |
| 2003 | -- | $597,075 +2% |
| 2002 | -- | $585,369 +2% |
| 2001 | $6,789 | $573,892 |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$26,934/mo
Principal & interest
$22396
Property taxes
$4538
Climate risks
Neighborhood: 93626
Nearby schools
GreatSchools rating
- 8/10Valley Oak Elementary SchoolGrades: K-6Distance: 6.6 mi
- 8/10Kastner Intermediate SchoolGrades: 7-8Distance: 8.3 mi
- 9/10Clovis West High SchoolGrades: 9-12Distance: 7.4 mi
Schools provided by the listing agent
- Elementary: Liberty
- Middle: Kastner
- High: Clovis West
Source: Fresno MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Local experts in 93626
