Skip main navigation
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

    List your home for rent

    $7,436/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $7,436/mo

    Rent Zestimate®

    Refinance and save

    $20,751/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $20,751/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    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

    DateEventPrice
    12/19/2025Sold$3,300,000-8.3%$508/sqft
    Source: Fresno MLS #637839 Report a problem
    11/29/2025Pending sale$3,600,000$554/sqft
    Source: Fresno MLS #637839 Report a problem
    10/2/2025Listed for sale$3,600,000+1700%$554/sqft
    Source: Fresno MLS #637839 Report a problem
    3/8/2018Sold$200,000+13.6%$31/sqft
    Source: Public Record Report a problem
    5/7/2004Sold$176,000$27/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax 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
    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.