Realty Solution
Powered by 
- 0
- 9
- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
No HOA
Street View
Listed by: Cathy Freeman (559) 389-5896 DRE #01724853, Matthew Connell DRE #02009491 | Cathy Freeman & Co. (559) 389-5896
$1,950,000
Monthly Est:$9,706
4 Beds
3 Baths3 full baths
3,230sqft
15640 N Friant, Friant, CA 93626
$1,950,000
$9,706/moEst:
Get Pre-Approved
Single Family Residence
Built in 2004
$-- HOA
3.09 acres lot
$604/sq.ft
Description
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!
- Houzeo last checked: 5 minutes ago
- Listing updated: September 28, 2026 at 9:51 pm
- Source: California Regional MLS-CA | MLS#: FR26205430
Property Details
Status
Active
Type
Single Family Residence
No. of Stories
1
County
City
Neighborhood
--
Year Built
2004
HOA Fees
-
Finished Area
3,230 sqft
Lot Size
3.09 acres lot
Basement Area
- sqft
MLS Name
California Regional MLS
MLS Number
FR26205430
MLS Status
Active
Days on Market
17
Cumulative Days on Market
7
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 3
Interior
Flooring
Carpet, Tile
Interior Features
Breakfast Bar, Breakfast Area, Ceiling Fans, Crown Molding, Separate Formal Dining Room, Granite Counters, High Ceilings, In Law Floorplan, Open Floorplan, Pantry, All Bedrooms Down, Utility Room, Walk In Pantry, Walk In Closets
Sewer
Public Sewer
Appliances
Double Oven, Dishwasher, Disposal, Microwave, Water Softener, Washer
Heating
Central, Fireplaces, Propane, Natural Gas, Solar
Window Features
Custom Coverings, Double Pane Windows, Roller Shields
Cooling
Central Air, Dual, Electric, Gas, See Remarks
Construction
Year Built
Year Built: 2004
Home type
Single Family Residence
Property Condition
Turnkey
Architectural Style
Custom
Roof
Tile
Utilities & Energy
Fireplace Features
Great Room, Masonry, Primary Bedroom
Security Features
Carbon Monoxide Detectors, Smoke Detectors
Pool Features
Fenced, Gas Heat, In Ground, Pebble, Private, See Remarks, Waterfall
Parking Features
Asphalt, Door Multi, Direct Access, Door Single, Driveway, Garage, Garage Door Opener, Paved, Private, Pull Through, Rv Access Parking, Tandem
Laundry Features
Washer Hookup, Inside, Laundry Room
Utilities
Cable Available, Cable Connected, Electricity Available, Natural Gas Available, Natural Gas Connected, Propane, Water Available, Water Connected
Water Source
Well
Other Features
Community Features
Foothills, Rural
Patio And Porch Features
Concrete, Covered, Open, Patio
Lot Features
Sprinklers In Rear, Sprinklers In Front, Sprinklers On Side, Sprinkler System
Price History
| Date | Event | Price |
|---|---|---|
09/21/2026 Source: | Listed for Sale | $1,950,000 $604/sqft |
Nearby Homes
Find Homes by Property Features in Friant, CA
Nearby New Homes For Sale
Based on information from California Regional Multiple Listing Service, Inc. as of Oct 09, 2026, 10:45AM and /or other sources. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information being provided is for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. © 2026 California Regional Multiple Listing Service. All Rights Reserved.
Advertising Broker: William Johnson DRE #01463271 | William Johnson Brokerage