A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 945250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1044750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1572 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2072 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` = 1680132 OR `props-main`.`id` = 1705859 OR `props-main`.`id` = 1703505 OR `props-main`.`id` = 1719669 OR `props-main`.`id` = 1689492 OR `props-main`.`id` = 1689540 OR `props-main`.`id` = 1691509 OR `props-main`.`id` = 1719069 OR `props-main`.`id` = 1717083 OR `props-main`.`id` = 1717146 OR `props-main`.`id` = 1700898 OR `props-main`.`id` = 1716200 OR `props-main`.`id` = 1709437 OR `props-main`.`id` = 1711299 OR `props-main`.`id` = 1716100 OR `props-main`.`id` = 1718625 OR `props-main`.`id` = 1703395 OR `props-main`.`id` = 1718935 OR `props-main`.`id` = 1701610 OR `props-main`.`id` = 1714877 OR `props-main`.`id` = 1717221 OR `props-main`.`id` = 1702239 OR `props-main`.`id` = 1712586 OR `props-main`.`id` = 1702073 OR `props-main`.`id` = 1717977 OR `props-main`.`id` = 1695747 OR `props-main`.`id` = 1703017 OR `props-main`.`id` = 1711353 OR `props-main`.`id` = 1717650 OR `props-main`.`id` = 1706989 OR `props-main`.`id` = 1715448 OR `props-main`.`id` = 1715447 OR `props-main`.`id` = 1718405 OR `props-main`.`id` = 1715449 OR `props-main`.`id` = 1715450 OR `props-main`.`id` = 1703477 OR `props-main`.`id` = 1677935 OR `props-main`.`id` = 1719451 OR `props-main`.`id` = 1719753 OR `props-main`.`id` = 1695021 OR `props-main`.`id` = 1719130 OR `props-main`.`id` = 1716632 OR `props-main`.`id` = 1668175 OR `props-main`.`id` = 1719096 OR `props-main`.`id` = 1697961 OR `props-main`.`id` = 1719215 OR `props-main`.`id` = 1719221 OR `props-main`.`id` = 1714917 OR `props-main`.`id` = 1708288 OR `props-main`.`id` = 1719755 OR `props-main`.`id` = 1623404 OR `props-main`.`id` = 1706630 OR `props-main`.`id` = 1717486 OR `props-main`.`id` = 1713172 OR `props-main`.`id` = 1683352 OR `props-main`.`id` = 1717364 OR `props-main`.`id` = 1689688 OR `props-main`.`id` = 1718481 OR `props-main`.`id` = 1689004 OR `props-main`.`id` = 1690508 OR `props-main`.`id` = 1702071 OR `props-main`.`id` = 1704091 OR `props-main`.`id` = 1717363 OR `props-main`.`id` = 1718145 OR `props-main`.`id` = 1719423 OR `props-main`.`id` = 1708113 OR `props-main`.`id` = 1704248 OR `props-main`.`id` = 1709796 OR `props-main`.`id` = 1717780 OR `props-main`.`id` = 1658740 OR `props-main`.`id` = 1702661 OR `props-main`.`id` = 1702662 OR `props-main`.`id` = 1687991 OR `props-main`.`id` = 1710121 OR `props-main`.`id` = 1641603 OR `props-main`.`id` = 1705965 OR `props-main`.`id` = 1713285 OR `props-main`.`id` = 1712694 OR `props-main`.`id` = 1701142 OR `props-main`.`id` = 1708336 OR `props-main`.`id` = 1716605 OR `props-main`.`id` = 1716070 OR `props-main`.`id` = 1704366 OR `props-main`.`id` = 1712492 OR `props-main`.`id` = 1712493 OR `props-main`.`id` = 1717257 OR `props-main`.`id` = 1651646 OR `props-main`.`id` = 1695009 OR `props-main`.`id` = 1670934 OR `props-main`.`id` = 1674173 OR `props-main`.`id` = 1687145 OR `props-main`.`id` = 1689563 OR `props-main`.`id` = 1690437 OR `props-main`.`id` = 1704939 OR `props-main`.`id` = 1704390 OR `props-main`.`id` = 1709237 OR `props-main`.`id` = 1719000 OR `props-main`.`id` = 1719080 OR `props-main`.`id` = 1623531 OR `props-main`.`id` = 1713358 OR `props-main`.`id` = 1702146 OR `props-main`.`id` = 1708333 OR `props-main`.`id` = 1717314 OR `props-main`.`id` = 1718875 OR `props-main`.`id` = 1712837 OR `props-main`.`id` = 1663980 OR `props-main`.`id` = 1719813 OR `props-main`.`id` = 1679310 OR `props-main`.`id` = 1693384 OR `props-main`.`id` = 1651401 OR `props-main`.`id` = 1651403 OR `props-main`.`id` = 1715482 OR `props-main`.`id` = 1690991 OR `props-main`.`id` = 1697760 OR `props-main`.`id` = 1679240 OR `props-main`.`id` = 1712858 OR `props-main`.`id` = 1694046 OR `props-main`.`id` = 1695016 OR `props-main`.`id` = 1694043 OR `props-main`.`id` = 1695018 OR `props-main`.`id` = 1710157 OR `props-main`.`id` = 1675353 OR `props-main`.`id` = 1718219 OR `props-main`.`id` = 1699019 OR `props-main`.`id` = 1672865)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSR24073052' 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: