A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 503499.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 556498.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1590 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2090 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` = 1657437 OR `props-main`.`id` = 1683214 OR `props-main`.`id` = 1658833 OR `props-main`.`id` = 1658832 OR `props-main`.`id` = 1658843 OR `props-main`.`id` = 1657435 OR `props-main`.`id` = 1686556 OR `props-main`.`id` = 1691528 OR `props-main`.`id` = 1687801 OR `props-main`.`id` = 1689329 OR `props-main`.`id` = 1686571 OR `props-main`.`id` = 1686555 OR `props-main`.`id` = 1686536 OR `props-main`.`id` = 1684618 OR `props-main`.`id` = 1684426 OR `props-main`.`id` = 1682264 OR `props-main`.`id` = 1682522 OR `props-main`.`id` = 1672050 OR `props-main`.`id` = 1690649 OR `props-main`.`id` = 1688019 OR `props-main`.`id` = 1686455 OR `props-main`.`id` = 1690481 OR `props-main`.`id` = 1690654 OR `props-main`.`id` = 1682379 OR `props-main`.`id` = 1690122 OR `props-main`.`id` = 1686530 OR `props-main`.`id` = 1686553 OR `props-main`.`id` = 1686544 OR `props-main`.`id` = 1687169 OR `props-main`.`id` = 1678832 OR `props-main`.`id` = 1679095 OR `props-main`.`id` = 1682310 OR `props-main`.`id` = 1682871 OR `props-main`.`id` = 1685858 OR `props-main`.`id` = 1682284 OR `props-main`.`id` = 1686526 OR `props-main`.`id` = 1686474 OR `props-main`.`id` = 1689636 OR `props-main`.`id` = 1682701 OR `props-main`.`id` = 1687849 OR `props-main`.`id` = 1689461 OR `props-main`.`id` = 1670931 OR `props-main`.`id` = 1689986 OR `props-main`.`id` = 1689987 OR `props-main`.`id` = 1666710 OR `props-main`.`id` = 1677473 OR `props-main`.`id` = 1691218 OR `props-main`.`id` = 1691346 OR `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` = 1690685 OR `props-main`.`id` = 1659431 OR `props-main`.`id` = 1689736 OR `props-main`.`id` = 1682719 OR `props-main`.`id` = 1682718 OR `props-main`.`id` = 1686057 OR `props-main`.`id` = 1682581 OR `props-main`.`id` = 1690798 OR `props-main`.`id` = 1682263 OR `props-main`.`id` = 1689988 OR `props-main`.`id` = 1681435 OR `props-main`.`id` = 1681445 OR `props-main`.`id` = 1680425 OR `props-main`.`id` = 1690630 OR `props-main`.`id` = 1689850 OR `props-main`.`id` = 1676645 OR `props-main`.`id` = 901883 OR `props-main`.`id` = 1688295 OR `props-main`.`id` = 1686490 OR `props-main`.`id` = 1690306 OR `props-main`.`id` = 1682261 OR `props-main`.`id` = 1682287 OR `props-main`.`id` = 1637747 OR `props-main`.`id` = 1683897 OR `props-main`.`id` = 1689528 OR `props-main`.`id` = 1689294 OR `props-main`.`id` = 1687391 OR `props-main`.`id` = 1691307 OR `props-main`.`id` = 1691294 OR `props-main`.`id` = 1678680 OR `props-main`.`id` = 1685247 OR `props-main`.`id` = 1682286 OR `props-main`.`id` = 1671228 OR `props-main`.`id` = 1686291 OR `props-main`.`id` = 1682050 OR `props-main`.`id` = 1691044 OR `props-main`.`id` = 1691213 OR `props-main`.`id` = 1683457 OR `props-main`.`id` = 1690735 OR `props-main`.`id` = 1691469 OR `props-main`.`id` = 1649903 OR `props-main`.`id` = 1686033 OR `props-main`.`id` = 1685439 OR `props-main`.`id` = 1659297 OR `props-main`.`id` = 1691627 OR `props-main`.`id` = 1690400 OR `props-main`.`id` = 1687951 OR `props-main`.`id` = 1688003 OR `props-main`.`id` = 1690894 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` = 1683742 OR `props-main`.`id` = 1680822 OR `props-main`.`id` = 1690291 OR `props-main`.`id` = 1687330 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` = 1689353 OR `props-main`.`id` = 1691501 OR `props-main`.`id` = 1674176 OR `props-main`.`id` = 1690555 OR `props-main`.`id` = 1683338 OR `props-main`.`id` = 1679231 OR `props-main`.`id` = 1688991 OR `props-main`.`id` = 1690629 OR `props-main`.`id` = 1689374 OR `props-main`.`id` = 1681350 OR `props-main`.`id` = 1685682 OR `props-main`.`id` = 1690779 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)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist224053101' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-27' 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();
6
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$549,000
4
3
1,978
0.14
342 Sunnyhill Dr
Turlock, CA 95382
$549,000
4
3
1,983
0.11
2800 Craftsman
Turlock, CA 95380
$545,000
4
2
1,636
0.25
2700 Oxford Ave
Turlock, CA 95382
$540,000
4
2
1,778
0.20
995 W Springer Dr
Turlock, CA 95382
Courtesy of Donny Sanchez, RE/MAX Executive 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.
