Rare Sierra Nevada foothills log cabin retreat in Oakhurst with panoramic mountain views and a private ADU | Both the main home and ADU are active Airbnb properties with a strong performance history making this a true turnkey income-producing mountain retreat | 3 bedrooms and 2 bathrooms across a 1288 sq ft main home and an approximately 500 sq ft ADU | Authentic mountain craftsmanship throughout with extensive hand-built river rock accents from the exterior fence to the interior fireplace | The great room features soaring vaulted wood-beam ceilings | knotty pine walls | a stunning river rock fireplace | game room with pool table | and a built-in river rock wet bar perfect for entertaining | Open kitchen with knotty pine cabinets | granite countertops | stainless gas range | tile backsplash | tile floors | breakfast bar seating | and a dining nook with bench seating | Main bathroom features floor-to-ceiling river rock tile surrounding the shower and tub | Two outdoor decks including a large covered deck with river rock columns | string lights and unobstructed Sierra Nevada mountain views | The extensive hand-crafted river rock fence is a signature feature framing the entire property alongside mature oak and cedar trees | Private ADU features a bedroom with French doors and a full bathroom with tiled walk-in shower | quartz vanity and modern fixtures | ADU room and bathroom added approx 6 years ago | Brand new roof installed just 2 months ago | Minutes to Oakhurst dining and shopping | close to Bass Lake | and a short drive to the south entrance of Yosemite National Park | Active short-term rental income opportunity in one of the Sierra foothills most sought-after vacation destinations | Be sure to take a look at the walkthrough video to see everything this property has to offer
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1965
Region
Mountain
# of Stories
Single Story, Two
Price Per Square Foot
$400
Price Per Acre
$971,604
Days On London
0
Cumulative Days On London
0
County
Madera
REO / Bank Owned
No
Cross Street Address
Bissett Station Road
Directions
From Highway 41 heading north from Fresno: Turn left onto Road 620 | Turn right onto Whittenburg Rd | Property will be on your right at 42699 Whittenburg Rd
Style
Cabin
Heating & Cooling
Evaporative Cool
Laundry
None
Roofing
Composition
Foundation
Concrete
Primary Bedroom Level
Upper
Bath Features
Shower
Flooring
Carpet, Tile
# of Fireplaces
2
Fireplace Type
Masonry, Free Standing
Exterior
Stucco, Wood
Pool
No
Pool
No
Gas & Electric
Propane
Sewer / Water
Septic Tank, Private Well
Solar
No
Parking Features
Potential RV Parking
Are there garage spaces?
No
APN
057 590 007 000
School District
Bass Lake Joint Unio
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
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 489202.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 540697.5 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) >= 1038 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1538 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` = 1749621 OR `props-main`.`id` = 1751538 OR `props-main`.`id` = 1717569 OR `props-main`.`id` = 1717563 OR `props-main`.`id` = 1720937 OR `props-main`.`id` = 1720923 OR `props-main`.`id` = 1718198 OR `props-main`.`id` = 1756356 OR `props-main`.`id` = 1756149 OR `props-main`.`id` = 1718146 OR `props-main`.`id` = 1725890 OR `props-main`.`id` = 1729761 OR `props-main`.`id` = 1705108 OR `props-main`.`id` = 1705099 OR `props-main`.`id` = 1753326 OR `props-main`.`id` = 1762504 OR `props-main`.`id` = 1744349 OR `props-main`.`id` = 1743536 OR `props-main`.`id` = 1727959 OR `props-main`.`id` = 1724835 OR `props-main`.`id` = 1728008 OR `props-main`.`id` = 1738714 OR `props-main`.`id` = 1757109 OR `props-main`.`id` = 1757092 OR `props-main`.`id` = 1729150 OR `props-main`.`id` = 1729143 OR `props-main`.`id` = 1735412 OR `props-main`.`id` = 1735463 OR `props-main`.`id` = 1717111 OR `props-main`.`id` = 1717141 OR `props-main`.`id` = 1584048 OR `props-main`.`id` = 1559272 OR `props-main`.`id` = 1735462 OR `props-main`.`id` = 230457 OR `props-main`.`id` = 1739010)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno653707' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-14' 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 41 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.
