A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 308750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 341250 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) >= 1026 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1526 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` = 1662106 OR `props-main`.`id` = 1687669 OR `props-main`.`id` = 1686730 OR `props-main`.`id` = 1686276 OR `props-main`.`id` = 1674820 OR `props-main`.`id` = 1677774 OR `props-main`.`id` = 1669910 OR `props-main`.`id` = 1681909 OR `props-main`.`id` = 1686587 OR `props-main`.`id` = 1685459 OR `props-main`.`id` = 1685460 OR `props-main`.`id` = 1689974 OR `props-main`.`id` = 1685056 OR `props-main`.`id` = 1664322 OR `props-main`.`id` = 1682191 OR `props-main`.`id` = 1687212 OR `props-main`.`id` = 1687213 OR `props-main`.`id` = 1687245 OR `props-main`.`id` = 1687246 OR `props-main`.`id` = 1687255 OR `props-main`.`id` = 1687256 OR `props-main`.`id` = 1679888 OR `props-main`.`id` = 1667587 OR `props-main`.`id` = 1664766 OR `props-main`.`id` = 1688012 OR `props-main`.`id` = 1662046 OR `props-main`.`id` = 1657276 OR `props-main`.`id` = 1683085 OR `props-main`.`id` = 1668439 OR `props-main`.`id` = 1668454 OR `props-main`.`id` = 1668433 OR `props-main`.`id` = 1668444 OR `props-main`.`id` = 1668943 OR `props-main`.`id` = 1676838 OR `props-main`.`id` = 1677794 OR `props-main`.`id` = 1677800 OR `props-main`.`id` = 1677797 OR `props-main`.`id` = 1683205 OR `props-main`.`id` = 1685298 OR `props-main`.`id` = 1667477 OR `props-main`.`id` = 1686593 OR `props-main`.`id` = 1679624 OR `props-main`.`id` = 1689425 OR `props-main`.`id` = 1679881 OR `props-main`.`id` = 1686714 OR `props-main`.`id` = 1688641 OR `props-main`.`id` = 1688642 OR `props-main`.`id` = 1688643 OR `props-main`.`id` = 1688644 OR `props-main`.`id` = 1688645 OR `props-main`.`id` = 1686713 OR `props-main`.`id` = 1664767 OR `props-main`.`id` = 1690097 OR `props-main`.`id` = 1690242 OR `props-main`.`id` = 1690172 OR `props-main`.`id` = 1690088 OR `props-main`.`id` = 1675152 OR `props-main`.`id` = 1675155 OR `props-main`.`id` = 1681688 OR `props-main`.`id` = 1681689 OR `props-main`.`id` = 1675154 OR `props-main`.`id` = 1612813 OR `props-main`.`id` = 1684013 OR `props-main`.`id` = 1684461 OR `props-main`.`id` = 1686360 OR `props-main`.`id` = 1627122 OR `props-main`.`id` = 1677676 OR `props-main`.`id` = 1657588 OR `props-main`.`id` = 1681076 OR `props-main`.`id` = 1657568 OR `props-main`.`id` = 1677493 OR `props-main`.`id` = 1684519 OR `props-main`.`id` = 1683722 OR `props-main`.`id` = 1637597 OR `props-main`.`id` = 1094176 OR `props-main`.`id` = 1688562 OR `props-main`.`id` = 1615610 OR `props-main`.`id` = 1614319 OR `props-main`.`id` = 1613643 OR `props-main`.`id` = 1685528 OR `props-main`.`id` = 1688188 OR `props-main`.`id` = 1657694 OR `props-main`.`id` = 1689872 OR `props-main`.`id` = 1689894 OR `props-main`.`id` = 1689903 OR `props-main`.`id` = 1686898 OR `props-main`.`id` = 1686890 OR `props-main`.`id` = 1686908 OR `props-main`.`id` = 1676324 OR `props-main`.`id` = 1688614 OR `props-main`.`id` = 1686882 OR `props-main`.`id` = 1688546 OR `props-main`.`id` = 1688559 OR `props-main`.`id` = 1680768 OR `props-main`.`id` = 1688539 OR `props-main`.`id` = 1680496 OR `props-main`.`id` = 1688765 OR `props-main`.`id` = 1688755 OR `props-main`.`id` = 1688795 OR `props-main`.`id` = 1689010 OR `props-main`.`id` = 1690341 OR `props-main`.`id` = 1690308 OR `props-main`.`id` = 1685164 OR `props-main`.`id` = 1680275 OR `props-main`.`id` = 1678533 OR `props-main`.`id` = 1678527 OR `props-main`.`id` = 1678528 OR `props-main`.`id` = 1678529 OR `props-main`.`id` = 1668628 OR `props-main`.`id` = 1673503 OR `props-main`.`id` = 1680247 OR `props-main`.`id` = 1668942 OR `props-main`.`id` = 1690157 OR `props-main`.`id` = 1684598 OR `props-main`.`id` = 1689541 OR `props-main`.`id` = 1688835 OR `props-main`.`id` = 1688838 OR `props-main`.`id` = 1689949 OR `props-main`.`id` = 1689924 OR `props-main`.`id` = 1689938 OR `props-main`.`id` = 1689961 OR `props-main`.`id` = 1689926 OR `props-main`.`id` = 1688307 OR `props-main`.`id` = 1688430 OR `props-main`.`id` = 1688513 OR `props-main`.`id` = 1684915 OR `props-main`.`id` = 1683885 OR `props-main`.`id` = 1689641 OR `props-main`.`id` = 1656855)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings230478' 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();