A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 427500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 472500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1467 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1967 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` = 1673424 OR `props-main`.`id` = 1681410 OR `props-main`.`id` = 1685855 OR `props-main`.`id` = 1684878 OR `props-main`.`id` = 1686383 OR `props-main`.`id` = 1687303 OR `props-main`.`id` = 1680907 OR `props-main`.`id` = 1685007 OR `props-main`.`id` = 1689354 OR `props-main`.`id` = 1678109 OR `props-main`.`id` = 1687363 OR `props-main`.`id` = 1643766 OR `props-main`.`id` = 1680763 OR `props-main`.`id` = 1673207 OR `props-main`.`id` = 1680494 OR `props-main`.`id` = 1685835 OR `props-main`.`id` = 1676376 OR `props-main`.`id` = 1673007 OR `props-main`.`id` = 1684793 OR `props-main`.`id` = 1683656 OR `props-main`.`id` = 1663888 OR `props-main`.`id` = 1685949 OR `props-main`.`id` = 1684928 OR `props-main`.`id` = 1682140 OR `props-main`.`id` = 1689622 OR `props-main`.`id` = 1684864 OR `props-main`.`id` = 1686746 OR `props-main`.`id` = 1678660 OR `props-main`.`id` = 1678014 OR `props-main`.`id` = 1668779 OR `props-main`.`id` = 1685679 OR `props-main`.`id` = 1684643 OR `props-main`.`id` = 1625562 OR `props-main`.`id` = 1625566 OR `props-main`.`id` = 1689576 OR `props-main`.`id` = 1660695 OR `props-main`.`id` = 1625666 OR `props-main`.`id` = 1689411 OR `props-main`.`id` = 1682849 OR `props-main`.`id` = 1662021 OR `props-main`.`id` = 1680436 OR `props-main`.`id` = 1676306 OR `props-main`.`id` = 1682690 OR `props-main`.`id` = 1681178 OR `props-main`.`id` = 1688597 OR `props-main`.`id` = 1689115 OR `props-main`.`id` = 1689592 OR `props-main`.`id` = 1685246 OR `props-main`.`id` = 1686159 OR `props-main`.`id` = 1686715 OR `props-main`.`id` = 1680300 OR `props-main`.`id` = 1679086 OR `props-main`.`id` = 1677754 OR `props-main`.`id` = 1685235 OR `props-main`.`id` = 1686640 OR `props-main`.`id` = 1689742 OR `props-main`.`id` = 1687195 OR `props-main`.`id` = 1686423 OR `props-main`.`id` = 1689596 OR `props-main`.`id` = 1686585 OR `props-main`.`id` = 1678552 OR `props-main`.`id` = 1686847 OR `props-main`.`id` = 1644786 OR `props-main`.`id` = 1684517 OR `props-main`.`id` = 1678486 OR `props-main`.`id` = 1687028 OR `props-main`.`id` = 1677611 OR `props-main`.`id` = 1689593 OR `props-main`.`id` = 1684050 OR `props-main`.`id` = 1684515 OR `props-main`.`id` = 1684034 OR `props-main`.`id` = 1680030 OR `props-main`.`id` = 1688711 OR `props-main`.`id` = 1661801 OR `props-main`.`id` = 1689589 OR `props-main`.`id` = 1678036 OR `props-main`.`id` = 1677187 OR `props-main`.`id` = 1681590 OR `props-main`.`id` = 1676779 OR `props-main`.`id` = 1676352 OR `props-main`.`id` = 1672007 OR `props-main`.`id` = 1685329 OR `props-main`.`id` = 1684831 OR `props-main`.`id` = 1674948 OR `props-main`.`id` = 1689355 OR `props-main`.`id` = 1688375 OR `props-main`.`id` = 1686953 OR `props-main`.`id` = 1679295 OR `props-main`.`id` = 1640476 OR `props-main`.`id` = 1681407 OR `props-main`.`id` = 1687054 OR `props-main`.`id` = 1678442 OR `props-main`.`id` = 1688999 OR `props-main`.`id` = 1685422 OR `props-main`.`id` = 1676668 OR `props-main`.`id` = 1673949 OR `props-main`.`id` = 1684985 OR `props-main`.`id` = 1647268 OR `props-main`.`id` = 1673330 OR `props-main`.`id` = 1680628 OR `props-main`.`id` = 1681069 OR `props-main`.`id` = 1684865 OR `props-main`.`id` = 1658477 OR `props-main`.`id` = 1663529)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML81972253' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-14' 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,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.
