Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/metrolist/226126964/2864-Elm-Ave/Merced/https://www.londonproperties.com/images/props/metrolist/full/226126964.jpgLondon Properties Merced Real Estate | 2864 Elm Ave
Presenting an inviting single-story at 2864 Elm Ave, in Merced, meticulously maintained and ready for immediate occupancy. This residence offers a seamless transition for discerning buyers seeking a refined living experience. The kitchen, designed with an open-plan concept, integrates fluidly with the living room, fostering an expansive and connected atmosphere. It features sophisticated quartz counters, providing both aesthetic appeal and practical durability for culinary endeavors. This professionally curated residence offers an exceptional opportunity for an elevated lifestyle.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1977
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bath 0-5YR, Other-Rmks 0-5YR, Bed 0-5YR, Kitchen 0-5YR
Stories
1
Levels
One
Home Warranty
No
Directions to Property
HWY 99 // Franklin Rd // Dan Ward Rd // Elm Ave
Cross Street
Dan Ward Rd
County
Merced
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Full Bath(s), Kitchen
Construction Materials
Block, Concrete, Frame, Wood, Other
Foundation
Slab
Roof
Composition
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
Inside Area
Full Bathrooms
1
Bath Features
Tub w/Shower Over, Window
Flooring
Laminate, Other
Appliances
Free Standing Gas Range, Hood Over Range
Room Type
Baths Other, Kitchen, Laundry, Living Room
Kitchen Features
Quartz Counter
Dining Room Features
Space in Kitchen, Other
Living Room Features
Other
Primary Bedroom Features
Closet
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public
Electric
Other
Irrigation
None
Water Source
Public
Sewer
Public Sewer
Parking Features
Uncovered Parking Space, Other
Carport Spaces
1.00
Lot Features
Shape Regular
APN
057 241 029 000
Land Use
Residential
Topography
Level
Fencing
Back Yard
Horse Property
No
Zoning Description
R-1
Subdivision
Air Home Sites 01
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Merced
Elementary School District
Merced City
Middle or Junior School District
Merced City
Senior High School District
Merced Union High
Census Tract
9.04
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 284050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 313950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 670 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1170 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` = 1686825 OR `props-main`.`id` = 1760742 OR `props-main`.`id` = 1761914 OR `props-main`.`id` = 1748622 OR `props-main`.`id` = 1786772 OR `props-main`.`id` = 1725148 OR `props-main`.`id` = 1771599 OR `props-main`.`id` = 1771780 OR `props-main`.`id` = 1723291 OR `props-main`.`id` = 1786700 OR `props-main`.`id` = 1786830 OR `props-main`.`id` = 1768640 OR `props-main`.`id` = 1768688 OR `props-main`.`id` = 1768663 OR `props-main`.`id` = 1768689 OR `props-main`.`id` = 1779219 OR `props-main`.`id` = 1728823 OR `props-main`.`id` = 1787685 OR `props-main`.`id` = 1788126 OR `props-main`.`id` = 1642555 OR `props-main`.`id` = 1789479 OR `props-main`.`id` = 1789478 OR `props-main`.`id` = 1749658 OR `props-main`.`id` = 1749678 OR `props-main`.`id` = 1749694 OR `props-main`.`id` = 1776326 OR `props-main`.`id` = 1788698 OR `props-main`.`id` = 1717810 OR `props-main`.`id` = 1716863 OR `props-main`.`id` = 1754942 OR `props-main`.`id` = 1680215 OR `props-main`.`id` = 1767621 OR `props-main`.`id` = 1786836 OR `props-main`.`id` = 302141 OR `props-main`.`id` = 1780414 OR `props-main`.`id` = 1697488 OR `props-main`.`id` = 1784940 OR `props-main`.`id` = 1786691 OR `props-main`.`id` = 1732932 OR `props-main`.`id` = 1744705 OR `props-main`.`id` = 1727530 OR `props-main`.`id` = 1736463 OR `props-main`.`id` = 1763004 OR `props-main`.`id` = 1781477 OR `props-main`.`id` = 1784921 OR `props-main`.`id` = 1064604 OR `props-main`.`id` = 1789928 OR `props-main`.`id` = 342849 OR `props-main`.`id` = 1775320 OR `props-main`.`id` = 1790138 OR `props-main`.`id` = 1749874 OR `props-main`.`id` = 1781376 OR `props-main`.`id` = 1788109 OR `props-main`.`id` = 1787806 OR `props-main`.`id` = 1760802 OR `props-main`.`id` = 1758927 OR `props-main`.`id` = 1758685 OR `props-main`.`id` = 1780821 OR `props-main`.`id` = 1724196 OR `props-main`.`id` = 1743851 OR `props-main`.`id` = 1786436 OR `props-main`.`id` = 1786469 OR `props-main`.`id` = 1786468 OR `props-main`.`id` = 1705804 OR `props-main`.`id` = 1707152 OR `props-main`.`id` = 1705917 OR `props-main`.`id` = 1705889 OR `props-main`.`id` = 1707126 OR `props-main`.`id` = 1707154 OR `props-main`.`id` = 1778794 OR `props-main`.`id` = 1779711 OR `props-main`.`id` = 1786581 OR `props-main`.`id` = 1726410 OR `props-main`.`id` = 1761805)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226126964' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-12' 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
Similar Properties
$299,900
3
1
796
0.23
2330 Meadowbrook
Merced, CA 95348
Courtesy of Daniel Maciel, Atlantic Realty 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.
