Charming Custom Barn-Style Cabin in MiramonteDiscover this adorable custom barn cabin tucked away in the highly sought-after community of Miramonte. Currently a successful vacation rental, this property is ready for its next chapterwhether as a cozy family getaway or continued investment.Ideally located near Highway 245 and just 10 miles from Kings Canyon and Sequoia National Parks, the cabin offers both convenience and seclusion. Inside, you'll love the hardwood floors, warm wood accents, and expansive picture windows that fill the space with natural light. Step outside to enjoy the large private deck, perfect for relaxing or entertaining.Practical features include ample downstairs storage and a 1,000-gallon water storage systemproviding both comfort and peace of mind.This one-of-a-kind cabin truly has it alldon't miss your opportunity to make it yours!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1963
Region
Mountain
# of Stories
Two
Price Per Square Foot
$255
Price Per Acre
$735,502
Days On Market
21
Cumulative Days On Market
21
County
Fresno
REO / Bank Owned
No
Cross Street Address
Highway 245
Directions
Highway 180 to Highway 245, to Todd Eymann Rd
Style
Cabin
Heating & Cooling
Floor or Wall Unit
Laundry
None
Roofing
Metal
Foundation
Wood Subfloor
Detached Structures
Shed
Kitchen
Built In Range/Oven, Electric Appliances, Eating Area, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 247000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 273000 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) >= 770 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1270 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` = 1667883 OR `props-main`.`id` = 1673182 OR `props-main`.`id` = 1646554 OR `props-main`.`id` = 1683492 OR `props-main`.`id` = 1673267 OR `props-main`.`id` = 1663306 OR `props-main`.`id` = 1693656 OR `props-main`.`id` = 1694625 OR `props-main`.`id` = 1668380)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno637470' 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 Cheyenne Mullins, Prospect Realty - [email protected] Last modified 1 month ago Fresno MLS last checked for updates 11 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.
