Listed by Cathy Freeman•DRE #01724853• Cathy Freeman & Co.
Listed by Matthew Connell•DRE #02009491• Cathy Freeman & Co.
Contact: 559-246-4824
For sale
$1,950,000
Est. $13,096/mo —
4
bd
•
3 ba
•
3,230
sq ft
15640 N Friant, Friant, CA 93626
This home is popular
It's in the top 10% of views. Tour it before it's gone!
Tomorrow:
About this home
Spectacular views!!! Serenity and Beauty accompany this Exquisitely Landscaped Custom Image Home perched upon 3.09 Acres of Prime Bluff Property. Immaculately kept, this Estate offers your own private Oasis recently renovated to include a beautiful large pebble tech pool, inground spa, water features, firepit, with gorgeous grounds to include an abundance of stone, stamped concrete and lighting. The expansive kitchen is a Chef's dream perfect for entertaining with dual ovens, dual dishwashers and an expansive breakfast counter. Master Suite with fireplace, en-suite bath, Jacuzzi tub, his/hers closets and a large walk thru shower. OWNED SOLAR with 2 zone HVAC system. An enormous Bonus Room with wet bar and wine refrigerator. The possibility for generational living with an Isolated bedroom and bathroom. California custom closets, roller shades with remote control, newer lighting/bath fixtures, crown moldings and designer paint throughout. Extensive fencing, RV parking, fruit trees and a raised garden. Enjoy the Magical Sunsets Unveiling Panoramic Views of the San Joaquin River Valley and Tabletop Vistas. Just minutes to River Park shopping center with numerous shops and restaurants or Millerton Lake recreational area. Schedule your private tour today!
Spectacular views!!! Serenity and Beauty accompany this Exquisitely Landscaped Custom Image Home perched upon 3.09 Acres of Prime Bluff Property. Immaculately kept, this Estate offers your own private Oasis recently renovated to include a beautiful large pebble tech pool, inground spa, water features, firepit, with gorgeous grounds to include an abundance of stone, stamped concrete and lighting. The expansive kitchen is a Chef's dream perfect for entertaining with dual ovens, dual dishwashers and an expansive breakfast counter. Master Suite with fireplace, en-suite bath, Jacuzzi tub, his/hers closets and a large walk thru shower. OWNED SOLAR with 2 zone HVAC system. An enormous Bonus Room with wet bar and wine refrigerator. The possibility for generational living with an Isolated bedroom and bathroom. California custom closets, roller shades with remote control, newer lighting/bath fixtures, crown moldings and designer paint throughout. Extensive fencing, RV parking, fruit trees and a raised garden. Enjoy the Magical Sunsets Unveiling Panoramic Views of the San Joaquin River Valley and Tabletop Vistas. Just minutes to River Park shopping center with numerous shops and restaurants or Millerton Lake recreational area. Schedule your private tour today!
FRESNOMLS #499692
Jun 18, 2018
Sold
$995,000
$308/sq ft
May 16, 2018
Pending
—
Mar 29, 2018
Listed
$995,000
$308/sq ft
+59
Shangri-La does Exist! An Exquisitely Landscaped 4 Bd, 3 ba, 4 Car Custom Image Home perched on 3.09 Acres of Prime Bluff Property in the highly sought after CUSD! Immaculately kept, the 3230sf Estate offers many amenities: Chef's Kitchen w/Granite/Gas App., a Master Suite w Frplc, En-Suite Bath w/Jacuzzi tub, his/hers closets and massive walk thru shower! A huge 24x16 Bonus Room w/Wetbar overlooks unique, tropical gardens surrounding a 42x42 Salt H2O Pool w/Tiki Bar. Extensive Stamped Patios/Walkway, Designer Paint/Window Coverings/Cen.Vac, In/Out Sound Sys, Rear Window Sun Shades, Remote Awning, 6Crown, 2-Zone HVAC and even OWNED SOLAR! Mom-in-Law possibilities. Notice the Extensive Fencing, RV parking, Finished 3 Car Garage (1 bay drive-thru) and Shed.Sip your Pina Colada, and Enjoy the Unfolding of Magical Sunsets Showcasing your Private, Panoramic View of the San Joaquin River Valley and Endless Table Top Vistas.Just mins. to River Park or Millerton Lake for Family Fun! Appt Only
Greater Lansing AoR #FR18085400
Jun 18, 2018
Sold
$995,000
$308/sq ft
Jun 18, 2018
Sold
$995,000
$308/sq ft
May 16, 2018
Contingent
—
Mar 29, 2018
Listed
$995,000
$308/sq ft
Mar 29, 2018
Listed
$995,000
$308/sq ft
CRMLS #FR17151097
Dec 2, 2017
Listing Removed
—
Sep 19, 2017
Price Changed
$995,000
$308/sq ft
Jul 3, 2017
Listed
$1,049,000
$325/sq ft
FRESNOMLS #1
Sep 18, 2017
Price Changed
$995,000
$308/sq ft
Jun 12, 2017
Price Changed
$1,049,000
$325/sq ft
CRMLS #MD15066826
Dec 28, 2015
Listing Removed
—
Mar 31, 2015
Listed
$999,999
$310/sq ft
FRESNOMLS #442173
Mar 31, 2015
Listed
$999,999
$310/sq ft
Public Records
Dec 10, 2002
Sold
$175,000
$54/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$13,307 (+2.0%)
$341,347 + $790,789
$1,132,136
2024
$13,050 (+2.0%)
$341,347 + $790,789
$1,132,136
2023
$12,800 (+1.4%)
$334,654 + $775,284
$1,109,938
2022
$12,629 (+2.9%)
$328,093 + $760,083
$1,088,176
2021
$12,273 (+0.4%)
$321,660 + $745,180
$1,066,840
2020
$12,226 (+2.0%)
$315,353 + $730,569
$1,045,922
2019
$11,987 (+62.7%)
$312,120 + $723,078
$1,035,198
2018
$7,369 (−10.0%)
$306,000 + $708,900
$1,014,900
2017
$8,186 (+43.5%)
$181,532 + $325,577
$507,109
2016
$5,704 (+1.6%)
$181,532 + $325,577
$507,109
2015
$5,615 (+6.8%)
$177,973 + $319,194
$497,167
2014
$5,259
$164,200 + $294,400
$458,600
Public record
Public record
Zoning
Beds
4
Baths
4
Stories
1
Lot width
—
Lot depth
—
Lot size
3.09 Acres
Year renovated
2004
Finished Sq. Ft.
3,230
Unfinished Sq. Ft.
—
Total Sq. Ft.
3,230
Year built
2004
Style
Single Family Residential
County
Fresno County
APN
30031043S
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 13, 2026.
AE20
Exclusive Agricultural Zone 20 Acres
The AE zone is intended to protect agricultural land and provide for those uses which are necessary and an integral part of an agricultural operation. This zone is intended to protect the general welfare of the agricultural community from encroachments of non-related agricultural uses. The AE zone shall be accompanied by an acreage designation which establishes the minimum size of parcels that may be created within the zone, including designations of 20 acres. The AE zone is consistent with the Agriculture, Irrigated Agriculture, and Westside/Eastside Rangeland land use designations of the General Plan.
Permitted uses
Include but are not limited to:
Greenhouse / nursery
Winery & vineyard
Agriculture-Other
Housing-Single unit
Processing
Kennel
Agriculture-Cropland
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
8/10 Fire Factor
27% chance of being in a wildfire in next 30 years
8/10 Heat Factor
7 days above 108° expected this year, 17 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
10/10 Air Factor
61 unhealthy days expected this year, 69 days in 30 years
Provided by First Street
Historical weather
Friant, CA • 93626
Average low and high temperatures (°F)
60
42
64
46
71
50
73
51
84
57
94
64
97
67
98
67
92
65
81
57
64
49
57
45
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
96/ 100
Exceptional sunlight
Sunscore
This home ranks in the top 13% for direct sun exposure in Friant. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
11.5 hrs
7.4 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 15640 N Friant
$1,892,653
$57K under list price of $1.95M
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $532K to $790K.