A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 356250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 393750 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) >= 860 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1360 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` = 1717627 OR `props-main`.`id` = 1712696 OR `props-main`.`id` = 1713650 OR `props-main`.`id` = 1722499 OR `props-main`.`id` = 1716132 OR `props-main`.`id` = 1720556 OR `props-main`.`id` = 1701860 OR `props-main`.`id` = 1723550 OR `props-main`.`id` = 1722422 OR `props-main`.`id` = 1722518 OR `props-main`.`id` = 1723900 OR `props-main`.`id` = 1719616 OR `props-main`.`id` = 1724394 OR `props-main`.`id` = 1719397 OR `props-main`.`id` = 1714587 OR `props-main`.`id` = 1712798 OR `props-main`.`id` = 1724712 OR `props-main`.`id` = 1723791 OR `props-main`.`id` = 1723085 OR `props-main`.`id` = 1723109 OR `props-main`.`id` = 1723111 OR `props-main`.`id` = 1714501 OR `props-main`.`id` = 1723277 OR `props-main`.`id` = 1724230 OR `props-main`.`id` = 1724504 OR `props-main`.`id` = 1724720 OR `props-main`.`id` = 1721787 OR `props-main`.`id` = 1723650 OR `props-main`.`id` = 1724956 OR `props-main`.`id` = 1724708 OR `props-main`.`id` = 1724223 OR `props-main`.`id` = 1712998 OR `props-main`.`id` = 1716936 OR `props-main`.`id` = 1713252 OR `props-main`.`id` = 1706854 OR `props-main`.`id` = 1720648 OR `props-main`.`id` = 1717131 OR `props-main`.`id` = 1724080 OR `props-main`.`id` = 1716343 OR `props-main`.`id` = 1715968 OR `props-main`.`id` = 1709827 OR `props-main`.`id` = 1722284 OR `props-main`.`id` = 1667438 OR `props-main`.`id` = 1721664 OR `props-main`.`id` = 1717098 OR `props-main`.`id` = 1721810 OR `props-main`.`id` = 1723886 OR `props-main`.`id` = 1709706 OR `props-main`.`id` = 1706808 OR `props-main`.`id` = 1721119 OR `props-main`.`id` = 1722677 OR `props-main`.`id` = 1708267 OR `props-main`.`id` = 1722106 OR `props-main`.`id` = 1603454 OR `props-main`.`id` = 1724044 OR `props-main`.`id` = 1724338 OR `props-main`.`id` = 1725188 OR `props-main`.`id` = 1695237 OR `props-main`.`id` = 1723780 OR `props-main`.`id` = 1722526 OR `props-main`.`id` = 1622931 OR `props-main`.`id` = 1721859 OR `props-main`.`id` = 1724944 OR `props-main`.`id` = 1720343 OR `props-main`.`id` = 1716687 OR `props-main`.`id` = 1721579 OR `props-main`.`id` = 1703898 OR `props-main`.`id` = 1714488 OR `props-main`.`id` = 1713767 OR `props-main`.`id` = 1706036 OR `props-main`.`id` = 1724760 OR `props-main`.`id` = 1713166 OR `props-main`.`id` = 1717099 OR `props-main`.`id` = 1719133 OR `props-main`.`id` = 1702640 OR `props-main`.`id` = 1716857 OR `props-main`.`id` = 1716205 OR `props-main`.`id` = 1722028 OR `props-main`.`id` = 1718288 OR `props-main`.`id` = 1718287 OR `props-main`.`id` = 1715644 OR `props-main`.`id` = 1713642 OR `props-main`.`id` = 1717768 OR `props-main`.`id` = 1700111 OR `props-main`.`id` = 1719796 OR `props-main`.`id` = 1710143 OR `props-main`.`id` = 1724556 OR `props-main`.`id` = 1723540 OR `props-main`.`id` = 1721468 OR `props-main`.`id` = 1711578 OR `props-main`.`id` = 1722241 OR `props-main`.`id` = 1721528 OR `props-main`.`id` = 1714310 OR `props-main`.`id` = 1719580 OR `props-main`.`id` = 1719106 OR `props-main`.`id` = 1724100 OR `props-main`.`id` = 1705953 OR `props-main`.`id` = 1722442 OR `props-main`.`id` = 1713619 OR `props-main`.`id` = 1720672 OR `props-main`.`id` = 1718324 OR `props-main`.`id` = 1721821 OR `props-main`.`id` = 1694561 OR `props-main`.`id` = 1724486 OR `props-main`.`id` = 1720745 OR `props-main`.`id` = 1724815 OR `props-main`.`id` = 1724507 OR `props-main`.`id` = 1724393 OR `props-main`.`id` = 1724766 OR `props-main`.`id` = 1721118 OR `props-main`.`id` = 1704719 OR `props-main`.`id` = 1720260 OR `props-main`.`id` = 1717510 OR `props-main`.`id` = 1685406 OR `props-main`.`id` = 1722330 OR `props-main`.`id` = 1724555 OR `props-main`.`id` = 1717322 OR `props-main`.`id` = 1724761 OR `props-main`.`id` = 1701269 OR `props-main`.`id` = 1713497 OR `props-main`.`id` = 1723141 OR `props-main`.`id` = 1723155)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226055789' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-04' 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();