A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 399000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 441000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1546 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2046 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` = 204765 OR `props-main`.`id` = 1755176 OR `props-main`.`id` = 1713342 OR `props-main`.`id` = 1737113 OR `props-main`.`id` = 1737134 OR `props-main`.`id` = 1737196 OR `props-main`.`id` = 1721101 OR `props-main`.`id` = 1721326 OR `props-main`.`id` = 1752967 OR `props-main`.`id` = 1752982 OR `props-main`.`id` = 1754673 OR `props-main`.`id` = 1755262 OR `props-main`.`id` = 1713511 OR `props-main`.`id` = 1725489 OR `props-main`.`id` = 1746429 OR `props-main`.`id` = 1746399 OR `props-main`.`id` = 1736125 OR `props-main`.`id` = 1736163 OR `props-main`.`id` = 1726991 OR `props-main`.`id` = 1726957 OR `props-main`.`id` = 1751615 OR `props-main`.`id` = 1747638 OR `props-main`.`id` = 1728646 OR `props-main`.`id` = 1728953 OR `props-main`.`id` = 1728957 OR `props-main`.`id` = 1749568 OR `props-main`.`id` = 1754331 OR `props-main`.`id` = 1749567 OR `props-main`.`id` = 1753409 OR `props-main`.`id` = 1753560 OR `props-main`.`id` = 1754359 OR `props-main`.`id` = 1753577 OR `props-main`.`id` = 1749711 OR `props-main`.`id` = 1749721 OR `props-main`.`id` = 1743212 OR `props-main`.`id` = 1743901 OR `props-main`.`id` = 1731812 OR `props-main`.`id` = 1728909 OR `props-main`.`id` = 1752152 OR `props-main`.`id` = 1725629 OR `props-main`.`id` = 1744526 OR `props-main`.`id` = 1754627 OR `props-main`.`id` = 1741482 OR `props-main`.`id` = 1728505 OR `props-main`.`id` = 1746893 OR `props-main`.`id` = 1734891 OR `props-main`.`id` = 1755211 OR `props-main`.`id` = 1755258 OR `props-main`.`id` = 1734087 OR `props-main`.`id` = 1749566 OR `props-main`.`id` = 1749584 OR `props-main`.`id` = 1754977 OR `props-main`.`id` = 1753399 OR `props-main`.`id` = 1718560 OR `props-main`.`id` = 1718552 OR `props-main`.`id` = 1739664 OR `props-main`.`id` = 1727790 OR `props-main`.`id` = 1746062 OR `props-main`.`id` = 1754495 OR `props-main`.`id` = 1754597 OR `props-main`.`id` = 1754485 OR `props-main`.`id` = 1734116 OR `props-main`.`id` = 1706773 OR `props-main`.`id` = 1727560 OR `props-main`.`id` = 1754635 OR `props-main`.`id` = 1724895 OR `props-main`.`id` = 1724960 OR `props-main`.`id` = 1724962 OR `props-main`.`id` = 1728178 OR `props-main`.`id` = 1727980 OR `props-main`.`id` = 1727994 OR `props-main`.`id` = 1728191 OR `props-main`.`id` = 1728013 OR `props-main`.`id` = 1741656 OR `props-main`.`id` = 1741666 OR `props-main`.`id` = 1741676 OR `props-main`.`id` = 1736853 OR `props-main`.`id` = 1755275 OR `props-main`.`id` = 1687778 OR `props-main`.`id` = 1753927 OR `props-main`.`id` = 1753941 OR `props-main`.`id` = 1722652 OR `props-main`.`id` = 1722651 OR `props-main`.`id` = 1709676 OR `props-main`.`id` = 1735461 OR `props-main`.`id` = 1738269 OR `props-main`.`id` = 1745257 OR `props-main`.`id` = 1745229 OR `props-main`.`id` = 1721195)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82050167' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-30' 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 10,700 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.
