Donna Pride559.642.8373dpride@londonproperties.comEmail Agent
Property Description
This is a wonderful investment opportunity!!!! There is no real value in the home, it is a fixer. However, the property and the views in the back are quite impressive. The whole property is usable and plenty of room for all of the toys, animals, and the kids to run around. It is a nice location being only a few minutes to the town of Oakhurst or to the Forks side of Bass Lake. With love and imagination the possibilities are endless!!!!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1955
Region
Foothill
# of Stories
Two
Price Per Square Foot
$208
Price Per Acre
$58,275
Days On Market
21
Cumulative Days On Market
21
County
Madera
REO / Bank Owned
No
Cross Street Address
Black
Directions
From Oakhurst head up Rd 426 to the property on the right.
Heating & Cooling
None
Laundry
None
Roofing
Composition
Foundation
Concrete
Primary Bedroom Level
Upper
Exterior
Wood
Pool
No
Pool
No
Gas & Electric
Public Utilities, Propane
Sewer / Water
Septic Tank, Private Well
Solar
No
Parking Features
Existing RV Parking
Garage Type
Detached
Garage Spaces
1
APN
066 430 043
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) >= 237500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 262500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 950 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1450 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` = 1676231 OR `props-main`.`id` = 1676229 OR `props-main`.`id` = 1673246 OR `props-main`.`id` = 1687436 OR `props-main`.`id` = 1687156 OR `props-main`.`id` = 1633507 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` = 1687181 OR `props-main`.`id` = 1687158 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` = 1686188 OR `props-main`.`id` = 1686192 OR `props-main`.`id` = 1663325 OR `props-main`.`id` = 1683814 OR `props-main`.`id` = 1656663 OR `props-main`.`id` = 1656662 OR `props-main`.`id` = 1674442 OR `props-main`.`id` = 1686999 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` = 1686607 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` = 1645396 OR `props-main`.`id` = 1655023 OR `props-main`.`id` = 1686257 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` = 1685560 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)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno628779' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-28' 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 Donna Pride, London Properties, Ltd. - dpride@sti.net Last modified 4 months ago Fresno MLS last checked for updates 36 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.
