A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 427405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 472395 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) >= 1400 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1900 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` = 1762740 OR `props-main`.`id` = 1762745 OR `props-main`.`id` = 1742095 OR `props-main`.`id` = 1726241 OR `props-main`.`id` = 1762252 OR `props-main`.`id` = 1746398 OR `props-main`.`id` = 1729166 OR `props-main`.`id` = 1745198 OR `props-main`.`id` = 1709531 OR `props-main`.`id` = 1747160 OR `props-main`.`id` = 1725928 OR `props-main`.`id` = 1758248 OR `props-main`.`id` = 1755978 OR `props-main`.`id` = 1540736 OR `props-main`.`id` = 1762113 OR `props-main`.`id` = 1701220 OR `props-main`.`id` = 1759045 OR `props-main`.`id` = 1758861 OR `props-main`.`id` = 1737431 OR `props-main`.`id` = 1755271 OR `props-main`.`id` = 1763017 OR `props-main`.`id` = 1723074 OR `props-main`.`id` = 1729973 OR `props-main`.`id` = 1762934 OR `props-main`.`id` = 1725083 OR `props-main`.`id` = 1744435 OR `props-main`.`id` = 1727132 OR `props-main`.`id` = 1737047 OR `props-main`.`id` = 1695479 OR `props-main`.`id` = 1719349 OR `props-main`.`id` = 1695365 OR `props-main`.`id` = 1695493 OR `props-main`.`id` = 1745750 OR `props-main`.`id` = 1746926 OR `props-main`.`id` = 1746923 OR `props-main`.`id` = 1746949 OR `props-main`.`id` = 1750492 OR `props-main`.`id` = 1722300 OR `props-main`.`id` = 1757266 OR `props-main`.`id` = 1759556 OR `props-main`.`id` = 1759555 OR `props-main`.`id` = 1730735 OR `props-main`.`id` = 1737765)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno648125' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-19' 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();
2
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$450,000
3
2
1,697
0.21
1506 W 5th St
Madera, CA 93637
$449,999
4
3
1,862
0.12
1583 Seneca Dr
Madera, CA 93637
Last modified 2 months ago Fresno MLS last checked for updates 41 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.
