A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 872860.95 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 964741.05 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1654 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2154 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` = 1737401 OR `props-main`.`id` = 1737407 OR `props-main`.`id` = 1737402 OR `props-main`.`id` = 1720836 OR `props-main`.`id` = 1724743 OR `props-main`.`id` = 1713646 OR `props-main`.`id` = 1746169 OR `props-main`.`id` = 1742207 OR `props-main`.`id` = 1722963 OR `props-main`.`id` = 1727863 OR `props-main`.`id` = 1741702 OR `props-main`.`id` = 1730228 OR `props-main`.`id` = 1729448 OR `props-main`.`id` = 1710125 OR `props-main`.`id` = 1709940 OR `props-main`.`id` = 1727137 OR `props-main`.`id` = 1728470 OR `props-main`.`id` = 1748169 OR `props-main`.`id` = 1739179 OR `props-main`.`id` = 1736887 OR `props-main`.`id` = 1724479 OR `props-main`.`id` = 1749042 OR `props-main`.`id` = 1705803 OR `props-main`.`id` = 1728216 OR `props-main`.`id` = 1747802 OR `props-main`.`id` = 1734787 OR `props-main`.`id` = 1726090 OR `props-main`.`id` = 1742858 OR `props-main`.`id` = 1717483 OR `props-main`.`id` = 1739368 OR `props-main`.`id` = 1746076 OR `props-main`.`id` = 1746075 OR `props-main`.`id` = 1721213 OR `props-main`.`id` = 1739069 OR `props-main`.`id` = 1721361 OR `props-main`.`id` = 1742276 OR `props-main`.`id` = 1735457 OR `props-main`.`id` = 1737360 OR `props-main`.`id` = 1724312 OR `props-main`.`id` = 1744690 OR `props-main`.`id` = 1725948 OR `props-main`.`id` = 1743993 OR `props-main`.`id` = 1744615 OR `props-main`.`id` = 1745565 OR `props-main`.`id` = 1720426)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41134201' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-15' 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();
2
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$899,000
2
3
2,042
0.22
1110 Lafite Ct
Brentwood (CC), CA 94513-4334
$885,000
2
3
2,042
0.16
1512 Miwok Ct
Brentwood (CC), CA 94513
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.
