Attention investors & anyone looking for a great opportunity! Turn key 2 unit short term rental property. Beautiful and peaceful cabin located in the Sierra Nevada mountains. Close to popular destinations such as Yosemite National Park, Bass Lake, & Lewis Creek trail heads. Upstairs unit boasts breathtaking mountain views at 4450 elevation and offers a 2 bedroom 1 bathroom cabin with full kitchen and bathroom & a covered deck to enjoy those relaxing cool summer evenings. The cozy downstairs stairs unit provides a studio with queen bed, private bathroom, and is currently equipped with microwave and refrigerator and features a new large private heavy duty reinforced deck, perfect to add your hot tub. Live upstairs and rent out the downstairs, or rent out the upstairs full time and save the downstairs unit for your vacation hideaway. Many possibilities with this one!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1925
Region
Mountain
# of Stories
Two
Price Per Square Foot
$352
Price Per Acre
$2,928,571
Days On Market
141
Cumulative Days On Market
141
County
Madera
Special Features
Isolated Bedroom
REO / Bank Owned
No
Cross Street Address
Brammer Purl
Directions
Highway 41 north to Road 630, to Brammer Purl, turn right on Locust stay left on poplar for 800 feet property is on your right
Style
Cabin
Heating & Cooling
Floor or Wall Unit, Window or Wall A/C
Laundry
On Upper Level
Roofing
Metal
Foundation
Wood Subfloor
Kitchen
Electric Appliances, Refrigerator
Primary Bedroom Level
Upper
Bath Features
Shower
Basement
Unfinished
# of Fireplaces
1
Exterior
Wood
Pool
No
Pool
No
Spa
No
Patio Features
Covered, Uncovered
Yard
Mature Landscape
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
Parking Features
Uncovered
Site Amenities
Other
APN
057 070 016 000
HOA Dues
1200.00
Frequency
yearly
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Oak Creek
School Type 3
Grade School
School Name 3
Oakhurst
Seller Will Consider
Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 389500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 430500 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) >= 916 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1416 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` = 1673088 OR `props-main`.`id` = 1673089 OR `props-main`.`id` = 1655951 OR `props-main`.`id` = 1655802 OR `props-main`.`id` = 1633845)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno633241' 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 Christopher Regert, Realty Concepts - Oakhurst - [email protected] Last modified 1 week ago Fresno MLS last checked for updates 31 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.
