Courtesy of Lisa Melton-Reimer, London Properties-Kingsburg - [email protected]
Turnkey vacation rental opportunity! Everything stays with this charming Miramonte Cabin, offering a fully furnished and thoughtfully equipped mountain retreat ready for its next owner. Ideally situated near the junction leading to both Sequoia and Kings Canyon National Parks, the cabin is perched at approximately 4,200 feet and showcases beautiful west-facing mountain views and colorful sunsets from the spacious deck.The inviting interior features comfortable living spaces, two bedrooms, 1.75 bathrooms and three air-conditioning units, including one in each bedroom and a high-powered unit downstairs. Furnishings, linens, kitchenware, appliances, barbecue, washer, dryer and other household essentials are included.Set on approximately two acres with plenty of room to wander, explore and enjoy the peaceful surroundings, the property is located along quiet Hogback Road and less than a mile from Pinehurst Lodge. Enjoy privacy and tranquility while remaining convenient to outdoor recreation, hiking, fishing and the majestic giant sequoias. An exceptional opportunity for a vacation rental, personal getaway or both!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1988
Region
Urban
Unique Conditions
Bankruptcy
# of Stories
Two
Price Per Square Foot
$280
Price Per Acre
$176,405
Days On London
0
Cumulative Days On London
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
HWY 245
Directions
From Hwy 180 head upward toward Snowline Lodge. Watch for the 5k ft marker, for you are 1.3 miles to the turnoff onto Hwy 245. On Hwy 245 toward Pinehurst. To reach the cabin, it's about 4 miles on 245, left onto Hogback Rd to the Cabin .2 Mi
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 998 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1498 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` = 1746288 OR `props-main`.`id` = 1753344 OR `props-main`.`id` = 1757637 OR `props-main`.`id` = 1744210 OR `props-main`.`id` = 1736798 OR `props-main`.`id` = 1737917 OR `props-main`.`id` = 1739202 OR `props-main`.`id` = 1718950 OR `props-main`.`id` = 1719054 OR `props-main`.`id` = 1718952 OR `props-main`.`id` = 1683492 OR `props-main`.`id` = 1716514 OR `props-main`.`id` = 1709207 OR `props-main`.`id` = 1706858 OR `props-main`.`id` = 1738737 OR `props-main`.`id` = 1740020)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno653169' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-04' 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();
1
Similar Properties
$355,000
3
2
1,460
2.00
53237 Hogback Rd
Miramonte, CA 93641
Last modified 2 hours ago Fresno MLS last checked for updates 3 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.
