A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1003 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1503 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` = 1679632 OR `props-main`.`id` = 1688089 OR `props-main`.`id` = 1686765 OR `props-main`.`id` = 1685876 OR `props-main`.`id` = 1689253 OR `props-main`.`id` = 1687922 OR `props-main`.`id` = 1678575 OR `props-main`.`id` = 1687926 OR `props-main`.`id` = 1687925 OR `props-main`.`id` = 1685109 OR `props-main`.`id` = 1685110 OR `props-main`.`id` = 1687923 OR `props-main`.`id` = 1666604 OR `props-main`.`id` = 1685111 OR `props-main`.`id` = 1687924 OR `props-main`.`id` = 1684912 OR `props-main`.`id` = 1688712 OR `props-main`.`id` = 1679721 OR `props-main`.`id` = 1678991 OR `props-main`.`id` = 1678998 OR `props-main`.`id` = 1656911 OR `props-main`.`id` = 1664251 OR `props-main`.`id` = 1673414 OR `props-main`.`id` = 1681238 OR `props-main`.`id` = 1656028 OR `props-main`.`id` = 1666305 OR `props-main`.`id` = 1685454 OR `props-main`.`id` = 1689109 OR `props-main`.`id` = 1681375 OR `props-main`.`id` = 1688878 OR `props-main`.`id` = 1687386 OR `props-main`.`id` = 1683914 OR `props-main`.`id` = 1686880 OR `props-main`.`id` = 1683687 OR `props-main`.`id` = 1680358 OR `props-main`.`id` = 1671592 OR `props-main`.`id` = 1671586 OR `props-main`.`id` = 1688401 OR `props-main`.`id` = 1684027 OR `props-main`.`id` = 1687464 OR `props-main`.`id` = 689708 OR `props-main`.`id` = 1689443 OR `props-main`.`id` = 1686102 OR `props-main`.`id` = 1677866 OR `props-main`.`id` = 1687177 OR `props-main`.`id` = 1688296 OR `props-main`.`id` = 1688317 OR `props-main`.`id` = 1688143 OR `props-main`.`id` = 232301 OR `props-main`.`id` = 1688136 OR `props-main`.`id` = 1688300 OR `props-main`.`id` = 1688268 OR `props-main`.`id` = 1686023 OR `props-main`.`id` = 1685936 OR `props-main`.`id` = 1685996 OR `props-main`.`id` = 1687086 OR `props-main`.`id` = 1687422 OR `props-main`.`id` = 1668271 OR `props-main`.`id` = 1657190 OR `props-main`.`id` = 1681288 OR `props-main`.`id` = 1657199 OR `props-main`.`id` = 1674421 OR `props-main`.`id` = 1653283 OR `props-main`.`id` = 1686905 OR `props-main`.`id` = 1665613 OR `props-main`.`id` = 1673154 OR `props-main`.`id` = 1689261 OR `props-main`.`id` = 1685470 OR `props-main`.`id` = 180610 OR `props-main`.`id` = 1684168 OR `props-main`.`id` = 1683621 OR `props-main`.`id` = 1683514 OR `props-main`.`id` = 1681988 OR `props-main`.`id` = 1632076 OR `props-main`.`id` = 1686650 OR `props-main`.`id` = 1675105 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` = 1673311 OR `props-main`.`id` = 1673635 OR `props-main`.`id` = 1683193 OR `props-main`.`id` = 1686691 OR `props-main`.`id` = 70513 OR `props-main`.`id` = 1686810 OR `props-main`.`id` = 1685375 OR `props-main`.`id` = 1689417 OR `props-main`.`id` = 1688745 OR `props-main`.`id` = 1686743 OR `props-main`.`id` = 1686070 OR `props-main`.`id` = 1688806 OR `props-main`.`id` = 1684627 OR `props-main`.`id` = 1688467 OR `props-main`.`id` = 1684686 OR `props-main`.`id` = 1657351 OR `props-main`.`id` = 1679921 OR `props-main`.`id` = 1674222 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` = 1676568 OR `props-main`.`id` = 1684202 OR `props-main`.`id` = 1684908 OR `props-main`.`id` = 1687357 OR `props-main`.`id` = 248876 OR `props-main`.`id` = 261479 OR `props-main`.`id` = 1686871 OR `props-main`.`id` = 1684837 OR `props-main`.`id` = 1683107 OR `props-main`.`id` = 1688297 OR `props-main`.`id` = 1688318 OR `props-main`.`id` = 1686670)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25224660' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-10' 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();