A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 427500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 472500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1877 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2377 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` = 1617327 OR `props-main`.`id` = 1622883 OR `props-main`.`id` = 1667929 OR `props-main`.`id` = 1714277 OR `props-main`.`id` = 1714276 OR `props-main`.`id` = 1667931 OR `props-main`.`id` = 1667930 OR `props-main`.`id` = 1714275 OR `props-main`.`id` = 1704658 OR `props-main`.`id` = 1716310 OR `props-main`.`id` = 1709939 OR `props-main`.`id` = 1713265 OR `props-main`.`id` = 1701696 OR `props-main`.`id` = 1716889 OR `props-main`.`id` = 1708408 OR `props-main`.`id` = 1693530 OR `props-main`.`id` = 1696476 OR `props-main`.`id` = 1709550 OR `props-main`.`id` = 1714495 OR `props-main`.`id` = 1696149 OR `props-main`.`id` = 1719094 OR `props-main`.`id` = 1719063 OR `props-main`.`id` = 1713738 OR `props-main`.`id` = 1713739 OR `props-main`.`id` = 1718628 OR `props-main`.`id` = 1709155 OR `props-main`.`id` = 1709186 OR `props-main`.`id` = 1709165 OR `props-main`.`id` = 1709169 OR `props-main`.`id` = 1702363 OR `props-main`.`id` = 1718339 OR `props-main`.`id` = 1712670 OR `props-main`.`id` = 1719758 OR `props-main`.`id` = 1709164 OR `props-main`.`id` = 1709163 OR `props-main`.`id` = 1710117 OR `props-main`.`id` = 1705116 OR `props-main`.`id` = 1714775 OR `props-main`.`id` = 1694865 OR `props-main`.`id` = 1718472 OR `props-main`.`id` = 1719089 OR `props-main`.`id` = 1719306 OR `props-main`.`id` = 1705935 OR `props-main`.`id` = 1716724 OR `props-main`.`id` = 1698061 OR `props-main`.`id` = 1695415 OR `props-main`.`id` = 1695414 OR `props-main`.`id` = 196010 OR `props-main`.`id` = 1707096 OR `props-main`.`id` = 1698962 OR `props-main`.`id` = 1704893 OR `props-main`.`id` = 1708107 OR `props-main`.`id` = 1704890 OR `props-main`.`id` = 1704894 OR `props-main`.`id` = 1701470 OR `props-main`.`id` = 1701206 OR `props-main`.`id` = 1713682 OR `props-main`.`id` = 1680643 OR `props-main`.`id` = 1714053 OR `props-main`.`id` = 1719554 OR `props-main`.`id` = 1697035 OR `props-main`.`id` = 1713512 OR `props-main`.`id` = 1713686 OR `props-main`.`id` = 1714589 OR `props-main`.`id` = 1714694 OR `props-main`.`id` = 1719524 OR `props-main`.`id` = 1708108 OR `props-main`.`id` = 1713684 OR `props-main`.`id` = 1696703 OR `props-main`.`id` = 1688973 OR `props-main`.`id` = 1719549 OR `props-main`.`id` = 1719735 OR `props-main`.`id` = 1719553 OR `props-main`.`id` = 1719749 OR `props-main`.`id` = 1706884 OR `props-main`.`id` = 1672896 OR `props-main`.`id` = 1714284 OR `props-main`.`id` = 1714782 OR `props-main`.`id` = 1717009 OR `props-main`.`id` = 1711417 OR `props-main`.`id` = 1041230 OR `props-main`.`id` = 1642756 OR `props-main`.`id` = 1719688 OR `props-main`.`id` = 1719681 OR `props-main`.`id` = 1642913 OR `props-main`.`id` = 1712413 OR `props-main`.`id` = 1687775 OR `props-main`.`id` = 1677522 OR `props-main`.`id` = 1718290 OR `props-main`.`id` = 1718273 OR `props-main`.`id` = 1715971 OR `props-main`.`id` = 1715954 OR `props-main`.`id` = 1708251 OR `props-main`.`id` = 1718403 OR `props-main`.`id` = 1693646 OR `props-main`.`id` = 1717945 OR `props-main`.`id` = 1718593 OR `props-main`.`id` = 1718415 OR `props-main`.`id` = 1697842 OR `props-main`.`id` = 1717574 OR `props-main`.`id` = 1633654 OR `props-main`.`id` = 1694963 OR `props-main`.`id` = 1705830 OR `props-main`.`id` = 291212 OR `props-main`.`id` = 1715692 OR `props-main`.`id` = 1717663 OR `props-main`.`id` = 788148 OR `props-main`.`id` = 1719680 OR `props-main`.`id` = 1693974 OR `props-main`.`id` = 1694679 OR `props-main`.`id` = 1693859 OR `props-main`.`id` = 77474 OR `props-main`.`id` = 1719759 OR `props-main`.`id` = 1718835 OR `props-main`.`id` = 1717387 OR `props-main`.`id` = 1710235 OR `props-main`.`id` = 1711132 OR `props-main`.`id` = 1711127 OR `props-main`.`id` = 1696741 OR `props-main`.`id` = 1703177 OR `props-main`.`id` = 1703165 OR `props-main`.`id` = 1709459)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41052327' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-04' 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: