A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 356250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 393750 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) >= 1730 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2230 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` = 1753107 OR `props-main`.`id` = 1644360 OR `props-main`.`id` = 1733173 OR `props-main`.`id` = 1730920 OR `props-main`.`id` = 1737164 OR `props-main`.`id` = 1733070 OR `props-main`.`id` = 1769511 OR `props-main`.`id` = 1769865 OR `props-main`.`id` = 1753968 OR `props-main`.`id` = 1761072 OR `props-main`.`id` = 1743662 OR `props-main`.`id` = 1728404 OR `props-main`.`id` = 1767732 OR `props-main`.`id` = 1742748 OR `props-main`.`id` = 1728007 OR `props-main`.`id` = 1755075 OR `props-main`.`id` = 1760410 OR `props-main`.`id` = 1745768 OR `props-main`.`id` = 1728537 OR `props-main`.`id` = 1614679 OR `props-main`.`id` = 1772109 OR `props-main`.`id` = 1730666 OR `props-main`.`id` = 1728746 OR `props-main`.`id` = 1745732 OR `props-main`.`id` = 1727857 OR `props-main`.`id` = 1746168 OR `props-main`.`id` = 1744082 OR `props-main`.`id` = 1748611 OR `props-main`.`id` = 1745189 OR `props-main`.`id` = 1773817 OR `props-main`.`id` = 1752556 OR `props-main`.`id` = 1734444 OR `props-main`.`id` = 1756496 OR `props-main`.`id` = 1751823 OR `props-main`.`id` = 1690538 OR `props-main`.`id` = 1732727 OR `props-main`.`id` = 1766631 OR `props-main`.`id` = 1728735 OR `props-main`.`id` = 1732839 OR `props-main`.`id` = 1727629 OR `props-main`.`id` = 1732833 OR `props-main`.`id` = 1735951 OR `props-main`.`id` = 1744326 OR `props-main`.`id` = 1754744 OR `props-main`.`id` = 1727433 OR `props-main`.`id` = 1733415 OR `props-main`.`id` = 1735459 OR `props-main`.`id` = 1728701 OR `props-main`.`id` = 1754755 OR `props-main`.`id` = 1736888 OR `props-main`.`id` = 1743616 OR `props-main`.`id` = 1727397 OR `props-main`.`id` = 1727298 OR `props-main`.`id` = 1727428 OR `props-main`.`id` = 1695915 OR `props-main`.`id` = 1744806 OR `props-main`.`id` = 1762824 OR `props-main`.`id` = 1734067 OR `props-main`.`id` = 1732083 OR `props-main`.`id` = 1720844 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` = 1743479)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41134456' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-09' 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:
$379,000
3
3
2,054
0.56
12955 Jackson Mill Drive
Groveland, CA 95321
$379,000
4
3
1,920
1.06
12910 Jackson Mill Dr
Groveland, CA 95321
$359,000
3
2
1,735
0.30
12033 Hillhurst Cir
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.
