A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 261250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 288750 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) >= 806 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1306 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` = 1738403 OR `props-main`.`id` = 1750789 OR `props-main`.`id` = 1752963 OR `props-main`.`id` = 1753107 OR `props-main`.`id` = 1644360 OR `props-main`.`id` = 1691988 OR `props-main`.`id` = 1733173 OR `props-main`.`id` = 1745930 OR `props-main`.`id` = 1746212 OR `props-main`.`id` = 1755944 OR `props-main`.`id` = 1730920 OR `props-main`.`id` = 1766946 OR `props-main`.`id` = 1733070 OR `props-main`.`id` = 1727818 OR `props-main`.`id` = 1774084 OR `props-main`.`id` = 1748203 OR `props-main`.`id` = 1754593 OR `props-main`.`id` = 1745309 OR `props-main`.`id` = 1769865 OR `props-main`.`id` = 1736638 OR `props-main`.`id` = 1736460 OR `props-main`.`id` = 1728739 OR `props-main`.`id` = 1778953 OR `props-main`.`id` = 1753968 OR `props-main`.`id` = 1765910 OR `props-main`.`id` = 1743662 OR `props-main`.`id` = 1737857 OR `props-main`.`id` = 1767732 OR `props-main`.`id` = 1754442 OR `props-main`.`id` = 1737314 OR `props-main`.`id` = 1728095 OR `props-main`.`id` = 1787368 OR `props-main`.`id` = 1755075 OR `props-main`.`id` = 1760410 OR `props-main`.`id` = 1745768 OR `props-main`.`id` = 1728537 OR `props-main`.`id` = 1751760 OR `props-main`.`id` = 1614679 OR `props-main`.`id` = 1743322 OR `props-main`.`id` = 1772109 OR `props-main`.`id` = 1730666 OR `props-main`.`id` = 1745732 OR `props-main`.`id` = 1746168 OR `props-main`.`id` = 1744082 OR `props-main`.`id` = 1748611 OR `props-main`.`id` = 1790951 OR `props-main`.`id` = 1777922 OR `props-main`.`id` = 1770616 OR `props-main`.`id` = 1791032 OR `props-main`.`id` = 1738988 OR `props-main`.`id` = 1773817 OR `props-main`.`id` = 1752556 OR `props-main`.`id` = 1789401 OR `props-main`.`id` = 1734444 OR `props-main`.`id` = 1774047 OR `props-main`.`id` = 1749530 OR `props-main`.`id` = 1756496 OR `props-main`.`id` = 1751823 OR `props-main`.`id` = 1727973 OR `props-main`.`id` = 1690538 OR `props-main`.`id` = 1732727 OR `props-main`.`id` = 1766631 OR `props-main`.`id` = 1770581 OR `props-main`.`id` = 1785554 OR `props-main`.`id` = 1728735 OR `props-main`.`id` = 1732839 OR `props-main`.`id` = 1727629 OR `props-main`.`id` = 1727659 OR `props-main`.`id` = 1727661 OR `props-main`.`id` = 1732833 OR `props-main`.`id` = 1735951 OR `props-main`.`id` = 1763545 OR `props-main`.`id` = 1775280 OR `props-main`.`id` = 1744326 OR `props-main`.`id` = 1754744 OR `props-main`.`id` = 1765374 OR `props-main`.`id` = 1733415 OR `props-main`.`id` = 1789206 OR `props-main`.`id` = 1728701 OR `props-main`.`id` = 1754755 OR `props-main`.`id` = 1736888 OR `props-main`.`id` = 1743616 OR `props-main`.`id` = 1775977 OR `props-main`.`id` = 1749657 OR `props-main`.`id` = 1727298 OR `props-main`.`id` = 1783409 OR `props-main`.`id` = 1744806 OR `props-main`.`id` = 1734067 OR `props-main`.`id` = 1732083 OR `props-main`.`id` = 1720844 OR `props-main`.`id` = 1785758 OR `props-main`.`id` = 1728736 OR `props-main`.`id` = 1751551 OR `props-main`.`id` = 1728006 OR `props-main`.`id` = 1758951 OR `props-main`.`id` = 1633622 OR `props-main`.`id` = 1776790 OR `props-main`.`id` = 1735033)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41139284' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-16' 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:
$269,000
2
2
1,160
0.32
19666 Cottonwood St
Groveland, CA 95321
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.
