A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 569810 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 629790 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1958 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2458 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` = 1689097 OR `props-main`.`id` = 1687165 OR `props-main`.`id` = 1679631 OR `props-main`.`id` = 1687977 OR `props-main`.`id` = 1687978 OR `props-main`.`id` = 1682401 OR `props-main`.`id` = 1681254 OR `props-main`.`id` = 1686735 OR `props-main`.`id` = 1689736 OR `props-main`.`id` = 1686057 OR `props-main`.`id` = 1690162 OR `props-main`.`id` = 1689988 OR `props-main`.`id` = 1681435 OR `props-main`.`id` = 1681445 OR `props-main`.`id` = 1680425 OR `props-main`.`id` = 1690277 OR `props-main`.`id` = 1689850 OR `props-main`.`id` = 1676645 OR `props-main`.`id` = 1688295 OR `props-main`.`id` = 1686490 OR `props-main`.`id` = 1690306 OR `props-main`.`id` = 1637747 OR `props-main`.`id` = 1683897 OR `props-main`.`id` = 1689528 OR `props-main`.`id` = 1689294 OR `props-main`.`id` = 1687968 OR `props-main`.`id` = 1667947 OR `props-main`.`id` = 1667959 OR `props-main`.`id` = 1687391 OR `props-main`.`id` = 1686642 OR `props-main`.`id` = 1678680 OR `props-main`.`id` = 1685247 OR `props-main`.`id` = 1671228 OR `props-main`.`id` = 1656313 OR `props-main`.`id` = 1686291 OR `props-main`.`id` = 1682050 OR `props-main`.`id` = 1683457 OR `props-main`.`id` = 1685631 OR `props-main`.`id` = 1677600 OR `props-main`.`id` = 1689845 OR `props-main`.`id` = 1649903 OR `props-main`.`id` = 1686033 OR `props-main`.`id` = 1685439 OR `props-main`.`id` = 1659297 OR `props-main`.`id` = 1690400 OR `props-main`.`id` = 1687951 OR `props-main`.`id` = 1688003 OR `props-main`.`id` = 1675248 OR `props-main`.`id` = 1689455 OR `props-main`.`id` = 1684669 OR `props-main`.`id` = 1684469 OR `props-main`.`id` = 1680299 OR `props-main`.`id` = 1680263 OR `props-main`.`id` = 280750 OR `props-main`.`id` = 1667713 OR `props-main`.`id` = 1683742 OR `props-main`.`id` = 1680822 OR `props-main`.`id` = 1690291 OR `props-main`.`id` = 1687330 OR `props-main`.`id` = 1678211 OR `props-main`.`id` = 1686707 OR `props-main`.`id` = 1685488 OR `props-main`.`id` = 1688695 OR `props-main`.`id` = 1679249 OR `props-main`.`id` = 1688074 OR `props-main`.`id` = 1688060 OR `props-main`.`id` = 1685822 OR `props-main`.`id` = 1689353 OR `props-main`.`id` = 1674176 OR `props-main`.`id` = 1685084 OR `props-main`.`id` = 1683338 OR `props-main`.`id` = 1679231 OR `props-main`.`id` = 1688991 OR `props-main`.`id` = 1690479 OR `props-main`.`id` = 1689374 OR `props-main`.`id` = 1681350 OR `props-main`.`id` = 1685682 OR `props-main`.`id` = 1690323 OR `props-main`.`id` = 1688575 OR `props-main`.`id` = 1669930 OR `props-main`.`id` = 1671067 OR `props-main`.`id` = 1678108 OR `props-main`.`id` = 1688379 OR `props-main`.`id` = 1653261)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist224063647' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-18' 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();
4
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$624,900
4
3
1,978
0.13
4591 Sandpiper Cir
Turlock, CA 95382
$605,000
4
3
2,060
0.14
834 Cedar Ridge Dr
Turlock, CA 95382
$599,900
4
3
2,442
0.13
4017 Enclave Dr
Turlock, CA 95382
$579,900
4
3
2,037
0.14
4184 Horizon Ct
Turlock, CA 95382
Courtesy of Jorge Valencia, TAG Realty Inc IDX provided by Reliance Marketing
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.
