A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 418950 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) >= 1438 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1938 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` = 1655628 OR `props-main`.`id` = 1682754 OR `props-main`.`id` = 1688171 OR `props-main`.`id` = 1655985 OR `props-main`.`id` = 1655977 OR `props-main`.`id` = 1691355 OR `props-main`.`id` = 1691163 OR `props-main`.`id` = 1688975 OR `props-main`.`id` = 1691296 OR `props-main`.`id` = 1691295 OR `props-main`.`id` = 1691292 OR `props-main`.`id` = 1688571 OR `props-main`.`id` = 1691297 OR `props-main`.`id` = 1662588 OR `props-main`.`id` = 1690063 OR `props-main`.`id` = 1679532 OR `props-main`.`id` = 1688452 OR `props-main`.`id` = 1691293 OR `props-main`.`id` = 1688068 OR `props-main`.`id` = 1691018 OR `props-main`.`id` = 279647 OR `props-main`.`id` = 1683856 OR `props-main`.`id` = 1687806 OR `props-main`.`id` = 1680078 OR `props-main`.`id` = 1692294 OR `props-main`.`id` = 1690946 OR `props-main`.`id` = 1688700 OR `props-main`.`id` = 1674436 OR `props-main`.`id` = 1659015 OR `props-main`.`id` = 1688814 OR `props-main`.`id` = 1691908 OR `props-main`.`id` = 1692030 OR `props-main`.`id` = 1692305 OR `props-main`.`id` = 1682890 OR `props-main`.`id` = 1678324 OR `props-main`.`id` = 1684897 OR `props-main`.`id` = 1686542 OR `props-main`.`id` = 1681956 OR `props-main`.`id` = 1622694 OR `props-main`.`id` = 1658779 OR `props-main`.`id` = 1637576 OR `props-main`.`id` = 1687934 OR `props-main`.`id` = 1665493 OR `props-main`.`id` = 1690817 OR `props-main`.`id` = 1689129 OR `props-main`.`id` = 1689332 OR `props-main`.`id` = 1686503 OR `props-main`.`id` = 1656086 OR `props-main`.`id` = 1690701 OR `props-main`.`id` = 1648800 OR `props-main`.`id` = 1622873 OR `props-main`.`id` = 1674548 OR `props-main`.`id` = 1678884 OR `props-main`.`id` = 1689316 OR `props-main`.`id` = 1678651 OR `props-main`.`id` = 1689907 OR `props-main`.`id` = 1683018 OR `props-main`.`id` = 1689591 OR `props-main`.`id` = 1123502 OR `props-main`.`id` = 1625895 OR `props-main`.`id` = 1686466 OR `props-main`.`id` = 1690560 OR `props-main`.`id` = 1687942 OR `props-main`.`id` = 1627326 OR `props-main`.`id` = 1684543 OR `props-main`.`id` = 1690072 OR `props-main`.`id` = 1690062 OR `props-main`.`id` = 1690209 OR `props-main`.`id` = 1689573 OR `props-main`.`id` = 1689568 OR `props-main`.`id` = 1622733 OR `props-main`.`id` = 1622891 OR `props-main`.`id` = 1674192 OR `props-main`.`id` = 1686301 OR `props-main`.`id` = 1691682 OR `props-main`.`id` = 1686551 OR `props-main`.`id` = 1686754 OR `props-main`.`id` = 1676643 OR `props-main`.`id` = 1655369 OR `props-main`.`id` = 1689315 OR `props-main`.`id` = 1685567 OR `props-main`.`id` = 1681806 OR `props-main`.`id` = 1689782 OR `props-main`.`id` = 1689790 OR `props-main`.`id` = 1688572 OR `props-main`.`id` = 1690433 OR `props-main`.`id` = 1690429 OR `props-main`.`id` = 1688778 OR `props-main`.`id` = 1692185 OR `props-main`.`id` = 1692318 OR `props-main`.`id` = 1673715 OR `props-main`.`id` = 1673741 OR `props-main`.`id` = 1686552 OR `props-main`.`id` = 1622798 OR `props-main`.`id` = 262682 OR `props-main`.`id` = 1692306 OR `props-main`.`id` = 1681301 OR `props-main`.`id` = 1689559 OR `props-main`.`id` = 1688050 OR `props-main`.`id` = 1688040 OR `props-main`.`id` = 1681087 OR `props-main`.`id` = 1064603 OR `props-main`.`id` = 1691825 OR `props-main`.`id` = 289931 OR `props-main`.`id` = 1677524 OR `props-main`.`id` = 1677523 OR `props-main`.`id` = 1680045 OR `props-main`.`id` = 1680039 OR `props-main`.`id` = 1680043 OR `props-main`.`id` = 1679706 OR `props-main`.`id` = 1686825 OR `props-main`.`id` = 1690564 OR `props-main`.`id` = 1691910 OR `props-main`.`id` = 1691909 OR `props-main`.`id` = 1691938 OR `props-main`.`id` = 1691855 OR `props-main`.`id` = 1690269 OR `props-main`.`id` = 1685786 OR `props-main`.`id` = 1678157)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41109784' 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: