Courtesy of Billy Lovewell, eXp Realty of California, Inc. - [email protected]
This 3 acre property features a nearly move-in ready, charming 1-bedroom, 1-bathroom home and an additional single-wide mobile home that offers great potential with a little TLC. The land is functional and gently rolling, already fully fenced and cross-fenced with a classic barn, making it the perfect setup for a hobby farm or mountain retreat. The main residence is highlighted by a spacious wraparound covered porch with a ceiling fan. Enjoy brick-paved walkways, and multiple spaces providing an expansive outdoor space to relax and take in the views of the snow-capped Sierra Mountain range.The property has been thoughtfully maintained with significant infrastructure, including central HVAC, updated well equipment, and most of the windows upgraded. Inside the main home, you'll find a bright and inviting layout with cottage-style charm that is ready for you to enjoy from day one. Each unit has its own power & propane service. The private well adequately supports both homes. Located just off Hwy 180, this rare gem offers an effortless commute to the Central Valley while sitting at the scenic gateway to our world-famous National Parks.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1963
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$367
Price Per Acre
$79,714
Days On London
0
Cumulative Days On London
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
HWY-180
Directions
Head toward George Smith Rd, right onto Bear Mountain Rd.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 265050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 292950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '1' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 510 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1010 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` = 1719948 OR `props-main`.`id` = 1717396 OR `props-main`.`id` = 1725912 OR `props-main`.`id` = 1736037 OR `props-main`.`id` = 1700852 OR `props-main`.`id` = 1739556 OR `props-main`.`id` = 1739611 OR `props-main`.`id` = 1708127)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno650698' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-19' 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
Last modified 3 hours 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.
