A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 294499.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 325498.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 830 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1330 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` = 1648800 OR `props-main`.`id` = 1678884 OR `props-main`.`id` = 1679447 OR `props-main`.`id` = 1123502 OR `props-main`.`id` = 1650972 OR `props-main`.`id` = 1682572 OR `props-main`.`id` = 1684543 OR `props-main`.`id` = 1684126 OR `props-main`.`id` = 1684144 OR `props-main`.`id` = 1684137 OR `props-main`.`id` = 1671769 OR `props-main`.`id` = 1673919 OR `props-main`.`id` = 1638871 OR `props-main`.`id` = 1673715 OR `props-main`.`id` = 1673741 OR `props-main`.`id` = 1622798 OR `props-main`.`id` = 1681087 OR `props-main`.`id` = 1656883 OR `props-main`.`id` = 1064603 OR `props-main`.`id` = 1627707 OR `props-main`.`id` = 1646944 OR `props-main`.`id` = 1647074 OR `props-main`.`id` = 1679706 OR `props-main`.`id` = 1622843 OR `props-main`.`id` = 1613031 OR `props-main`.`id` = 1678157 OR `props-main`.`id` = 1681183 OR `props-main`.`id` = 1684012 OR `props-main`.`id` = 1683991 OR `props-main`.`id` = 1664312 OR `props-main`.`id` = 1676252 OR `props-main`.`id` = 1680554 OR `props-main`.`id` = 1684735 OR `props-main`.`id` = 1680532 OR `props-main`.`id` = 1642555 OR `props-main`.`id` = 1636675 OR `props-main`.`id` = 1655648 OR `props-main`.`id` = 1683355 OR `props-main`.`id` = 1683573 OR `props-main`.`id` = 1684758 OR `props-main`.`id` = 1680215 OR `props-main`.`id` = 1646767 OR `props-main`.`id` = 1682283 OR `props-main`.`id` = 302141 OR `props-main`.`id` = 1671727 OR `props-main`.`id` = 1680618 OR `props-main`.`id` = 1683900 OR `props-main`.`id` = 1673241 OR `props-main`.`id` = 1673275 OR `props-main`.`id` = 1675048 OR `props-main`.`id` = 1682563 OR `props-main`.`id` = 1064604 OR `props-main`.`id` = 1650700 OR `props-main`.`id` = 1650686 OR `props-main`.`id` = 342849 OR `props-main`.`id` = 1654918 OR `props-main`.`id` = 1676251 OR `props-main`.`id` = 1671593 OR `props-main`.`id` = 1671585 OR `props-main`.`id` = 1680047 OR `props-main`.`id` = 1683767 OR `props-main`.`id` = 1681588 OR `props-main`.`id` = 1678643 OR `props-main`.`id` = 1679616 OR `props-main`.`id` = 1668456)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25178186' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-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:
$325,000
3
2
1,144
0.20
1843 W 8th St
Merced, CA 95341
$324,000
3
1
970
0.22
2868 Beachwood Dr
Merced, CA 95348
$320,000
3
2
1,022
1842 Heritage Dr
Merced, CA 95341
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.
