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` = 1727969 OR `props-main`.`id` = 1723980 OR `props-main`.`id` = 1646091 OR `props-main`.`id` = 1731949 OR `props-main`.`id` = 1728141 OR `props-main`.`id` = 1753968 OR `props-main`.`id` = 1743662 OR `props-main`.`id` = 1728404 OR `props-main`.`id` = 1742748 OR `props-main`.`id` = 1728007 OR `props-main`.`id` = 1748612 OR `props-main`.`id` = 1745768 OR `props-main`.`id` = 1728537 OR `props-main`.`id` = 1727504 OR `props-main`.`id` = 1614679 OR `props-main`.`id` = 1730666 OR `props-main`.`id` = 1742747 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` = 1752556 OR `props-main`.`id` = 1734444 OR `props-main`.`id` = 1751823 OR `props-main`.`id` = 1690538 OR `props-main`.`id` = 1726226 OR `props-main`.`id` = 1732727 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` = 1727433 OR `props-main`.`id` = 1737856 OR `props-main`.`id` = 1733415 OR `props-main`.`id` = 1728185 OR `props-main`.`id` = 1730667 OR `props-main`.`id` = 1735459 OR `props-main`.`id` = 1728701 OR `props-main`.`id` = 1736888 OR `props-main`.`id` = 1727271 OR `props-main`.`id` = 1743616 OR `props-main`.`id` = 1739136 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` = 1727855 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` = 1633622 OR `props-main`.`id` = 1736029 OR `props-main`.`id` = 1743479)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41134456' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-26' 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:
$379,000
4
3
1,920
1.06
12910 Jackson Mill Dr
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.
