Indian Lakes Estates, borders Chukchansi Gold Resort & Casino in Madera County. Near Coarsegold California and approximately 30 minutes to Fresno. A Foothill Community at approximately 2200 ft. elevation. This home suffered an interior flood, Damaged & Mold. Sold As Is with Cash Offers Only.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2002
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$123
Price Per Acre
$160,000
Days On Market
0
Cumulative Days On Market
0
County
Madera
REO / Bank Owned
Yes
Cross Street Address
Hwy 41/Road 417
Directions
Highway 41 & Road 417. Right on Delaware Rd.
Style
Ranch
Heating & Cooling
Central Cooling
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Kitchen
Built In Range/Oven, Dishwasher, Microwave
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Flooring
Carpet, Laminate
Exterior
Stucco
Pool
No
Pool
No
Patio Features
Uncovered
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Septic Tank
Solar
No
Garage Type
Detached
Garage Spaces
2
APN
054 433 006 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) >= 152000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 168000 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) >= 1055 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1555 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` = 1703154 OR `props-main`.`id` = 1666385 OR `props-main`.`id` = 1687640 OR `props-main`.`id` = 1695863 OR `props-main`.`id` = 1695910 OR `props-main`.`id` = 1696520 OR `props-main`.`id` = 1687540 OR `props-main`.`id` = 1665733 OR `props-main`.`id` = 1687541 OR `props-main`.`id` = 1665734 OR `props-main`.`id` = 1703560 OR `props-main`.`id` = 1681464 OR `props-main`.`id` = 1681472 OR `props-main`.`id` = 1702749 OR `props-main`.`id` = 1692012 OR `props-main`.`id` = 1695677 OR `props-main`.`id` = 1695674 OR `props-main`.`id` = 1681247 OR `props-main`.`id` = 1691365 OR `props-main`.`id` = 1691396 OR `props-main`.`id` = 1696984 OR `props-main`.`id` = 1697260 OR `props-main`.`id` = 1697269 OR `props-main`.`id` = 1676602 OR `props-main`.`id` = 1676386 OR `props-main`.`id` = 1701190 OR `props-main`.`id` = 1696307 OR `props-main`.`id` = 1665689 OR `props-main`.`id` = 1665648 OR `props-main`.`id` = 1666355 OR `props-main`.`id` = 1687633)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno642488' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-21' 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 Na Landseadal, Rod Aluisi Real Estate - [email protected] Last modified 21 hours ago Fresno MLS last checked for updates 28 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.
