A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 399000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 441000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1547 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2047 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` = 1682751 OR `props-main`.`id` = 1682753 OR `props-main`.`id` = 1677327 OR `props-main`.`id` = 1667395 OR `props-main`.`id` = 1667390 OR `props-main`.`id` = 1667389 OR `props-main`.`id` = 1667396 OR `props-main`.`id` = 1617327 OR `props-main`.`id` = 1622883 OR `props-main`.`id` = 1682365 OR `props-main`.`id` = 1682775 OR `props-main`.`id` = 1667912 OR `props-main`.`id` = 1667929 OR `props-main`.`id` = 1682778 OR `props-main`.`id` = 1682777 OR `props-main`.`id` = 1667931 OR `props-main`.`id` = 1667930 OR `props-main`.`id` = 1682776 OR `props-main`.`id` = 1682474 OR `props-main`.`id` = 1682750 OR `props-main`.`id` = 1690009 OR `props-main`.`id` = 1652894 OR `props-main`.`id` = 1689517 OR `props-main`.`id` = 1683299 OR `props-main`.`id` = 1684177 OR `props-main`.`id` = 1622831 OR `props-main`.`id` = 1684189 OR `props-main`.`id` = 1686349 OR `props-main`.`id` = 1683591 OR `props-main`.`id` = 1622835 OR `props-main`.`id` = 1683646 OR `props-main`.`id` = 1689808 OR `props-main`.`id` = 1685963 OR `props-main`.`id` = 1688176 OR `props-main`.`id` = 1678158 OR `props-main`.`id` = 1678167 OR `props-main`.`id` = 1678174 OR `props-main`.`id` = 1684626 OR `props-main`.`id` = 1684590 OR `props-main`.`id` = 1688826 OR `props-main`.`id` = 1689146 OR `props-main`.`id` = 1686316 OR `props-main`.`id` = 1688241 OR `props-main`.`id` = 1681396 OR `props-main`.`id` = 1684933 OR `props-main`.`id` = 1682142 OR `props-main`.`id` = 1689844 OR `props-main`.`id` = 1684934 OR `props-main`.`id` = 1682099 OR `props-main`.`id` = 1682109 OR `props-main`.`id` = 1682141 OR `props-main`.`id` = 1688413 OR `props-main`.`id` = 1682111 OR `props-main`.`id` = 1688414 OR `props-main`.`id` = 1637234 OR `props-main`.`id` = 1688415 OR `props-main`.`id` = 1682438 OR `props-main`.`id` = 1690197 OR `props-main`.`id` = 1685506 OR `props-main`.`id` = 1690255 OR `props-main`.`id` = 1690264 OR `props-main`.`id` = 1684589 OR `props-main`.`id` = 196010 OR `props-main`.`id` = 1688358 OR `props-main`.`id` = 1686442 OR `props-main`.`id` = 1688768 OR `props-main`.`id` = 1681122 OR `props-main`.`id` = 1649345 OR `props-main`.`id` = 1683095 OR `props-main`.`id` = 1680643 OR `props-main`.`id` = 1689768 OR `props-main`.`id` = 1688390 OR `props-main`.`id` = 1650411 OR `props-main`.`id` = 1663308 OR `props-main`.`id` = 1678097 OR `props-main`.`id` = 1681116 OR `props-main`.`id` = 1678071 OR `props-main`.`id` = 1681106 OR `props-main`.`id` = 1689518 OR `props-main`.`id` = 1689525 OR `props-main`.`id` = 1688968 OR `props-main`.`id` = 1688389 OR `props-main`.`id` = 1685337 OR `props-main`.`id` = 1681102 OR `props-main`.`id` = 1686439 OR `props-main`.`id` = 1686586 OR `props-main`.`id` = 1658895 OR `props-main`.`id` = 1686520 OR `props-main`.`id` = 1686461 OR `props-main`.`id` = 1622860 OR `props-main`.`id` = 1688973 OR `props-main`.`id` = 1680418 OR `props-main`.`id` = 1680833 OR `props-main`.`id` = 1672896 OR `props-main`.`id` = 1682803 OR `props-main`.`id` = 1685197 OR `props-main`.`id` = 1041230 OR `props-main`.`id` = 1686397 OR `props-main`.`id` = 1642756 OR `props-main`.`id` = 1652406 OR `props-main`.`id` = 1686260 OR `props-main`.`id` = 1686272 OR `props-main`.`id` = 1686278 OR `props-main`.`id` = 1642913 OR `props-main`.`id` = 1686690 OR `props-main`.`id` = 1687775 OR `props-main`.`id` = 1677522 OR `props-main`.`id` = 1687412 OR `props-main`.`id` = 1622892 OR `props-main`.`id` = 1645586 OR `props-main`.`id` = 1677642 OR `props-main`.`id` = 1667508 OR `props-main`.`id` = 1685840 OR `props-main`.`id` = 1633654 OR `props-main`.`id` = 1633707 OR `props-main`.`id` = 1682495 OR `props-main`.`id` = 1686582 OR `props-main`.`id` = 1689207 OR `props-main`.`id` = 1689198 OR `props-main`.`id` = 1689602 OR `props-main`.`id` = 1674964 OR `props-main`.`id` = 1674950 OR `props-main`.`id` = 1686002 OR `props-main`.`id` = 1675303 OR `props-main`.`id` = 1688231 OR `props-main`.`id` = 1665550 OR `props-main`.`id` = 291212 OR `props-main`.`id` = 1687144 OR `props-main`.`id` = 788148 OR `props-main`.`id` = 1678839 OR `props-main`.`id` = 1662202 OR `props-main`.`id` = 77474)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25066310' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-18' 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();