A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 625100 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 690900 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) >= 1675 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2175 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` = 1680272 OR `props-main`.`id` = 1690179 OR `props-main`.`id` = 1680526 OR `props-main`.`id` = 1680268 OR `props-main`.`id` = 1684689 OR `props-main`.`id` = 1682187 OR `props-main`.`id` = 1683143 OR `props-main`.`id` = 1689813 OR `props-main`.`id` = 1690283 OR `props-main`.`id` = 1689495 OR `props-main`.`id` = 1685456 OR `props-main`.`id` = 1689779 OR `props-main`.`id` = 1687949 OR `props-main`.`id` = 1681866 OR `props-main`.`id` = 1683534 OR `props-main`.`id` = 1682961 OR `props-main`.`id` = 1688368 OR `props-main`.`id` = 1688351 OR `props-main`.`id` = 1686153 OR `props-main`.`id` = 1679727 OR `props-main`.`id` = 1683316 OR `props-main`.`id` = 1688123 OR `props-main`.`id` = 1652528 OR `props-main`.`id` = 1678249 OR `props-main`.`id` = 1688276 OR `props-main`.`id` = 1688215 OR `props-main`.`id` = 1679807 OR `props-main`.`id` = 1679448 OR `props-main`.`id` = 1688166 OR `props-main`.`id` = 1691089 OR `props-main`.`id` = 1688165 OR `props-main`.`id` = 1679813 OR `props-main`.`id` = 1676488 OR `props-main`.`id` = 1689365 OR `props-main`.`id` = 1669593 OR `props-main`.`id` = 1669594 OR `props-main`.`id` = 1676849 OR `props-main`.`id` = 1669591 OR `props-main`.`id` = 1669590 OR `props-main`.`id` = 1669592 OR `props-main`.`id` = 1662083 OR `props-main`.`id` = 1657988 OR `props-main`.`id` = 1690070 OR `props-main`.`id` = 1679137 OR `props-main`.`id` = 1691165 OR `props-main`.`id` = 1690211 OR `props-main`.`id` = 1670822 OR `props-main`.`id` = 1676513 OR `props-main`.`id` = 1655083 OR `props-main`.`id` = 1682611 OR `props-main`.`id` = 1680370 OR `props-main`.`id` = 1691195 OR `props-main`.`id` = 1659677 OR `props-main`.`id` = 1656033 OR `props-main`.`id` = 1685196 OR `props-main`.`id` = 1679371 OR `props-main`.`id` = 1679298 OR `props-main`.`id` = 1651165 OR `props-main`.`id` = 1690401 OR `props-main`.`id` = 1689349 OR `props-main`.`id` = 1688933 OR `props-main`.`id` = 1688228 OR `props-main`.`id` = 1690194 OR `props-main`.`id` = 1689953 OR `props-main`.`id` = 1690205 OR `props-main`.`id` = 1686121 OR `props-main`.`id` = 1680448 OR `props-main`.`id` = 1687802 OR `props-main`.`id` = 1686088 OR `props-main`.`id` = 1674365 OR `props-main`.`id` = 1689467 OR `props-main`.`id` = 1677139 OR `props-main`.`id` = 1685437 OR `props-main`.`id` = 1656191 OR `props-main`.`id` = 1688651 OR `props-main`.`id` = 1689929 OR `props-main`.`id` = 1684828 OR `props-main`.`id` = 1682721 OR `props-main`.`id` = 1691118 OR `props-main`.`id` = 1678804 OR `props-main`.`id` = 1668725 OR `props-main`.`id` = 1683357 OR `props-main`.`id` = 1654551 OR `props-main`.`id` = 1688952 OR `props-main`.`id` = 1685128 OR `props-main`.`id` = 1680251 OR `props-main`.`id` = 1689348 OR `props-main`.`id` = 1688282 OR `props-main`.`id` = 1690279 OR `props-main`.`id` = 1683637 OR `props-main`.`id` = 1686641 OR `props-main`.`id` = 1688249 OR `props-main`.`id` = 1679946 OR `props-main`.`id` = 1682664 OR `props-main`.`id` = 1671060 OR `props-main`.`id` = 1671026 OR `props-main`.`id` = 1682799 OR `props-main`.`id` = 1682804 OR `props-main`.`id` = 1682607 OR `props-main`.`id` = 1690518 OR `props-main`.`id` = 1682958 OR `props-main`.`id` = 1616278 OR `props-main`.`id` = 1682950 OR `props-main`.`id` = 1614564 OR `props-main`.`id` = 1688222 OR `props-main`.`id` = 1676858 OR `props-main`.`id` = 1670845 OR `props-main`.`id` = 1686808 OR `props-main`.`id` = 1689362 OR `props-main`.`id` = 1685915 OR `props-main`.`id` = 1689367 OR `props-main`.`id` = 1680764 OR `props-main`.`id` = 1657554 OR `props-main`.`id` = 1680776 OR `props-main`.`id` = 1657999 OR `props-main`.`id` = 1679225 OR `props-main`.`id` = 1667795 OR `props-main`.`id` = 1689369 OR `props-main`.`id` = 1684217 OR `props-main`.`id` = 1658814 OR `props-main`.`id` = 1688340 OR `props-main`.`id` = 1667438)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML81973994' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-26' 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();