A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 945250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1044750 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) >= 1550 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2050 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` = 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` = 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` = 1689613 OR `props-main`.`id` = 1623519 OR `props-main`.`id` = 1689539 OR `props-main`.`id` = 1674172 OR `props-main`.`id` = 1687515 OR `props-main`.`id` = 1671623 OR `props-main`.`id` = 1657811 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` = 1688153 OR `props-main`.`id` = 1688532 OR `props-main`.`id` = 1680831 OR `props-main`.`id` = 1686444 OR `props-main`.`id` = 1685477 OR `props-main`.`id` = 1686613 OR `props-main`.`id` = 1689249 OR `props-main`.`id` = 1652999 OR `props-main`.`id` = 1673686 OR `props-main`.`id` = 1637276 OR `props-main`.`id` = 1684925 OR `props-main`.`id` = 1685281 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` = 1623381 OR `props-main`.`id` = 1655059 OR `props-main`.`id` = 1678609 OR `props-main`.`id` = 1674440 OR `props-main`.`id` = 1631363 OR `props-main`.`id` = 1639815)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC24117440' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-13' 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:
$975,000
3
2
1,673
0.13
449 Mar Vista Drive
Los Osos, CA 93402
$974,000
3
2
1,597
0.11
1630 13th St
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.
