A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 413250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 456750 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) >= 1099 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1599 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` = 1690068 OR `props-main`.`id` = 1662178 OR `props-main`.`id` = 1685288 OR `props-main`.`id` = 1690457 OR `props-main`.`id` = 1689437 OR `props-main`.`id` = 1668014 OR `props-main`.`id` = 1685127 OR `props-main`.`id` = 1690428 OR `props-main`.`id` = 1690911 OR `props-main`.`id` = 1685855 OR `props-main`.`id` = 1671828 OR `props-main`.`id` = 1690741 OR `props-main`.`id` = 1690635 OR `props-main`.`id` = 1686994 OR `props-main`.`id` = 1686383 OR `props-main`.`id` = 1687303 OR `props-main`.`id` = 1680907 OR `props-main`.`id` = 1685007 OR `props-main`.`id` = 1689595 OR `props-main`.`id` = 1689354 OR `props-main`.`id` = 1678109 OR `props-main`.`id` = 1664563 OR `props-main`.`id` = 1687792 OR `props-main`.`id` = 1687363 OR `props-main`.`id` = 1643766 OR `props-main`.`id` = 1680763 OR `props-main`.`id` = 1673207 OR `props-main`.`id` = 1690336 OR `props-main`.`id` = 1680494 OR `props-main`.`id` = 1685835 OR `props-main`.`id` = 1676376 OR `props-main`.`id` = 1690661 OR `props-main`.`id` = 1673007 OR `props-main`.`id` = 1686705 OR `props-main`.`id` = 1690719 OR `props-main`.`id` = 1689379 OR `props-main`.`id` = 1683656 OR `props-main`.`id` = 1690768 OR `props-main`.`id` = 1663888 OR `props-main`.`id` = 1685949 OR `props-main`.`id` = 1684928 OR `props-main`.`id` = 1682140 OR `props-main`.`id` = 1689622 OR `props-main`.`id` = 1690552 OR `props-main`.`id` = 1684864 OR `props-main`.`id` = 1689397 OR `props-main`.`id` = 1690289 OR `props-main`.`id` = 1690509 OR `props-main`.`id` = 1689830 OR `props-main`.`id` = 1678660 OR `props-main`.`id` = 1678014 OR `props-main`.`id` = 1658001 OR `props-main`.`id` = 1690717 OR `props-main`.`id` = 1668779 OR `props-main`.`id` = 1684643 OR `props-main`.`id` = 1689576 OR `props-main`.`id` = 1660695 OR `props-main`.`id` = 1690258 OR `props-main`.`id` = 1689411 OR `props-main`.`id` = 1682690 OR `props-main`.`id` = 1681178 OR `props-main`.`id` = 1689115 OR `props-main`.`id` = 1689592 OR `props-main`.`id` = 1688169 OR `props-main`.`id` = 1690745 OR `props-main`.`id` = 1689296 OR `props-main`.`id` = 1690288 OR `props-main`.`id` = 1686159 OR `props-main`.`id` = 1681349 OR `props-main`.`id` = 1690425 OR `props-main`.`id` = 1679086 OR `props-main`.`id` = 1677754 OR `props-main`.`id` = 1685235 OR `props-main`.`id` = 1690524 OR `props-main`.`id` = 1690156 OR `props-main`.`id` = 1688064 OR `props-main`.`id` = 1687195 OR `props-main`.`id` = 1646600 OR `props-main`.`id` = 1666517 OR `props-main`.`id` = 1689873 OR `props-main`.`id` = 1689915 OR `props-main`.`id` = 1689866 OR `props-main`.`id` = 1644786 OR `props-main`.`id` = 1678556 OR `props-main`.`id` = 1690026 OR `props-main`.`id` = 1678486 OR `props-main`.`id` = 1677611 OR `props-main`.`id` = 1689593 OR `props-main`.`id` = 1688192 OR `props-main`.`id` = 1690891 OR `props-main`.`id` = 1683510 OR `props-main`.`id` = 1676779 OR `props-main`.`id` = 1676352 OR `props-main`.`id` = 1685329 OR `props-main`.`id` = 1684831 OR `props-main`.`id` = 1678989 OR `props-main`.`id` = 1682861 OR `props-main`.`id` = 1682680 OR `props-main`.`id` = 1688375 OR `props-main`.`id` = 1687196 OR `props-main`.`id` = 1685788 OR `props-main`.`id` = 1680419 OR `props-main`.`id` = 1690043 OR `props-main`.`id` = 1681407 OR `props-main`.`id` = 1687054 OR `props-main`.`id` = 1678442 OR `props-main`.`id` = 1685422 OR `props-main`.`id` = 1676668 OR `props-main`.`id` = 1673949 OR `props-main`.`id` = 1647268 OR `props-main`.`id` = 1673330 OR `props-main`.`id` = 1681069 OR `props-main`.`id` = 1684865 OR `props-main`.`id` = 1663529)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC24152402' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-23' 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();