A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 204250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 225750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 660 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1160 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` = 1697949 OR `props-main`.`id` = 1648160 OR `props-main`.`id` = 1695623 OR `props-main`.`id` = 1695625 OR `props-main`.`id` = 1695626 OR `props-main`.`id` = 1695619 OR `props-main`.`id` = 1687890 OR `props-main`.`id` = 1709157 OR `props-main`.`id` = 1703334 OR `props-main`.`id` = 1703064 OR `props-main`.`id` = 1703239 OR `props-main`.`id` = 1703211 OR `props-main`.`id` = 1704713 OR `props-main`.`id` = 1704791 OR `props-main`.`id` = 1705252 OR `props-main`.`id` = 1691768 OR `props-main`.`id` = 1703199 OR `props-main`.`id` = 1703231 OR `props-main`.`id` = 1703246 OR `props-main`.`id` = 1703238 OR `props-main`.`id` = 1703214 OR `props-main`.`id` = 1703229 OR `props-main`.`id` = 1697888 OR `props-main`.`id` = 1710244 OR `props-main`.`id` = 1710887 OR `props-main`.`id` = 1691513 OR `props-main`.`id` = 1691512 OR `props-main`.`id` = 1691516 OR `props-main`.`id` = 1710681 OR `props-main`.`id` = 1704781 OR `props-main`.`id` = 1703653 OR `props-main`.`id` = 1648104 OR `props-main`.`id` = 1701577 OR `props-main`.`id` = 1676322 OR `props-main`.`id` = 1684449 OR `props-main`.`id` = 1698534 OR `props-main`.`id` = 1698516 OR `props-main`.`id` = 1345557 OR `props-main`.`id` = 1648077 OR `props-main`.`id` = 1705945 OR `props-main`.`id` = 1648373 OR `props-main`.`id` = 1705944 OR `props-main`.`id` = 1710960 OR `props-main`.`id` = 1705063 OR `props-main`.`id` = 1648374 OR `props-main`.`id` = 1690864 OR `props-main`.`id` = 1696334 OR `props-main`.`id` = 1695647 OR `props-main`.`id` = 1711107 OR `props-main`.`id` = 1704403 OR `props-main`.`id` = 1709572 OR `props-main`.`id` = 1626310 OR `props-main`.`id` = 1698541 OR `props-main`.`id` = 1698960 OR `props-main`.`id` = 1691567 OR `props-main`.`id` = 1698028 OR `props-main`.`id` = 1648357 OR `props-main`.`id` = 1695654 OR `props-main`.`id` = 1648351 OR `props-main`.`id` = 1698635 OR `props-main`.`id` = 1700021 OR `props-main`.`id` = 1703933 OR `props-main`.`id` = 1698829 OR `props-main`.`id` = 1710107 OR `props-main`.`id` = 1698833 OR `props-main`.`id` = 1698608 OR `props-main`.`id` = 1704490 OR `props-main`.`id` = 1694860 OR `props-main`.`id` = 1704591 OR `props-main`.`id` = 1704428 OR `props-main`.`id` = 1673945 OR `props-main`.`id` = 1698597 OR `props-main`.`id` = 1709876 OR `props-main`.`id` = 1699138 OR `props-main`.`id` = 1697989 OR `props-main`.`id` = 1709486 OR `props-main`.`id` = 1709768 OR `props-main`.`id` = 1698027 OR `props-main`.`id` = 1703117 OR `props-main`.`id` = 1703115 OR `props-main`.`id` = 1698609 OR `props-main`.`id` = 1703116 OR `props-main`.`id` = 1709521 OR `props-main`.`id` = 1698623 OR `props-main`.`id` = 1695691 OR `props-main`.`id` = 1692369 OR `props-main`.`id` = 1710218 OR `props-main`.`id` = 1704107 OR `props-main`.`id` = 1691236 OR `props-main`.`id` = 1697880 OR `props-main`.`id` = 1652724 OR `props-main`.`id` = 1698972 OR `props-main`.`id` = 1698687 OR `props-main`.`id` = 1697624 OR `props-main`.`id` = 1704291 OR `props-main`.`id` = 1697155 OR `props-main`.`id` = 1699136 OR `props-main`.`id` = 1693403 OR `props-main`.`id` = 1705392 OR `props-main`.`id` = 1705404 OR `props-main`.`id` = 1705410 OR `props-main`.`id` = 1703777 OR `props-main`.`id` = 1698691 OR `props-main`.`id` = 1698055 OR `props-main`.`id` = 1698669 OR `props-main`.`id` = 1698523 OR `props-main`.`id` = 1689244 OR `props-main`.`id` = 1689243 OR `props-main`.`id` = 1703029 OR `props-main`.`id` = 1675437 OR `props-main`.`id` = 1689757 OR `props-main`.`id` = 1673888 OR `props-main`.`id` = 1704948 OR `props-main`.`id` = 1687173 OR `props-main`.`id` = 1701108 OR `props-main`.`id` = 1695353)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare239910' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-25' 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: