Breathtaking views and peaceful privacy await you at 20997 Auberry Rd in Clovis, CA. Nestled on 11.5 scenic foothill acres, this 2,434 sq ft home offers the perfect blend of comfort and country living. A long private driveway leads to this secluded retreat, where you'll enjoy panoramic views that stretch for miles.Inside, you'll find 3 spacious bedrooms and 3 bathrooms, including a primary suite with its own cozy fireplace-perfect for relaxing evenings. The well-appointed kitchen features a Viking gas stove, breakfast bar, ample counter space, and beautifully crafted cabinets that offer plenty of storage.Enjoy the freedom of open space, the tranquility of nature, and the convenience of a large 3-car garage. Whether you're entertaining guests or simply savoring the peaceful surroundings, this bluff-top-style property delivers views you'll never tire of.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1998
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$300
Price Per Acre
$63,364
Days On Market
107
Cumulative Days On Market
107
County
Fresno
REO / Bank Owned
No
Cross Street Address
Millerton
Directions
145 to Road 206(Right), Left n Millerton Road, Left on Auberry Road, Turn left.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 693452.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 766447.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2184 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2684 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` = 1658519 OR `props-main`.`id` = 1680095 OR `props-main`.`id` = 1683009 OR `props-main`.`id` = 1678635 OR `props-main`.`id` = 1687043 OR `props-main`.`id` = 1648036 OR `props-main`.`id` = 1675308 OR `props-main`.`id` = 1632390 OR `props-main`.`id` = 1667896 OR `props-main`.`id` = 1678497 OR `props-main`.`id` = 1687288 OR `props-main`.`id` = 1666174 OR `props-main`.`id` = 1666175)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno633996' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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 Teddi Peters, Coldwell Banker Preferred Realtors - [email protected] Last modified 3 weeks ago Fresno MLS last checked for updates 8 minutes 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.
