A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 949050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1048950 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) >= 2512 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3012 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` = 1712469 OR `props-main`.`id` = 1718464 OR `props-main`.`id` = 1717812 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` = 1694156 OR `props-main`.`id` = 1678262 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` = 1709204 OR `props-main`.`id` = 1706973 OR `props-main`.`id` = 1708446 OR `props-main`.`id` = 1711533 OR `props-main`.`id` = 1718606 OR `props-main`.`id` = 1710130 OR `props-main`.`id` = 1704783 OR `props-main`.`id` = 1711079 OR `props-main`.`id` = 1692459 OR `props-main`.`id` = 1702008 OR `props-main`.`id` = 1713479 OR `props-main`.`id` = 1716407 OR `props-main`.`id` = 1709996 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`) != 'crmlsPI25264466' 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:
$980,000
4
4
2,681
0.36
1625 Leah Way
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.
