With over 807 feet of Highway 41frontage, located between two signalized intersections and immediately across the highway from Chukchansi Crossing, this property offers 13.59 acres of impressive potential. Currently, zoned as residential (ARF - Agricultural Rural Foothill District), the property includes one 1370 sq. ft., 3 bedroom, 2 bath residence and two mobile homes. Each structure requires varying degrees of refurbishment. The property is located adjacent to commercially zoned properties. Alternatively, the future of this property could lie in strategic commercial redevelopment capitalizing on its proximity to Chukchansi Gold Resort Hotel and Casino. Think toward the future and 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
20
Cumulative Days On London
20
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` = 1704425 OR `props-main`.`id` = 1720089 OR `props-main`.`id` = 1711484 OR `props-main`.`id` = 1711502 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` = 1709430 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` = 1736705 OR `props-main`.`id` = 1736487 OR `props-main`.`id` = 1735470 OR `props-main`.`id` = 1738715 OR `props-main`.`id` = 1738692 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` = 1665648 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` = 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)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno650075' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-26' 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 1 week ago Fresno MLS last checked for updates 24 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.
