Prime location with everyday convenience. This 5 bedroom, 3 bath home is within walking distance to shopping, dining, and parks. A bedroom and full bath are located on the main level, ideal for guests or flexible living. Enjoy an open floor plan and a spacious yard. New exterior paint adds great curb appeal. Schedule your showing today.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2004
Year Built Source
Public Records
Special Listing Conditions
Standard
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
1
Entry Location
Front
Price Per Square Foot
$232
Days On London
42
Cumulative Days On London
42
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
Directions
State Hwy 59, Buena Vista Dr. Drive to Paseo Verde Ave
Architectural Style
Traditional
Room Type
Family Room, Kitchen, Laundry, Living Room, Main Floor Bedroom, Main Floor Primary Bedroom
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Individual Room
Roof
Tile
Construction Materials
Drywall Walls, Stucco
Direction Faces
West
Door Features
Panel Doors, Sliding Doors
Window Features
Double Pane Windows
Foundation Details
Slab
Property Condition
Repairs Cosmetic
Main Level Bedrooms
1
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Main Level Bathrooms
1
Room Kitchen Features
Kitchen Island, Tile Counters
Eating Area
Breakfast Counter / Bar
Appliances Y/N
Yes
Appliances
Dishwasher, Electric Range, Disposal, Range Hood, Vented Exhaust Fan
Room Bathroom Features
Shower in Tub, Double Sinks in Primary Bath, Exhaust fan(s), Main Floor Full Bath
Interior Features
Ceiling Fan(s), Tile Counters, Two Story Ceilings
Flooring
Carpet, Laminate, Tile
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Living Room, Zero Clearance
Exterior Features
Rain Gutters
Pool Features
None
Pool Private Y/N
No
Patio Y/N
Yes
Patio And Porch Features
Concrete, Patio Open
Electric
220 Volts
Utilities
Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Driveway Up Slope From Street, Garage
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Back Yard, Front Yard, Lawn
Lot Size Area
7373.0000
Lot Size Units
Square Feet
Road Frontage Type
City Street
Road Surface Type
Paved
View Y/N
Yes
View
Neighborhood
Fencing
Stucco Wall, Wood
Common Interest
None
Parcel Number
058290033000
Additional Parcels Y/N
No
Zoning
RP-D
Community Features
Biking, Curbs, Dog Park, Gutters, Park, Sidewalks, Street Lights, Suburban
Senior Community Y/N
No
Association Y/N
No
High School District
Merced City
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
60
Tax Census Tract
10.08
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 493905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 545895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1991 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2491 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` = 1702709 OR `props-main`.`id` = 1674192 OR `props-main`.`id` = 1710126 OR `props-main`.`id` = 1710525 OR `props-main`.`id` = 1676643 OR `props-main`.`id` = 1655369 OR `props-main`.`id` = 1695165 OR `props-main`.`id` = 1710893 OR `props-main`.`id` = 1703320 OR `props-main`.`id` = 1704769 OR `props-main`.`id` = 1700089 OR `props-main`.`id` = 1700067 OR `props-main`.`id` = 1700069 OR `props-main`.`id` = 1689782 OR `props-main`.`id` = 1690433 OR `props-main`.`id` = 1690429 OR `props-main`.`id` = 1692161 OR `props-main`.`id` = 1698961 OR `props-main`.`id` = 1696999 OR `props-main`.`id` = 1703834 OR `props-main`.`id` = 1703838 OR `props-main`.`id` = 1703818 OR `props-main`.`id` = 1696241 OR `props-main`.`id` = 1694976 OR `props-main`.`id` = 1710526 OR `props-main`.`id` = 262682 OR `props-main`.`id` = 1702267 OR `props-main`.`id` = 1696512 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` = 1709731 OR `props-main`.`id` = 1064603 OR `props-main`.`id` = 1706987 OR `props-main`.`id` = 1704003 OR `props-main`.`id` = 1694975 OR `props-main`.`id` = 1694974 OR `props-main`.`id` = 1697274 OR `props-main`.`id` = 1680830 OR `props-main`.`id` = 1706988 OR `props-main`.`id` = 1686965 OR `props-main`.`id` = 1710609 OR `props-main`.`id` = 1710085 OR `props-main`.`id` = 289931 OR `props-main`.`id` = 1677524 OR `props-main`.`id` = 1704151 OR `props-main`.`id` = 1710269 OR `props-main`.`id` = 1710271 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` = 1710962 OR `props-main`.`id` = 1631841 OR `props-main`.`id` = 1691250 OR `props-main`.`id` = 1705888 OR `props-main`.`id` = 1693624 OR `props-main`.`id` = 1693647 OR `props-main`.`id` = 87746 OR `props-main`.`id` = 1702244 OR `props-main`.`id` = 1681389 OR `props-main`.`id` = 1681378 OR `props-main`.`id` = 1710870 OR `props-main`.`id` = 1710751 OR `props-main`.`id` = 1703393 OR `props-main`.`id` = 270485 OR `props-main`.`id` = 1709692 OR `props-main`.`id` = 1684012 OR `props-main`.`id` = 1683991 OR `props-main`.`id` = 1698786 OR `props-main`.`id` = 1701576 OR `props-main`.`id` = 1699025 OR `props-main`.`id` = 1696131 OR `props-main`.`id` = 1694328 OR `props-main`.`id` = 1694334 OR `props-main`.`id` = 224715 OR `props-main`.`id` = 224717 OR `props-main`.`id` = 1687504 OR `props-main`.`id` = 1696130 OR `props-main`.`id` = 1695785 OR `props-main`.`id` = 1684373 OR `props-main`.`id` = 1684370 OR `props-main`.`id` = 1701516 OR `props-main`.`id` = 1708286 OR `props-main`.`id` = 1691912 OR `props-main`.`id` = 93375 OR `props-main`.`id` = 1707864 OR `props-main`.`id` = 1709552 OR `props-main`.`id` = 1710204 OR `props-main`.`id` = 1684758 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` = 1701910 OR `props-main`.`id` = 1709743 OR `props-main`.`id` = 1695361 OR `props-main`.`id` = 1695368 OR `props-main`.`id` = 1701982 OR `props-main`.`id` = 1667441 OR `props-main`.`id` = 1667401 OR `props-main`.`id` = 1707950 OR `props-main`.`id` = 1708171 OR `props-main`.`id` = 223289 OR `props-main`.`id` = 223288 OR `props-main`.`id` = 1659390 OR `props-main`.`id` = 1659386 OR `props-main`.`id` = 1659394 OR `props-main`.`id` = 1708379 OR `props-main`.`id` = 1708335 OR `props-main`.`id` = 1703144 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` = 1708422 OR `props-main`.`id` = 1702412 OR `props-main`.`id` = 1708427 OR `props-main`.`id` = 1711272 OR `props-main`.`id` = 1702577 OR `props-main`.`id` = 1702568 OR `props-main`.`id` = 1705622 OR `props-main`.`id` = 1705703 OR `props-main`.`id` = 1704802 OR `props-main`.`id` = 1707000 OR `props-main`.`id` = 1708472 OR `props-main`.`id` = 1704233 OR `props-main`.`id` = 1710308 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` = 1709442 OR `props-main`.`id` = 1710839 OR `props-main`.`id` = 360956 OR `props-main`.`id` = 1705673 OR `props-main`.`id` = 1689954 OR `props-main`.`id` = 1711218 OR `props-main`.`id` = 1709672 OR `props-main`.`id` = 1706672 OR `props-main`.`id` = 1706679 OR `props-main`.`id` = 1703717 OR `props-main`.`id` = 1703858 OR `props-main`.`id` = 1694399 OR `props-main`.`id` = 1706057 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` = 1694386 OR `props-main`.`id` = 1689536 OR `props-main`.`id` = 1702926 OR `props-main`.`id` = 1685384 OR `props-main`.`id` = 1683766 OR `props-main`.`id` = 1683771 OR `props-main`.`id` = 1704369 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` = 1704360 OR `props-main`.`id` = 1704364 OR `props-main`.`id` = 1702711 OR `props-main`.`id` = 1702684 OR `props-main`.`id` = 1702695 OR `props-main`.`id` = 1706816 OR `props-main`.`id` = 1703184 OR `props-main`.`id` = 1702578 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` = 1711333 OR `props-main`.`id` = 1704899 OR `props-main`.`id` = 1704926 OR `props-main`.`id` = 1708144 OR `props-main`.`id` = 1708145 OR `props-main`.`id` = 1708146 OR `props-main`.`id` = 1698754 OR `props-main`.`id` = 1701226 OR `props-main`.`id` = 1701225 OR `props-main`.`id` = 1706107 OR `props-main`.`id` = 1706773 OR `props-main`.`id` = 1706127 OR `props-main`.`id` = 1706126 OR `props-main`.`id` = 1706108)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26008772' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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.
