This 3 bed, 2 bath home is located in Ahwahnee, just 25 miles to the South Gate of Yosemite National Park. The property has been heavily lived in and will require clean-up, hauling, and renovation, but the potential is undeniable. Pick your cliche...Investor Special, Hidden Gem, Fixer Upper...Whatever you want to call it, bring your contractor, bring your trailer and bring your vision...just be ready to work to turn it back into something special. This is a Cash Only sale
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1964
Region
Foothill
Unique Conditions
Probate
# of Stories
Single Story
Price Per Square Foot
$119
Price Per Acre
$183,761
Days On Market
0
Cumulative Days On Market
0
County
Madera
REO / Bank Owned
No
Cross Street Address
Hwy 49
Directions
wy 41 to Hwy 49. Right on Rd 621 to address on Right.
Heating & Cooling
Other
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Primary Bedroom Level
Main
Bath Features
Tub/Shower
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Not Applicable
Solar
No
Parking Features
Existing RV Parking
APN
055 102 006 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
Wasuma
School Type 3
Grade School
School Name 3
Wasuma
Seller Will Consider
Cash
72877
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 204250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 225750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1558 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2058 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` = 1685652 OR `props-main`.`id` = 1685657 OR `props-main`.`id` = 1683786 OR `props-main`.`id` = 1649970 OR `props-main`.`id` = 1649939 OR `props-main`.`id` = 1652674 OR `props-main`.`id` = 1685769 OR `props-main`.`id` = 1622615 OR `props-main`.`id` = 1650742 OR `props-main`.`id` = 1650743 OR `props-main`.`id` = 1646938 OR `props-main`.`id` = 1666178 OR `props-main`.`id` = 1685358 OR `props-main`.`id` = 1685382 OR `props-main`.`id` = 1668479 OR `props-main`.`id` = 1668859 OR `props-main`.`id` = 1679341 OR `props-main`.`id` = 1611781 OR `props-main`.`id` = 1611780 OR `props-main`.`id` = 1666256 OR `props-main`.`id` = 1651918 OR `props-main`.`id` = 1646146 OR `props-main`.`id` = 1686974 OR `props-main`.`id` = 1664210 OR `props-main`.`id` = 1686922 OR `props-main`.`id` = 1686043 OR `props-main`.`id` = 1686688 OR `props-main`.`id` = 1673997 OR `props-main`.`id` = 1674621 OR `props-main`.`id` = 1653133 OR `props-main`.`id` = 1682052 OR `props-main`.`id` = 1678525 OR `props-main`.`id` = 1678534 OR `props-main`.`id` = 1687223 OR `props-main`.`id` = 1658817 OR `props-main`.`id` = 1658790 OR `props-main`.`id` = 1673165 OR `props-main`.`id` = 1673159 OR `props-main`.`id` = 1687202 OR `props-main`.`id` = 1671600 OR `props-main`.`id` = 1659215 OR `props-main`.`id` = 1687251 OR `props-main`.`id` = 1679666 OR `props-main`.`id` = 1679602 OR `props-main`.`id` = 1679606 OR `props-main`.`id` = 1674110 OR `props-main`.`id` = 1674063 OR `props-main`.`id` = 1678297 OR `props-main`.`id` = 1678304 OR `props-main`.`id` = 1674578 OR `props-main`.`id` = 1660701 OR `props-main`.`id` = 1611124 OR `props-main`.`id` = 1611151 OR `props-main`.`id` = 1611455 OR `props-main`.`id` = 1665848)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno637594' 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 Kristin Bateman, London Properties, Ltd. - kbateman@londonproperties.com Last modified 1 day 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.
