A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 693500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 766500 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) >= 1410 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1910 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` = 1727224 OR `props-main`.`id` = 1725970 OR `props-main`.`id` = 1727105 OR `props-main`.`id` = 1691420 OR `props-main`.`id` = 1680387 OR `props-main`.`id` = 1659690 OR `props-main`.`id` = 1704564 OR `props-main`.`id` = 1623061 OR `props-main`.`id` = 1689223 OR `props-main`.`id` = 1695036 OR `props-main`.`id` = 1702900 OR `props-main`.`id` = 1623056 OR `props-main`.`id` = 1722562 OR `props-main`.`id` = 1722306 OR `props-main`.`id` = 1737796 OR `props-main`.`id` = 1735119 OR `props-main`.`id` = 1727063 OR `props-main`.`id` = 1721383 OR `props-main`.`id` = 1739257 OR `props-main`.`id` = 1720514 OR `props-main`.`id` = 1730523 OR `props-main`.`id` = 1716603 OR `props-main`.`id` = 1733225 OR `props-main`.`id` = 1738741 OR `props-main`.`id` = 1716925 OR `props-main`.`id` = 1734848 OR `props-main`.`id` = 1698109 OR `props-main`.`id` = 1698110 OR `props-main`.`id` = 1698112 OR `props-main`.`id` = 1734791 OR `props-main`.`id` = 1698111 OR `props-main`.`id` = 1738235 OR `props-main`.`id` = 1692092 OR `props-main`.`id` = 1727702 OR `props-main`.`id` = 1693742 OR `props-main`.`id` = 1707897 OR `props-main`.`id` = 1684438 OR `props-main`.`id` = 1725658 OR `props-main`.`id` = 1725935 OR `props-main`.`id` = 1727093 OR `props-main`.`id` = 1721040 OR `props-main`.`id` = 1724006 OR `props-main`.`id` = 1711078 OR `props-main`.`id` = 1723586 OR `props-main`.`id` = 1723342 OR `props-main`.`id` = 1736730 OR `props-main`.`id` = 1705198 OR `props-main`.`id` = 1734673 OR `props-main`.`id` = 1723359 OR `props-main`.`id` = 1736562 OR `props-main`.`id` = 1702382 OR `props-main`.`id` = 1701141 OR `props-main`.`id` = 1708226 OR `props-main`.`id` = 1712548 OR `props-main`.`id` = 1720431 OR `props-main`.`id` = 1722707 OR `props-main`.`id` = 1722743 OR `props-main`.`id` = 1724583 OR `props-main`.`id` = 1733428 OR `props-main`.`id` = 1736545 OR `props-main`.`id` = 1736546 OR `props-main`.`id` = 1727285 OR `props-main`.`id` = 1738631 OR `props-main`.`id` = 1739302 OR `props-main`.`id` = 1738056 OR `props-main`.`id` = 1725349 OR `props-main`.`id` = 1728319 OR `props-main`.`id` = 1727385 OR `props-main`.`id` = 1737830 OR `props-main`.`id` = 1737171 OR `props-main`.`id` = 1732640 OR `props-main`.`id` = 1732641 OR `props-main`.`id` = 1728507 OR `props-main`.`id` = 1733226 OR `props-main`.`id` = 1726335 OR `props-main`.`id` = 1726337 OR `props-main`.`id` = 1713070 OR `props-main`.`id` = 1738548 OR `props-main`.`id` = 1713150 OR `props-main`.`id` = 1726958 OR `props-main`.`id` = 1727452 OR `props-main`.`id` = 1623058 OR `props-main`.`id` = 1724694 OR `props-main`.`id` = 1728473 OR `props-main`.`id` = 1727582)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82040912' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-19' 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();
9
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$760,000
3
2
1,756
0.23
940 Austin Ct
Paso Robles, CA 93446
$750,000
3
2
1,761
0.41
726 N Trigo Ln
Paso Robles, CA 93446
$749,999
5
2
1,654
0.35
1035 Pioneer Trail
Paso Robles, CA 93446
$749,000
3
2
1,640
0.20
192 Sandbar Ct
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.
