Welcome or Register
Back to Saved Search
Listing 15 out of 198
$995,000 For Sale

15640 N Friant
Friant, CA 93626

4 beds, 3 baths | Single Family Home
3,230 sq ft, 3.09 acre lot - MLS# 481846
Property Photo


Shangri-La does Exist! An Exquisitely Landscaped 4 Bd, 3 ba, 3 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


  • Property Type: Single Family Home
  • Sub Type: Single Family Residence
  • Listing Status: Active
  • Listing Price: $995,000
  • County/Area: Fresno County
  • Zip Code: 93626
  • Year Built: 2004
  • School District: Clovis Unified
  • Elementary School: Liberty
  • Middle School: Kastner
  • High School: Clovis West
  • Sq.Ft.: 3,230 sq ft
  • Stories: Single Story
  • Bedrooms: 4
  • Baths (full): 3
  • Total Baths: 3.00
  • Garage: See Garage Details
  • Fireplace: 2
  • Acres: 3.09 acre lot
  • Pool or Spa: Yes In Ground
  • Zoning: Ae20
  • Bath Features: Tub/Shower, Shower, Tub, Jetted Tub
  • Detached Structures: Shed
  • Dining Room Features: Formal
  • Disabled Features: Wheel Chair Access, One Level Floor
  • Energy Efficiency: Dual Pane Windows
  • Estimated Selling Date: 1800-01-01
  • Exterior: Stucco, Wood
  • Extra Rooms: Great Room, Game Room
  • Flooring: Carpet, Tile
  • Foundation: Concrete
  • Garage Details: 4-Car Attached Potential RV Parking, Uncovered, Work/Shop Area, Drive Thru, Auto Opener, Street, Tandem Garage, Other
  • Gas & Electric: Public Utilities, Propane
  • Heating & Cooling: Central Heat & Cool
  • Kitchen: Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Trash Compactor, Eating Area, Breakfast Bar, Pantry, Wine Refrigerator, Other
  • Laundry: Inside, Utility Room, Gas Hook Up, Electric Hook Up
  • Lease Type: Net
  • Leased Equipment: Propane
  • Lot Measurement: SqFt
  • Lot Size Source: (Tax Records)
  • Lot Square Footage: 134600.00
  • Patio Features: Covered, Uncovered, Concrete
  • Region: Foothill
  • Roofing: Tile
  • Sewer/Water: Septic Tank, Private Well
  • Site Amenities: Bluff View, Riverview, Pasture, Other
  • Special Features: Isolated Bedroom, Isolated Bathroom, Security System, Security Gate, Built In Cabinets, Central Vac, Skylight, Water Softener, Wet/Dry Bar, High Tech Cable, Other/See Remarks, Horses Allowed
  • Square Footage Source: Tax Records
  • Tract/Builder: Image
  • Transaction Type: Sale
  • Water Level: 107.00
  • Well Depth: 600.00
  • Yard: Sprinklers Front, Sprinklers Back, Sprinklers Auto, Fenced, Mature Landscape, Fruit/Nut Trees, Garden Area, Drip System, Other
Courtesy of Guarantee Real Estate, Diana Scott

Thank you for visiting today. If this is your first visit, take your time and look around. I have plenty of information and resources available to you. If you are a return visitor, thank you. I would love to hear from you and tell you how I can serve all your real estate needs.


* fields are required