A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 878750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 971250 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) >= 1794 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2294 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` = 1716042 OR `props-main`.`id` = 1713729 OR `props-main`.`id` = 1702434 OR `props-main`.`id` = 1716335 OR `props-main`.`id` = 1711136 OR `props-main`.`id` = 1711134 OR `props-main`.`id` = 1715837 OR `props-main`.`id` = 1707897 OR `props-main`.`id` = 1711137 OR `props-main`.`id` = 1716311 OR `props-main`.`id` = 1713444 OR `props-main`.`id` = 1711078 OR `props-main`.`id` = 1703574 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` = 1707871 OR `props-main`.`id` = 1709771 OR `props-main`.`id` = 1685873 OR `props-main`.`id` = 1702382 OR `props-main`.`id` = 1701141 OR `props-main`.`id` = 1708226 OR `props-main`.`id` = 1695459 OR `props-main`.`id` = 1695460 OR `props-main`.`id` = 1695599 OR `props-main`.`id` = 1695602 OR `props-main`.`id` = 1704566 OR `props-main`.`id` = 1706939 OR `props-main`.`id` = 1708381 OR `props-main`.`id` = 1712548 OR `props-main`.`id` = 1713770 OR `props-main`.`id` = 1712469 OR `props-main`.`id` = 1702313 OR `props-main`.`id` = 1707994 OR `props-main`.`id` = 1712748 OR `props-main`.`id` = 1713070 OR `props-main`.`id` = 1679619 OR `props-main`.`id` = 1703149 OR `props-main`.`id` = 1713768 OR `props-main`.`id` = 1713150 OR `props-main`.`id` = 1698805 OR `props-main`.`id` = 1685716 OR `props-main`.`id` = 1693448 OR `props-main`.`id` = 1701144 OR `props-main`.`id` = 1713211 OR `props-main`.`id` = 1710015 OR `props-main`.`id` = 1712332 OR `props-main`.`id` = 1623058 OR `props-main`.`id` = 1698448 OR `props-main`.`id` = 1694156 OR `props-main`.`id` = 1678262 OR `props-main`.`id` = 1656460 OR `props-main`.`id` = 1686838 OR `props-main`.`id` = 1704312 OR `props-main`.`id` = 1704247 OR `props-main`.`id` = 1710017 OR `props-main`.`id` = 1697759 OR `props-main`.`id` = 1697677 OR `props-main`.`id` = 1704365 OR `props-main`.`id` = 1707058 OR `props-main`.`id` = 1713961 OR `props-main`.`id` = 1703016 OR `props-main`.`id` = 1709994 OR `props-main`.`id` = 1709964 OR `props-main`.`id` = 1650747 OR `props-main`.`id` = 1693604 OR `props-main`.`id` = 1640741 OR `props-main`.`id` = 1705656 OR `props-main`.`id` = 1709204 OR `props-main`.`id` = 1706973 OR `props-main`.`id` = 1713124 OR `props-main`.`id` = 1713742 OR `props-main`.`id` = 1695995 OR `props-main`.`id` = 1698409 OR `props-main`.`id` = 1706975 OR `props-main`.`id` = 1708446 OR `props-main`.`id` = 1711533 OR `props-main`.`id` = 1710130 OR `props-main`.`id` = 1713633 OR `props-main`.`id` = 1697727 OR `props-main`.`id` = 1623065 OR `props-main`.`id` = 1704783 OR `props-main`.`id` = 1695416 OR `props-main`.`id` = 1711079 OR `props-main`.`id` = 1692459 OR `props-main`.`id` = 1702008 OR `props-main`.`id` = 1713479 OR `props-main`.`id` = 1696208 OR `props-main`.`id` = 1623078 OR `props-main`.`id` = 1623077 OR `props-main`.`id` = 1623248 OR `props-main`.`id` = 1716407 OR `props-main`.`id` = 1441090 OR `props-main`.`id` = 1623256 OR `props-main`.`id` = 1623254 OR `props-main`.`id` = 1674417 OR `props-main`.`id` = 1709996 OR `props-main`.`id` = 1691926 OR `props-main`.`id` = 1689003 OR `props-main`.`id` = 1704872 OR `props-main`.`id` = 1696746 OR `props-main`.`id` = 1696730 OR `props-main`.`id` = 1696744 OR `props-main`.`id` = 1703862 OR `props-main`.`id` = 1703863 OR `props-main`.`id` = 1696745)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsNS26049853' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-16' 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();
7
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$949,990
3
2
2,126
0.24
1113 Vinaza Rd
Paso Robles, CA 93446
$949,000
4
3
2,197
0.11
470 Kenton Ct
Paso Robles, CA 93446
$885,000
3
2
1,867
0.14
2424 Traditions
Paso Robles, CA 93446
$879,000
3
2
2,248
1.00
1555 Lyle
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.
