A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 418950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1690 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2190 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` = 1688313 OR `props-main`.`id` = 1684733 OR `props-main`.`id` = 1684918 OR `props-main`.`id` = 1687273 OR `props-main`.`id` = 1687950 OR `props-main`.`id` = 1687955 OR `props-main`.`id` = 1687957 OR `props-main`.`id` = 1687982 OR `props-main`.`id` = 1683661 OR `props-main`.`id` = 1688664 OR `props-main`.`id` = 1689496 OR `props-main`.`id` = 1689498 OR `props-main`.`id` = 1674596 OR `props-main`.`id` = 1686355 OR `props-main`.`id` = 1668439 OR `props-main`.`id` = 1668454 OR `props-main`.`id` = 1668433 OR `props-main`.`id` = 1668444 OR `props-main`.`id` = 1668943 OR `props-main`.`id` = 1688638 OR `props-main`.`id` = 1683329 OR `props-main`.`id` = 1676838 OR `props-main`.`id` = 1642940 OR `props-main`.`id` = 1644759 OR `props-main`.`id` = 1657138 OR `props-main`.`id` = 1677794 OR `props-main`.`id` = 1677800 OR `props-main`.`id` = 1677797 OR `props-main`.`id` = 1683205 OR `props-main`.`id` = 1685298 OR `props-main`.`id` = 1667477 OR `props-main`.`id` = 1689425 OR `props-main`.`id` = 1686714 OR `props-main`.`id` = 1686713 OR `props-main`.`id` = 1675152 OR `props-main`.`id` = 1675155 OR `props-main`.`id` = 1681688 OR `props-main`.`id` = 1681689 OR `props-main`.`id` = 1685719 OR `props-main`.`id` = 1675154 OR `props-main`.`id` = 1688584 OR `props-main`.`id` = 1688519 OR `props-main`.`id` = 1689240 OR `props-main`.`id` = 1675217 OR `props-main`.`id` = 1683522 OR `props-main`.`id` = 1683663 OR `props-main`.`id` = 1688055 OR `props-main`.`id` = 1657588 OR `props-main`.`id` = 1681076 OR `props-main`.`id` = 1657568 OR `props-main`.`id` = 1687097 OR `props-main`.`id` = 1686231 OR `props-main`.`id` = 1686230 OR `props-main`.`id` = 1686236 OR `props-main`.`id` = 1684519 OR `props-main`.`id` = 1683722 OR `props-main`.`id` = 1637597 OR `props-main`.`id` = 1681250 OR `props-main`.`id` = 1094176 OR `props-main`.`id` = 1676856 OR `props-main`.`id` = 1676897 OR `props-main`.`id` = 1688140 OR `props-main`.`id` = 1688152 OR `props-main`.`id` = 1688133 OR `props-main`.`id` = 1688139 OR `props-main`.`id` = 1688562 OR `props-main`.`id` = 1615610 OR `props-main`.`id` = 1614319 OR `props-main`.`id` = 1613643 OR `props-main`.`id` = 1685519 OR `props-main`.`id` = 1685528 OR `props-main`.`id` = 1657694 OR `props-main`.`id` = 1674591 OR `props-main`.`id` = 1686674 OR `props-main`.`id` = 1685501 OR `props-main`.`id` = 1679737 OR `props-main`.`id` = 1636871 OR `props-main`.`id` = 1688211 OR `props-main`.`id` = 1689008 OR `props-main`.`id` = 1676324 OR `props-main`.`id` = 1686882 OR `props-main`.`id` = 1684453 OR `props-main`.`id` = 1680768 OR `props-main`.`id` = 1688539 OR `props-main`.`id` = 1680481 OR `props-main`.`id` = 1680496 OR `props-main`.`id` = 1688765 OR `props-main`.`id` = 1688755 OR `props-main`.`id` = 1688795 OR `props-main`.`id` = 1689010 OR `props-main`.`id` = 1673193 OR `props-main`.`id` = 1658281 OR `props-main`.`id` = 1649972 OR `props-main`.`id` = 1686012 OR `props-main`.`id` = 1686009 OR `props-main`.`id` = 1680031 OR `props-main`.`id` = 1685164 OR `props-main`.`id` = 1680275 OR `props-main`.`id` = 1685942 OR `props-main`.`id` = 1684996 OR `props-main`.`id` = 1684097 OR `props-main`.`id` = 1684104 OR `props-main`.`id` = 1684098 OR `props-main`.`id` = 1684111 OR `props-main`.`id` = 1678533 OR `props-main`.`id` = 1678527 OR `props-main`.`id` = 1678528 OR `props-main`.`id` = 1678529 OR `props-main`.`id` = 1668942 OR `props-main`.`id` = 1687914 OR `props-main`.`id` = 1684535 OR `props-main`.`id` = 1684598 OR `props-main`.`id` = 1689541 OR `props-main`.`id` = 1688307 OR `props-main`.`id` = 1688513 OR `props-main`.`id` = 1683885 OR `props-main`.`id` = 1656855)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare229762' 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: