A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 825550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 912450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 630 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1130 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` = 1726266 OR `props-main`.`id` = 1707957 OR `props-main`.`id` = 1691761 OR `props-main`.`id` = 1717013 OR `props-main`.`id` = 1746660 OR `props-main`.`id` = 1747159 OR `props-main`.`id` = 1728534 OR `props-main`.`id` = 1738856 OR `props-main`.`id` = 1702287 OR `props-main`.`id` = 1745925 OR `props-main`.`id` = 1728218 OR `props-main`.`id` = 1728183 OR `props-main`.`id` = 1738589 OR `props-main`.`id` = 1742280 OR `props-main`.`id` = 1679261 OR `props-main`.`id` = 1733209 OR `props-main`.`id` = 1703909 OR `props-main`.`id` = 1719274 OR `props-main`.`id` = 1747200 OR `props-main`.`id` = 1723587 OR `props-main`.`id` = 1737774 OR `props-main`.`id` = 1742192 OR `props-main`.`id` = 1737326 OR `props-main`.`id` = 1745316 OR `props-main`.`id` = 1721150 OR `props-main`.`id` = 1731127 OR `props-main`.`id` = 1735356 OR `props-main`.`id` = 1725701 OR `props-main`.`id` = 1727064 OR `props-main`.`id` = 1746270 OR `props-main`.`id` = 1723423 OR `props-main`.`id` = 1742283 OR `props-main`.`id` = 1725681 OR `props-main`.`id` = 1747419 OR `props-main`.`id` = 1745459 OR `props-main`.`id` = 1745166 OR `props-main`.`id` = 1657720 OR `props-main`.`id` = 1745677 OR `props-main`.`id` = 1742865 OR `props-main`.`id` = 1715755 OR `props-main`.`id` = 1692599 OR `props-main`.`id` = 1733507 OR `props-main`.`id` = 1658089 OR `props-main`.`id` = 1623290 OR `props-main`.`id` = 1719213)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC26105500' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-11' 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:
$849,000
2
1
728
0.06
3437 Shearer Avenue
Cayucos, CA 93430
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.
