A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 356250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 393750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1325 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1825 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` = 1688313 OR `props-main`.`id` = 1691308 OR `props-main`.`id` = 1691280 OR `props-main`.`id` = 1687273 OR `props-main`.`id` = 1683661 OR `props-main`.`id` = 1688664 OR `props-main`.`id` = 1688012 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` = 1688638 OR `props-main`.`id` = 1683329 OR `props-main`.`id` = 1642940 OR `props-main`.`id` = 1644759 OR `props-main`.`id` = 1657138 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` = 1686714 OR `props-main`.`id` = 1691623 OR `props-main`.`id` = 1686713 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` = 1692194 OR `props-main`.`id` = 1675154 OR `props-main`.`id` = 1688519 OR `props-main`.`id` = 1690686 OR `props-main`.`id` = 1692202 OR `props-main`.`id` = 1690454 OR `props-main`.`id` = 1690442 OR `props-main`.`id` = 1690460 OR `props-main`.`id` = 1690462 OR `props-main`.`id` = 1690473 OR `props-main`.`id` = 1690307 OR `props-main`.`id` = 1683522 OR `props-main`.`id` = 1683663 OR `props-main`.`id` = 1691741 OR `props-main`.`id` = 1691743 OR `props-main`.`id` = 1691750 OR `props-main`.`id` = 1691756 OR `props-main`.`id` = 1688055 OR `props-main`.`id` = 1692193 OR `props-main`.`id` = 1692198 OR `props-main`.`id` = 1657588 OR `props-main`.`id` = 1687097 OR `props-main`.`id` = 1686231 OR `props-main`.`id` = 1686230 OR `props-main`.`id` = 1686236 OR `props-main`.`id` = 1684519 OR `props-main`.`id` = 1683722 OR `props-main`.`id` = 1637597 OR `props-main`.`id` = 1681250 OR `props-main`.`id` = 1094176 OR `props-main`.`id` = 1676856 OR `props-main`.`id` = 1676897 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` = 1657694 OR `props-main`.`id` = 1679737 OR `props-main`.`id` = 1689872 OR `props-main`.`id` = 1689894 OR `props-main`.`id` = 1689903 OR `props-main`.`id` = 1690996 OR `props-main`.`id` = 1690884 OR `props-main`.`id` = 1690885 OR `props-main`.`id` = 1636871 OR `props-main`.`id` = 1689008 OR `props-main`.`id` = 1676324 OR `props-main`.`id` = 1691064 OR `props-main`.`id` = 1691072 OR `props-main`.`id` = 1690461 OR `props-main`.`id` = 1690327 OR `props-main`.`id` = 1690838 OR `props-main`.`id` = 1686882 OR `props-main`.`id` = 1684453 OR `props-main`.`id` = 1680768 OR `props-main`.`id` = 1692116 OR `props-main`.`id` = 1691002 OR `props-main`.`id` = 1692064 OR `props-main`.`id` = 1690789 OR `props-main`.`id` = 1691019 OR `props-main`.`id` = 1691430 OR `props-main`.`id` = 1691429 OR `props-main`.`id` = 1691435 OR `props-main`.`id` = 1688765 OR `props-main`.`id` = 1688755 OR `props-main`.`id` = 1688795 OR `props-main`.`id` = 1689010 OR `props-main`.`id` = 1673193 OR `props-main`.`id` = 1690308 OR `props-main`.`id` = 1658281 OR `props-main`.`id` = 1649972 OR `props-main`.`id` = 1691690 OR `props-main`.`id` = 1685164 OR `props-main`.`id` = 1680275 OR `props-main`.`id` = 1685942 OR `props-main`.`id` = 1691868 OR `props-main`.`id` = 1684996 OR `props-main`.`id` = 1684097 OR `props-main`.`id` = 1684104 OR `props-main`.`id` = 1684098 OR `props-main`.`id` = 1684111 OR `props-main`.`id` = 1678533 OR `props-main`.`id` = 1678527 OR `props-main`.`id` = 1678528 OR `props-main`.`id` = 1678529 OR `props-main`.`id` = 1689541 OR `props-main`.`id` = 1688307 OR `props-main`.`id` = 1688513 OR `props-main`.`id` = 1683885 OR `props-main`.`id` = 1689641 OR `props-main`.`id` = 1656855 OR `props-main`.`id` = 1690966 OR `props-main`.`id` = 1690853 OR `props-main`.`id` = 1690979 OR `props-main`.`id` = 1690599 OR `props-main`.`id` = 1690598 OR `props-main`.`id` = 1691131 OR `props-main`.`id` = 1690545 OR `props-main`.`id` = 1690544 OR `props-main`.`id` = 1690547)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings230396' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-31' 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();

CAME_FROM_PROP_SITE: