A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 460181.9 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 508622.1 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) >= 1370 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1870 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` = 1714839 OR `props-main`.`id` = 1659386 OR `props-main`.`id` = 1659394 OR `props-main`.`id` = 1719273 OR `props-main`.`id` = 1685606 OR `props-main`.`id` = 1698211 OR `props-main`.`id` = 1716047 OR `props-main`.`id` = 1716133 OR `props-main`.`id` = 1702577 OR `props-main`.`id` = 1702568 OR `props-main`.`id` = 1704802 OR `props-main`.`id` = 1707000 OR `props-main`.`id` = 1714876 OR `props-main`.`id` = 1714091 OR `props-main`.`id` = 1622703 OR `props-main`.`id` = 1708190 OR `props-main`.`id` = 204765 OR `props-main`.`id` = 1708196 OR `props-main`.`id` = 1702162 OR `props-main`.`id` = 1714570 OR `props-main`.`id` = 1715915 OR `props-main`.`id` = 1715927 OR `props-main`.`id` = 1715798 OR `props-main`.`id` = 1713342 OR `props-main`.`id` = 1712953 OR `props-main`.`id` = 1689954 OR `props-main`.`id` = 1711218 OR `props-main`.`id` = 1709672 OR `props-main`.`id` = 1706672 OR `props-main`.`id` = 1712818 OR `props-main`.`id` = 1706679 OR `props-main`.`id` = 1716572 OR `props-main`.`id` = 1713540 OR `props-main`.`id` = 1713511 OR `props-main`.`id` = 1713661 OR `props-main`.`id` = 1713146 OR `props-main`.`id` = 1705344 OR `props-main`.`id` = 1705282 OR `props-main`.`id` = 1709925 OR `props-main`.`id` = 1716479 OR `props-main`.`id` = 1689536 OR `props-main`.`id` = 1715696 OR `props-main`.`id` = 1718105 OR `props-main`.`id` = 1711312 OR `props-main`.`id` = 1716949 OR `props-main`.`id` = 1703392 OR `props-main`.`id` = 1704849 OR `props-main`.`id` = 1717897 OR `props-main`.`id` = 1717924 OR `props-main`.`id` = 1712713 OR `props-main`.`id` = 1712543 OR `props-main`.`id` = 1706816 OR `props-main`.`id` = 1716168 OR `props-main`.`id` = 1716223 OR `props-main`.`id` = 1712710 OR `props-main`.`id` = 1705259 OR `props-main`.`id` = 1705596 OR `props-main`.`id` = 1705601 OR `props-main`.`id` = 1704350 OR `props-main`.`id` = 1709853 OR `props-main`.`id` = 1712821 OR `props-main`.`id` = 1718560 OR `props-main`.`id` = 1718552 OR `props-main`.`id` = 1717529 OR `props-main`.`id` = 1711333 OR `props-main`.`id` = 1708144 OR `props-main`.`id` = 1715751 OR `props-main`.`id` = 1715752 OR `props-main`.`id` = 1666278 OR `props-main`.`id` = 1701226 OR `props-main`.`id` = 1701225 OR `props-main`.`id` = 1706107 OR `props-main`.`id` = 1706773 OR `props-main`.`id` = 1706126 OR `props-main`.`id` = 1706108 OR `props-main`.`id` = 1701227 OR `props-main`.`id` = 1701229 OR `props-main`.`id` = 1708147 OR `props-main`.`id` = 1715795 OR `props-main`.`id` = 1709924 OR `props-main`.`id` = 1710118 OR `props-main`.`id` = 1629281 OR `props-main`.`id` = 1600784 OR `props-main`.`id` = 1701369 OR `props-main`.`id` = 1717746 OR `props-main`.`id` = 1701451 OR `props-main`.`id` = 1717610 OR `props-main`.`id` = 1687778 OR `props-main`.`id` = 1641188)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC24073435' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-02' 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();
8
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$491,635
3
2
1,415
0.14
4692 NE Jema Way
Merced, CA 95348
$487,495
4
3
1,750
0.15
727 Skyler Ct
Merced, CA 95348
$481,194
3
2
1,854
0.12
753 Skyler Ct
Merced, CA 95348
$480,490
4
2
1,509
0.15
4779 Isabella Ct #28 B1
Merced, CA 95348
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.
