A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 902500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 997500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2925 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3425 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` = 1646767 OR `props-main`.`id` = 1682283 OR `props-main`.`id` = 1690155 OR `props-main`.`id` = 1687943 OR `props-main`.`id` = 1687870 OR `props-main`.`id` = 1688917 OR `props-main`.`id` = 1688921 OR `props-main`.`id` = 588889 OR `props-main`.`id` = 1689931 OR `props-main`.`id` = 1689932 OR `props-main`.`id` = 1064604 OR `props-main`.`id` = 159004 OR `props-main`.`id` = 72047 OR `props-main`.`id` = 1687150 OR `props-main`.`id` = 1654918 OR `props-main`.`id` = 1687171 OR `props-main`.`id` = 1689941 OR `props-main`.`id` = 1676251 OR `props-main`.`id` = 1689801 OR `props-main`.`id` = 1689687 OR `props-main`.`id` = 1687278 OR `props-main`.`id` = 1690034 OR `props-main`.`id` = 1687269 OR `props-main`.`id` = 1677931 OR `props-main`.`id` = 1683767 OR `props-main`.`id` = 1684475 OR `props-main`.`id` = 1684473 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1687248 OR `props-main`.`id` = 1681454 OR `props-main`.`id` = 1687267 OR `props-main`.`id` = 1680386 OR `props-main`.`id` = 1680392 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 1678715 OR `props-main`.`id` = 1686457 OR `props-main`.`id` = 1686562 OR `props-main`.`id` = 1679715 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 1678728 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 1675208 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 1688612 OR `props-main`.`id` = 1688631 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 1680711 OR `props-main`.`id` = 1682226 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1689533 OR `props-main`.`id` = 1682874 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1684138 OR `props-main`.`id` = 1673216 OR `props-main`.`id` = 1673221 OR `props-main`.`id` = 1686760 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1689674 OR `props-main`.`id` = 1689667 OR `props-main`.`id` = 1690040 OR `props-main`.`id` = 1644663 OR `props-main`.`id` = 1642699 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1687151 OR `props-main`.`id` = 521102)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225120832' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-17' 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: