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 Larissa Sherman will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.realestatemaniac.com/agent/14716/larissa-sherman/property/link/metrolist/226004854/2900-Los-Altos-Ct/Atwater/https://www.realestatemaniac.com/images/props/metrolist/full/226004854.jpgLondon Properties Atwater Real Estate | 2900 Los Altos Ct
Adorable Atwater Gem...such a great place to call home! The charming 3 bedroom, 2 bath home tucked away on a quiet cul-de-sac in the heart of Atwater allows you the convenience of being just minutes from local shopping, dining, and everyday amenities, while still savoring the peace and privacy of this desirable location. You'll love the inviting curb appeal and inside, the comfortable living space offers endless possibilitiesperfect for a cozy, quiet night in or for hosting lively gatherings with friends and family with the living room adjacent to the kitchen and large dining area. This home has been lovingly maintained, and it shows! Major upgrades have already been completed, including a newer roof, windows, and HVAC system, giving you peace of mind knowing some costly improvements are already taken care of. Situated on a larger cul-de-sac lot, the backyard provides ample space for outdoor entertaining, gardening, or simply relaxing and enjoying the California sunshine. Properties like this don't come along oftendon't miss your opportunity to make this home your own!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1996
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Unknown
Stories
1
Home Warranty
No
Directions to Property
Fruitland Ave. to Soquel Ave., left on Los Altos Ct.
Cross Street
Soquel
County
Merced
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Dining Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Construction Materials
Frame
Foundation
Slab
Roof
Composition
Heating
Central
Cooling
Central
Laundry Features
Inside Area
Full Bathrooms
2
Bath Features
Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Living Room
Flooring
Carpet, Laminate, Linoleum
Kitchen Features
Island
Dining Room Features
Formal Area
Living Room Features
Cathedral/Vaulted
Primary Bathroom Features
Shower Stall(s), Double Sinks, Walk-In Closet
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public
Electric
Other
Irrigation
None
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached
Garage Spaces
2.00
Lot Features
Court
APN
150 292 022 000
Horse Property
No
Zoning Description
R-1 5 6
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Merced
Elementary School District
Atwater Elementary
Middle or Junior School District
Atwater Elementary
Senior High School District
Merced Union High
Census Tract
6.03
72871
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 380000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 420000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1128 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1628 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` = 1696912 OR `props-main`.`id` = 1681454 OR `props-main`.`id` = 1622894 OR `props-main`.`id` = 1691764 OR `props-main`.`id` = 1678715 OR `props-main`.`id` = 1700943 OR `props-main`.`id` = 1701001 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 1678728 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 1675208 OR `props-main`.`id` = 1694839 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 1688631 OR `props-main`.`id` = 1701023 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 281861 OR `props-main`.`id` = 1698472 OR `props-main`.`id` = 764482 OR `props-main`.`id` = 1680711 OR `props-main`.`id` = 301259 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1698016 OR `props-main`.`id` = 1698461 OR `props-main`.`id` = 1684766 OR `props-main`.`id` = 1681613 OR `props-main`.`id` = 1701004 OR `props-main`.`id` = 1681501 OR `props-main`.`id` = 1695235 OR `props-main`.`id` = 1701056 OR `props-main`.`id` = 1651865 OR `props-main`.`id` = 1702194 OR `props-main`.`id` = 1688038 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1702283 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1702415 OR `props-main`.`id` = 1702848 OR `props-main`.`id` = 1697663 OR `props-main`.`id` = 1702224 OR `props-main`.`id` = 1686740 OR `props-main`.`id` = 1691488 OR `props-main`.`id` = 1680693 OR `props-main`.`id` = 1680717 OR `props-main`.`id` = 1680723 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1688629 OR `props-main`.`id` = 1688587 OR `props-main`.`id` = 1688598 OR `props-main`.`id` = 1685842 OR `props-main`.`id` = 1697382 OR `props-main`.`id` = 1702507 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` = 1701011 OR `props-main`.`id` = 1683927 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1693696 OR `props-main`.`id` = 1701763 OR `props-main`.`id` = 1702081 OR `props-main`.`id` = 1697622 OR `props-main`.`id` = 1696843 OR `props-main`.`id` = 1695667 OR `props-main`.`id` = 1698907 OR `props-main`.`id` = 1698905 OR `props-main`.`id` = 1702479 OR `props-main`.`id` = 1651866 OR `props-main`.`id` = 1651867 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` = 1700648 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 175921 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1702762 OR `props-main`.`id` = 1688816 OR `props-main`.`id` = 1700967 OR `props-main`.`id` = 1692458 OR `props-main`.`id` = 1693700 OR `props-main`.`id` = 1696460 OR `props-main`.`id` = 1697464 OR `props-main`.`id` = 1656550 OR `props-main`.`id` = 1656714 OR `props-main`.`id` = 258606 OR `props-main`.`id` = 155874 OR `props-main`.`id` = 1702582 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` = 1678843 OR `props-main`.`id` = 1656585 OR `props-main`.`id` = 1699808 OR `props-main`.`id` = 1692125 OR `props-main`.`id` = 1700013 OR `props-main`.`id` = 1685496 OR `props-main`.`id` = 1691063 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` = 1700940)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226004854' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-15' 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();
5
Similar Properties
$399,900
4
2
1,539
0.14
1053 Huntingdale
Atwater, CA 95301
$395,000
4
2
1,489
0.15
190 Tammy Dr
Atwater, CA 95301
$389,999
3
2
1,409
0.17
1652 Chaparral Ct
Atwater, CA 95301
$385,000
3
2
1,527
0.14
3141 Forest Grove
Atwater, CA 95301
Courtesy of Larissa Sherman, London Properties, LTD 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.