A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 546250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 603750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1734 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2234 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` = 1687300 OR `props-main`.`id` = 1679505 OR `props-main`.`id` = 1690747 OR `props-main`.`id` = 1666285 OR `props-main`.`id` = 1679767 OR `props-main`.`id` = 1687331 OR `props-main`.`id` = 1688493 OR `props-main`.`id` = 1685880 OR `props-main`.`id` = 1686989 OR `props-main`.`id` = 1660890 OR `props-main`.`id` = 1686299 OR `props-main`.`id` = 1676299 OR `props-main`.`id` = 1689645 OR `props-main`.`id` = 1680044 OR `props-main`.`id` = 1650190 OR `props-main`.`id` = 1671188 OR `props-main`.`id` = 1671191 OR `props-main`.`id` = 1671194 OR `props-main`.`id` = 1667675 OR `props-main`.`id` = 1677584 OR `props-main`.`id` = 1689136 OR `props-main`.`id` = 1679396 OR `props-main`.`id` = 1658353)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno613058' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-23' 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();
1
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$560,000
4
3
2,196
1.24
35580 John Albert Dr
Madera, CA 93636
Courtesy of Robert Smith, Realty Concepts, Ltd. - Fresno Last modified 1 year, 4 months ago Fresno MLS last checked for updates 7 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.
