A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 498750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 551250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 856 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1356 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` = 1702900 OR `props-main`.`id` = 1716800 OR `props-main`.`id` = 1680387 OR `props-main`.`id` = 1659690 OR `props-main`.`id` = 1695036 OR `props-main`.`id` = 1706938 OR `props-main`.`id` = 1702434 OR `props-main`.`id` = 1717778 OR `props-main`.`id` = 1716603 OR `props-main`.`id` = 1704048 OR `props-main`.`id` = 1716335 OR `props-main`.`id` = 1719125 OR `props-main`.`id` = 1716925 OR `props-main`.`id` = 1698109 OR `props-main`.`id` = 1698110 OR `props-main`.`id` = 1698112 OR `props-main`.`id` = 1692090 OR `props-main`.`id` = 1715837 OR `props-main`.`id` = 1698111 OR `props-main`.`id` = 1692092 OR `props-main`.`id` = 1693742 OR `props-main`.`id` = 1707897 OR `props-main`.`id` = 1684438 OR `props-main`.`id` = 1701091 OR `props-main`.`id` = 1709746 OR `props-main`.`id` = 1709285 OR `props-main`.`id` = 1698903 OR `props-main`.`id` = 1705198 OR `props-main`.`id` = 1701494 OR `props-main`.`id` = 1703822 OR `props-main`.`id` = 1703825 OR `props-main`.`id` = 1703826 OR `props-main`.`id` = 1703823 OR `props-main`.`id` = 1703824 OR `props-main`.`id` = 1707871 OR `props-main`.`id` = 1685873 OR `props-main`.`id` = 1702382 OR `props-main`.`id` = 1717361 OR `props-main`.`id` = 1701141 OR `props-main`.`id` = 1695460 OR `props-main`.`id` = 1695599 OR `props-main`.`id` = 1704566 OR `props-main`.`id` = 1708381 OR `props-main`.`id` = 1712548 OR `props-main`.`id` = 1713770 OR `props-main`.`id` = 1702313 OR `props-main`.`id` = 1707994 OR `props-main`.`id` = 1719422 OR `props-main`.`id` = 1713070 OR `props-main`.`id` = 1718479 OR `props-main`.`id` = 1637972 OR `props-main`.`id` = 1713768 OR `props-main`.`id` = 1713150 OR `props-main`.`id` = 1686445 OR `props-main`.`id` = 1713384 OR `props-main`.`id` = 1719689 OR `props-main`.`id` = 1623058 OR `props-main`.`id` = 1719619 OR `props-main`.`id` = 1708055 OR `props-main`.`id` = 1717264 OR `props-main`.`id` = 1623066 OR `props-main`.`id` = 1640741 OR `props-main`.`id` = 1713742)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsNS24115708' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-03' 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:
$499,900
3
2
1,044
0.14
1107 Patricia
Paso Robles, CA 93446
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.
