A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 531050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 586950 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) >= 3187 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3687 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` = 1714983 OR `props-main`.`id` = 1719775 OR `props-main`.`id` = 1708131 OR `props-main`.`id` = 1718676 OR `props-main`.`id` = 1694317 OR `props-main`.`id` = 1714009 OR `props-main`.`id` = 1718000 OR `props-main`.`id` = 1719566 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1704367 OR `props-main`.`id` = 1715597 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1717159 OR `props-main`.`id` = 1689035 OR `props-main`.`id` = 1692208 OR `props-main`.`id` = 1711281 OR `props-main`.`id` = 1718254 OR `props-main`.`id` = 1712495 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1704573 OR `props-main`.`id` = 1713847 OR `props-main`.`id` = 1716845 OR `props-main`.`id` = 1716326 OR `props-main`.`id` = 1716751 OR `props-main`.`id` = 1689212 OR `props-main`.`id` = 1713154 OR `props-main`.`id` = 1693924 OR `props-main`.`id` = 1715990 OR `props-main`.`id` = 1689657 OR `props-main`.`id` = 1710090 OR `props-main`.`id` = 439522 OR `props-main`.`id` = 1709455 OR `props-main`.`id` = 1716508 OR `props-main`.`id` = 1706637 OR `props-main`.`id` = 1716294 OR `props-main`.`id` = 1716286 OR `props-main`.`id` = 1709935 OR `props-main`.`id` = 1716627 OR `props-main`.`id` = 1717197 OR `props-main`.`id` = 1717456 OR `props-main`.`id` = 1717420 OR `props-main`.`id` = 1717431 OR `props-main`.`id` = 1717440 OR `props-main`.`id` = 1715709 OR `props-main`.`id` = 1701870 OR `props-main`.`id` = 1719684 OR `props-main`.`id` = 1681726 OR `props-main`.`id` = 1717439 OR `props-main`.`id` = 1712677 OR `props-main`.`id` = 1713049 OR `props-main`.`id` = 1710011 OR `props-main`.`id` = 1704410 OR `props-main`.`id` = 1715897 OR `props-main`.`id` = 1711143 OR `props-main`.`id` = 1708087 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1703958 OR `props-main`.`id` = 1716028 OR `props-main`.`id` = 1712606 OR `props-main`.`id` = 1716498 OR `props-main`.`id` = 1719778 OR `props-main`.`id` = 1719773 OR `props-main`.`id` = 1719777 OR `props-main`.`id` = 1703808 OR `props-main`.`id` = 1719779 OR `props-main`.`id` = 1719786 OR `props-main`.`id` = 1719769 OR `props-main`.`id` = 1708299 OR `props-main`.`id` = 1719770 OR `props-main`.`id` = 1719785 OR `props-main`.`id` = 1708298 OR `props-main`.`id` = 1708311 OR `props-main`.`id` = 1719767 OR `props-main`.`id` = 1719784 OR `props-main`.`id` = 1719787 OR `props-main`.`id` = 1719768 OR `props-main`.`id` = 1719793 OR `props-main`.`id` = 1708309 OR `props-main`.`id` = 1708297 OR `props-main`.`id` = 1719791 OR `props-main`.`id` = 1719792 OR `props-main`.`id` = 1708296 OR `props-main`.`id` = 1719790 OR `props-main`.`id` = 1719783 OR `props-main`.`id` = 1719780 OR `props-main`.`id` = 1708306 OR `props-main`.`id` = 1708307 OR `props-main`.`id` = 1719782 OR `props-main`.`id` = 1719788 OR `props-main`.`id` = 1719789 OR `props-main`.`id` = 1719771 OR `props-main`.`id` = 1718323 OR `props-main`.`id` = 1703614 OR `props-main`.`id` = 1719772 OR `props-main`.`id` = 1701632 OR `props-main`.`id` = 1706911 OR `props-main`.`id` = 1709276 OR `props-main`.`id` = 1708154 OR `props-main`.`id` = 1705157 OR `props-main`.`id` = 1705163 OR `props-main`.`id` = 1705164 OR `props-main`.`id` = 1705159 OR `props-main`.`id` = 1705160 OR `props-main`.`id` = 1709662 OR `props-main`.`id` = 1709663 OR `props-main`.`id` = 1709664 OR `props-main`.`id` = 1719460 OR `props-main`.`id` = 1709665 OR `props-main`.`id` = 1701893 OR `props-main`.`id` = 1709661 OR `props-main`.`id` = 1709649 OR `props-main`.`id` = 1701898 OR `props-main`.`id` = 1701878 OR `props-main`.`id` = 1719512 OR `props-main`.`id` = 1704030)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno512427' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-03' 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: