$5,774,000
$251K PRICE DROP

15516 N Friant Rd Friant, CA 93626

Estimated payment $32,369/month

Total Views 16,685
6 Beds
5.5 Baths
6,362 Sq Ft
$908 Price per Sq Ft

Highlights

  • Private Pool
  • River View
  • Fireplace in Primary Bedroom
  • Liberty Elementary School Rated A
  • 7.26 Acre Lot
  • Hydromassage or Jetted Bathtub

About This Home

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.

Listing Agent

Sarah Hedrick

Realty Concepts, Ltd Brokerage Email: SarahHedrickRealtor@gmail.com License #01371742 Listed on: 03/20/2025

Realty Concepts, Ltd

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $11,623

Year Built

  • Built in 1997

Lot Details

  • 7.26 Acre Lot
  • Sprinkler System
  • Property is zoned AE20

Parking

  • 14 Car Attached Garage

Property Views

  • River
  • Bluff
  • Pasture

Interior Spaces

  • 6,362 Sq Ft Home
  • 1-Story Property
  • Great Room
  • Family Room
  • Living Room with Fireplace
  • Home Office
  • Bonus Room with Fireplace
  • Game Room
  • Laundry Room

Kitchen

  • Built-In Range
  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 6 Main Level Bedrooms
  • Fireplace in Primary Bedroom
  • Hydromassage or Jetted Bathtub
  • Separate Shower

Utilities

  • Central Heating and Cooling System
  • Private Water Source
  • Septic Type Unknown

Additional Features

  • Private Pool
  • Pasture

Community Details

  • No Home Owners Association
  • Foothills

Listing and Financial Details

  • Tax Lot D
  • Assessor Parcel Number 30031045S

Home Details

Home Type

Single Family

Est. Annual Taxes

$11,623

Year Built

Built in 1997

Lot Details

0

Parking

14

Listing Details

  • Structure Type: House
  • Assessments: Yes
  • Property Attached: No
  • View: Yes
  • Zoning: AE20
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Parcel Number: 30031045S
  • Year Built: 1997
  • Special Features: None

Interior Features

  • Fireplace: Yes
  • Living Area: 6362.00 Square Feet
  • Stories: 1
  • Entry Location: front
  • Common Walls: No Common Walls
  • Appliances: Yes
  • Full Bathrooms: 5
  • Full And Three Quarter Bathrooms: 5
  • Half Bathrooms: 1
  • Total Bedrooms: 6
  • Entry Level: 1
  • Fireplace Features: Bonus Room, Living Room, Primary Bedroom
  • Levels: One
  • Main Level Bathrooms: 5
  • Main Level Bedrooms: 6
  • Price Per Square Foot: 907.58
  • Room Type: Den, Family Room, Game Room, Great Room, Office
  • Bathroom Features: Jetted Tub, Separate Tub And Shower

Exterior Features

  • View: Bluff, Pasture, River
  • Pool Features: Private
  • Pool Private: Yes

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 14.00
  • Total Parking Spaces: 14.00

Utilities

  • Sprinklers: Yes
  • Heating: Yes
  • Laundry: Yes
  • Appliances: Built-In Range, Dishwasher, Disposal, Gas Range, Microwave, Refrigerator
  • Heating Type: Central
  • Laundry Features: Individual Room, Inside
  • Sewer: Septic Type Unknown
  • Water Source: Private
  • Cooling: Central Air
  • Cooling: Yes

Condo/Co-op/Association

  • Association: No
  • Senior Community: No
  • Community Features: Foothills

Schools

  • School District: Clovis Unified

Lot Info

  • Additional Parcels: No
  • Land Lease: No
  • Lot Features: Bluff, Pasture, Sprinkler System
  • Lot Size Sq Ft: 316160.00
  • Lot Size Acres: 7.2580

Multi Family

  • Lease Considered: No
  • Lot Size Area: 316160.0000 Square Feet
  • Number Of Units Total: 2

Tax Info

  • Tax Census Tract: 55.15
  • Tax Lot: D

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $11,623 $1,015,503 $223,982 $791,521
2023 $11,399 $976,072 $215,286 $760,786
2022 $11,245 $956,934 $211,065 $745,869
2021 $10,927 $938,172 $206,927 $731,245
2020 $10,884 $928,553 $204,806 $723,747
2019 $10,670 $910,347 $200,791 $709,556
2018 $10,434 $892,498 $196,854 $695,644
2017 $10,253 $874,999 $192,995 $682,004
2016 $9,902 $857,843 $189,211 $668,632
2015 $9,749 $844,958 $186,369 $658,589
2014 $9,566 $828,408 $182,719 $645,689
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/03/2025 06/03/25 Price Changed $5,774,000 -4.2% $908 / Sq Ft
03/20/2025 03/20/25 For Sale $6,024,500 -- $947 / Sq Ft
Source: California Regional Multiple Listing Service (CRMLS)

Purchase History

Date Type Sale Price Title Company
Interfamily Deed Transfer -- Chicago Title Company
Interfamily Deed Transfer -- Chicago Title Company
Interfamily Deed Transfer -- --
Interfamily Deed Transfer -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Closed $750,000 New Conventional
Closed $300,000 New Conventional
Closed $605,000 Credit Line Revolving
Closed $550,000 Unknown
Closed $500,000 Credit Line Revolving
Closed $558,000 Credit Line Revolving
Closed $322,000 Unknown
Closed $250,000 Credit Line Revolving
Closed $400,000 Unknown
Source: Public Records

Source: California Regional Multiple Listing Service (CRMLS)

MLS Number: SC25061273

California Regional Multiple Listing Service (CRMLS)

APN: 300-310-45S