A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 498655 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 551145 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2564 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3064 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` = 1711302 OR `props-main`.`id` = 1693424 OR `props-main`.`id` = 1693425 OR `props-main`.`id` = 1684982 OR `props-main`.`id` = 1694468 OR `props-main`.`id` = 1684978 OR `props-main`.`id` = 1636192 OR `props-main`.`id` = 63187 OR `props-main`.`id` = 224353 OR `props-main`.`id` = 1713289 OR `props-main`.`id` = 1717930 OR `props-main`.`id` = 1695260 OR `props-main`.`id` = 1718911 OR `props-main`.`id` = 1718889 OR `props-main`.`id` = 1705644 OR `props-main`.`id` = 1718353 OR `props-main`.`id` = 1713583 OR `props-main`.`id` = 1717365 OR `props-main`.`id` = 1717366 OR `props-main`.`id` = 1710093 OR `props-main`.`id` = 1713220 OR `props-main`.`id` = 1713263 OR `props-main`.`id` = 1717346 OR `props-main`.`id` = 1694694 OR `props-main`.`id` = 1694695 OR `props-main`.`id` = 1700113 OR `props-main`.`id` = 1700114 OR `props-main`.`id` = 1700116 OR `props-main`.`id` = 1700117 OR `props-main`.`id` = 1718657 OR `props-main`.`id` = 1701454 OR `props-main`.`id` = 1718252 OR `props-main`.`id` = 1650401 OR `props-main`.`id` = 1693518 OR `props-main`.`id` = 994639 OR `props-main`.`id` = 1703742 OR `props-main`.`id` = 1718777 OR `props-main`.`id` = 1713858 OR `props-main`.`id` = 1716600 OR `props-main`.`id` = 1716881 OR `props-main`.`id` = 1718023 OR `props-main`.`id` = 1717742 OR `props-main`.`id` = 1717760 OR `props-main`.`id` = 1718017 OR `props-main`.`id` = 1717884 OR `props-main`.`id` = 1702895 OR `props-main`.`id` = 1702893 OR `props-main`.`id` = 1706097 OR `props-main`.`id` = 1712402 OR `props-main`.`id` = 1716720 OR `props-main`.`id` = 1710289 OR `props-main`.`id` = 1713819)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno629341' 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: