15640 N Friant
Friant
93626
$1,950,000
Residential
beds: 4
baths: 3.0
3,230 sq. ft.
built: 2004
- Status:
- Active
- Prop. Type:
- Residential
- MLS® Num:
- 307081761
- Bedrooms:
- 4
- Bathrooms:
- 3
- Year Built:
- 2004
- Photos (53)
- Schedule / Email
- Send listing
- Mortgage calculator
- Print listing
Schedule a viewing:
Cancel any time.
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!
- Property Sub Type:
- Detached
- County Or Parish:
- Fresno
- Total Building Area:
- 3,230 sq. ft.
- Total Floor Area:
- 3,230 sq. ft.
- Total Bedrooms:
- 4
- Optional Bedrooms:
- 4
- Bathrooms:
- 3
- Full Bathrooms:
- 3
- Half Bathrooms:
- 0
- Fireplace Details:
- Great Room, Masonry
- Architecture:
- Custom Built
- Stories:
- 1 Story
- Num Stories:
- 1
- Total Stories:
- 1
- Entry Level:
- 1
- Year Built:
- 2004
- Age (in years):
- 22 year(s)
- Home Owner Fees:
- $0
- Mello Roos Fee:
- $0
- Mello Roos Fee Frequency:
- Year
- Terms:
- Cash, Conventional
- Highway 41 to Friant Road
- Site Influences:
- Sprinklers In Front, Sprinklers In Rear
- View:
- Mountains/Hills, Other/Remarks, Bluff
- Appliances:
- Dishwasher, Disposal, Microwave, Washer, Water Softener, Double Oven
- Accessibility Features:
- 2+ Access Exits, See Remarks
- Interior Features:
- Granite Counters, Pantry
- Special Listing Conditions:
- Standard
- Laundry:
- Washer Hookup
- Miscellaneous:
- Foothills, Rural
- Property Condition:
- Turnkey
- Lot Size:
- 3.09 acre(s)
- Parcel Number:
- 30031043S
- Parking Features:
- Tandem, Direct Garage Access, Garage, Garage - Single Door, Garage - Two Door, Garage Door Opener
- Total Parking Spaces:
- 4
- Total Garage Spaces:
- 4
- Heating:
- Fireplace, Forced Air Unit, Passive Solar
- Heating fuel:
- Natural Gas, Propane, Solar
- Cooling:
- Central Forced Air, Other/Remarks, Electric, Gas, Dual
- Utilities:
- Cable Available, Cable Connected, Electricity Available, Natural Gas Available, Natural Gas Connected, Propane, Water Available, Water Connected
- Pool Features:
- Below Ground, Private, See Remarks, Fenced, Pebble, Waterfall
- Spa Features:
- Private Below Ground, Heated, Private
- Roof:
- Tile/Clay
- Patio And Porch Features:
- Covered, Concrete, Patio, Patio Open
- Security:
- Carbon Monoxide Detectors
- Interior Walls:
- No Common Walls
- Water supply:
- Well
- Irrigation:
- Sprinklers
- Sewer Septic:
- Public Sewer
- Floor finish:
- Carpet, Tile
- Assessments:
- Unknown
- Fencing:
- Wrought Iron
-
Photo 1 of 53 -
Photo 2 of 53
-
Photo 3 of 53
-
Photo 4 of 53
-
Photo 5 of 53
-
Photo 6 of 53
-
Photo 7 of 53
-
Photo 8 of 53
-
Photo 9 of 53
-
Photo 10 of 53
-
Photo 11 of 53
-
Photo 12 of 53
-
Photo 13 of 53
-
Photo 14 of 53
-
Photo 15 of 53
-
Photo 16 of 53
-
Photo 17 of 53
-
Photo 18 of 53
-
Photo 19 of 53
-
Photo 20 of 53
-
Photo 21 of 53
-
Photo 22 of 53
-
Photo 23 of 53
-
Photo 24 of 53
-
Photo 25 of 53
-
Photo 26 of 53
-
Photo 27 of 53
-
Photo 28 of 53
-
Photo 29 of 53
-
Photo 30 of 53
-
Photo 31 of 53
-
Photo 32 of 53
-
Photo 33 of 53
-
Photo 34 of 53
-
Photo 35 of 53
-
Photo 36 of 53
-
Photo 37 of 53
-
Photo 38 of 53
-
Photo 39 of 53
-
Photo 40 of 53
-
Photo 41 of 53
-
Photo 42 of 53
-
Photo 43 of 53
-
Photo 44 of 53
-
Photo 45 of 53
-
Photo 46 of 53
-
Photo 47 of 53
-
Photo 48 of 53
-
Photo 49 of 53
-
Photo 50 of 53
-
Photo 51 of 53
-
Photo 52 of 53
-
Photo 53 of 53
Listed by Cathy Freeman & Co.
Data was last updated September 22, 2026 at 07:10 PM (UTC)
Area Statistics
- Listings on market:
- 11
- Avg list price:
- $590,000
- Min list price:
- $449,990
- Max list price:
- $1,950,000
- Avg days on market:
- 60
- Min days on market:
- 0
- Max days on market:
- 203
- Avg price per sq.ft.:
- $258.36
These statistics are generated based on the current listing's property type
and located in
Friant. Average values are
derived using median calculations. This data is not produced by
the MLS® system.
- BOB LADUE
- COASTAL MORTGAGE AND REALTY
- 1 (619) 5912916
- Contact by Email
This information is deemed reliable but not guaranteed.
You should rely on this information only to decide whether or not to further investigate a particular property.
BEFORE MAKING ANY OTHER DECISION, YOU SHOULD PERSONALLY INVESTIGATE THE FACTS (e.g. square footage and lot size) with the assistance of an appropriate professional.
You may use this information only to identify properties you may be interested in investigating further.
All uses except for personal, non-commercial use in accordance with the foregoing purpose are prohibited.
Redistribution or copying of this information, any photographs or video tours is strictly prohibited.
This information is derived from the Internet Data Exchange (IDX) service provided by San Diego Multiple Listing Service, Inc.
Displayed property listings may be held by a brokerage firm other than the broker and/or agent responsible for this display.
The information and any photographs and video tours and the compilation from which they are derived is protected by copyright.
Compilation © 2026 San Diego Multiple Listing Service, Inc.
3110 Camino Del Rio S. #311
San Diego, CA 92108
This information is deemed reliable but not guaranteed.
You should rely on this information only to decide whether or not to further investigate a particular property.
BEFORE MAKING ANY OTHER DECISION, YOU SHOULD PERSONALLY INVESTIGATE THE FACTS (e.g. square footage and lot size) with the assistance of an appropriate professional.
You may use this information only to identify properties you may be interested in investigating further.
All uses except for personal, non-commercial use in accordance with the foregoing purpose are prohibited.
Redistribution or copying of this information, any photographs or video tours is strictly prohibited.
This information is derived from the Internet Data Exchange (IDX) service provided by San Diego Multiple Listing Service, Inc.
Displayed property listings may be held by a brokerage firm other than the broker and/or agent responsible for this display.
The information and any photographs and video tours and the compilation from which they are derived is protected by copyright.
Compilation © 2026 San Diego Multiple Listing Service, Inc.