A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 902500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 997500 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) >= 2080 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2580 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` = 1741325 OR `props-main`.`id` = 1693448 OR `props-main`.`id` = 1739575 OR `props-main`.`id` = 1750679 OR `props-main`.`id` = 1701144 OR `props-main`.`id` = 1742790 OR `props-main`.`id` = 1723344 OR `props-main`.`id` = 1737172 OR `props-main`.`id` = 1723366 OR `props-main`.`id` = 1623058 OR `props-main`.`id` = 1725102 OR `props-main`.`id` = 1728408 OR `props-main`.`id` = 1723368 OR `props-main`.`id` = 1727582 OR `props-main`.`id` = 1727274 OR `props-main`.`id` = 1739795 OR `props-main`.`id` = 1727782 OR `props-main`.`id` = 1736941 OR `props-main`.`id` = 1735819 OR `props-main`.`id` = 1750990 OR `props-main`.`id` = 1697759 OR `props-main`.`id` = 1697677 OR `props-main`.`id` = 1750643 OR `props-main`.`id` = 1742183 OR `props-main`.`id` = 1723350 OR `props-main`.`id` = 1747697 OR `props-main`.`id` = 1733379 OR `props-main`.`id` = 1724540 OR `props-main`.`id` = 1738201 OR `props-main`.`id` = 1742847 OR `props-main`.`id` = 1734117 OR `props-main`.`id` = 1709964 OR `props-main`.`id` = 1719102 OR `props-main`.`id` = 1742674 OR `props-main`.`id` = 1721738 OR `props-main`.`id` = 1723013 OR `props-main`.`id` = 1716449 OR `props-main`.`id` = 1640741 OR `props-main`.`id` = 1745335 OR `props-main`.`id` = 1732694 OR `props-main`.`id` = 1709204 OR `props-main`.`id` = 1732738 OR `props-main`.`id` = 1732739 OR `props-main`.`id` = 1722231 OR `props-main`.`id` = 1722631 OR `props-main`.`id` = 1721764 OR `props-main`.`id` = 1723486 OR `props-main`.`id` = 1723319 OR `props-main`.`id` = 1724732 OR `props-main`.`id` = 1728738 OR `props-main`.`id` = 1723876 OR `props-main`.`id` = 1731858 OR `props-main`.`id` = 1750193 OR `props-main`.`id` = 1748148 OR `props-main`.`id` = 1723364 OR `props-main`.`id` = 1720610 OR `props-main`.`id` = 1723332 OR `props-main`.`id` = 1734613 OR `props-main`.`id` = 1696208 OR `props-main`.`id` = 1623078 OR `props-main`.`id` = 1623077 OR `props-main`.`id` = 1441090 OR `props-main`.`id` = 1729985 OR `props-main`.`id` = 1732024 OR `props-main`.`id` = 1732835 OR `props-main`.`id` = 1689003 OR `props-main`.`id` = 1729984 OR `props-main`.`id` = 1721039 OR `props-main`.`id` = 1724579 OR `props-main`.`id` = 1649812 OR `props-main`.`id` = 1734088 OR `props-main`.`id` = 1725470 OR `props-main`.`id` = 1717415 OR `props-main`.`id` = 1696746 OR `props-main`.`id` = 1725471 OR `props-main`.`id` = 1703862 OR `props-main`.`id` = 1696745 OR `props-main`.`id` = 1745983)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsPI26139889' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-18' 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();
3
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$989,900
3
3
2,333
0.46
609 Shannon Hill Dr
Paso Robles, CA 93446
$949,000
3
2
2,165
0.21
721 Lenox Ct
Paso Robles, CA 93446
$945,000
4
3
2,508
0.29
322 Montebello Oaks
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.
