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/crmls/MC25174727/1338-Hermosa-Dr/Merced/https://www.londonproperties.com/images/props/crmls/full/MC25174727.jpgLondon Properties Merced Real Estate | 1338 Hermosa Dr
Listing Agent: Mary Camper, London Properties Ltd - Merced
Like new...this 4-bedroom, 2.5-bath located in the Cottages at El Redondo is perfect for an investor, first-time home buyer or anyone who is looking for a move-in ready home. It features laminate floors throughout, a spacious kitchen with granite counter tops, a gas range and a kitchen island - perfect for entertaining. The primary suite has natural light, a walk-in closet and a double sink vanity in the bathroom. Built for energy efficiency with the benefits of a tankless water heater and OWNED SOLAR. If low maintenance is what you are looking for, the backyard provides just enough space for dining al fresco. Located in North Merced near parks, shopping and restaurants and in close proximity to Hwy 59...don't let this one get away.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2022
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
1
Entry Location
front door
Price Per Square Foot
$241
Days On London
202
Cumulative Days On London
202
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
Yes
Heating Y/N
Yes
Certified 433a Y/N
No
Directions
North on R Street, left at Yosemite Ave, right at El Redondo, left at Hermosa
Room Type
Walk-In Closet, All Bedrooms Up, Kitchen, Living Room, Primary Suite
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Inside, Electric Dryer Hookup, In Closet, Washer Hookup
Roof
Composition
Security Features
Carbon Monoxide Detector(s), Smoke Detector(s)
Construction Materials
Stucco
Direction Faces
North
Door Features
Sliding Doors, Panel Doors
Window Features
Double Pane Windows, Blinds, Screens
Foundation Details
Slab
Property Condition
Turnkey
Main Level Bedrooms
0
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Bathrooms Half
1
Main Level Bathrooms
1
Room Kitchen Features
Kitchen Island, Granite Counters
Eating Area
In Kitchen
Appliances Y/N
Yes
Appliances
Disposal, Microwave, Tankless Water Heater, Gas Range, Water Line to Refrigerator, Dishwasher
Room Bathroom Features
Shower in Tub, Exhaust fan(s), Double sinks in bath(s), Double Sinks in Primary Bath, Shower, Granite Counters
Interior Features
Built-in Features, High Ceilings, Ceiling Fan(s), Recessed Lighting, Granite Counters
Flooring
Laminate
Common Walls
No Common Walls
Fireplace Y/N
No
Fireplace Features
None
Exterior Features
Rain Gutters
Pool Features
None
Pool Private Y/N
No
Spa Y/N
No
Spa Features
None
Patio Y/N
Yes
Patio And Porch Features
Front Porch, Concrete, Patio Open
Electric
Photovoltaics Seller Owned, Electricity - On Property, 220 Volts in Laundry
Utilities
Natural Gas Connected, Sewer Connected, Electricity Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Y/N
Yes
Parking Total
4.00
Parking Features
Garage, Concrete, Garage - Single Door, Garage Faces Front, Driveway
Attached Garage Y/N
Yes
Garage Spaces
2.00
Number Remotes
1
Uncovered Spaces
2.00
Lot Features
Level with Street, Landscaped, Front Yard, Walkstreet, Sprinkler System, Lawn
Lot Size Area
2500.0000
Lot Size Units
Square Feet
Road Frontage Type
City Street
Road Surface Type
Paved
View Y/N
Yes
View
Neighborhood
Sprinklers Y/N
Yes
Fencing
Wood
Common Interest
None
Parcel Number
206178002000
Additional Parcels Y/N
No
Zoning
P-D
Community Features
Gutters, Curbs, Street Lights, Sidewalks
Senior Community Y/N
No
Association Y/N
No
High School District
Merced Union
Elementary School
Merced City
Middle Or Junior School
Merced City
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
62
Tax Census Tract
10.08
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 375250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 414750 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) >= 1387 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1887 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` = 1689782 OR `props-main`.`id` = 1690433 OR `props-main`.`id` = 1690429 OR `props-main`.`id` = 1698961 OR `props-main`.`id` = 1714714 OR `props-main`.`id` = 1716281 OR `props-main`.`id` = 262682 OR `props-main`.`id` = 1688050 OR `props-main`.`id` = 1688040 OR `props-main`.`id` = 1711274 OR `props-main`.`id` = 1703457 OR `props-main`.`id` = 1704693 OR `props-main`.`id` = 1064603 OR `props-main`.`id` = 1706987 OR `props-main`.`id` = 1704003 OR `props-main`.`id` = 1697274 OR `props-main`.`id` = 1680830 OR `props-main`.`id` = 1706988 OR `props-main`.`id` = 1686965 OR `props-main`.`id` = 1714366 OR `props-main`.`id` = 289931 OR `props-main`.`id` = 1677524 OR `props-main`.`id` = 1677523 OR `props-main`.`id` = 1708410 OR `props-main`.`id` = 1708334 OR `props-main`.`id` = 1679706 OR `props-main`.`id` = 1686825 OR `props-main`.`id` = 1690564 OR `props-main`.`id` = 1695318 OR `props-main`.`id` = 1704152 OR `props-main`.`id` = 1714687 OR `props-main`.`id` = 1631841 OR `props-main`.`id` = 1693624 OR `props-main`.`id` = 1693647 OR `props-main`.`id` = 1714599 OR `props-main`.`id` = 87746 OR `props-main`.`id` = 1702244 OR `props-main`.`id` = 1714493 OR `props-main`.`id` = 270485 OR `props-main`.`id` = 1709692 OR `props-main`.`id` = 1698786 OR `props-main`.`id` = 1712920 OR `props-main`.`id` = 1712897 OR `props-main`.`id` = 1712913 OR `props-main`.`id` = 1715895 OR `props-main`.`id` = 1696131 OR `props-main`.`id` = 1696130 OR `props-main`.`id` = 1716049 OR `props-main`.`id` = 1716226 OR `props-main`.`id` = 1713167 OR `props-main`.`id` = 1704847 OR `props-main`.`id` = 1704795 OR `props-main`.`id` = 1708286 OR `props-main`.`id` = 1695615 OR `props-main`.`id` = 1691912 OR `props-main`.`id` = 1707864 OR `props-main`.`id` = 1713102 OR `props-main`.`id` = 1709552 OR `props-main`.`id` = 1713364 OR `props-main`.`id` = 1715691 OR `props-main`.`id` = 1680215 OR `props-main`.`id` = 1704743 OR `props-main`.`id` = 1704754 OR `props-main`.`id` = 302141 OR `props-main`.`id` = 1697562 OR `props-main`.`id` = 1711179 OR `props-main`.`id` = 1711176 OR `props-main`.`id` = 1710014 OR `props-main`.`id` = 1710016 OR `props-main`.`id` = 1696579 OR `props-main`.`id` = 1705931 OR `props-main`.`id` = 1701910 OR `props-main`.`id` = 1706801 OR `props-main`.`id` = 1707950 OR `props-main`.`id` = 1708171 OR `props-main`.`id` = 1714839 OR `props-main`.`id` = 1659390 OR `props-main`.`id` = 1659386 OR `props-main`.`id` = 1659394 OR `props-main`.`id` = 1716063 OR `props-main`.`id` = 1716060 OR `props-main`.`id` = 1708379 OR `props-main`.`id` = 1708335 OR `props-main`.`id` = 1716493 OR `props-main`.`id` = 1716503 OR `props-main`.`id` = 1705311 OR `props-main`.`id` = 1685606 OR `props-main`.`id` = 1698211 OR `props-main`.`id` = 1702750 OR `props-main`.`id` = 1702741 OR `props-main`.`id` = 202390 OR `props-main`.`id` = 342849 OR `props-main`.`id` = 1716169 OR `props-main`.`id` = 1716047 OR `props-main`.`id` = 1716133 OR `props-main`.`id` = 1711272 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` = 1698176 OR `props-main`.`id` = 1703877 OR `props-main`.`id` = 1708190 OR `props-main`.`id` = 204765 OR `props-main`.`id` = 1708196 OR `props-main`.`id` = 1702162 OR `props-main`.`id` = 1709467 OR `props-main`.`id` = 1714905 OR `props-main`.`id` = 1714570 OR `props-main`.`id` = 1715798 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` = 1703717 OR `props-main`.`id` = 1703858 OR `props-main`.`id` = 1716572 OR `props-main`.`id` = 1713511 OR `props-main`.`id` = 1713661 OR `props-main`.`id` = 1713146 OR `props-main`.`id` = 1704869 OR `props-main`.`id` = 1704889 OR `props-main`.`id` = 1704915 OR `props-main`.`id` = 1705344 OR `props-main`.`id` = 1701912 OR `props-main`.`id` = 1701908 OR `props-main`.`id` = 1705282 OR `props-main`.`id` = 1709925 OR `props-main`.`id` = 1716479 OR `props-main`.`id` = 1694386 OR `props-main`.`id` = 1689536 OR `props-main`.`id` = 1715510 OR `props-main`.`id` = 1715546 OR `props-main`.`id` = 1715696 OR `props-main`.`id` = 1711312 OR `props-main`.`id` = 1703392 OR `props-main`.`id` = 1704849 OR `props-main`.`id` = 1694943 OR `props-main`.`id` = 1704838 OR `props-main`.`id` = 1712713 OR `props-main`.`id` = 1702711 OR `props-main`.`id` = 1702684 OR `props-main`.`id` = 1702695 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` = 1712821 OR `props-main`.`id` = 1712822 OR `props-main`.`id` = 1711333 OR `props-main`.`id` = 1708144 OR `props-main`.`id` = 1715750 OR `props-main`.`id` = 1715751 OR `props-main`.`id` = 1715752 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)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25174727' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-17' 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();
0
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.
