A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 270750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 299250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1437 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1937 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` = 1685684 OR `props-main`.`id` = 1684510 OR `props-main`.`id` = 1684499 OR `props-main`.`id` = 1682117 OR `props-main`.`id` = 1690870 OR `props-main`.`id` = 1690743 OR `props-main`.`id` = 1690867 OR `props-main`.`id` = 1690665 OR `props-main`.`id` = 1540736 OR `props-main`.`id` = 1657185 OR `props-main`.`id` = 1659538 OR `props-main`.`id` = 1672047 OR `props-main`.`id` = 1678549 OR `props-main`.`id` = 1685950 OR `props-main`.`id` = 1688237 OR `props-main`.`id` = 1688449 OR `props-main`.`id` = 1688292 OR `props-main`.`id` = 1663850 OR `props-main`.`id` = 1690871 OR `props-main`.`id` = 1690868 OR `props-main`.`id` = 1690878 OR `props-main`.`id` = 1687071 OR `props-main`.`id` = 1666013 OR `props-main`.`id` = 1681365 OR `props-main`.`id` = 1651852 OR `props-main`.`id` = 1670864 OR `props-main`.`id` = 1671668 OR `props-main`.`id` = 1655090 OR `props-main`.`id` = 1665908 OR `props-main`.`id` = 1689843 OR `props-main`.`id` = 1691017 OR `props-main`.`id` = 1679161 OR `props-main`.`id` = 1682346 OR `props-main`.`id` = 1679755 OR `props-main`.`id` = 1631707 OR `props-main`.`id` = 1688909 OR `props-main`.`id` = 1681508 OR `props-main`.`id` = 1665807 OR `props-main`.`id` = 1665806 OR `props-main`.`id` = 1675252 OR `props-main`.`id` = 1647364 OR `props-main`.`id` = 1671122 OR `props-main`.`id` = 1657787 OR `props-main`.`id` = 1681199 OR `props-main`.`id` = 1657933 OR `props-main`.`id` = 1686567 OR `props-main`.`id` = 1657855 OR `props-main`.`id` = 1677949 OR `props-main`.`id` = 1680336 OR `props-main`.`id` = 1691011 OR `props-main`.`id` = 1690915 OR `props-main`.`id` = 1674557 OR `props-main`.`id` = 1688425 OR `props-main`.`id` = 1674537 OR `props-main`.`id` = 1681224 OR `props-main`.`id` = 1685875 OR `props-main`.`id` = 1682159 OR `props-main`.`id` = 1690752 OR `props-main`.`id` = 1688332 OR `props-main`.`id` = 1674193 OR `props-main`.`id` = 1684549 OR `props-main`.`id` = 1680540 OR `props-main`.`id` = 1687399 OR `props-main`.`id` = 1683033 OR `props-main`.`id` = 1685552 OR `props-main`.`id` = 1686686 OR `props-main`.`id` = 1683470 OR `props-main`.`id` = 1690485 OR `props-main`.`id` = 1687023 OR `props-main`.`id` = 1686852 OR `props-main`.`id` = 1686859 OR `props-main`.`id` = 1684649 OR `props-main`.`id` = 1681225 OR `props-main`.`id` = 1687930 OR `props-main`.`id` = 1687963 OR `props-main`.`id` = 1687157 OR `props-main`.`id` = 1674395 OR `props-main`.`id` = 1688224 OR `props-main`.`id` = 1685481 OR `props-main`.`id` = 1682609 OR `props-main`.`id` = 1689994 OR `props-main`.`id` = 1675069 OR `props-main`.`id` = 1676425 OR `props-main`.`id` = 1676433 OR `props-main`.`id` = 1671145 OR `props-main`.`id` = 1685624 OR `props-main`.`id` = 1687975 OR `props-main`.`id` = 1684852 OR `props-main`.`id` = 1668526 OR `props-main`.`id` = 1670811 OR `props-main`.`id` = 1674186 OR `props-main`.`id` = 1678202 OR `props-main`.`id` = 1678203 OR `props-main`.`id` = 1678209 OR `props-main`.`id` = 1679399 OR `props-main`.`id` = 1679635 OR `props-main`.`id` = 1689973 OR `props-main`.`id` = 1673276 OR `props-main`.`id` = 1685627 OR `props-main`.`id` = 1690200 OR `props-main`.`id` = 1683794 OR `props-main`.`id` = 1685617 OR `props-main`.`id` = 1657879 OR `props-main`.`id` = 1679186 OR `props-main`.`id` = 1674841 OR `props-main`.`id` = 1685494 OR `props-main`.`id` = 1656273 OR `props-main`.`id` = 1690869 OR `props-main`.`id` = 1688946 OR `props-main`.`id` = 1676214 OR `props-main`.`id` = 1690866 OR `props-main`.`id` = 1690877 OR `props-main`.`id` = 1677972 OR `props-main`.`id` = 1679099 OR `props-main`.`id` = 1679100 OR `props-main`.`id` = 1678504 OR `props-main`.`id` = 1676339 OR `props-main`.`id` = 1612454 OR `props-main`.`id` = 1660938 OR `props-main`.`id` = 1686180 OR `props-main`.`id` = 1687111 OR `props-main`.`id` = 1683320 OR `props-main`.`id` = 1689717 OR `props-main`.`id` = 1677713 OR `props-main`.`id` = 1684521)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno616852' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-23' 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: