Listing Agent: Melinda Price, London Properties Ltd - Merced
Looking for something exceptional? Built in 2005, this is not your run of the mill construction. This fabulous home features 2x6 construction, Tuscan wall finish, smooth plaster-look stucco finish, all the doors, cabinets, and built-ins are knotty alder wood - even the interior doors are solid alder. Tons of storage, granite counters, stainless steel appliances. The split floor plan features 4 bedrooms, 3.5 baths, two large living areas and an oversized 3 car garage. The family room has a gorgeous gas fireplace, doors to the patio and lots of natural light. You will never worry about power outages with the solar energy system as well as a permanently installed Generac generator sized to run the entire home in the event of a power failure. The HUGE Gunite pool is completely fenced - a great feature for keeping little ones and pets safe. The yard is crossed fenced with an area perfect for a large shop...and another separate area perfect for a veggie garden. This home needs just a little TCL and that is mostly in the landscaping. Put in just a little sweat equity and you will have an incredible showplace of a home. Situated in a lovely cul-de-sac of custom homes. Anyone would be proud to own this beautiful home.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2005
Year Built Source
Assessor
Special Listing Conditions
Trust
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Entry Location
Front
Price Per Square Foot
$284
Days On London
0
Cumulative Days On London
0
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
Buhach Rd to Mulberry Ave. Rt on Mulberry to Herrod Ave. Rt on Herrod Ave to Sandy Ct. Home is located at end of Cul-de-Sac
Disclosures
Death On Property < 3 yrs, CC And R's
Architectural Style
Custom Built, Mediterranean
Room Type
Jack & Jill, Entry, Separate Family Room, Laundry, Kitchen, Living Room, Family Room, Primary Suite
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Individual Room
Roof
Composition
Security Features
Carbon Monoxide Detector(s), Smoke Detector(s)
Construction Materials
Stucco
Window Features
Double Pane Windows, Blinds
Foundation Details
Slab
Property Condition
Repairs Cosmetic
Main Level Bedrooms
4
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Bathrooms Half
1
Main Level Bathrooms
4
Room Kitchen Features
Kitchen Island, Granite Counters
Eating Area
Breakfast Counter / Bar, Dining Room, Breakfast Nook
Appliances Y/N
Yes
Appliances
6 Burner Stove,Microwave,Refrigerator,Gas Water Heater,Range Hood,Gas Range,Gas Oven,Dishwasher
Room Bathroom Features
Tile Counters, Shower in Tub, Double sinks in bath(s), Double Sinks in Primary Bath
Interior Features
Crown Molding, Built-in Features, High Ceilings, Ceiling Fan(s), Open Floorplan, Granite Counters
Flooring
Tile, Carpet
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Gas, Living Room
Exterior Features
Rain Gutters
Pool Features
In Ground, Waterfall, Fenced, Private, Gunite
Pool Private Y/N
Yes
Spa Y/N
No
Spa Features
None
Patio Y/N
Yes
Patio And Porch Features
Covered
Electric
220 Volts in Laundry
Utilities
Natural Gas Connected
Water Source
Well
Sewer
Septic Type Unknown
Parking Y/N
Yes
Parking Total
3.00
Parking Features
Concrete, Circular Driveway, Direct Garage Access, Garage - Three Door, Driveway, Garage Faces Side
Attached Garage Y/N
Yes
Garage Spaces
3.00
Lot Features
Sprinklers In Front, Cul-De-Sac, 0-1 Unit/Acre, Irregular Lot, Sprinklers Timer, Sprinkler System
Lot Size Area
1.0000
Lot Size Units
Acres
View Y/N
Yes
View
Neighborhood
Sprinklers Y/N
Yes
Fencing
Wood
Common Interest
None
Parcel Number
207100024000
Additional Parcels Y/N
No
Community Features
Street Lights
Senior Community Y/N
No
Association Y/N
No
High School District
Merced Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Special Assessments
Tax Lot
7
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 946105 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1045695 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3252 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3752 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` = 1701847 OR `props-main`.`id` = 274199 OR `props-main`.`id` = 1691442 OR `props-main`.`id` = 1714429 OR `props-main`.`id` = 1722925 OR `props-main`.`id` = 1714426 OR `props-main`.`id` = 1691448 OR `props-main`.`id` = 1722924 OR `props-main`.`id` = 1691443 OR `props-main`.`id` = 1722926 OR `props-main`.`id` = 1714428 OR `props-main`.`id` = 221849 OR `props-main`.`id` = 1713477 OR `props-main`.`id` = 1622825 OR `props-main`.`id` = 1702364 OR `props-main`.`id` = 144493 OR `props-main`.`id` = 1713337 OR `props-main`.`id` = 1713468 OR `props-main`.`id` = 1713597 OR `props-main`.`id` = 1723905 OR `props-main`.`id` = 1723975 OR `props-main`.`id` = 236633 OR `props-main`.`id` = 1667973 OR `props-main`.`id` = 1687773 OR `props-main`.`id` = 1687772 OR `props-main`.`id` = 1721685 OR `props-main`.`id` = 1078072 OR `props-main`.`id` = 1702939 OR `props-main`.`id` = 1702920 OR `props-main`.`id` = 1714627 OR `props-main`.`id` = 1113258 OR `props-main`.`id` = 1717756 OR `props-main`.`id` = 1717748 OR `props-main`.`id` = 1701745 OR `props-main`.`id` = 1701484 OR `props-main`.`id` = 588889 OR `props-main`.`id` = 1723149 OR `props-main`.`id` = 159004 OR `props-main`.`id` = 72047 OR `props-main`.`id` = 1715535 OR `props-main`.`id` = 1720310 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 1705043 OR `props-main`.`id` = 1704605 OR `props-main`.`id` = 1722015 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 1723863 OR `props-main`.`id` = 281861 OR `props-main`.`id` = 1723150 OR `props-main`.`id` = 1698472 OR `props-main`.`id` = 1717926 OR `props-main`.`id` = 1723060 OR `props-main`.`id` = 764482 OR `props-main`.`id` = 1716596 OR `props-main`.`id` = 1713267 OR `props-main`.`id` = 301259 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1723302 OR `props-main`.`id` = 1721065 OR `props-main`.`id` = 1720707 OR `props-main`.`id` = 1720899 OR `props-main`.`id` = 1698461 OR `props-main`.`id` = 1723280 OR `props-main`.`id` = 1719056 OR `props-main`.`id` = 1717369 OR `props-main`.`id` = 1713318 OR `props-main`.`id` = 1713316 OR `props-main`.`id` = 1713327 OR `props-main`.`id` = 1702194 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1724072 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1717379 OR `props-main`.`id` = 1697663 OR `props-main`.`id` = 1723294 OR `props-main`.`id` = 1724484 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 1724483 OR `props-main`.`id` = 1723293 OR `props-main`.`id` = 1718717 OR `props-main`.`id` = 1718711 OR `props-main`.`id` = 1718743 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1708125 OR `props-main`.`id` = 1708155 OR `props-main`.`id` = 1707998 OR `props-main`.`id` = 1685842 OR `props-main`.`id` = 1723297 OR `props-main`.`id` = 1724575 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1722886 OR `props-main`.`id` = 1723453 OR `props-main`.`id` = 1724879 OR `props-main`.`id` = 1723056 OR `props-main`.`id` = 1723051 OR `props-main`.`id` = 1723046)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26092638' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-01' 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.
