A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 446500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 493500 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) >= 1010 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1510 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` = 1697509 OR `props-main`.`id` = 1694053 OR `props-main`.`id` = 1697619 OR `props-main`.`id` = 1697625 OR `props-main`.`id` = 1697647 OR `props-main`.`id` = 1693377 OR `props-main`.`id` = 1697638 OR `props-main`.`id` = 1697963 OR `props-main`.`id` = 1691135 OR `props-main`.`id` = 1693344 OR `props-main`.`id` = 1692786 OR `props-main`.`id` = 1677808 OR `props-main`.`id` = 1693084 OR `props-main`.`id` = 1693086 OR `props-main`.`id` = 1692607 OR `props-main`.`id` = 1692292 OR `props-main`.`id` = 1692857 OR `props-main`.`id` = 1695884 OR `props-main`.`id` = 1673314 OR `props-main`.`id` = 1673305 OR `props-main`.`id` = 1695198 OR `props-main`.`id` = 1692757 OR `props-main`.`id` = 1695700 OR `props-main`.`id` = 1680781 OR `props-main`.`id` = 1692987 OR `props-main`.`id` = 1692988 OR `props-main`.`id` = 1692989 OR `props-main`.`id` = 1693264 OR `props-main`.`id` = 1696210 OR `props-main`.`id` = 1690812 OR `props-main`.`id` = 1686817 OR `props-main`.`id` = 1693246 OR `props-main`.`id` = 1646613 OR `props-main`.`id` = 1685917 OR `props-main`.`id` = 1695085 OR `props-main`.`id` = 1698031 OR `props-main`.`id` = 1697495 OR `props-main`.`id` = 1673085 OR `props-main`.`id` = 1688348 OR `props-main`.`id` = 1693703 OR `props-main`.`id` = 1659614 OR `props-main`.`id` = 1695792 OR `props-main`.`id` = 1654922 OR `props-main`.`id` = 1693161 OR `props-main`.`id` = 1693447 OR `props-main`.`id` = 1688468 OR `props-main`.`id` = 1694822 OR `props-main`.`id` = 1697506 OR `props-main`.`id` = 1695578 OR `props-main`.`id` = 1683135 OR `props-main`.`id` = 1684215 OR `props-main`.`id` = 1697529 OR `props-main`.`id` = 1689031 OR `props-main`.`id` = 1694051 OR `props-main`.`id` = 1697976 OR `props-main`.`id` = 1691521 OR `props-main`.`id` = 1689410 OR `props-main`.`id` = 1692004 OR `props-main`.`id` = 1697369 OR `props-main`.`id` = 1696226 OR `props-main`.`id` = 1692578 OR `props-main`.`id` = 1697478 OR `props-main`.`id` = 1684990 OR `props-main`.`id` = 1697884 OR `props-main`.`id` = 1689437 OR `props-main`.`id` = 1697394 OR `props-main`.`id` = 1696203 OR `props-main`.`id` = 1697364 OR `props-main`.`id` = 1692642 OR `props-main`.`id` = 1685955 OR `props-main`.`id` = 1691757 OR `props-main`.`id` = 1671828 OR `props-main`.`id` = 1693314 OR `props-main`.`id` = 1691631 OR `props-main`.`id` = 1693383 OR `props-main`.`id` = 1686383 OR `props-main`.`id` = 1694102 OR `props-main`.`id` = 1685007 OR `props-main`.`id` = 1694787 OR `props-main`.`id` = 1693271 OR `props-main`.`id` = 1692167 OR `props-main`.`id` = 1697397 OR `props-main`.`id` = 1687792 OR `props-main`.`id` = 1691344 OR `props-main`.`id` = 1685634 OR `props-main`.`id` = 1694103 OR `props-main`.`id` = 1680763 OR `props-main`.`id` = 1694585 OR `props-main`.`id` = 1690336 OR `props-main`.`id` = 1676376 OR `props-main`.`id` = 1691990 OR `props-main`.`id` = 1690661 OR `props-main`.`id` = 1689356 OR `props-main`.`id` = 1694651 OR `props-main`.`id` = 1689379 OR `props-main`.`id` = 1691388 OR `props-main`.`id` = 1697602 OR `props-main`.`id` = 1693720 OR `props-main`.`id` = 1684928 OR `props-main`.`id` = 1689622 OR `props-main`.`id` = 1697443 OR `props-main`.`id` = 1697596 OR `props-main`.`id` = 1695775 OR `props-main`.`id` = 1691106 OR `props-main`.`id` = 1697912 OR `props-main`.`id` = 1695782 OR `props-main`.`id` = 1684643 OR `props-main`.`id` = 1691594 OR `props-main`.`id` = 1694279 OR `props-main`.`id` = 1660695 OR `props-main`.`id` = 1695600 OR `props-main`.`id` = 1691545 OR `props-main`.`id` = 1697814)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225131894' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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();