A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 389500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 430500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.25' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1253 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1753 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` = 1715536 OR `props-main`.`id` = 1715541 OR `props-main`.`id` = 1686106 OR `props-main`.`id` = 1713898 OR `props-main`.`id` = 1698144 OR `props-main`.`id` = 1712365 OR `props-main`.`id` = 1713929 OR `props-main`.`id` = 1703702 OR `props-main`.`id` = 1685845 OR `props-main`.`id` = 1689104 OR `props-main`.`id` = 1717830 OR `props-main`.`id` = 1718766 OR `props-main`.`id` = 1715366 OR `props-main`.`id` = 1702780 OR `props-main`.`id` = 1690281 OR `props-main`.`id` = 1712646 OR `props-main`.`id` = 1711298 OR `props-main`.`id` = 1711291 OR `props-main`.`id` = 1711300 OR `props-main`.`id` = 1711292 OR `props-main`.`id` = 1718890 OR `props-main`.`id` = 1715079 OR `props-main`.`id` = 1716770 OR `props-main`.`id` = 1715204 OR `props-main`.`id` = 1715935 OR `props-main`.`id` = 1706794 OR `props-main`.`id` = 1712593 OR `props-main`.`id` = 1715126 OR `props-main`.`id` = 1650946 OR `props-main`.`id` = 1707093 OR `props-main`.`id` = 1717022 OR `props-main`.`id` = 1678402 OR `props-main`.`id` = 1707025 OR `props-main`.`id` = 1704319 OR `props-main`.`id` = 1704216 OR `props-main`.`id` = 1717895 OR `props-main`.`id` = 1717914 OR `props-main`.`id` = 1712887 OR `props-main`.`id` = 1718346 OR `props-main`.`id` = 1717728 OR `props-main`.`id` = 1713918 OR `props-main`.`id` = 1698173 OR `props-main`.`id` = 1708188 OR `props-main`.`id` = 1718974 OR `props-main`.`id` = 1686098 OR `props-main`.`id` = 1718378 OR `props-main`.`id` = 1718195 OR `props-main`.`id` = 1718197 OR `props-main`.`id` = 1718854 OR `props-main`.`id` = 1718157 OR `props-main`.`id` = 1717693 OR `props-main`.`id` = 1712569 OR `props-main`.`id` = 1716221 OR `props-main`.`id` = 1716371 OR `props-main`.`id` = 1716378 OR `props-main`.`id` = 1715015 OR `props-main`.`id` = 1704019 OR `props-main`.`id` = 1703173 OR `props-main`.`id` = 1715047 OR `props-main`.`id` = 1701591 OR `props-main`.`id` = 1712570 OR `props-main`.`id` = 1701592 OR `props-main`.`id` = 1703329 OR `props-main`.`id` = 1718159 OR `props-main`.`id` = 1713626 OR `props-main`.`id` = 1718152 OR `props-main`.`id` = 1711334 OR `props-main`.`id` = 1713653 OR `props-main`.`id` = 1718844 OR `props-main`.`id` = 1704510 OR `props-main`.`id` = 1713824 OR `props-main`.`id` = 1718881 OR `props-main`.`id` = 1704109 OR `props-main`.`id` = 1718638 OR `props-main`.`id` = 1718200 OR `props-main`.`id` = 1717943 OR `props-main`.`id` = 1717970 OR `props-main`.`id` = 1704073 OR `props-main`.`id` = 1704406 OR `props-main`.`id` = 1715155 OR `props-main`.`id` = 1717878 OR `props-main`.`id` = 1717887 OR `props-main`.`id` = 1716646 OR `props-main`.`id` = 1657899 OR `props-main`.`id` = 1716582 OR `props-main`.`id` = 1715682 OR `props-main`.`id` = 1718904 OR `props-main`.`id` = 1717026 OR `props-main`.`id` = 1715356 OR `props-main`.`id` = 1706122 OR `props-main`.`id` = 1706867 OR `props-main`.`id` = 1708366 OR `props-main`.`id` = 1687411 OR `props-main`.`id` = 1701240 OR `props-main`.`id` = 1697177 OR `props-main`.`id` = 1709503 OR `props-main`.`id` = 1712366 OR `props-main`.`id` = 1716660 OR `props-main`.`id` = 1716657 OR `props-main`.`id` = 1716670 OR `props-main`.`id` = 1716671 OR `props-main`.`id` = 1716682 OR `props-main`.`id` = 1716681 OR `props-main`.`id` = 1718438 OR `props-main`.`id` = 1708271 OR `props-main`.`id` = 1713776 OR `props-main`.`id` = 1715642 OR `props-main`.`id` = 1715045 OR `props-main`.`id` = 1345585 OR `props-main`.`id` = 1693526)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno629072' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-31' 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();

CAME_FROM_PROP_SITE: