Spectacular San Joaquin River front home. Stunning 180 VIEWs include river, birding pond & never to be developed (conservancy owned) Ledger Island. 4 bdrm 3 bath home which is nestled on 2.5 acres w/approx 300 ft of river front. A masterpiece by noted architect Gene Zelmer merges the natural surroundings around a personal home. Multi-level wood decks which are literally over the river's edge, also provide constant wildlife viewing. A combination of natural & custom landscaping features a pool with a spill-over'' water shelf, natural rock waterfall & spa. Huge walls of glass bringing striking river views into ea. living space of this sanctuary. It features a great room w/a cozy fireplace, redwood walls & cathedral wood beam ceiling giving you the warmth of a fine mountain resort. The master suite has stunning views, 2 closets & hardwood floors. An upstairs loft w/4th bedroom, bathroom & large office. Enjoy the beauty of nature while you're only 10 min away from River Park amenities!
Single-familyProperty Type
1980Year Built
2.5 acresLot Size
$665Est. Price/Sq.Ft.
1 car garageParking
Listed by Nico Gentile•DRE #DRE #01974513• Gentile Real Estate
Bought with Nico Gentile•DRE #DRE #01974513• Gentile Real Estate
Unique Gene Zellmer home in breath-taking location on San Joaquin River w/300 feet of river frontage (8 miles north of River Park,5 minutes to Copper River).Step into this lovely home,you are captured by the views of the river through floor-to-ceiling windows in the living room & kitchen dining area. From the living room & sunroom, step outside onto the patio area that boasts extensive decking with various levels & multiple vantage spots that enable you to enjoy the river & surrounding terrain. This home and property have been well maintained with a new comp roof & exterior paint, new additional decking overlooking the river, custom wrought-iron fence surrounding property w/ automatic gate, extensive landscaping with new sprinkling system, self-contained dog kennel w/automtic watering system & heated floors, bar & wine cabinetry in upstairs loft area, resurfaced heated pool& spa with new pumps & heater. An opportunity to own a well-planned home & property w/San Joaquin River frontage!
FRESNOMLS #229275
Sep 7, 2005
Sold
$925,000
$336/sq ft
Dec 23, 2004
Price Changed
$995,000
$362/sq ft
Dec 23, 2004
Delisted
—
Nov 14, 2004
Listed
$925,000
$336/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$18,311 (+4.8%)
$1,055,370 + $502,533
$1,557,903
2024
$17,468 (+2.0%)
$1,055,370 + $502,533
$1,557,903
2023
$17,133 (+1.4%)
$1,034,677 + $451,013
$1,485,690
2022
$16,905 (+34.4%)
$1,014,390 + $442,170
$1,456,560
2021
$12,579 (+10.6%)
$994,500 + $433,500
$1,428,000
2020
$11,373 (+12.2%)
$606,216 + $373,833
$980,049
2019
$10,134 (+2.3%)
$600,000 + $370,000
$970,000
2018
$9,910 (+5.8%)
$600,000 + $265,000
$865,000
2017
$9,367 (+21.4%)
$476,355 + $207,111
$683,466
2016
$7,716 (+1.6%)
$476,355 + $207,111
$683,466
2015
$7,596 (+3.9%)
$467,015 + $203,050
$670,065
2014
$7,313
$460,000 + $175,000
$635,000
Tax history for 14597 N Friant Rd
Year
Property tax
Land + Additions
Assessment*
2025
$18,311 (+4.8%)
$1,055,370 + $502,533
$1,557,903
2024
$17,468 (+2.0%)
$1,055,370 + $502,533
$1,557,903
2023
$17,133 (+1.4%)
$1,034,677 + $451,013
$1,485,690
2022
$16,905 (+34.4%)
$1,014,390 + $442,170
$1,456,560
2021
$12,579 (+10.6%)
$994,500 + $433,500
$1,428,000
2020
$11,373 (+12.2%)
$606,216 + $373,833
$980,049
2019
$10,134 (+2.3%)
$600,000 + $370,000
$970,000
2018
$9,910 (+5.8%)
$600,000 + $265,000
$865,000
2017
$9,367 (+21.4%)
$476,355 + $207,111
$683,466
2016
$7,716 (+1.6%)
$476,355 + $207,111
$683,466
2015
$7,596 (+3.9%)
$467,015 + $203,050
$670,065
2014
$7,313
$460,000 + $175,000
$635,000
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
3
Baths
4
Stories
2
Lot width
—
Lot depth
—
Lot size
2.5 Acres
Year renovated
1980
Sq. Ft.
2,656
Year built
1980
Style
Single Family Residential
County
Fresno County
APN
30025026
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
Property details
Parking
Parking Information
Parking Features: RV Access/Parking, Garage Door Opener
Interior
Bathroom Information
Bathroom Features: Tub/Shower,Tub
Heating & Cooling
Has Heating
Heating: Other Heating/Cooling
Has Cooling
Cooling: Central Heat & Cool, Other Heating/Cooling
Interior Features
Interior Features: Loft
Appliances: Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Microwave, Trash Compactor
Flooring: Carpet, Hardwood, Other
Window Features: Double Pane Windows
Laundry Features: Inside, Utility Room
Fireplace Information
Has Fireplace
Fireplaces Total: 1
Exterior
Exterior Features
Levels: Two
Roof: Composition
Construction Materials: Wood Siding
Foundation Details: Concrete
Other Structures: Shed(s)
Patio And Porch Features: Deck
Has Waterfront
Waterfront Features: Waterfront
Pool Information
Has Private Pool
Pool Features: In Ground, Private
Has Spa
Spa Features: In Ground
Living Area
Living Area Source: Owner
Lot Information
Lot Features: Rural, Sprinklers In Front, Sprinklers In Rear, Sprinklers Auto, Mature Landscape
Property Information
Property Sub Type: Single Family Residence
Location
School Information
Elementary School: Liberty
Middle Or Junior School: Kastner
High School: Clovis West
High School District: Clovis Unified
Location Information
Directions: North on Friant past Willow Ave
County Or Parish: Fresno
Utility Information
Sewer: Septic Tank
Utilities: Public Utilities, Propane
Public facts
Beds: 3
Baths: 4.0
Sq. Ft.: 2,656
Stories: 2.0
Lot Size: 2.5 acres
Style: Single Family Residential
Year Built: 1980
Year Renovated: 1980
County: Fresno County
APN: 30025026
Home facts updated by county records on Aug 13, 2026
Around this home
Schools
Valley Oak Elementary School
Public K-6 • Assigned • 5.5mi
8/10
Kastner Intermediate School
Public 7-8 • Assigned • 7.3mi
8/10
Clovis West High School
Public 9-12 • Assigned • 6.3mi
9/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
5/10 Fire Factor
4% chance of being in a wildfire in next 30 years
8/10 Heat Factor
6 days above 108° expected this year, 13 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
10/10 Air Factor
53 unhealthy days expected this year, 57 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
96
65
98
67
92
65
81
57
64
49
57
45
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 13.5 hours in
June and 4.2 hours in December, placing it above the
U.S. average for solar exposure.
13.5 hrs
4.2 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$1.74M – $2.11M
Reach more buyers when you sell with Redfin. Save up to $18,300 in fees.3 minutes to get started.