Listing Agent: Sheril Carmona, Tinetti Realty Group
Perfectly located in the prestige Shaffer Lakes community! Beautifully designed four bedroom home (including casita room), offering 2,072sqft of comfortable living space with a smart, functional layout. The open kitchen flows seamlessly into the family room and dining area, perfect for everyday living and entertaining. Enjoy an indoor laundry room and generous storage throughout. The separated casita offers the perfect space to use as an in-law space, office, bedroom, or hobby room and has it's own private bath! The attached two car garage features a long tandem area ideal for a workshop, storage, or hobby space. Enjoy a beautifully landscaped, park-like backyard with a relaxing pool and spa combo. If that wasn't enough, did we mention this home has OWNED SOLAR!? Schedule your private showing today!
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2006
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Price Per Square Foot
$253
Days On London
15
Cumulative Days On London
15
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
Community located off Shaffer Rd, can enter gate off Camellia Drive
Room Type
Family Room, Kitchen, Laundry, Walk-In Closet
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Individual Room, Inside
Roof
Tile
Security Features
Carbon Monoxide Detector(s), Smoke Detector(s)
Window Features
Double Pane Windows
Foundation Details
Slab
Property Condition
Turnkey
Main Level Bedrooms
4
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Main Level Bathrooms
3
Room Kitchen Features
Granite Counters, Kitchen Island, Kitchen Open to Family Room
Eating Area
Breakfast Counter / Bar, In Living Room
Room Bathroom Features
Shower in Tub, Separate tub and shower
Interior Features
Granite Counters, High Ceilings
Flooring
Carpet, Tile
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Family Room
Pool Features
Private, Gunite
Pool Private Y/N
Yes
Spa Y/N
Yes
Spa Features
Private
Patio Y/N
Yes
Patio And Porch Features
Covered
Water Source
Public
Sewer
Public Sewer
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Garage
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Back Yard, Front Yard, Landscaped
Lot Size Area
7501.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Neighborhood
Fencing
Wood
Common Interest
None
Parcel Number
150280036000
Additional Parcels Y/N
No
Community Features
Curbs, Lake, Sidewalks, Street Lights
Association Amenities
Other
Senior Community Y/N
No
Association Y/N
Yes
Association Name
Shaffer Lakes West
Association Management Name
Shaffer Lakes West
Association Fee
187.00
Association Fee Frequency
Monthly
High School District
Merced Union
Elementary School
Merced
Middle Or Junior School
Merced City
Exclusions
Both Refrigerators, Freezer, Washer, and Dryer do not stay.
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
18
72871
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 498750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 551250 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) >= 1822 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2322 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` = 1680711 OR `props-main`.`id` = 1698461 OR `props-main`.`id` = 1684766 OR `props-main`.`id` = 1695235 OR `props-main`.`id` = 1702194 OR `props-main`.`id` = 1702283 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1697663 OR `props-main`.`id` = 1691488 OR `props-main`.`id` = 1680693 OR `props-main`.`id` = 1680717 OR `props-main`.`id` = 1680723 OR `props-main`.`id` = 1705044 OR `props-main`.`id` = 1705636 OR `props-main`.`id` = 1705151 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1704868 OR `props-main`.`id` = 1704987 OR `props-main`.`id` = 1685842 OR `props-main`.`id` = 1700148 OR `props-main`.`id` = 1671761 OR `props-main`.`id` = 1691960 OR `props-main`.`id` = 1691872 OR `props-main`.`id` = 1691969 OR `props-main`.`id` = 1700180 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1702899 OR `props-main`.`id` = 1702479 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1694068 OR `props-main`.`id` = 1701739 OR `props-main`.`id` = 1701720 OR `props-main`.`id` = 1701729 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 175921 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1706413 OR `props-main`.`id` = 1688816 OR `props-main`.`id` = 1700967 OR `props-main`.`id` = 1692458 OR `props-main`.`id` = 1656550 OR `props-main`.`id` = 1656714 OR `props-main`.`id` = 258606 OR `props-main`.`id` = 155874 OR `props-main`.`id` = 1704204 OR `props-main`.`id` = 1704209 OR `props-main`.`id` = 342762 OR `props-main`.`id` = 1702763 OR `props-main`.`id` = 1700162 OR `props-main`.`id` = 1694847 OR `props-main`.`id` = 1696793 OR `props-main`.`id` = 1690176 OR `props-main`.`id` = 1690198 OR `props-main`.`id` = 1656585 OR `props-main`.`id` = 1703045 OR `props-main`.`id` = 1699808 OR `props-main`.`id` = 1703033 OR `props-main`.`id` = 1692125 OR `props-main`.`id` = 1700013 OR `props-main`.`id` = 1685496 OR `props-main`.`id` = 1691063 OR `props-main`.`id` = 1706080 OR `props-main`.`id` = 1697937 OR `props-main`.`id` = 1697917 OR `props-main`.`id` = 1622832 OR `props-main`.`id` = 1622833 OR `props-main`.`id` = 1700939 OR `props-main`.`id` = 1706164 OR `props-main`.`id` = 1683263 OR `props-main`.`id` = 1667509 OR `props-main`.`id` = 1700987 OR `props-main`.`id` = 1698501 OR `props-main`.`id` = 1691914 OR `props-main`.`id` = 1692176 OR `props-main`.`id` = 586564 OR `props-main`.`id` = 1705294 OR `props-main`.`id` = 1705304 OR `props-main`.`id` = 1704592 OR `props-main`.`id` = 1704282 OR `props-main`.`id` = 1697635)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26007384' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-08' 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.