Located in a desirable neighborhood with convenient freeway access and close to shopping, dining, and neighborhood parks, this well-designed two-story home offers a functional open-concept layout ideal for today's lifestyle. The main level features a welcoming living area that flows seamlessly into the kitchen and dining space. The kitchen is appointed with granite countertops, rich cabinetry, and ample workspace for everyday living and entertaining. A downstairs bedroom and half bath provide added flexibility for guests, a home office, or multigenerational living. Upstairs, the spacious primary suite includes a private bath and walk-in closet, complemented by three additional bedrooms and a full hall bath. NEM2 solar adds energy efficiency, while the low-maintenance backyard is designed for relaxing and entertaining with a charming gazebo. Additional features include a two-car garage with a finished floor, 220-volt outlet, and EV charger for added convenience.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
2008
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
2
Levels
Two
Home Warranty
No
Directions to Property
Take Hwy 120 then South on McKinley Ave, left on W Atherton Dr, right on Hearthsong Dr, then left on Silhouettes St which turns into Summerwind Ln.
Cross Street
Donatello St
County
San Joaquin
Special Listing Conditions
None
Main Level
Bedroom(s), Dining Room, Garage, Kitchen, Living Room, Primary Bedroom
Construction Materials
Stucco, Frame
Foundation
Slab
Roof
Composition
Heating
Central, Natural Gas
Cooling
Ceiling Fan(s), Central
Laundry Features
Laundry Closet, Hookups Only, Inside Area
Other Structures
Gazebo, Shed(s), Storage
Full Bathrooms
2
Half Bathrooms
1
Bath Features
Shower Stall(s), Tub, Tub w/Shower Over
Flooring
Carpet, Tile
Appliances
Free Standing Gas Range, Dishwasher, Disposal, Microwave
Kitchen Features
Granite Counter, Stone Counter
Dining Room Features
Formal Area
Living Room Features
Great Room
Primary Bedroom Features
Walk-In Closet
Upper Level
Bedroom(s), Full Bath(s), Primary Bedroom
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public, Solar
Electric
220 Volts,220 Volts in Laundry
Irrigation
None
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached, Garage Door Opener
Garage Spaces
2.00
Open Parking Spaces
2.00
Lot Features
Auto Sprinkler Front, Curb(s)/Gutter(s), Landscape Back, Landscape Front
APN
241 760 15
Fencing
Fenced
Horse Property
No
Zoning Description
RES
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
San Joaquin
Elementary School District
Manteca Unified
Middle or Junior School District
Manteca Unified
Senior High School District
Manteca Unified
Census Tract
51.22
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 508250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 561750 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) >= 1535 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2035 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` = 1722104 OR `props-main`.`id` = 1742671 OR `props-main`.`id` = 1750324 OR `props-main`.`id` = 1731859 OR `props-main`.`id` = 1750325 OR `props-main`.`id` = 1709497 OR `props-main`.`id` = 1720984 OR `props-main`.`id` = 1727908 OR `props-main`.`id` = 1722188 OR `props-main`.`id` = 1746317 OR `props-main`.`id` = 1746420 OR `props-main`.`id` = 1721228 OR `props-main`.`id` = 1745457 OR `props-main`.`id` = 1739110 OR `props-main`.`id` = 1746015 OR `props-main`.`id` = 1736608 OR `props-main`.`id` = 1743275 OR `props-main`.`id` = 1746793 OR `props-main`.`id` = 1743928 OR `props-main`.`id` = 1737013 OR `props-main`.`id` = 1749858 OR `props-main`.`id` = 1704819 OR `props-main`.`id` = 1730034 OR `props-main`.`id` = 1741804 OR `props-main`.`id` = 1709829 OR `props-main`.`id` = 1740663 OR `props-main`.`id` = 1728059 OR `props-main`.`id` = 1724869 OR `props-main`.`id` = 1737119 OR `props-main`.`id` = 1736195 OR `props-main`.`id` = 1721458 OR `props-main`.`id` = 1728058 OR `props-main`.`id` = 1724868 OR `props-main`.`id` = 1728057 OR `props-main`.`id` = 1724870 OR `props-main`.`id` = 1728051 OR `props-main`.`id` = 1728049 OR `props-main`.`id` = 1726628 OR `props-main`.`id` = 1728544 OR `props-main`.`id` = 1747433 OR `props-main`.`id` = 1726764 OR `props-main`.`id` = 1751262 OR `props-main`.`id` = 1725420 OR `props-main`.`id` = 1735919 OR `props-main`.`id` = 1729852 OR `props-main`.`id` = 1731268 OR `props-main`.`id` = 1737861 OR `props-main`.`id` = 1724636 OR `props-main`.`id` = 1734878 OR `props-main`.`id` = 1748462 OR `props-main`.`id` = 1748958 OR `props-main`.`id` = 1734377 OR `props-main`.`id` = 1744811 OR `props-main`.`id` = 1749059 OR `props-main`.`id` = 1745899 OR `props-main`.`id` = 1728074 OR `props-main`.`id` = 1743916 OR `props-main`.`id` = 1742564 OR `props-main`.`id` = 1743998 OR `props-main`.`id` = 1740307 OR `props-main`.`id` = 1743917 OR `props-main`.`id` = 1750950 OR `props-main`.`id` = 1747156 OR `props-main`.`id` = 1741324 OR `props-main`.`id` = 1724763 OR `props-main`.`id` = 1730999 OR `props-main`.`id` = 1723093 OR `props-main`.`id` = 1716386 OR `props-main`.`id` = 1747730 OR `props-main`.`id` = 1749895 OR `props-main`.`id` = 1746659 OR `props-main`.`id` = 1749513 OR `props-main`.`id` = 1728774 OR `props-main`.`id` = 1726455 OR `props-main`.`id` = 1717627 OR `props-main`.`id` = 1730978 OR `props-main`.`id` = 1739503 OR `props-main`.`id` = 1718046 OR `props-main`.`id` = 1751096 OR `props-main`.`id` = 1738571 OR `props-main`.`id` = 1732047 OR `props-main`.`id` = 1750652 OR `props-main`.`id` = 1732926 OR `props-main`.`id` = 1733144 OR `props-main`.`id` = 1744619 OR `props-main`.`id` = 1750954 OR `props-main`.`id` = 1747301 OR `props-main`.`id` = 1730597 OR `props-main`.`id` = 1701860 OR `props-main`.`id` = 1750636 OR `props-main`.`id` = 1725848 OR `props-main`.`id` = 1728910 OR `props-main`.`id` = 1728871 OR `props-main`.`id` = 1746149 OR `props-main`.`id` = 1744370 OR `props-main`.`id` = 1724712 OR `props-main`.`id` = 1701938 OR `props-main`.`id` = 1719152 OR `props-main`.`id` = 1720665 OR `props-main`.`id` = 1750403 OR `props-main`.`id` = 1616278 OR `props-main`.`id` = 1750401 OR `props-main`.`id` = 1614564 OR `props-main`.`id` = 1750365 OR `props-main`.`id` = 1713456 OR `props-main`.`id` = 1725709 OR `props-main`.`id` = 1736586 OR `props-main`.`id` = 1748987 OR `props-main`.`id` = 1743458 OR `props-main`.`id` = 1743459 OR `props-main`.`id` = 1741213 OR `props-main`.`id` = 1735304 OR `props-main`.`id` = 1742195 OR `props-main`.`id` = 1734539 OR `props-main`.`id` = 1741199 OR `props-main`.`id` = 1738176 OR `props-main`.`id` = 1737832 OR `props-main`.`id` = 1728623 OR `props-main`.`id` = 1708320 OR `props-main`.`id` = 1748460 OR `props-main`.`id` = 1721079)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226002298' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-20' 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
Courtesy of Stacy Granberg, EXIT Realty Consultants 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.
