A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 280250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 309750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1116 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1616 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` = 1665972 OR `props-main`.`id` = 1666314 OR `props-main`.`id` = 1665971 OR `props-main`.`id` = 1660400 OR `props-main`.`id` = 1660401 OR `props-main`.`id` = 1674536 OR `props-main`.`id` = 1689510 OR `props-main`.`id` = 1688155 OR `props-main`.`id` = 1638642 OR `props-main`.`id` = 1681564 OR `props-main`.`id` = 1674614 OR `props-main`.`id` = 1686222 OR `props-main`.`id` = 1689420 OR `props-main`.`id` = 1680728 OR `props-main`.`id` = 1684236 OR `props-main`.`id` = 1686172 OR `props-main`.`id` = 1689025 OR `props-main`.`id` = 1683287 OR `props-main`.`id` = 1666238 OR `props-main`.`id` = 1686721 OR `props-main`.`id` = 1677467 OR `props-main`.`id` = 1687491 OR `props-main`.`id` = 1684712 OR `props-main`.`id` = 1662537 OR `props-main`.`id` = 1681519 OR `props-main`.`id` = 1678452 OR `props-main`.`id` = 1679671 OR `props-main`.`id` = 1636479 OR `props-main`.`id` = 1683102 OR `props-main`.`id` = 1683103 OR `props-main`.`id` = 1666477 OR `props-main`.`id` = 1682026 OR `props-main`.`id` = 1679412 OR `props-main`.`id` = 1657521 OR `props-main`.`id` = 1666004 OR `props-main`.`id` = 1666327 OR `props-main`.`id` = 1681261 OR `props-main`.`id` = 1679203 OR `props-main`.`id` = 1680010 OR `props-main`.`id` = 1680490 OR `props-main`.`id` = 1663617 OR `props-main`.`id` = 1680817 OR `props-main`.`id` = 1685355 OR `props-main`.`id` = 1685353 OR `props-main`.`id` = 1655543 OR `props-main`.`id` = 1685048 OR `props-main`.`id` = 1666338 OR `props-main`.`id` = 1665709 OR `props-main`.`id` = 1688672 OR `props-main`.`id` = 1686096 OR `props-main`.`id` = 1662145 OR `props-main`.`id` = 1633562 OR `props-main`.`id` = 1681633 OR `props-main`.`id` = 1681635 OR `props-main`.`id` = 1638703 OR `props-main`.`id` = 1681636 OR `props-main`.`id` = 1679169 OR `props-main`.`id` = 1664505 OR `props-main`.`id` = 1660381 OR `props-main`.`id` = 1664519 OR `props-main`.`id` = 1662312 OR `props-main`.`id` = 1683717 OR `props-main`.`id` = 1674219 OR `props-main`.`id` = 1665932 OR `props-main`.`id` = 1634333 OR `props-main`.`id` = 1654292 OR `props-main`.`id` = 1683931 OR `props-main`.`id` = 1683962 OR `props-main`.`id` = 1683964 OR `props-main`.`id` = 1681366 OR `props-main`.`id` = 1681364 OR `props-main`.`id` = 1683960 OR `props-main`.`id` = 1681362 OR `props-main`.`id` = 1632478 OR `props-main`.`id` = 1683961 OR `props-main`.`id` = 1681344 OR `props-main`.`id` = 1681343 OR `props-main`.`id` = 1686343 OR `props-main`.`id` = 1683963 OR `props-main`.`id` = 1681342 OR `props-main`.`id` = 1666101 OR `props-main`.`id` = 1684698 OR `props-main`.`id` = 1684722 OR `props-main`.`id` = 1684734 OR `props-main`.`id` = 1666227 OR `props-main`.`id` = 1668403 OR `props-main`.`id` = 1683609 OR `props-main`.`id` = 1681209 OR `props-main`.`id` = 1689545 OR `props-main`.`id` = 1681960 OR `props-main`.`id` = 1682188 OR `props-main`.`id` = 1688397 OR `props-main`.`id` = 1684956 OR `props-main`.`id` = 1688399 OR `props-main`.`id` = 1660896 OR `props-main`.`id` = 1681919 OR `props-main`.`id` = 1667520 OR `props-main`.`id` = 1450737 OR `props-main`.`id` = 1689151 OR `props-main`.`id` = 1686729 OR `props-main`.`id` = 1686728 OR `props-main`.`id` = 1689321 OR `props-main`.`id` = 1678214 OR `props-main`.`id` = 1617341 OR `props-main`.`id` = 1649227 OR `props-main`.`id` = 1687699 OR `props-main`.`id` = 1688344 OR `props-main`.`id` = 1638674 OR `props-main`.`id` = 1656862 OR `props-main`.`id` = 1683633 OR `props-main`.`id` = 1665859 OR `props-main`.`id` = 1609082 OR `props-main`.`id` = 1683912 OR `props-main`.`id` = 1683436 OR `props-main`.`id` = 1656582 OR `props-main`.`id` = 1656572 OR `props-main`.`id` = 1677687 OR `props-main`.`id` = 131234 OR `props-main`.`id` = 1657828 OR `props-main`.`id` = 1687842 OR `props-main`.`id` = 70356 OR `props-main`.`id` = 1654282 OR `props-main`.`id` = 1666331 OR `props-main`.`id` = 1683634 OR `props-main`.`id` = 1684695 OR `props-main`.`id` = 1684687 OR `props-main`.`id` = 1679054 OR `props-main`.`id` = 1678139 OR `props-main`.`id` = 1684123 OR `props-main`.`id` = 1661123)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno615352' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-11' 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: