A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 282150 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 311850 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1412 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1912 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` = 1689443 OR `props-main`.`id` = 1686102 OR `props-main`.`id` = 1688143 OR `props-main`.`id` = 1687086 OR `props-main`.`id` = 1687422 OR `props-main`.`id` = 1657190 OR `props-main`.`id` = 1657199 OR `props-main`.`id` = 1674421 OR `props-main`.`id` = 1686905 OR `props-main`.`id` = 1665613 OR `props-main`.`id` = 1673154 OR `props-main`.`id` = 1690029 OR `props-main`.`id` = 1689947 OR `props-main`.`id` = 1689820 OR `props-main`.`id` = 1689499 OR `props-main`.`id` = 180610 OR `props-main`.`id` = 1684168 OR `props-main`.`id` = 1683621 OR `props-main`.`id` = 1683514 OR `props-main`.`id` = 1632076 OR `props-main`.`id` = 1686650 OR `props-main`.`id` = 1680609 OR `props-main`.`id` = 1685898 OR `props-main`.`id` = 1657225 OR `props-main`.`id` = 1685922 OR `props-main`.`id` = 1679178 OR `props-main`.`id` = 235509 OR `props-main`.`id` = 1681864 OR `props-main`.`id` = 1679179 OR `props-main`.`id` = 1689471 OR `props-main`.`id` = 1673311 OR `props-main`.`id` = 1673635 OR `props-main`.`id` = 1683193 OR `props-main`.`id` = 1686691 OR `props-main`.`id` = 1690187 OR `props-main`.`id` = 1686810 OR `props-main`.`id` = 1685375 OR `props-main`.`id` = 1690333 OR `props-main`.`id` = 1689417 OR `props-main`.`id` = 1690148 OR `props-main`.`id` = 86628 OR `props-main`.`id` = 1686743 OR `props-main`.`id` = 1686070 OR `props-main`.`id` = 1688806 OR `props-main`.`id` = 1686809 OR `props-main`.`id` = 1684627 OR `props-main`.`id` = 1676891 OR `props-main`.`id` = 1688467 OR `props-main`.`id` = 1684686 OR `props-main`.`id` = 1657351 OR `props-main`.`id` = 1688537 OR `props-main`.`id` = 1679921 OR `props-main`.`id` = 1680814 OR `props-main`.`id` = 1689963 OR `props-main`.`id` = 1674222 OR `props-main`.`id` = 1689265 OR `props-main`.`id` = 1689714 OR `props-main`.`id` = 1689712 OR `props-main`.`id` = 1689418 OR `props-main`.`id` = 1684661 OR `props-main`.`id` = 1689311 OR `props-main`.`id` = 1688831 OR `props-main`.`id` = 1688829 OR `props-main`.`id` = 1688858 OR `props-main`.`id` = 1667529 OR `props-main`.`id` = 1683564 OR `props-main`.`id` = 1689226 OR `props-main`.`id` = 1676568 OR `props-main`.`id` = 1684202 OR `props-main`.`id` = 1667572 OR `props-main`.`id` = 1689282 OR `props-main`.`id` = 1684908 OR `props-main`.`id` = 1687357 OR `props-main`.`id` = 1689652 OR `props-main`.`id` = 1688385 OR `props-main`.`id` = 1678114 OR `props-main`.`id` = 1685447 OR `props-main`.`id` = 1688337 OR `props-main`.`id` = 1685024 OR `props-main`.`id` = 1642537 OR `props-main`.`id` = 248876 OR `props-main`.`id` = 261479 OR `props-main`.`id` = 1661800 OR `props-main`.`id` = 1690252 OR `props-main`.`id` = 1685023 OR `props-main`.`id` = 1658333 OR `props-main`.`id` = 1684421 OR `props-main`.`id` = 1688987 OR `props-main`.`id` = 1684837 OR `props-main`.`id` = 1683107 OR `props-main`.`id` = 1651438 OR `props-main`.`id` = 1664172 OR `props-main`.`id` = 1690141 OR `props-main`.`id` = 1688992 OR `props-main`.`id` = 1690146 OR `props-main`.`id` = 1689474 OR `props-main`.`id` = 1688297 OR `props-main`.`id` = 1688318 OR `props-main`.`id` = 1679511 OR `props-main`.`id` = 1680357 OR `props-main`.`id` = 1638016 OR `props-main`.`id` = 1677294 OR `props-main`.`id` = 1686670 OR `props-main`.`id` = 1678849 OR `props-main`.`id` = 1688927 OR `props-main`.`id` = 1690311 OR `props-main`.`id` = 1683168 OR `props-main`.`id` = 1681360 OR `props-main`.`id` = 1683295 OR `props-main`.`id` = 1673634 OR `props-main`.`id` = 1648636 OR `props-main`.`id` = 1680793 OR `props-main`.`id` = 1688737 OR `props-main`.`id` = 1683973 OR `props-main`.`id` = 1679272 OR `props-main`.`id` = 1672856 OR `props-main`.`id` = 1687358 OR `props-main`.`id` = 1668069 OR `props-main`.`id` = 1668077 OR `props-main`.`id` = 1668087 OR `props-main`.`id` = 1652560 OR `props-main`.`id` = 1665941)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno633176' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-17' 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: