Discover your own 4.5-acre foothill retreat offering exceptional privacy, stunning views, and the freedom to cultivate crops, raise livestock, or enjoy beekeeping. Located just 40 minutes from Fresno and 15 minutes from Shaver Lake, this property is perfect for those who value nature, self-sustainability, and open space while still being conveniently close to city amenities. Experience all four beautiful seasons the California foothills have to offer, an ideal setting for your dream home or countryside getaway. The bedrooms are generously sized, offering comfort and relaxation throughout the home. This property is the definition of cozy living! Imagine sipping hot tea or cocoa and curling up by the fireplace as you gaze out over the beautiful valley and rolling hillsides. It's the perfect place to unwind and take in the peaceful charm of the foothills.Side note: This home is under the California Fair Plan ($3,666/ YR) which insures wild fire = 70% LESS than typical wild fire insurance.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1997
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$242
Price Per Acre
$88,667
Days On London
0
Cumulative Days On London
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
Stoney Creek Rd
Directions
Gps works. CA-168 to Sample Rd. Continue to Pittman Hill Rd. Turn right onto Tollhouse Rd. Turn right onto Burrough Valley Rd. Turn left onto Seminole Rd and property on your left
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 418950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1397 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1897 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` = 1703930 OR `props-main`.`id` = 1716062 OR `props-main`.`id` = 1728252 OR `props-main`.`id` = 1721256 OR `props-main`.`id` = 1700038 OR `props-main`.`id` = 1728726 OR `props-main`.`id` = 1723865 OR `props-main`.`id` = 1725404 OR `props-main`.`id` = 1721733 OR `props-main`.`id` = 1721725 OR `props-main`.`id` = 1705554 OR `props-main`.`id` = 1726936 OR `props-main`.`id` = 1701289 OR `props-main`.`id` = 1728035 OR `props-main`.`id` = 1728029 OR `props-main`.`id` = 1678078 OR `props-main`.`id` = 1728041 OR `props-main`.`id` = 1719164)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649375' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-25' 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 Moua Xiong, Altura Realty - [email protected] Last modified 2 hours ago Fresno MLS last checked for updates 17 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.
