A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 327750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 362250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 638 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1138 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` = 1714350 OR `props-main`.`id` = 1699060 OR `props-main`.`id` = 1723143 OR `props-main`.`id` = 1721110 OR `props-main`.`id` = 1700083 OR `props-main`.`id` = 1724260 OR `props-main`.`id` = 1724277 OR `props-main`.`id` = 1704117 OR `props-main`.`id` = 1718874 OR `props-main`.`id` = 1709553 OR `props-main`.`id` = 1715937 OR `props-main`.`id` = 1715825 OR `props-main`.`id` = 1720669 OR `props-main`.`id` = 1724943 OR `props-main`.`id` = 1717586 OR `props-main`.`id` = 1718915 OR `props-main`.`id` = 1714442 OR `props-main`.`id` = 1714507 OR `props-main`.`id` = 1714215 OR `props-main`.`id` = 1720687 OR `props-main`.`id` = 1721598 OR `props-main`.`id` = 1720268 OR `props-main`.`id` = 1724251 OR `props-main`.`id` = 1724242 OR `props-main`.`id` = 1714305 OR `props-main`.`id` = 1723275 OR `props-main`.`id` = 1722016 OR `props-main`.`id` = 1722023 OR `props-main`.`id` = 1717281 OR `props-main`.`id` = 1724689 OR `props-main`.`id` = 1724254 OR `props-main`.`id` = 1681376 OR `props-main`.`id` = 1714322 OR `props-main`.`id` = 1721700 OR `props-main`.`id` = 1724822 OR `props-main`.`id` = 1723705 OR `props-main`.`id` = 1721292 OR `props-main`.`id` = 1713155 OR `props-main`.`id` = 1724999 OR `props-main`.`id` = 1722686 OR `props-main`.`id` = 1714764 OR `props-main`.`id` = 1722687 OR `props-main`.`id` = 1718929 OR `props-main`.`id` = 1722688 OR `props-main`.`id` = 1718216 OR `props-main`.`id` = 1720697 OR `props-main`.`id` = 1714262 OR `props-main`.`id` = 1714263 OR `props-main`.`id` = 1714264 OR `props-main`.`id` = 1724872 OR `props-main`.`id` = 1714372 OR `props-main`.`id` = 1724355 OR `props-main`.`id` = 1723216 OR `props-main`.`id` = 1724942 OR `props-main`.`id` = 1724319 OR `props-main`.`id` = 1717511 OR `props-main`.`id` = 1722882 OR `props-main`.`id` = 1724679 OR `props-main`.`id` = 1723551 OR `props-main`.`id` = 1724222 OR `props-main`.`id` = 1698031 OR `props-main`.`id` = 1721904 OR `props-main`.`id` = 1723228 OR `props-main`.`id` = 1697572 OR `props-main`.`id` = 1721817 OR `props-main`.`id` = 1720711 OR `props-main`.`id` = 1724217 OR `props-main`.`id` = 1722611 OR `props-main`.`id` = 1722133 OR `props-main`.`id` = 1721157 OR `props-main`.`id` = 1724505 OR `props-main`.`id` = 1720304 OR `props-main`.`id` = 1722989 OR `props-main`.`id` = 1717982 OR `props-main`.`id` = 1715582 OR `props-main`.`id` = 1720873 OR `props-main`.`id` = 1721404 OR `props-main`.`id` = 1723565 OR `props-main`.`id` = 1723651 OR `props-main`.`id` = 1723007 OR `props-main`.`id` = 1713035 OR `props-main`.`id` = 1720561 OR `props-main`.`id` = 1714720 OR `props-main`.`id` = 1723305 OR `props-main`.`id` = 1720456 OR `props-main`.`id` = 1714510 OR `props-main`.`id` = 1703336 OR `props-main`.`id` = 1721848 OR `props-main`.`id` = 1724219 OR `props-main`.`id` = 1702533 OR `props-main`.`id` = 1720627 OR `props-main`.`id` = 1723554 OR `props-main`.`id` = 1723779 OR `props-main`.`id` = 1712373 OR `props-main`.`id` = 1722670 OR `props-main`.`id` = 1722317 OR `props-main`.`id` = 1720637 OR `props-main`.`id` = 1712711 OR `props-main`.`id` = 1718941 OR `props-main`.`id` = 1725099 OR `props-main`.`id` = 1724593 OR `props-main`.`id` = 1707045 OR `props-main`.`id` = 1724184 OR `props-main`.`id` = 1724877 OR `props-main`.`id` = 1722465 OR `props-main`.`id` = 1716075 OR `props-main`.`id` = 1702807 OR `props-main`.`id` = 1723504 OR `props-main`.`id` = 1716276 OR `props-main`.`id` = 1724953 OR `props-main`.`id` = 1723691 OR `props-main`.`id` = 1713162 OR `props-main`.`id` = 1718926 OR `props-main`.`id` = 1722505 OR `props-main`.`id` = 1722260 OR `props-main`.`id` = 1720968)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist223063051' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-03' 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: