A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 446490.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 493489.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1527 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2027 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` = 1664486 OR `props-main`.`id` = 1685606 OR `props-main`.`id` = 1668036 OR `props-main`.`id` = 1671252 OR `props-main`.`id` = 1671258 OR `props-main`.`id` = 1688495 OR `props-main`.`id` = 1688489 OR `props-main`.`id` = 1688492 OR `props-main`.`id` = 1688846 OR `props-main`.`id` = 1685714 OR `props-main`.`id` = 1686794 OR `props-main`.`id` = 1685713 OR `props-main`.`id` = 1686780 OR `props-main`.`id` = 1686824 OR `props-main`.`id` = 1686948 OR `props-main`.`id` = 1681588 OR `props-main`.`id` = 1686975 OR `props-main`.`id` = 1678643 OR `props-main`.`id` = 1687101 OR `props-main`.`id` = 1679616 OR `props-main`.`id` = 1651652 OR `props-main`.`id` = 1681413 OR `props-main`.`id` = 204765 OR `props-main`.`id` = 1688832 OR `props-main`.`id` = 1690056 OR `props-main`.`id` = 1664281 OR `props-main`.`id` = 1689954 OR `props-main`.`id` = 1680148 OR `props-main`.`id` = 1663685 OR `props-main`.`id` = 1669733 OR `props-main`.`id` = 1669885 OR `props-main`.`id` = 1622834 OR `props-main`.`id` = 1668860 OR `props-main`.`id` = 1668868 OR `props-main`.`id` = 1683028 OR `props-main`.`id` = 1689609 OR `props-main`.`id` = 1689610 OR `props-main`.`id` = 1656184 OR `props-main`.`id` = 1676633 OR `props-main`.`id` = 1676678 OR `props-main`.`id` = 1676655 OR `props-main`.`id` = 1685944 OR `props-main`.`id` = 1685927 OR `props-main`.`id` = 1674669 OR `props-main`.`id` = 1684707 OR `props-main`.`id` = 1683876 OR `props-main`.`id` = 1671882 OR `props-main`.`id` = 1687450 OR `props-main`.`id` = 1681473 OR `props-main`.`id` = 1689536 OR `props-main`.`id` = 1685384 OR `props-main`.`id` = 1683766 OR `props-main`.`id` = 1683771 OR `props-main`.`id` = 1689130 OR `props-main`.`id` = 1683576 OR `props-main`.`id` = 1684011 OR `props-main`.`id` = 1688630 OR `props-main`.`id` = 1688825 OR `props-main`.`id` = 1689310 OR `props-main`.`id` = 1673062 OR `props-main`.`id` = 1673052 OR `props-main`.`id` = 1673060 OR `props-main`.`id` = 1689096 OR `props-main`.`id` = 1689087 OR `props-main`.`id` = 1682921 OR `props-main`.`id` = 1686600 OR `props-main`.`id` = 1686109 OR `props-main`.`id` = 1686150 OR `props-main`.`id` = 1685831 OR `props-main`.`id` = 1688601 OR `props-main`.`id` = 1673969 OR `props-main`.`id` = 1649201 OR `props-main`.`id` = 1681877 OR `props-main`.`id` = 1667553 OR `props-main`.`id` = 1685763 OR `props-main`.`id` = 1682603 OR `props-main`.`id` = 1666278 OR `props-main`.`id` = 1681148 OR `props-main`.`id` = 1682067 OR `props-main`.`id` = 1684572 OR `props-main`.`id` = 1688391 OR `props-main`.`id` = 1688395 OR `props-main`.`id` = 1688412 OR `props-main`.`id` = 1654367 OR `props-main`.`id` = 1680252 OR `props-main`.`id` = 1681176 OR `props-main`.`id` = 1682094 OR `props-main`.`id` = 1682095 OR `props-main`.`id` = 1682096 OR `props-main`.`id` = 1684983 OR `props-main`.`id` = 1684984 OR `props-main`.`id` = 1684986 OR `props-main`.`id` = 1684988 OR `props-main`.`id` = 1629281 OR `props-main`.`id` = 1600784 OR `props-main`.`id` = 1628060 OR `props-main`.`id` = 1685542 OR `props-main`.`id` = 1684427 OR `props-main`.`id` = 1684010 OR `props-main`.`id` = 1684416 OR `props-main`.`id` = 1638859 OR `props-main`.`id` = 1682491 OR `props-main`.`id` = 1675090 OR `props-main`.`id` = 1675106 OR `props-main`.`id` = 1675112 OR `props-main`.`id` = 1687778 OR `props-main`.`id` = 1636373 OR `props-main`.`id` = 1636374 OR `props-main`.`id` = 1686120 OR `props-main`.`id` = 1641188 OR `props-main`.`id` = 1682472)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225004946' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-17' 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();