Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/crmls/FR26070942/37777-China-Creek-Rd/Oakhurst/https://www.londonproperties.com/images/props/crmls/full/FR26070942.jpgLondon Properties Oakhurst Real Estate | 37777 China Creek Rd
The Deal is in The Details! With a beautiful redwood front porch, hickory wood floors, Brazilian Cherry countertops, Cherry Wood cabinets and solid wood doors; this home is loaded with custom upgrades. The gourmet kitchen is made for a chef (literally) with a beautiful Wolf stove, oven and range and a stainless steel dishwasher. The home also features a couple of bonus rooms/spaces that you will not find in the gross living area. The first is the upstairs that can be accessed via the spiral staircase in the living room. In addition, there is a usable basement that can be accessed from the outside of the home. The roof, exterior and interior paint have all been done within the last 3 years. This traditional ranch homestead is privately located on very usable 5 acres with mature trees, lots of fencing and a circle driveway. The detached garage/shop has plenty of space for all your toys and equipment. Schedule a tour to see this home today!
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1951
Year Built Source
Public Records
Special Listing Conditions
Standard
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
1
Price Per Square Foot
$245
Days On London
0
Cumulative Days On London
0
County Or Parish
Madera
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
Yes
Heating Y/N
Yes
Directions
Take Road 426 to Road 423, Continue Straight onto China Creek. Stay on China Creek until you cross the one lane bridge. Home will be the 3rd driveway on your left.
Architectural Style
Ranch
Room Type
Primary Bedroom, Laundry, Bonus Room, All Bedrooms Down, Main Floor Primary Bedroom, Foyer, Kitchen, Living Room, Main Floor Bedroom, Family Room, Loft, Primary Bathroom
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 402800 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 445200 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) >= 1482 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1982 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` = 1697170 OR `props-main`.`id` = 1693787 OR `props-main`.`id` = 1693778 OR `props-main`.`id` = 1595385 OR `props-main`.`id` = 1673246 OR `props-main`.`id` = 1719335 OR `props-main`.`id` = 1719406 OR `props-main`.`id` = 1720512 OR `props-main`.`id` = 1720481 OR `props-main`.`id` = 1708476 OR `props-main`.`id` = 1708471 OR `props-main`.`id` = 1665802 OR `props-main`.`id` = 1687546 OR `props-main`.`id` = 1665957 OR `props-main`.`id` = 1687583 OR `props-main`.`id` = 1704571 OR `props-main`.`id` = 1665948 OR `props-main`.`id` = 1687582 OR `props-main`.`id` = 1679689 OR `props-main`.`id` = 1679681 OR `props-main`.`id` = 1654955 OR `props-main`.`id` = 1717206 OR `props-main`.`id` = 1717024 OR `props-main`.`id` = 1713262 OR `props-main`.`id` = 1713264 OR `props-main`.`id` = 1655023 OR `props-main`.`id` = 1684949 OR `props-main`.`id` = 1684969 OR `props-main`.`id` = 1649455 OR `props-main`.`id` = 1649459 OR `props-main`.`id` = 1673392 OR `props-main`.`id` = 1693731 OR `props-main`.`id` = 1716688 OR `props-main`.`id` = 1716703 OR `props-main`.`id` = 1711360 OR `props-main`.`id` = 1702816 OR `props-main`.`id` = 1702819 OR `props-main`.`id` = 1705229 OR `props-main`.`id` = 1716257 OR `props-main`.`id` = 1716235 OR `props-main`.`id` = 1717212 OR `props-main`.`id` = 1703772 OR `props-main`.`id` = 1719818 OR `props-main`.`id` = 1705648 OR `props-main`.`id` = 1692450 OR `props-main`.`id` = 1692558 OR `props-main`.`id` = 1694054)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsFR26070942' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-06' 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
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.
