A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 213750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 236250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1257 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1757 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` = 1739084 OR `props-main`.`id` = 1754708 OR `props-main`.`id` = 1755566 OR `props-main`.`id` = 1728461 OR `props-main`.`id` = 1754502 OR `props-main`.`id` = 1748528 OR `props-main`.`id` = 1728405 OR `props-main`.`id` = 1729161 OR `props-main`.`id` = 1731181 OR `props-main`.`id` = 1744287 OR `props-main`.`id` = 1745455 OR `props-main`.`id` = 1727434 OR `props-main`.`id` = 1762721 OR `props-main`.`id` = 1748466 OR `props-main`.`id` = 1736767 OR `props-main`.`id` = 1745681 OR `props-main`.`id` = 1728568 OR `props-main`.`id` = 1740792 OR `props-main`.`id` = 1766371 OR `props-main`.`id` = 1740306 OR `props-main`.`id` = 1727432 OR `props-main`.`id` = 1751393 OR `props-main`.`id` = 1764740 OR `props-main`.`id` = 1727451 OR `props-main`.`id` = 1740649 OR `props-main`.`id` = 1738634 OR `props-main`.`id` = 1736534 OR `props-main`.`id` = 1760562 OR `props-main`.`id` = 1728651 OR `props-main`.`id` = 1773144 OR `props-main`.`id` = 1759622 OR `props-main`.`id` = 1749872 OR `props-main`.`id` = 1732278 OR `props-main`.`id` = 1727341 OR `props-main`.`id` = 1748192 OR `props-main`.`id` = 1735548 OR `props-main`.`id` = 1727621 OR `props-main`.`id` = 1774110 OR `props-main`.`id` = 1770882 OR `props-main`.`id` = 1755961 OR `props-main`.`id` = 1737834 OR `props-main`.`id` = 1753084 OR `props-main`.`id` = 1769089 OR `props-main`.`id` = 1733416 OR `props-main`.`id` = 1727564 OR `props-main`.`id` = 1763775 OR `props-main`.`id` = 1729975 OR `props-main`.`id` = 1748527 OR `props-main`.`id` = 1759104 OR `props-main`.`id` = 1754132 OR `props-main`.`id` = 1757221 OR `props-main`.`id` = 1769248 OR `props-main`.`id` = 1701517 OR `props-main`.`id` = 1744538 OR `props-main`.`id` = 1768331 OR `props-main`.`id` = 1738755 OR `props-main`.`id` = 1748339 OR `props-main`.`id` = 1728624 OR `props-main`.`id` = 1728094 OR `props-main`.`id` = 1765116 OR `props-main`.`id` = 1751625 OR `props-main`.`id` = 1770915 OR `props-main`.`id` = 1774172 OR `props-main`.`id` = 1738987 OR `props-main`.`id` = 1755586 OR `props-main`.`id` = 1732563 OR `props-main`.`id` = 1772169 OR `props-main`.`id` = 1751359 OR `props-main`.`id` = 1750751 OR `props-main`.`id` = 1744374 OR `props-main`.`id` = 1738945 OR `props-main`.`id` = 1748609 OR `props-main`.`id` = 1729974 OR `props-main`.`id` = 1765046 OR `props-main`.`id` = 1751381 OR `props-main`.`id` = 1755076 OR `props-main`.`id` = 1731137)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41138122' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-10' 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 11,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.
