Donna Pride559.642.8373dpride@londonproperties.comEmail Agent
Property Description
Oakhurst's custom-built home offers unparalleled comfort, beauty, and a connection to the nature. With 4 bedroom and 3 bathrooms, and three living area, it provides ample room for entertaining and relaxation. There is an large deck that invites the nature of your surrounding to be appreciated. With the 1.39 acres of land, it has the potential to be a multipurpose property. This is currently being used as an Airbnb. Please request income and understand an appointment is a must.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1993
Region
Mountain
# of Stories
Two, Multi/Split
Price Per Square Foot
$262
Days On Market
12
Cumulative Days On Market
120
County
Madera
Reports Available
NHD, Prelim Title Report
REO / Bank Owned
No
Cross Street Address
spook lane
Directions
CA 41, south on road 426, east on spook land, east on Moonray lane property is on the right.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Composition
Foundation
Both
Kitchen
Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Eating Area, Breakfast Bar, Refrigerator
Dining Room Features
Formal, Living Room/Area, Family Room/Area
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Shower
Extra Rooms
Game Room
Flooring
Carpet, Laminate
# of Fireplaces
1
Fireplace Type
Masonry
Exterior
Wood
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Energy Efficiency
Dual Pane Windows
Solar
Yes
Solar Type
Power Purchase AGMT
Garage Type
Attached
Garage Spaces
3
APN
065 142 032 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
72877
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 660250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 729750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2405 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2905 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` = 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` = 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` = 1684949 OR `props-main`.`id` = 1684969 OR `props-main`.`id` = 1649455 OR `props-main`.`id` = 1649459 OR `props-main`.`id` = 1684140 OR `props-main`.`id` = 1652449 OR `props-main`.`id` = 1674206 OR `props-main`.`id` = 1652455 OR `props-main`.`id` = 1677858 OR `props-main`.`id` = 1673392 OR `props-main`.`id` = 1678542 OR `props-main`.`id` = 1663325 OR `props-main`.`id` = 1643063 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` = 1681594 OR `props-main`.`id` = 1681611 OR `props-main`.`id` = 1684616 OR `props-main`.`id` = 1677160 OR `props-main`.`id` = 1677211 OR `props-main`.`id` = 1655004 OR `props-main`.`id` = 1679453 OR `props-main`.`id` = 1683252 OR `props-main`.`id` = 1679458 OR `props-main`.`id` = 1683265 OR `props-main`.`id` = 1654966 OR `props-main`.`id` = 1684184 OR `props-main`.`id` = 1684196 OR `props-main`.`id` = 1673104 OR `props-main`.`id` = 1673106 OR `props-main`.`id` = 1677652 OR `props-main`.`id` = 1684109 OR `props-main`.`id` = 1684613 OR `props-main`.`id` = 1657752 OR `props-main`.`id` = 1673013 OR `props-main`.`id` = 1645396 OR `props-main`.`id` = 1638870 OR `props-main`.`id` = 1655023 OR `props-main`.`id` = 1673677 OR `props-main`.`id` = 1671575 OR `props-main`.`id` = 1638512 OR `props-main`.`id` = 1667500 OR `props-main`.`id` = 1619284 OR `props-main`.`id` = 1663715 OR `props-main`.`id` = 1668424 OR `props-main`.`id` = 1668707 OR `props-main`.`id` = 1668699 OR `props-main`.`id` = 1639830 OR `props-main`.`id` = 1619294 OR `props-main`.`id` = 1638533 OR `props-main`.`id` = 1680246 OR `props-main`.`id` = 1657135 OR `props-main`.`id` = 1655920 OR `props-main`.`id` = 1622608 OR `props-main`.`id` = 1613594 OR `props-main`.`id` = 1622498 OR `props-main`.`id` = 1636751 OR `props-main`.`id` = 1667484 OR `props-main`.`id` = 1667579 OR `props-main`.`id` = 1685356 OR `props-main`.`id` = 1674714 OR `props-main`.`id` = 1674821 OR `props-main`.`id` = 1622491)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno636466' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-15' 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();
1
Similar Properties
$699,900
5
4
2,680
2.54
50689 Critter Creek Ln
Oakhurst, CA 93644
Courtesy of Lysha Payseno, Valley Land & Investment Co. - lyshaapay@gmail.com Last modified 1 week ago Fresno MLS last checked for updates 23 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.
