A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 294500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 325500 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) >= 1672 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2172 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` = 1696068 OR `props-main`.`id` = 1702454 OR `props-main`.`id` = 1719282 OR `props-main`.`id` = 1703071 OR `props-main`.`id` = 1703362 OR `props-main`.`id` = 1718450 OR `props-main`.`id` = 507301 OR `props-main`.`id` = 1713580 OR `props-main`.`id` = 1714790 OR `props-main`.`id` = 1705838 OR `props-main`.`id` = 1713173 OR `props-main`.`id` = 1713566 OR `props-main`.`id` = 1708295 OR `props-main`.`id` = 1720264 OR `props-main`.`id` = 1706747 OR `props-main`.`id` = 722218 OR `props-main`.`id` = 1712398 OR `props-main`.`id` = 1708177 OR `props-main`.`id` = 1701262 OR `props-main`.`id` = 1718788 OR `props-main`.`id` = 1715736 OR `props-main`.`id` = 1685973 OR `props-main`.`id` = 1716484 OR `props-main`.`id` = 1695325 OR `props-main`.`id` = 1715501 OR `props-main`.`id` = 1713323 OR `props-main`.`id` = 1719278 OR `props-main`.`id` = 1719478 OR `props-main`.`id` = 1705458 OR `props-main`.`id` = 1705855 OR `props-main`.`id` = 1703847 OR `props-main`.`id` = 1704538 OR `props-main`.`id` = 1717167 OR `props-main`.`id` = 1706098 OR `props-main`.`id` = 1717625 OR `props-main`.`id` = 1719237 OR `props-main`.`id` = 1712603 OR `props-main`.`id` = 1712616 OR `props-main`.`id` = 1712615 OR `props-main`.`id` = 1612822 OR `props-main`.`id` = 1695657 OR `props-main`.`id` = 1695663 OR `props-main`.`id` = 1712342 OR `props-main`.`id` = 1704717 OR `props-main`.`id` = 1716817 OR `props-main`.`id` = 1716753 OR `props-main`.`id` = 1705225 OR `props-main`.`id` = 1712401 OR `props-main`.`id` = 1704426 OR `props-main`.`id` = 1704433 OR `props-main`.`id` = 1685922 OR `props-main`.`id` = 1708507 OR `props-main`.`id` = 1704995 OR `props-main`.`id` = 1695439 OR `props-main`.`id` = 1719801 OR `props-main`.`id` = 1696213 OR `props-main`.`id` = 1696215 OR `props-main`.`id` = 1696452 OR `props-main`.`id` = 1704765 OR `props-main`.`id` = 1717759 OR `props-main`.`id` = 1704346 OR `props-main`.`id` = 1691767 OR `props-main`.`id` = 1718491 OR `props-main`.`id` = 1713298 OR `props-main`.`id` = 1714886 OR `props-main`.`id` = 86628 OR `props-main`.`id` = 1713877 OR `props-main`.`id` = 1715477 OR `props-main`.`id` = 1705075 OR `props-main`.`id` = 1713360 OR `props-main`.`id` = 1704368 OR `props-main`.`id` = 1718862 OR `props-main`.`id` = 1700126 OR `props-main`.`id` = 1703122 OR `props-main`.`id` = 1703132 OR `props-main`.`id` = 1719438 OR `props-main`.`id` = 1695772 OR `props-main`.`id` = 1676891 OR `props-main`.`id` = 1709700 OR `props-main`.`id` = 1718341 OR `props-main`.`id` = 1708162 OR `props-main`.`id` = 1717214 OR `props-main`.`id` = 37605 OR `props-main`.`id` = 1680814 OR `props-main`.`id` = 1698164 OR `props-main`.`id` = 1706051 OR `props-main`.`id` = 1719376 OR `props-main`.`id` = 1719692 OR `props-main`.`id` = 1717975 OR `props-main`.`id` = 1704194 OR `props-main`.`id` = 1690540 OR `props-main`.`id` = 1705220 OR `props-main`.`id` = 1700060 OR `props-main`.`id` = 1692404 OR `props-main`.`id` = 1716427 OR `props-main`.`id` = 1706912 OR `props-main`.`id` = 1715834 OR `props-main`.`id` = 1716539 OR `props-main`.`id` = 1717743 OR `props-main`.`id` = 166956 OR `props-main`.`id` = 1715493 OR `props-main`.`id` = 1703478 OR `props-main`.`id` = 1674697 OR `props-main`.`id` = 1713059 OR `props-main`.`id` = 1719065 OR `props-main`.`id` = 1709460 OR `props-main`.`id` = 1715735 OR `props-main`.`id` = 1719824 OR `props-main`.`id` = 1694030 OR `props-main`.`id` = 1680361 OR `props-main`.`id` = 1696606 OR `props-main`.`id` = 1698002 OR `props-main`.`id` = 1698699 OR `props-main`.`id` = 1691561 OR `props-main`.`id` = 1695855 OR `props-main`.`id` = 1719823 OR `props-main`.`id` = 1718488 OR `props-main`.`id` = 1713834 OR `props-main`.`id` = 1716760 OR `props-main`.`id` = 1671754 OR `props-main`.`id` = 1716430 OR `props-main`.`id` = 1654023 OR `props-main`.`id` = 1712714 OR `props-main`.`id` = 1718263 OR `props-main`.`id` = 1712786 OR `props-main`.`id` = 1710147 OR `props-main`.`id` = 1710161 OR `props-main`.`id` = 1703751 OR `props-main`.`id` = 1719846 OR `props-main`.`id` = 1719601 OR `props-main`.`id` = 1713964 OR `props-main`.`id` = 138928 OR `props-main`.`id` = 1707122 OR `props-main`.`id` = 1717514 OR `props-main`.`id` = 235292)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsFR24240615' 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: