A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 380000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 420000 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) >= 1786 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2286 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` = 1706006 OR `props-main`.`id` = 1705833 OR `props-main`.`id` = 1714818 OR `props-main`.`id` = 1716813 OR `props-main`.`id` = 1714388 OR `props-main`.`id` = 1714241 OR `props-main`.`id` = 1705541 OR `props-main`.`id` = 1712576 OR `props-main`.`id` = 1714758 OR `props-main`.`id` = 1705530 OR `props-main`.`id` = 1689695 OR `props-main`.`id` = 1720266 OR `props-main`.`id` = 1712966 OR `props-main`.`id` = 1714122 OR `props-main`.`id` = 1714564 OR `props-main`.`id` = 1714820 OR `props-main`.`id` = 1713788 OR `props-main`.`id` = 1705533 OR `props-main`.`id` = 1714132 OR `props-main`.`id` = 1715456 OR `props-main`.`id` = 1714642 OR `props-main`.`id` = 1718261 OR `props-main`.`id` = 1717064 OR `props-main`.`id` = 1718089 OR `props-main`.`id` = 1716548 OR `props-main`.`id` = 1714097 OR `props-main`.`id` = 1705542 OR `props-main`.`id` = 1716570 OR `props-main`.`id` = 1705485 OR `props-main`.`id` = 1711110 OR `props-main`.`id` = 1710212 OR `props-main`.`id` = 1715685 OR `props-main`.`id` = 1716339 OR `props-main`.`id` = 1714503 OR `props-main`.`id` = 1714702 OR `props-main`.`id` = 1705512 OR `props-main`.`id` = 1708448 OR `props-main`.`id` = 1705180 OR `props-main`.`id` = 1717441 OR `props-main`.`id` = 1718025 OR `props-main`.`id` = 1712757 OR `props-main`.`id` = 1710232 OR `props-main`.`id` = 1714796 OR `props-main`.`id` = 1689989 OR `props-main`.`id` = 1717442 OR `props-main`.`id` = 1714815 OR `props-main`.`id` = 1716006 OR `props-main`.`id` = 1705976 OR `props-main`.`id` = 1705482 OR `props-main`.`id` = 1708035 OR `props-main`.`id` = 1717126 OR `props-main`.`id` = 1708135 OR `props-main`.`id` = 1714559 OR `props-main`.`id` = 1688898 OR `props-main`.`id` = 1716778 OR `props-main`.`id` = 1718683 OR `props-main`.`id` = 1718026 OR `props-main`.`id` = 1705535 OR `props-main`.`id` = 1714403 OR `props-main`.`id` = 1696108 OR `props-main`.`id` = 1717247 OR `props-main`.`id` = 1714145 OR `props-main`.`id` = 1705529 OR `props-main`.`id` = 1714817 OR `props-main`.`id` = 1714137 OR `props-main`.`id` = 1714554 OR `props-main`.`id` = 1719644 OR `props-main`.`id` = 1714144 OR `props-main`.`id` = 1584926 OR `props-main`.`id` = 1714701 OR `props-main`.`id` = 1706913 OR `props-main`.`id` = 1717476 OR `props-main`.`id` = 1714794 OR `props-main`.`id` = 1697375 OR `props-main`.`id` = 1714210 OR `props-main`.`id` = 1714142 OR `props-main`.`id` = 1703721 OR `props-main`.`id` = 1708243 OR `props-main`.`id` = 1719707 OR `props-main`.`id` = 1711100 OR `props-main`.`id` = 1716306 OR `props-main`.`id` = 1712972 OR `props-main`.`id` = 1705310 OR `props-main`.`id` = 1717588 OR `props-main`.`id` = 1709242 OR `props-main`.`id` = 1714301 OR `props-main`.`id` = 1714563 OR `props-main`.`id` = 1712637 OR `props-main`.`id` = 1715994 OR `props-main`.`id` = 1715995 OR `props-main`.`id` = 1714562 OR `props-main`.`id` = 1712776 OR `props-main`.`id` = 1714553 OR `props-main`.`id` = 1714062 OR `props-main`.`id` = 1717654 OR `props-main`.`id` = 1716488 OR `props-main`.`id` = 1714849 OR `props-main`.`id` = 1717489 OR `props-main`.`id` = 1712471 OR `props-main`.`id` = 1705303 OR `props-main`.`id` = 1691249 OR `props-main`.`id` = 1714715 OR `props-main`.`id` = 1690349 OR `props-main`.`id` = 1717662 OR `props-main`.`id` = 1700190 OR `props-main`.`id` = 1704710 OR `props-main`.`id` = 1706067 OR `props-main`.`id` = 1718158 OR `props-main`.`id` = 1706676 OR `props-main`.`id` = 1716650 OR `props-main`.`id` = 1705490 OR `props-main`.`id` = 1718141 OR `props-main`.`id` = 1714816 OR `props-main`.`id` = 1714695 OR `props-main`.`id` = 1714143 OR `props-main`.`id` = 1713749)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist224059939' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-04' 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: