Donna Pride559.642.8373dpride@londonproperties.comEmail Agent
Property Description
Welcome to one of the cutest little homes in all of Oakhurst! This unique home is just under 1000 sq ft and sits on a whopping 5 acre parcel. If you're looking for the mountain life but still need the amenities of the city then this property would be perfect. The town of Oakhurst has everything you need including a Community College! Yet just a couple of miles outside of town brings you that true mountainous feel. This property features large trees throughout along with rolling topography! The house itself is super cozy and has been mostly updated. Newer Floors and countertops along with new electrical and a new wall cooling unit all make this place such a nice place to be. The outside has been set up as an entertainers delight. There are outdoor soaking tubs and gazebos along with a cantina that your guests are sure to love! Everything about this place screams relax and enjoy. This is truly what the good life is all about!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1935
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$413
Price Per Acre
$74,980
Days On Market
56
Cumulative Days On Market
56
County
Madera
REO / Bank Owned
No
Cross Street Address
china creek rd and rd 422
Directions
from the 41 turn right on road 426 and head out a few miles. Eventually make another right on 423 and then stay right onto road 422. Property is on the left about half a mile or so
Heating & Cooling
Window or Wall A/C
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Primary Bedroom Level
Main
# of Fireplaces
1
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Propane
Sewer / Water
Septic Tank
Solar
No
Parking Features
Carport
Carport Spaces
1
APN
066 170 013 000
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
72877
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 356155 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 393645 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 658 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1158 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` = 1652730 OR `props-main`.`id` = 1652742 OR `props-main`.`id` = 1649946 OR `props-main`.`id` = 1650012 OR `props-main`.`id` = 1674403 OR `props-main`.`id` = 1656153 OR `props-main`.`id` = 1656240 OR `props-main`.`id` = 1614050 OR `props-main`.`id` = 1676231 OR `props-main`.`id` = 1676229 OR `props-main`.`id` = 1673246 OR `props-main`.`id` = 1633507 OR `props-main`.`id` = 1651333 OR `props-main`.`id` = 1651368 OR `props-main`.`id` = 1674852 OR `props-main`.`id` = 1676178 OR `props-main`.`id` = 1674154 OR `props-main`.`id` = 1671569 OR `props-main`.`id` = 1671578 OR `props-main`.`id` = 1665802 OR `props-main`.`id` = 1622489 OR `props-main`.`id` = 1678813 OR `props-main`.`id` = 1678066 OR `props-main`.`id` = 1665957 OR `props-main`.`id` = 1626196 OR `props-main`.`id` = 1666250 OR `props-main`.`id` = 1626195 OR `props-main`.`id` = 1665948 OR `props-main`.`id` = 1651367 OR `props-main`.`id` = 1683801 OR `props-main`.`id` = 1683783 OR `props-main`.`id` = 1650669 OR `props-main`.`id` = 1661941 OR `props-main`.`id` = 1661942 OR `props-main`.`id` = 1661954 OR `props-main`.`id` = 1679689 OR `props-main`.`id` = 1679681 OR `props-main`.`id` = 1668234 OR `props-main`.`id` = 1654955 OR `props-main`.`id` = 1627895 OR `props-main`.`id` = 1627897 OR `props-main`.`id` = 1674210 OR `props-main`.`id` = 1675284 OR `props-main`.`id` = 1675295 OR `props-main`.`id` = 1652720 OR `props-main`.`id` = 1649455 OR `props-main`.`id` = 1649459 OR `props-main`.`id` = 1652449 OR `props-main`.`id` = 1674206 OR `props-main`.`id` = 1652455 OR `props-main`.`id` = 1673392 OR `props-main`.`id` = 1678542 OR `props-main`.`id` = 1683892 OR `props-main`.`id` = 1663325 OR `props-main`.`id` = 1643063 OR `props-main`.`id` = 1671702 OR `props-main`.`id` = 1671741 OR `props-main`.`id` = 1683814 OR `props-main`.`id` = 1656663 OR `props-main`.`id` = 1656662 OR `props-main`.`id` = 1622531 OR `props-main`.`id` = 1674442 OR `props-main`.`id` = 1622454 OR `props-main`.`id` = 1631943 OR `props-main`.`id` = 1666166 OR `props-main`.`id` = 1646345 OR `props-main`.`id` = 1677652 OR `props-main`.`id` = 1657752 OR `props-main`.`id` = 1678122 OR `props-main`.`id` = 1678091)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno633527' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-05' 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 Nicholas Baird, Realty Concepts, Ltd. - Clovis - nickbaird@realtyconcepts.com Last modified 1 month ago Fresno MLS last checked for updates 32 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.
