A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 916750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1013250 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) >= 1381 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1881 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` = 1718793 OR `props-main`.`id` = 1706976 OR `props-main`.`id` = 1717722 OR `props-main`.`id` = 1719402 OR `props-main`.`id` = 1718722 OR `props-main`.`id` = 1719275 OR `props-main`.`id` = 1714021 OR `props-main`.`id` = 1716718 OR `props-main`.`id` = 1716361 OR `props-main`.`id` = 1715549 OR `props-main`.`id` = 1715548 OR `props-main`.`id` = 1715550 OR `props-main`.`id` = 1715551 OR `props-main`.`id` = 1719586 OR `props-main`.`id` = 1683594 OR `props-main`.`id` = 1685282 OR `props-main`.`id` = 1713957 OR `props-main`.`id` = 1703910 OR `props-main`.`id` = 1717146 OR `props-main`.`id` = 1700898 OR `props-main`.`id` = 1716100 OR `props-main`.`id` = 1703395 OR `props-main`.`id` = 1718935 OR `props-main`.`id` = 1701610 OR `props-main`.`id` = 1714877 OR `props-main`.`id` = 1702239 OR `props-main`.`id` = 1712586 OR `props-main`.`id` = 1668328 OR `props-main`.`id` = 1719721 OR `props-main`.`id` = 1680645 OR `props-main`.`id` = 1713533 OR `props-main`.`id` = 1706989 OR `props-main`.`id` = 1705858 OR `props-main`.`id` = 1718405 OR `props-main`.`id` = 1703477 OR `props-main`.`id` = 1706901 OR `props-main`.`id` = 1719753 OR `props-main`.`id` = 1719130 OR `props-main`.`id` = 1716894 OR `props-main`.`id` = 1707098 OR `props-main`.`id` = 1715796 OR `props-main`.`id` = 1708488 OR `props-main`.`id` = 1702032 OR `props-main`.`id` = 1715820 OR `props-main`.`id` = 1715819 OR `props-main`.`id` = 1713731 OR `props-main`.`id` = 1714879 OR `props-main`.`id` = 1713172 OR `props-main`.`id` = 1689688 OR `props-main`.`id` = 1689004 OR `props-main`.`id` = 1690508 OR `props-main`.`id` = 1702071 OR `props-main`.`id` = 1704091 OR `props-main`.`id` = 1717363 OR `props-main`.`id` = 1718145 OR `props-main`.`id` = 1716666 OR `props-main`.`id` = 1719423 OR `props-main`.`id` = 1707136 OR `props-main`.`id` = 1702661 OR `props-main`.`id` = 1702662 OR `props-main`.`id` = 1687991 OR `props-main`.`id` = 1710121 OR `props-main`.`id` = 1705965 OR `props-main`.`id` = 1713285)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC24052511' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-04' 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();
5
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$999,988
3
3
1,710
0.09
161 Tango
San Luis Obispo, CA 93401
$989,000
3
3
1,615
0.06
194 Earthwood Ln
San Luis Obispo, CA 93401
$931,725
3
3
1,609
0.06
256 Memphis Belle Way
San Luis Obispo, CA 93401
$925,000
3
3
1,558
0.06
780 Haystack Place
San Luis Obispo, CA 93405
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.
