divCalling All Investors!/divdivbr/divdivThis is a 500 sq ft cabin that already has approved plans and pulled permits to expand it to about 900 sq ft, 2 bed / 2 bath. The hard part dealing with the county is already done!span style=''font-size: 10pt;''This rustic cabin offers the perfect canvas for investors, flippers, or those looking to create a mountain retreat. Nestled in the scenic foothills of Oakhurst, the property features a charming wood exterior, vintage details, and a peaceful natural setting./span/divdivbrInside, you'll find an open living area with wood paneling, a freestanding wood stove, and plenty of potential for a creative redesign. The kitchen and bathrooms are in need of full renovation, making this a btrue fixer-upper opportunity/b for those ready to bring their vision to life.
The property also includes outdoor space with mature trees, a detached outbuilding, and ample room to expand or reimagine.span style=''font-size: 10pt;''Close to Yosemite, Bass Lake, and Oakhurst amenities making it a perfect opportunity for an Airbnb./spanspan style=''font-size: 10pt;''Endless potential to renovate or rebuild./span/divdivbbr/b/divdivbSold AS IS - Seller will not make repairs/b
Don't miss your chance to transform this diamond in the rough into your next profitable project or cozy getaway!/divbrdivbr/div
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1954
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$390
Price Per Acre
$166,667
Days On Market
93
Cumulative Days On Market
93
County
Madera
REO / Bank Owned
No
Cross Street Address
Artesian way
Directions
Start at intersection of Hwy 41 and Road 426 Head east on road 426 continue for 2.5 miles Property will be on your ride hand side. Gate access.
Heating & Cooling
None
Laundry
None
Roofing
Metal
Foundation
Wood Subfloor
Primary Bedroom Level
Main
# of Fireplaces
1
Exterior
Wood
Pool
No
Pool
No
Gas & Electric
Public Utilities, Propane
Sewer / Water
Septic Tank
Solar
No
APN
066 440 009 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) >= 185250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 204750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 250 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 750 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` = 1633615 OR `props-main`.`id` = 1633634 OR `props-main`.`id` = 1697170 OR `props-main`.`id` = 1676231 OR `props-main`.`id` = 1676229 OR `props-main`.`id` = 1673246 OR `props-main`.`id` = 1697815 OR `props-main`.`id` = 1697334 OR `props-main`.`id` = 1633507 OR `props-main`.`id` = 1674154 OR `props-main`.`id` = 1689515 OR `props-main`.`id` = 1689558 OR `props-main`.`id` = 1665802 OR `props-main`.`id` = 1687546 OR `props-main`.`id` = 1698695 OR `props-main`.`id` = 1687677 OR `props-main`.`id` = 1678066 OR `props-main`.`id` = 1665957 OR `props-main`.`id` = 1687583 OR `props-main`.`id` = 1687181 OR `props-main`.`id` = 1687158 OR `props-main`.`id` = 1665948 OR `props-main`.`id` = 1687582 OR `props-main`.`id` = 1687613 OR `props-main`.`id` = 1695147 OR `props-main`.`id` = 1695163 OR `props-main`.`id` = 1695130 OR `props-main`.`id` = 1695141 OR `props-main`.`id` = 1679689 OR `props-main`.`id` = 1679681 OR `props-main`.`id` = 1654955 OR `props-main`.`id` = 1627895 OR `props-main`.`id` = 1627897 OR `props-main`.`id` = 1687665 OR `props-main`.`id` = 1684949 OR `props-main`.`id` = 1684969 OR `props-main`.`id` = 1649455 OR `props-main`.`id` = 1649459 OR `props-main`.`id` = 1697242 OR `props-main`.`id` = 1699977 OR `props-main`.`id` = 1699974 OR `props-main`.`id` = 1652449 OR `props-main`.`id` = 1674206 OR `props-main`.`id` = 1652455 OR `props-main`.`id` = 1673392 OR `props-main`.`id` = 1693731 OR `props-main`.`id` = 1683814 OR `props-main`.`id` = 1689940 OR `props-main`.`id` = 1687552 OR `props-main`.`id` = 1689922 OR `props-main`.`id` = 1686999 OR `props-main`.`id` = 1687537 OR `props-main`.`id` = 1691994 OR `props-main`.`id` = 1692450 OR `props-main`.`id` = 1692558 OR `props-main`.`id` = 1694054 OR `props-main`.`id` = 1677160 OR `props-main`.`id` = 1677211 OR `props-main`.`id` = 1677652 OR `props-main`.`id` = 1657752 OR `props-main`.`id` = 1673677 OR `props-main`.`id` = 1671575 OR `props-main`.`id` = 1691422 OR `props-main`.`id` = 1685560)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno637653' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-27' 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 Eunhae Roldan, Realty Concepts, Ltd. - Fresno - [email protected] Last modified 5 hours ago Fresno MLS last checked for updates 15 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.
