A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 436050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 481950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1705 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2205 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` = 1686411 OR `props-main`.`id` = 1689048 OR `props-main`.`id` = 1686388 OR `props-main`.`id` = 1684632 OR `props-main`.`id` = 1687323 OR `props-main`.`id` = 1686203 OR `props-main`.`id` = 1683306 OR `props-main`.`id` = 1683282 OR `props-main`.`id` = 1689646 OR `props-main`.`id` = 1685352 OR `props-main`.`id` = 1636728 OR `props-main`.`id` = 1636687 OR `props-main`.`id` = 1666079 OR `props-main`.`id` = 1666475 OR `props-main`.`id` = 1688235 OR `props-main`.`id` = 1676865 OR `props-main`.`id` = 1667523 OR `props-main`.`id` = 1676760 OR `props-main`.`id` = 1683485 OR `props-main`.`id` = 232981 OR `props-main`.`id` = 144625 OR `props-main`.`id` = 1685923 OR `props-main`.`id` = 1680740 OR `props-main`.`id` = 1666292 OR `props-main`.`id` = 1684191 OR `props-main`.`id` = 1684197 OR `props-main`.`id` = 1686963 OR `props-main`.`id` = 1688083 OR `props-main`.`id` = 1687939 OR `props-main`.`id` = 1673064 OR `props-main`.`id` = 1677619 OR `props-main`.`id` = 1679273 OR `props-main`.`id` = 1687797 OR `props-main`.`id` = 1674965 OR `props-main`.`id` = 1660590 OR `props-main`.`id` = 1677279 OR `props-main`.`id` = 1688522 OR `props-main`.`id` = 1685573 OR `props-main`.`id` = 1632394 OR `props-main`.`id` = 1632372 OR `props-main`.`id` = 1688799 OR `props-main`.`id` = 1678059 OR `props-main`.`id` = 1673063 OR `props-main`.`id` = 1673069 OR `props-main`.`id` = 1682042 OR `props-main`.`id` = 1683147 OR `props-main`.`id` = 1688567 OR `props-main`.`id` = 1688580 OR `props-main`.`id` = 1688081 OR `props-main`.`id` = 1684817 OR `props-main`.`id` = 1680785 OR `props-main`.`id` = 1683544 OR `props-main`.`id` = 1686935 OR `props-main`.`id` = 1689644 OR `props-main`.`id` = 1678307 OR `props-main`.`id` = 1675331 OR `props-main`.`id` = 1677988 OR `props-main`.`id` = 1677736 OR `props-main`.`id` = 1689217 OR `props-main`.`id` = 1689161 OR `props-main`.`id` = 1686335 OR `props-main`.`id` = 1686200 OR `props-main`.`id` = 1689142 OR `props-main`.`id` = 1679531 OR `props-main`.`id` = 1689264 OR `props-main`.`id` = 1681768 OR `props-main`.`id` = 1681482 OR `props-main`.`id` = 1681441 OR `props-main`.`id` = 1682126 OR `props-main`.`id` = 1683194 OR `props-main`.`id` = 165469 OR `props-main`.`id` = 1676567 OR `props-main`.`id` = 1686063 OR `props-main`.`id` = 1688289 OR `props-main`.`id` = 1689255 OR `props-main`.`id` = 1672917 OR `props-main`.`id` = 1689656 OR `props-main`.`id` = 1663225 OR `props-main`.`id` = 1687976 OR `props-main`.`id` = 1688299 OR `props-main`.`id` = 1689422 OR `props-main`.`id` = 1689257 OR `props-main`.`id` = 1689419 OR `props-main`.`id` = 1689229 OR `props-main`.`id` = 1684221 OR `props-main`.`id` = 1678591 OR `props-main`.`id` = 1678544 OR `props-main`.`id` = 1680228 OR `props-main`.`id` = 1495106 OR `props-main`.`id` = 1495592 OR `props-main`.`id` = 1638338 OR `props-main`.`id` = 1687108 OR `props-main`.`id` = 1687047 OR `props-main`.`id` = 1666199)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno630101' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-12' 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: