A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 771780 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 853020 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1848 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2348 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` = 1696939 OR `props-main`.`id` = 1691420 OR `props-main`.`id` = 1716800 OR `props-main`.`id` = 1704564 OR `props-main`.`id` = 1623061 OR `props-main`.`id` = 1689223 OR `props-main`.`id` = 1695036 OR `props-main`.`id` = 1706938 OR `props-main`.`id` = 1623056 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` = 1685543 OR `props-main`.`id` = 1715837 OR `props-main`.`id` = 1707897 OR `props-main`.`id` = 1717813 OR `props-main`.`id` = 1711137 OR `props-main`.`id` = 1711078 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` = 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` = 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` = 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` = 1716449 OR `props-main`.`id` = 1709204 OR `props-main`.`id` = 1706973 OR `props-main`.`id` = 1718606)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsNS24071359' 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();
3
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$849,990
4
4
2,083
0.13
1112 Mazzini Rd
Paso Robles, CA 93446
$825,000
4
3
2,293
0.16
171 Bridgegate Ln
Paso Robles, CA 93446
$799,990
4
4
2,083
0.19
1123 Mazzini Rd
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.
