A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 994338.4 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1099005.6 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) >= 1561 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2061 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` = 1664201 OR `props-main`.`id` = 1697214 OR `props-main`.`id` = 1701282 OR `props-main`.`id` = 1694310 OR `props-main`.`id` = 1692444 OR `props-main`.`id` = 1691489 OR `props-main`.`id` = 1673317 OR `props-main`.`id` = 1680132 OR `props-main`.`id` = 1685333 OR `props-main`.`id` = 1685334 OR `props-main`.`id` = 1688733 OR `props-main`.`id` = 1683594 OR `props-main`.`id` = 1689492 OR `props-main`.`id` = 1689540 OR `props-main`.`id` = 1685282 OR `props-main`.`id` = 1693760 OR `props-main`.`id` = 1701090 OR `props-main`.`id` = 1696477 OR `props-main`.`id` = 1697002 OR `props-main`.`id` = 1700931 OR `props-main`.`id` = 1685952 OR `props-main`.`id` = 1700898 OR `props-main`.`id` = 1656779 OR `props-main`.`id` = 1676256 OR `props-main`.`id` = 1668328 OR `props-main`.`id` = 1649797 OR `props-main`.`id` = 1695010 OR `props-main`.`id` = 1695430 OR `props-main`.`id` = 1690590 OR `props-main`.`id` = 1677935 OR `props-main`.`id` = 1696414 OR `props-main`.`id` = 1686681 OR `props-main`.`id` = 1688182 OR `props-main`.`id` = 1690705 OR `props-main`.`id` = 1668175 OR `props-main`.`id` = 1623404 OR `props-main`.`id` = 1697318 OR `props-main`.`id` = 1689688)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC25267401' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-06' 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();
1
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$998,860
3
3
1,708
0.09
209 Foxtrot Ct
San Luis Obispo, CA 93401
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.
