This property offers 13.5 acres right off Hwy 41. Its surrounded by commercial property. It backs up against the creek. It has al lot of potential. Come with a vision.
Property Type
Residential
Property Subtype 1
Single Family Residence
Property Subtype 2
Mobile Home
Year Built
1989
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$613
Price Per Acre
$61,810
Days On London
0
Cumulative Days On London
0
County
Madera
REO / Bank Owned
No
Cross Street Address
Hwy 41
Directions
Left off hwy 41
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Primary Bedroom Level
Main
Exterior
Wood
Pool
No
Pool
No
Gas & Electric
Propane
Sewer / Water
Private Well
Solar
No
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
1
APN
054 313 023 000
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Coarsegold
School Type 3
Grade School
School Name 3
Coarsegold
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 798000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 882000 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) >= 1120 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1620 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` = 1622991 OR `props-main`.`id` = 1731309 OR `props-main`.`id` = 1731485 OR `props-main`.`id` = 1731525 OR `props-main`.`id` = 1731699 OR `props-main`.`id` = 1704425 OR `props-main`.`id` = 1731430 OR `props-main`.`id` = 1720089 OR `props-main`.`id` = 1711484 OR `props-main`.`id` = 1711502 OR `props-main`.`id` = 1731465 OR `props-main`.`id` = 1714393 OR `props-main`.`id` = 1706720 OR `props-main`.`id` = 1706689 OR `props-main`.`id` = 1665733 OR `props-main`.`id` = 1665734 OR `props-main`.`id` = 1687540 OR `props-main`.`id` = 1687541 OR `props-main`.`id` = 1731464 OR `props-main`.`id` = 1709430 OR `props-main`.`id` = 1733373 OR `props-main`.`id` = 1733161 OR `props-main`.`id` = 1720783 OR `props-main`.`id` = 1711503 OR `props-main`.`id` = 1711512 OR `props-main`.`id` = 1717404 OR `props-main`.`id` = 1719738 OR `props-main`.`id` = 1734080 OR `props-main`.`id` = 1733374 OR `props-main`.`id` = 1733314 OR `props-main`.`id` = 1681245 OR `props-main`.`id` = 1687501 OR `props-main`.`id` = 1722178 OR `props-main`.`id` = 1725484 OR `props-main`.`id` = 1722419 OR `props-main`.`id` = 1725498 OR `props-main`.`id` = 1723235 OR `props-main`.`id` = 1690456 OR `props-main`.`id` = 1687556 OR `props-main`.`id` = 1722179 OR `props-main`.`id` = 1665689 OR `props-main`.`id` = 1731337 OR `props-main`.`id` = 1665648 OR `props-main`.`id` = 1731530 OR `props-main`.`id` = 1717119 OR `props-main`.`id` = 1717142 OR `props-main`.`id` = 1728448 OR `props-main`.`id` = 1733418 OR `props-main`.`id` = 1733412 OR `props-main`.`id` = 1732729 OR `props-main`.`id` = 1725898 OR `props-main`.`id` = 1725891 OR `props-main`.`id` = 1732706 OR `props-main`.`id` = 1714829 OR `props-main`.`id` = 1724827 OR `props-main`.`id` = 1723573 OR `props-main`.`id` = 1731638)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno650075' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-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
Last modified 2 hours ago Fresno MLS last checked for updates 4 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.
