A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 527250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 582750 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) >= 1839 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2339 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` = 1714130 OR `props-main`.`id` = 1725131 OR `props-main`.`id` = 1715896 OR `props-main`.`id` = 1704222 OR `props-main`.`id` = 1703284 OR `props-main`.`id` = 1719112 OR `props-main`.`id` = 1716244 OR `props-main`.`id` = 1709832 OR `props-main`.`id` = 1716245 OR `props-main`.`id` = 1716261 OR `props-main`.`id` = 1709821 OR `props-main`.`id` = 1722041 OR `props-main`.`id` = 1714598 OR `props-main`.`id` = 1725222 OR `props-main`.`id` = 1714334 OR `props-main`.`id` = 1723613 OR `props-main`.`id` = 1714721 OR `props-main`.`id` = 1724325 OR `props-main`.`id` = 1724208 OR `props-main`.`id` = 1724604 OR `props-main`.`id` = 1714345 OR `props-main`.`id` = 1724261 OR `props-main`.`id` = 1714770 OR `props-main`.`id` = 1724713 OR `props-main`.`id` = 1724482 OR `props-main`.`id` = 1725184 OR `props-main`.`id` = 1714678 OR `props-main`.`id` = 1718798 OR `props-main`.`id` = 1724234 OR `props-main`.`id` = 1725265 OR `props-main`.`id` = 1713542 OR `props-main`.`id` = 1658344 OR `props-main`.`id` = 1660514 OR `props-main`.`id` = 1658341 OR `props-main`.`id` = 1660513 OR `props-main`.`id` = 1724252 OR `props-main`.`id` = 1721045 OR `props-main`.`id` = 1718178 OR `props-main`.`id` = 1723459 OR `props-main`.`id` = 1724309 OR `props-main`.`id` = 1722494 OR `props-main`.`id` = 1716059 OR `props-main`.`id` = 1717860 OR `props-main`.`id` = 1714749 OR `props-main`.`id` = 1725338 OR `props-main`.`id` = 1721060 OR `props-main`.`id` = 1721913 OR `props-main`.`id` = 1721360 OR `props-main`.`id` = 1723004 OR `props-main`.`id` = 1723011 OR `props-main`.`id` = 1723470 OR `props-main`.`id` = 1716546 OR `props-main`.`id` = 1723478 OR `props-main`.`id` = 1714111 OR `props-main`.`id` = 1714446 OR `props-main`.`id` = 1709819 OR `props-main`.`id` = 1722223 OR `props-main`.`id` = 1719596 OR `props-main`.`id` = 1714898 OR `props-main`.`id` = 1706914 OR `props-main`.`id` = 1719808 OR `props-main`.`id` = 1709718 OR `props-main`.`id` = 1722283 OR `props-main`.`id` = 1705210 OR `props-main`.`id` = 1725100 OR `props-main`.`id` = 1722256 OR `props-main`.`id` = 1695149 OR `props-main`.`id` = 1716662 OR `props-main`.`id` = 1719477 OR `props-main`.`id` = 1711240 OR `props-main`.`id` = 1724759 OR `props-main`.`id` = 1684503 OR `props-main`.`id` = 1666524 OR `props-main`.`id` = 1719254 OR `props-main`.`id` = 1719284 OR `props-main`.`id` = 1716054 OR `props-main`.`id` = 1709963 OR `props-main`.`id` = 1723661 OR `props-main`.`id` = 1724500)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226056306' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-05' 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
Courtesy of Gladys Aguilera, Century 21 Select Real Estate IDX provided by Reliance Marketing
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.
