A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 555750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 614250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1941 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2441 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` = 1694977 OR `props-main`.`id` = 1622892 OR `props-main`.`id` = 1697522 OR `props-main`.`id` = 1645586 OR `props-main`.`id` = 1697842 OR `props-main`.`id` = 1697858 OR `props-main`.`id` = 1685840 OR `props-main`.`id` = 1633654 OR `props-main`.`id` = 1694963 OR `props-main`.`id` = 1692822 OR `props-main`.`id` = 1691729 OR `props-main`.`id` = 1686002 OR `props-main`.`id` = 1675303 OR `props-main`.`id` = 1696652 OR `props-main`.`id` = 1695038 OR `props-main`.`id` = 1695334 OR `props-main`.`id` = 1692161 OR `props-main`.`id` = 1693971 OR `props-main`.`id` = 1665550 OR `props-main`.`id` = 291212 OR `props-main`.`id` = 1695488 OR `props-main`.`id` = 1679235 OR `props-main`.`id` = 1696999 OR `props-main`.`id` = 1694964 OR `props-main`.`id` = 1687144 OR `props-main`.`id` = 1694976 OR `props-main`.`id` = 1680830 OR `props-main`.`id` = 788148 OR `props-main`.`id` = 1697105 OR `props-main`.`id` = 1696839 OR `props-main`.`id` = 1693974 OR `props-main`.`id` = 1694679 OR `props-main`.`id` = 1693859 OR `props-main`.`id` = 1631841 OR `props-main`.`id` = 1691250 OR `props-main`.`id` = 77474 OR `props-main`.`id` = 1683579 OR `props-main`.`id` = 1673816 OR `props-main`.`id` = 87746 OR `props-main`.`id` = 1681389 OR `props-main`.`id` = 1681378 OR `props-main`.`id` = 1691953 OR `props-main`.`id` = 1691950 OR `props-main`.`id` = 1695408 OR `props-main`.`id` = 1659395 OR `props-main`.`id` = 1695413 OR `props-main`.`id` = 1695333 OR `props-main`.`id` = 1697187 OR `props-main`.`id` = 270485 OR `props-main`.`id` = 1696095 OR `props-main`.`id` = 1696116 OR `props-main`.`id` = 1696131 OR `props-main`.`id` = 1694328 OR `props-main`.`id` = 1694332 OR `props-main`.`id` = 1694334 OR `props-main`.`id` = 224715 OR `props-main`.`id` = 224717 OR `props-main`.`id` = 1687504 OR `props-main`.`id` = 1696741 OR `props-main`.`id` = 1696130 OR `props-main`.`id` = 1671187 OR `props-main`.`id` = 1695785 OR `props-main`.`id` = 1696844 OR `props-main`.`id` = 1696986 OR `props-main`.`id` = 1684373 OR `props-main`.`id` = 1684370 OR `props-main`.`id` = 1686079 OR `props-main`.`id` = 1691912 OR `props-main`.`id` = 93375 OR `props-main`.`id` = 1697698 OR `props-main`.`id` = 1686717 OR `props-main`.`id` = 1696913 OR `props-main`.`id` = 1695821 OR `props-main`.`id` = 1696336 OR `props-main`.`id` = 1696071 OR `props-main`.`id` = 1695361 OR `props-main`.`id` = 1637274 OR `props-main`.`id` = 1695368 OR `props-main`.`id` = 1688618 OR `props-main`.`id` = 1689807 OR `props-main`.`id` = 1667441 OR `props-main`.`id` = 1667401 OR `props-main`.`id` = 1697374 OR `props-main`.`id` = 1690905 OR `props-main`.`id` = 1690919 OR `props-main`.`id` = 223289 OR `props-main`.`id` = 223288 OR `props-main`.`id` = 1692307 OR `props-main`.`id` = 1659390 OR `props-main`.`id` = 1659386 OR `props-main`.`id` = 1659394 OR `props-main`.`id` = 1691397 OR `props-main`.`id` = 1693860 OR `props-main`.`id` = 1682982 OR `props-main`.`id` = 1685606 OR `props-main`.`id` = 1697758 OR `props-main`.`id` = 1697765 OR `props-main`.`id` = 1697768 OR `props-main`.`id` = 1693903 OR `props-main`.`id` = 1671252 OR `props-main`.`id` = 1671258 OR `props-main`.`id` = 1691670 OR `props-main`.`id` = 202390 OR `props-main`.`id` = 1696692 OR `props-main`.`id` = 1696472 OR `props-main`.`id` = 1697524 OR `props-main`.`id` = 1692357 OR `props-main`.`id` = 1686794 OR `props-main`.`id` = 1685713 OR `props-main`.`id` = 206435 OR `props-main`.`id` = 1692668 OR `props-main`.`id` = 1622703 OR `props-main`.`id` = 1692788 OR `props-main`.`id` = 1695702 OR `props-main`.`id` = 1695723 OR `props-main`.`id` = 1651652 OR `props-main`.`id` = 204765 OR `props-main`.`id` = 1697659 OR `props-main`.`id` = 1697203 OR `props-main`.`id` = 1633539 OR `props-main`.`id` = 360956 OR `props-main`.`id` = 1697465 OR `props-main`.`id` = 1696384 OR `props-main`.`id` = 1685969 OR `props-main`.`id` = 1685977 OR `props-main`.`id` = 1622834 OR `props-main`.`id` = 1656522 OR `props-main`.`id` = 1689536 OR `props-main`.`id` = 1683766 OR `props-main`.`id` = 1683771 OR `props-main`.`id` = 1691662 OR `props-main`.`id` = 1693408 OR `props-main`.`id` = 1689130 OR `props-main`.`id` = 1683576 OR `props-main`.`id` = 1693788 OR `props-main`.`id` = 1694943 OR `props-main`.`id` = 1695710 OR `props-main`.`id` = 1666278)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC24202694' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-13' 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();
0
CAME_FROM_PROP_SITE:
We're sorry, this listing is no longer available. Please click here to search from over 9,100 active listings.
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
