A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 123500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 136500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1161 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1661 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` = 1078072 OR `props-main`.`id` = 1702939 OR `props-main`.`id` = 1702920 OR `props-main`.`id` = 1714627 OR `props-main`.`id` = 1730748 OR `props-main`.`id` = 1730840 OR `props-main`.`id` = 1113258 OR `props-main`.`id` = 1717756 OR `props-main`.`id` = 1717748 OR `props-main`.`id` = 588889 OR `props-main`.`id` = 159004 OR `props-main`.`id` = 72047 OR `props-main`.`id` = 1727719 OR `props-main`.`id` = 1728599 OR `props-main`.`id` = 1728309 OR `props-main`.`id` = 1738219 OR `props-main`.`id` = 1720310 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 1745126 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 1723863 OR `props-main`.`id` = 1745256 OR `props-main`.`id` = 281861 OR `props-main`.`id` = 1723150 OR `props-main`.`id` = 1717926 OR `props-main`.`id` = 1740557 OR `props-main`.`id` = 764482 OR `props-main`.`id` = 1731188 OR `props-main`.`id` = 301259 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1723302 OR `props-main`.`id` = 1721065 OR `props-main`.`id` = 1723280 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1746430 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1723294 OR `props-main`.`id` = 1724484 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 1723293 OR `props-main`.`id` = 1743898 OR `props-main`.`id` = 1742833 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1744330 OR `props-main`.`id` = 1744263 OR `props-main`.`id` = 1736031 OR `props-main`.`id` = 1723297 OR `props-main`.`id` = 1740956 OR `props-main`.`id` = 1732522 OR `props-main`.`id` = 1726751 OR `props-main`.`id` = 1715714 OR `props-main`.`id` = 1671761 OR `props-main`.`id` = 1734911 OR `props-main`.`id` = 1737000 OR `props-main`.`id` = 1727284 OR `props-main`.`id` = 1725386 OR `props-main`.`id` = 1723279 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1740984 OR `props-main`.`id` = 1725250 OR `props-main`.`id` = 1724879 OR `props-main`.`id` = 1727965 OR `props-main`.`id` = 1737493 OR `props-main`.`id` = 1746086 OR `props-main`.`id` = 1744379 OR `props-main`.`id` = 1711217 OR `props-main`.`id` = 1734790 OR `props-main`.`id` = 1702479 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1726183 OR `props-main`.`id` = 1732098 OR `props-main`.`id` = 1738351 OR `props-main`.`id` = 1738699 OR `props-main`.`id` = 1728911 OR `props-main`.`id` = 1732524 OR `props-main`.`id` = 1742756 OR `props-main`.`id` = 1742406 OR `props-main`.`id` = 1744002 OR `props-main`.`id` = 1742755 OR `props-main`.`id` = 1742710 OR `props-main`.`id` = 1742766 OR `props-main`.`id` = 1732735 OR `props-main`.`id` = 1739111 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 175921 OR `props-main`.`id` = 1740651 OR `props-main`.`id` = 1734262 OR `props-main`.`id` = 1739301 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1714397 OR `props-main`.`id` = 1731191 OR `props-main`.`id` = 1731165 OR `props-main`.`id` = 1731179 OR `props-main`.`id` = 1726708 OR `props-main`.`id` = 1737256 OR `props-main`.`id` = 1736193 OR `props-main`.`id` = 1737170 OR `props-main`.`id` = 1726817 OR `props-main`.`id` = 1688816 OR `props-main`.`id` = 1717457 OR `props-main`.`id` = 1742751 OR `props-main`.`id` = 1746267 OR `props-main`.`id` = 1746248 OR `props-main`.`id` = 1746258 OR `props-main`.`id` = 342762 OR `props-main`.`id` = 1707011 OR `props-main`.`id` = 1716394 OR `props-main`.`id` = 1694847)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226085476' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-07' 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: