Zoned CRM - Mixed-Use OpportunitybrThis unique property combines two parcels (APNs: 065-040-009-000 & 065-040-010-000) for a total of approximately 1.37 acres (59,677+/- sq ft) with multiple access points, including direct Highway 41 and additional easements.
The site includes a 1,000 sq ft 1-bedroom, 1-bath home/office space with new carpet, a pellet stove, full kitchen, and laundry. Additional improvements feature a secured fully fenced lot with a custom ranch-style fence, two wells (one with brand new pump and new with updated wiring), and a septic system. Steeped in Oakhurst history, this property was once a thriving nursery and is ready for its next chapter. Don't miss the chance to explore the potential at 41045 Highway 41, Oakhurst, CA 93644.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built Exception
Unknown
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$285
Price Per Acre
$158,333
Days On Market
150
Cumulative Days On Market
150
County
Madera
REO / Bank Owned
No
Cross Street Address
Across for Hodges Hill
Directions
Highway 41 use GPS 41045 Hwy 41 Sign at property
Style
Cabin
Heating & Cooling
Evaporative Cool, Other
Laundry
Inside
Roofing
Metal
Foundation
Concrete
Kitchen
Electric Appliances, Refrigerator
Primary Bedroom Level
Lower
Flooring
Carpet, Laminate
# of Fireplaces
1
Fireplace Type
Pellet
Exterior
Wood
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Private Well
Solar
No
Parking Features
Uncovered
APN
065 040 009 000
Zoning
CRM
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
Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 270750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 299250 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) >= 750 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1250 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` = 1687537 OR `props-main`.`id` = 1691994 OR `props-main`.`id` = 1692450 OR `props-main`.`id` = 1692558 OR `props-main`.`id` = 1697703 OR `props-main`.`id` = 1697697 OR `props-main`.`id` = 1694054 OR `props-main`.`id` = 1684616 OR `props-main`.`id` = 1677160 OR `props-main`.`id` = 1677211 OR `props-main`.`id` = 1683252 OR `props-main`.`id` = 1699083 OR `props-main`.`id` = 1683265 OR `props-main`.`id` = 1699088 OR `props-main`.`id` = 1686607 OR `props-main`.`id` = 1679722 OR `props-main`.`id` = 1684613 OR `props-main`.`id` = 1657752 OR `props-main`.`id` = 1694244 OR `props-main`.`id` = 1655023 OR `props-main`.`id` = 1673677 OR `props-main`.`id` = 1671575 OR `props-main`.`id` = 1638512 OR `props-main`.`id` = 1690785 OR `props-main`.`id` = 1694278 OR `props-main`.`id` = 1639830 OR `props-main`.`id` = 1691422 OR `props-main`.`id` = 1690800 OR `props-main`.`id` = 1638533 OR `props-main`.`id` = 1691997 OR `props-main`.`id` = 1687557 OR `props-main`.`id` = 1685560 OR `props-main`.`id` = 1688570 OR `props-main`.`id` = 1688561 OR `props-main`.`id` = 1636751 OR `props-main`.`id` = 1690912 OR `props-main`.`id` = 1667484 OR `props-main`.`id` = 1694569 OR `props-main`.`id` = 1667579 OR `props-main`.`id` = 1693930 OR `props-main`.`id` = 1693922 OR `props-main`.`id` = 1697427 OR `props-main`.`id` = 1697412 OR `props-main`.`id` = 1696406 OR `props-main`.`id` = 1696282 OR `props-main`.`id` = 1685356 OR `props-main`.`id` = 1687708 OR `props-main`.`id` = 1687547 OR `props-main`.`id` = 1687473 OR `props-main`.`id` = 1677521 OR `props-main`.`id` = 1685286 OR `props-main`.`id` = 1685061 OR `props-main`.`id` = 1686201 OR `props-main`.`id` = 1635838 OR `props-main`.`id` = 1635840 OR `props-main`.`id` = 1696418 OR `props-main`.`id` = 1696415 OR `props-main`.`id` = 1678407 OR `props-main`.`id` = 1662495 OR `props-main`.`id` = 1657428 OR `props-main`.`id` = 1657431 OR `props-main`.`id` = 1699500 OR `props-main`.`id` = 1687261 OR `props-main`.`id` = 1690329 OR `props-main`.`id` = 1690188 OR `props-main`.`id` = 1627751 OR `props-main`.`id` = 1627748)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno634388' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-29' 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 2 hours ago Fresno MLS last checked for updates 8 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.
