A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1140000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1260000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1731 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2231 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` = 1636887 OR `props-main`.`id` = 1623193 OR `props-main`.`id` = 1679105 OR `props-main`.`id` = 1688776 OR `props-main`.`id` = 1679568 OR `props-main`.`id` = 1623316 OR `props-main`.`id` = 1645585 OR `props-main`.`id` = 1623322 OR `props-main`.`id` = 1688022 OR `props-main`.`id` = 1683593 OR `props-main`.`id` = 1685230 OR `props-main`.`id` = 1687947 OR `props-main`.`id` = 1623423 OR `props-main`.`id` = 1688154 OR `props-main`.`id` = 1689134 OR `props-main`.`id` = 1686113 OR `props-main`.`id` = 1688321 OR `props-main`.`id` = 1690120 OR `props-main`.`id` = 1689318 OR `props-main`.`id` = 1656674 OR `props-main`.`id` = 1630139 OR `props-main`.`id` = 1630473 OR `props-main`.`id` = 1685569 OR `props-main`.`id` = 1686199 OR `props-main`.`id` = 1690558 OR `props-main`.`id` = 1691028 OR `props-main`.`id` = 1691027 OR `props-main`.`id` = 1623519 OR `props-main`.`id` = 1689539 OR `props-main`.`id` = 1674172 OR `props-main`.`id` = 1690566 OR `props-main`.`id` = 1690568 OR `props-main`.`id` = 1687515 OR `props-main`.`id` = 1690565 OR `props-main`.`id` = 1690567 OR `props-main`.`id` = 1671623 OR `props-main`.`id` = 1674195 OR `props-main`.`id` = 1647434 OR `props-main`.`id` = 1680756 OR `props-main`.`id` = 1647433 OR `props-main`.`id` = 1671633 OR `props-main`.`id` = 1689228 OR `props-main`.`id` = 1672831 OR `props-main`.`id` = 1680831 OR `props-main`.`id` = 1691052 OR `props-main`.`id` = 1685477 OR `props-main`.`id` = 1686613 OR `props-main`.`id` = 1690922 OR `props-main`.`id` = 1689249 OR `props-main`.`id` = 1652999 OR `props-main`.`id` = 1689943 OR `props-main`.`id` = 1673686 OR `props-main`.`id` = 1637276 OR `props-main`.`id` = 1679278 OR `props-main`.`id` = 1649121 OR `props-main`.`id` = 1652503 OR `props-main`.`id` = 1683271 OR `props-main`.`id` = 1663489 OR `props-main`.`id` = 1689459 OR `props-main`.`id` = 1636610 OR `props-main`.`id` = 1623381 OR `props-main`.`id` = 1655059 OR `props-main`.`id` = 1678609 OR `props-main`.`id` = 1690613 OR `props-main`.`id` = 1674440 OR `props-main`.`id` = 1631363)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC24120241' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-23' 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();
2
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$1,199,000
3
4
1,751
0.14
1440 Pismo Avenue
Los Osos, CA 93402
$1,195,000
4
2
2,221
0.27
1421 Las Encinas Dr
Los Osos, CA 93402
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.
