A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 796100 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 879900 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1908 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2408 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` = 1719125 OR `props-main`.`id` = 1715837 OR `props-main`.`id` = 1717813 OR `props-main`.`id` = 1711137 OR `props-main`.`id` = 1711078 OR `props-main`.`id` = 1709285 OR `props-main`.`id` = 1705198 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` = 1708226 OR `props-main`.`id` = 1712469 OR `props-main`.`id` = 1702313 OR `props-main`.`id` = 1707994 OR `props-main`.`id` = 1719422 OR `props-main`.`id` = 1718464 OR `props-main`.`id` = 1713070 OR `props-main`.`id` = 1718479 OR `props-main`.`id` = 1717812 OR `props-main`.`id` = 1713768 OR `props-main`.`id` = 1713150 OR `props-main`.`id` = 1698805 OR `props-main`.`id` = 1693448 OR `props-main`.`id` = 1701144 OR `props-main`.`id` = 1717753 OR `props-main`.`id` = 1713211 OR `props-main`.`id` = 1719689 OR `props-main`.`id` = 1710015 OR `props-main`.`id` = 1712332 OR `props-main`.`id` = 1623058 OR `props-main`.`id` = 1719619 OR `props-main`.`id` = 1694156 OR `props-main`.`id` = 1678262 OR `props-main`.`id` = 1717264 OR `props-main`.`id` = 1718630 OR `props-main`.`id` = 1718361 OR `props-main`.`id` = 1716923 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` = 1717491 OR `props-main`.`id` = 1718718 OR `props-main`.`id` = 1703016 OR `props-main`.`id` = 1709994 OR `props-main`.`id` = 1709964 OR `props-main`.`id` = 1719102 OR `props-main`.`id` = 1716960 OR `props-main`.`id` = 1650747 OR `props-main`.`id` = 1693604 OR `props-main`.`id` = 1716449 OR `props-main`.`id` = 1640741 OR `props-main`.`id` = 1709204 OR `props-main`.`id` = 1706973 OR `props-main`.`id` = 1713742 OR `props-main`.`id` = 1708446 OR `props-main`.`id` = 1711533 OR `props-main`.`id` = 1718606 OR `props-main`.`id` = 1710130 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` = 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` = 1689003 OR `props-main`.`id` = 1704872 OR `props-main`.`id` = 1717857 OR `props-main`.`id` = 1716604 OR `props-main`.`id` = 1649812 OR `props-main`.`id` = 1717415 OR `props-main`.`id` = 1696746 OR `props-main`.`id` = 1703862 OR `props-main`.`id` = 1703863 OR `props-main`.`id` = 1696745 OR `props-main`.`id` = 1655027)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsNS24166238' 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();
1
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$825,000
4
3
2,293
0.16
171 Bridgegate Ln
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.
