Sold for $3,300,000 on 12/19/25
$3,300,000
15624 N Friant Rd, Friant, CA 93626
5beds
6baths
6,501sqft
Residential, Single Family Residence
Built in 2023
2.48 Acres Lot
$3,300,200 Zestimate®
$508/sqft
$7,436 Estimated rent
Home value
$3,300,200
$3.04M - $3.60M
$7,436/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Perched above the San Joaquin River with sweeping views of the Tabletop Mountains, this 2023 custom build by Cornerstone Homes offers one of the most breathtaking settings in the Central Valley. Set on 2.5 gated acres, the 6,501-square-foot residence delivers seclusion and sophistication all within 5 minutes from Copper River. The architecture speaks of timeless beauty. White stucco walls, arched entryways, and wrought-iron accents reflect Santa Barbara style, while soaring 15-foot ceilings and artisan details define the interior. A reclaimed wood ceiling over a century old sourced from a California mission adds history and warmth, complemented by hand-stained moldings, handcrafted tile, and European oak floors throughout. This residence is more than custom it is truly one of a kind. Open, light-filled spaces flow seamlessly, with the family room, kitchen, and dining areas framed by graceful arches. A 20-foot sliding glass wall and expansive windows capture river and mountain views. The main kitchen is a culinary showpiece with Wolf appliances, custom cabinetry, quartzite surfaces, and masonry stone accents. A secondary kitchen with reclaimed wood shelving ensures effortless entertaining, while a masonry stone-framed wine cellar holds 270 bottles. Additional living spaces include a paneled study, an expansive game room with panoramic windows, and a six-car garage. Five en-suite bedrooms provide private retreats with spa-inspired baths the primary suite opening directly to the backyard oasis. Two powder rooms add guest convenience. The pool and heated spa overlook sunsets, the river, and the mountains. Expansive patios and a quartzite outdoor kitchen make gatherings effortless, while date palms, olive trees, and landscaping complete the Santa Barbara aesthetic. The home is built for today: Savant smart automation, whole-home audio, motorized shades, advanced insulation, and a 12.5 kWh owned solar array for net-zero energy. Though serene and private, the estate is minutes from Copper River. Families enjoy Clovis Unified schools, food lovers savor local dining, and outdoor enthusiasts explore nearby trails, lakes, and golf courses. State-owned land protects the setting ensuring views remain forever unobstructed.This estate is for the discerning buyer someone who values design, privacy, and the ability to entertain and retreat.With commanding views, timeless architecture,and resort-style amenities,it is more than a home it isCalifornia living, reimagined.
Zillow last checked: 8 hours ago
Listing updated: December 19, 2025 at 10:01am
Listed by:
Jason Brar DRE #02057202 559-301-6462,
CORNERSTONE REAL ESTATE
Bought with:
Sarah Hedrick, DRE #01371742
Realty Concepts, Ltd. - Fresno
Source: Fresno MLS,MLS#: 637839Originating MLS: Fresno MLS
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- 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
Dining room
- Area: 0
- Dimensions: 0 x 0
Family room
- Area: 0
- Dimensions: 0 x 0
Kitchen
- Area: 0
- Dimensions: 0 x 0
Living room
- Area: 0
- Dimensions: 0 x 0
Basement
- Area: 0
Heating
- Has Heating (Unspecified Type)
Cooling
- Central Air
Appliances
- Laundry: Inside, Gas Dryer Hookup, Electric Dryer Hookup
Features
- Flooring: Tile, Hardwood
- Number of fireplaces: 1
- Fireplace features: Gas
Interior area
- Total structure area: 6,501
- Total interior livable area: 6,501 sqft
Property
Parking
- Total spaces: 6
- Parking features: Garage - Attached
- Attached garage spaces: 6
Features
- Levels: One
- Stories: 1
- Has private pool: Yes
- Pool features: Pebble, Private, In Ground
- Spa features: In Ground
- Has view: Yes
- View description: Bluff View
Lot
- Size: 2.48 Acres
- Dimensions: 200 x 540
- Features: Rural
Details
- Parcel number: 30031044S
- Zoning: A1
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Spanish
- Property subtype: Residential, Single Family Residence
Materials
- Stucco
- Foundation: Concrete
- Roof: Tile
Condition
- Year built: 2023
Details
- Builder name: Cornerstone Homes
Utilities & green energy
- Sewer: Septic Tank
- Water: Private
- Utilities for property: Public Utilities, Propane
Green energy
- Energy generation: Solar
Community & neighborhood
Location
- Region: Friant
HOA & financial
Other financial information
- Total actual rent: 0
Other
Other facts
- Listing agreement: Exclusive Right To Sell
Price history
| Date | Event | Price |
|---|---|---|
| 12/19/2025 | Sold | $3,300,000-8.3%$508/sqft |
Source: Fresno MLS #637839 Report a problem | ||
| 11/29/2025 | Pending sale | $3,600,000$554/sqft |
Source: Fresno MLS #637839 Report a problem | ||
| 10/2/2025 | Listed for sale | $3,600,000+1700%$554/sqft |
Source: Fresno MLS #637839 Report a problem | ||
| 3/8/2018 | Sold | $200,000+13.6%$31/sqft |
Source: Public Record Report a problem | ||
| 5/7/2004 | Sold | $176,000$27/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $17,727 +2% | $1,515,162 +2% |
| 2024 | $17,383 +67.7% | $1,485,453 +579.1% |
| 2023 | $10,365 +308.3% | $218,727 +2% |
Find assessor info on the county website
Neighborhood: 93626
Nearby schools
GreatSchools rating
- 8/10Valley Oak Elementary SchoolGrades: K-6Distance: 6.6 mi
- 7/10Kastner Intermediate SchoolGrades: 7-8Distance: 8.4 mi
- 9/10Clovis West High SchoolGrades: 9-12Distance: 7.5 mi
Schools provided by the listing agent
- Elementary: Valley Oak
- 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.

