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
$252
Price Per Acre
$92,222
Days On Market
11
Cumulative Days On Market
11
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) >= 394250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 435750 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` = 1690549 OR `props-main`.`id` = 1686926 OR `props-main`.`id` = 1686923 OR `props-main`.`id` = 1687998 OR `props-main`.`id` = 1695629 OR `props-main`.`id` = 1693894 OR `props-main`.`id` = 1678945 OR `props-main`.`id` = 1647271 OR `props-main`.`id` = 1647365 OR `props-main`.`id` = 1690482 OR `props-main`.`id` = 1680337 OR `props-main`.`id` = 1684054 OR `props-main`.`id` = 1697184 OR `props-main`.`id` = 1678078 OR `props-main`.`id` = 1684057 OR `props-main`.`id` = 1685601 OR `props-main`.`id` = 1665998)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640129' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-15' 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 weeks ago Fresno MLS last checked for updates 33 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.
