A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 389500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 430500 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) >= 1215 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1715 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` = 1687086 OR `props-main`.`id` = 1657190 OR `props-main`.`id` = 1657199 OR `props-main`.`id` = 1673154 OR `props-main`.`id` = 1689261 OR `props-main`.`id` = 1689499 OR `props-main`.`id` = 180610 OR `props-main`.`id` = 1683621 OR `props-main`.`id` = 1683514 OR `props-main`.`id` = 1632076 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` = 1689471 OR `props-main`.`id` = 1673311 OR `props-main`.`id` = 1673635 OR `props-main`.`id` = 1683193 OR `props-main`.`id` = 1686810 OR `props-main`.`id` = 1685375 OR `props-main`.`id` = 1689417 OR `props-main`.`id` = 86628 OR `props-main`.`id` = 1686743 OR `props-main`.`id` = 1686070 OR `props-main`.`id` = 1683053 OR `props-main`.`id` = 1688806 OR `props-main`.`id` = 1685975 OR `props-main`.`id` = 1686809 OR `props-main`.`id` = 1684627 OR `props-main`.`id` = 1685123 OR `props-main`.`id` = 1676891 OR `props-main`.`id` = 1688467 OR `props-main`.`id` = 1657351 OR `props-main`.`id` = 1688537 OR `props-main`.`id` = 1679921 OR `props-main`.`id` = 1666457 OR `props-main`.`id` = 1666460 OR `props-main`.`id` = 1680814 OR `props-main`.`id` = 1674222 OR `props-main`.`id` = 1689265 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` = 1689450 OR `props-main`.`id` = 1678175 OR `props-main`.`id` = 1689226 OR `props-main`.`id` = 1689290 OR `props-main`.`id` = 1676568 OR `props-main`.`id` = 1684202 OR `props-main`.`id` = 1667572 OR `props-main`.`id` = 1683686 OR `props-main`.`id` = 1689282 OR `props-main`.`id` = 1684908 OR `props-main`.`id` = 1674697 OR `props-main`.`id` = 1688459 OR `props-main`.`id` = 1687357 OR `props-main`.`id` = 1689652 OR `props-main`.`id` = 1688385 OR `props-main`.`id` = 1673696 OR `props-main`.`id` = 1678114 OR `props-main`.`id` = 1685447 OR `props-main`.`id` = 1688337 OR `props-main`.`id` = 1685024 OR `props-main`.`id` = 1642537 OR `props-main`.`id` = 1686163 OR `props-main`.`id` = 248876 OR `props-main`.`id` = 261479 OR `props-main`.`id` = 1684953 OR `props-main`.`id` = 1661800 OR `props-main`.`id` = 1685023 OR `props-main`.`id` = 1671754 OR `props-main`.`id` = 1654023 OR `props-main`.`id` = 1658333 OR `props-main`.`id` = 1684421 OR `props-main`.`id` = 1688987 OR `props-main`.`id` = 1686871 OR `props-main`.`id` = 1684837 OR `props-main`.`id` = 1683107 OR `props-main`.`id` = 1651438 OR `props-main`.`id` = 1685059 OR `props-main`.`id` = 1689474 OR `props-main`.`id` = 1688297 OR `props-main`.`id` = 1688318 OR `props-main`.`id` = 1679511 OR `props-main`.`id` = 1680357 OR `props-main`.`id` = 1638016 OR `props-main`.`id` = 1677294 OR `props-main`.`id` = 1686670 OR `props-main`.`id` = 1678849 OR `props-main`.`id` = 1688927 OR `props-main`.`id` = 1683168 OR `props-main`.`id` = 1681360 OR `props-main`.`id` = 1683295 OR `props-main`.`id` = 1680453 OR `props-main`.`id` = 1673634 OR `props-main`.`id` = 1648636 OR `props-main`.`id` = 1680793 OR `props-main`.`id` = 1688737 OR `props-main`.`id` = 1683973 OR `props-main`.`id` = 1679272 OR `props-main`.`id` = 1672856 OR `props-main`.`id` = 1687358 OR `props-main`.`id` = 1668069 OR `props-main`.`id` = 1668077 OR `props-main`.`id` = 1668087 OR `props-main`.`id` = 1652560 OR `props-main`.`id` = 1680470 OR `props-main`.`id` = 1665941 OR `props-main`.`id` = 1646806 OR `props-main`.`id` = 1673041 OR `props-main`.`id` = 1672985 OR `props-main`.`id` = 1673039 OR `props-main`.`id` = 1683175 OR `props-main`.`id` = 217900 OR `props-main`.`id` = 1678889 OR `props-main`.`id` = 1688423 OR `props-main`.`id` = 1680568 OR `props-main`.`id` = 1670908 OR `props-main`.`id` = 1681580 OR `props-main`.`id` = 217381 OR `props-main`.`id` = 1682061 OR `props-main`.`id` = 1684199)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsTR25123579' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-12' 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();