Country living without the compromise. Just 25 minutes from Clovis shopping, this move-in ready home offers the space, views, and escape you've been searching for. Featuring 4 bedrooms plus a bonus room, owned solar, a newer roof and AC, and updated well mechanics. Step outside to your private deck overlooking stunning sunsets and mountain views the perfect place to unwind. Complete with a barn/shop, gated & fenced, RV parking, a seasonal creek, and plenty of room for your family and pets, this property truly has it all. Conveniently located near Millerton Lake and Table Mountain Casino Resort. Here you get the best of both adventure and everyday convenience.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1976
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$269
Price Per Acre
$132,979
Days On London
0
Cumulative Days On London
0
County
Fresno
Leased Equipment
Propane
Special Features
Horses Allowed
REO / Bank Owned
No
Cross Street Address
Auberry Rd
Directions
Northbound on Friant, make a right on Copper and a left on Auberry. Turn right on Frontier, left on Homestead Rd and Turn right onto Goldrush L
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Detached Structures
Shop
Kitchen
Built In Range/Oven, Electric Appliances, Dishwasher, Eating Area
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 593750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 656250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2072 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2572 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1701917 OR `props-main`.`id` = 1680095 OR `props-main`.`id` = 1683009 OR `props-main`.`id` = 1703406 OR `props-main`.`id` = 1713058 OR `props-main`.`id` = 1718387 OR `props-main`.`id` = 1708063)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno646089' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-26' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
Courtesy of Monica Flores, Real Broker - [email protected] Last modified 3 hours ago
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
