A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 531905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 587895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '7' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2609 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3109 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` = 1684410 OR `props-main`.`id` = 1690659 OR `props-main`.`id` = 1693181 OR `props-main`.`id` = 1690430 OR `props-main`.`id` = 1692804 OR `props-main`.`id` = 1683622 OR `props-main`.`id` = 1654801 OR `props-main`.`id` = 1688217 OR `props-main`.`id` = 1642963 OR `props-main`.`id` = 1679065 OR `props-main`.`id` = 1693382 OR `props-main`.`id` = 1693377 OR `props-main`.`id` = 1692908 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` = 1692723 OR `props-main`.`id` = 1692870 OR `props-main`.`id` = 1689519 OR `props-main`.`id` = 1692607 OR `props-main`.`id` = 1692292 OR `props-main`.`id` = 1681376 OR `props-main`.`id` = 1693123 OR `props-main`.`id` = 1692857 OR `props-main`.`id` = 1673314 OR `props-main`.`id` = 1673305 OR `props-main`.`id` = 1693667 OR `props-main`.`id` = 1638924 OR `props-main`.`id` = 1692798 OR `props-main`.`id` = 1692757 OR `props-main`.`id` = 1691604 OR `props-main`.`id` = 1684821 OR `props-main`.`id` = 1691763 OR `props-main`.`id` = 1692816 OR `props-main`.`id` = 1693133 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` = 1686619 OR `props-main`.`id` = 1686854 OR `props-main`.`id` = 1691454 OR `props-main`.`id` = 1690812 OR `props-main`.`id` = 1693246 OR `props-main`.`id` = 1691971 OR `props-main`.`id` = 1646613 OR `props-main`.`id` = 1691806 OR `props-main`.`id` = 1681153 OR `props-main`.`id` = 1691345 OR `props-main`.`id` = 1685917 OR `props-main`.`id` = 1691773 OR `props-main`.`id` = 1691276 OR `props-main`.`id` = 1677576 OR `props-main`.`id` = 1673085 OR `props-main`.`id` = 1688348 OR `props-main`.`id` = 1691622 OR `props-main`.`id` = 1676452 OR `props-main`.`id` = 1693703 OR `props-main`.`id` = 1659614 OR `props-main`.`id` = 1684963 OR `props-main`.`id` = 1654922 OR `props-main`.`id` = 1693161 OR `props-main`.`id` = 1693447 OR `props-main`.`id` = 1688468 OR `props-main`.`id` = 1684670 OR `props-main`.`id` = 1691042 OR `props-main`.`id` = 1683135 OR `props-main`.`id` = 1684215 OR `props-main`.`id` = 1645539 OR `props-main`.`id` = 1689031 OR `props-main`.`id` = 1688512 OR `props-main`.`id` = 1690751 OR `props-main`.`id` = 1685802 OR `props-main`.`id` = 1687208 OR `props-main`.`id` = 1691521 OR `props-main`.`id` = 1689410 OR `props-main`.`id` = 1692004 OR `props-main`.`id` = 1657403 OR `props-main`.`id` = 1690852 OR `props-main`.`id` = 1690068 OR `props-main`.`id` = 1662178 OR `props-main`.`id` = 1685288 OR `props-main`.`id` = 1690457 OR `props-main`.`id` = 1693563 OR `props-main`.`id` = 1692578 OR `props-main`.`id` = 1684990 OR `props-main`.`id` = 1693095 OR `props-main`.`id` = 1683580 OR `props-main`.`id` = 1671549 OR `props-main`.`id` = 1689437 OR `props-main`.`id` = 1668014 OR `props-main`.`id` = 1692531 OR `props-main`.`id` = 1690428 OR `props-main`.`id` = 1692642 OR `props-main`.`id` = 1685955 OR `props-main`.`id` = 1691757 OR `props-main`.`id` = 1685855 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` = 1693271 OR `props-main`.`id` = 1692167 OR `props-main`.`id` = 1678109 OR `props-main`.`id` = 1664563 OR `props-main`.`id` = 1693517 OR `props-main`.`id` = 1687792 OR `props-main`.`id` = 1685634 OR `props-main`.`id` = 1690336 OR `props-main`.`id` = 1680494 OR `props-main`.`id` = 1676376 OR `props-main`.`id` = 1691990 OR `props-main`.`id` = 1689356 OR `props-main`.`id` = 1686705 OR `props-main`.`id` = 1690941 OR `props-main`.`id` = 1689379 OR `props-main`.`id` = 1691388 OR `props-main`.`id` = 1690768 OR `props-main`.`id` = 1663888 OR `props-main`.`id` = 1693720 OR `props-main`.`id` = 1691304 OR `props-main`.`id` = 1689622 OR `props-main`.`id` = 1692338 OR `props-main`.`id` = 1691830 OR `props-main`.`id` = 1691106)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist224047382' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-06' 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: