There are good homes, great homes, and then there's the extraordinary. Perched atop an elevated six-acre bluff, the home captures breathtaking 360-degree views---river, mountain, and valley vistas on one side, and sweeping pasture on the other. A living canvas that evolves with every hour. Spanning approx. 5,300sf, this expansive single-story features 4 bedrooms, 4 baths, plus two detached one-bedroom guest suites---ideal for multi-generational living or private accommodations. The primary suite is a true retreat with stunning views, a spa-inspired bath, spa tub, walk-in shower, dual vanities, and generous closets. Throughout the house, rich Saltillo tile and handcrafted woodwork create warmth and timeless character. The open layout flows between living room, oversized family room, and a chef's kitchen with a six-burner Wolf range, triple ovens, warming drawer, Sub-Zero refrigeration, freezer drawers, and dual copper sinks. Designed for both entertaining and everyday comfort, the home also includes a sunken sitting room, media room, and a large laundry room with additional Sub-Zero fridge. An elevator leads to a 3000sf 14-car underground garage and 1,600-bottle, temp.-controlled wine cellar with tasting area. Thoughtfully concealed, the garage maintains the estate's pristine aesthetic while offering seamless access. Resort-style grounds feature a pool, outdoor living spaces, built-in BBQ, lighted tennis court, sport court, putting green, and rooftop deck. A private helipad offers effortless access to business, entertainment, and nearby coastal and national park destinations. Bed, bath, and sq. ft is different than tax records, if important, buyer to verify.
For sale
$3,995,000
15516 N Friant Rd, Friant, CA 93626
6beds
6baths
6,363sqft
Residential, Single Family Residence
Built in 1997
6.44 Acres Lot
$3,622,100 Zestimate®
$628/sqft
$-- HOA
What's special
- 158 days
- 952
- 50
Zillow last checked:
Listing updated:
Listed by:
Joe Sciarrone DRE #01509897 559-269-9413,
London Properties, Ltd.
Source: Fresno MLS,MLS#: 647302Originating MLS: Fresno MLS
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: Pantry
- Area: 0
- Dimensions: 0 x 0
Living room
- Area: 0
- Dimensions: 0 x 0
Basement
- Area: 3000
Heating
- Has Heating (Unspecified Type)
Cooling
- Central Air
Appliances
- Included: Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Refrigerator, Wine Refrigerator
- Laundry: Inside, Utility Room
Features
- Isolated Bedroom, Isolated Bathroom, Built-in Features, Wine Room
- Flooring: Tile
- Windows: Double Pane Windows
- Number of fireplaces: 5
- Fireplace features: Masonry, Gas
Interior area
- Total structure area: 6,363
- Total interior livable area: 6,363 sqft
Video & virtual tour
Property
Parking
- Total spaces: 14
- Parking features: Potential RV 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, Concrete
- Exterior features: Tennis Court(s)
- Has private pool: Yes
- Pool features: Gunite, Private, In Ground
- Has spa: Yes
- Spa features: In Ground
- Fencing: Cross Fenced,Fenced
- Has view: Yes
- View description: Bluff View
Lot
- Size: 6.44 Acres
- Features: Urban, Pasture, Sprinklers In Front, Sprinklers In Rear, Sprinklers Auto, Mature Landscape
Details
- Additional structures: Workshop, Shed(s), Other, Accessory Dwelling Unit
- Parcel number: 30031045S
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Spanish
- Property subtype: Residential, Single Family Residence
Materials
- Stucco
- Foundation: Concrete
- Roof: Tile
Condition
- Year built: 1997
Utilities & green energy
- Electric: No Electric Meter, On
- Gas: No Gas Meter
- Sewer: Septic Tank
- Water: Private
- Utilities for property: Propane
Green energy
- Energy generation: Solar
Community & HOA
Community
- Security: Security System, Security Gate
Location
- Region: Friant
Financial & listing details
- Price per square foot: $628/sqft
- Tax assessed value: $1,035,812
- Date on market: 4/16/2026
- Cumulative days on market: 476 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Government,Conventional,Cash
Estimated market value
$3,622,100
$3.44M - $3.80M
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 5/8/2026 | Price change | $3,995,000-11.2%$628/sqft |
Source: Fresno MLS #647302 Report a problem | ||
| 4/17/2026 | Listed for sale | $4,500,000$707/sqft |
Source: Fresno MLS #647302 Report a problem | ||
| 3/13/2026 | Listing removed | $4,500,000$707/sqft |
Source: Fresno MLS #639256 Report a problem | ||
| 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%$907/sqft |
Source: | ||
| 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%$907/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
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | -- | $1,035,812 +2% |
| 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
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 93626
Nearby schools
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.






