Please provide the following information and Tricia Zarate will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.zarateproperties.com/agent/16765/tricia-zarate/property/link/crmls/MC25196876/2108-George-Washington-Ct/Atwater/https://www.zarateproperties.com/images/props/crmls/full/MC25196876.jpgLondon Properties Atwater Real Estate | 2108 George Washington Ct
Listing Agent: Patricia Zarate, London Properties Ltd, Atwater
Beautiful home in a sought-after gated community of Atwater! This spacious two-story offers 4 bedrooms, 2.5 bathrooms, and a fantastic layout with a half bath conveniently located downstairs. The home features two living areas, perfect for gatherings or flexible use of space. The kitchen showcases sleek granite countertops and opens into the living space with durable wood-look tile flooring. Upstairs, all bedrooms are tucked away for privacy. The home also includes a two-car garage with a tandem space, providing plenty of room for storage or hobbies Sitting on an oversized lot, this property offers endless possibilities for entertaining, gardening, or even adding a pool. Enjoy the peace of mind and comfort of living in a secure, well-maintained neighborhood-all while having plenty of space inside and out.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2005
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
1
Entry Location
Front
Price Per Square Foot
$224
Days On Market
3
Cumulative Days On Market
3
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
Bell Dr. to Patriotic Dr., right on George Washington Ct.
Room Type
All Bedrooms Up
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Electric Dryer Hookup, Upper Level
Roof
Tile
Construction Materials
Stucco
Door Features
Panel Doors
Window Features
Double Pane Windows
Main Level Bedrooms
0
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Main Level Bathrooms
1
Room Kitchen Features
Kitchen Island
Eating Area
Breakfast Nook
Appliances Y/N
Yes
Appliances
Double Oven
Room Bathroom Features
Bathtub, Double Sinks in Primary Bath
Interior Features
Granite Counters, Recessed Lighting
Flooring
Carpet, Tile
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Living Room
Pool Features
None
Pool Private Y/N
No
Patio Y/N
Yes
Patio And Porch Features
Slab
Electric
220 Volts in Laundry
Utilities
Electricity Connected, Natural Gas Connected
Water Source
Public
Sewer
Public Sewer
Parking Total
3.00
Attached Garage Y/N
Yes
Garage Spaces
3.00
Lot Features
Cul-De-Sac, Sprinklers In Front, Sprinklers In Rear
Lot Size Area
13049.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Neighborhood
Sprinklers Y/N
Yes
Fencing
Wood
Common Interest
None
Parcel Number
056500013000
Additional Parcels Y/N
No
Zoning
P-D 23
Community Features
Curbs
Association Amenities
Playground
Senior Community Y/N
No
Association Y/N
Yes
Association Name
America West Homeowners Association
Association Management Name
Community Association Management Services, Inc
Association Fee
175.00
Association Fee Frequency
Monthly
High School District
Merced Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
63
Tax Census Tract
7.02
72871
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 494000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 546000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2070 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2570 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` = 1674115 OR `props-main`.`id` = 1674068 OR `props-main`.`id` = 1679145 OR `props-main`.`id` = 1676250 OR `props-main`.`id` = 1676266 OR `props-main`.`id` = 1622894 OR `props-main`.`id` = 1678715 OR `props-main`.`id` = 1684244 OR `props-main`.`id` = 1684353 OR `props-main`.`id` = 1678728 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 281861 OR `props-main`.`id` = 764482 OR `props-main`.`id` = 1674113 OR `props-main`.`id` = 1674316 OR `props-main`.`id` = 1680711 OR `props-main`.`id` = 301259 OR `props-main`.`id` = 1682226 OR `props-main`.`id` = 1684190 OR `props-main`.`id` = 1683888 OR `props-main`.`id` = 1683921 OR `props-main`.`id` = 1681613 OR `props-main`.`id` = 1684357 OR `props-main`.`id` = 1681501 OR `props-main`.`id` = 1639779 OR `props-main`.`id` = 1675140 OR `props-main`.`id` = 1627752 OR `props-main`.`id` = 1651865 OR `props-main`.`id` = 1679233 OR `props-main`.`id` = 1674298 OR `props-main`.`id` = 1676559 OR `props-main`.`id` = 1682532 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1650510 OR `props-main`.`id` = 1683145 OR `props-main`.`id` = 1682973 OR `props-main`.`id` = 1673216 OR `props-main`.`id` = 1673221 OR `props-main`.`id` = 1615839 OR `props-main`.`id` = 1614225 OR `props-main`.`id` = 1679979 OR `props-main`.`id` = 1679963 OR `props-main`.`id` = 1679970 OR `props-main`.`id` = 1683616 OR `props-main`.`id` = 1680693 OR `props-main`.`id` = 1680717 OR `props-main`.`id` = 1680723 OR `props-main`.`id` = 1663964 OR `props-main`.`id` = 1663966 OR `props-main`.`id` = 1645529 OR `props-main`.`id` = 1644663 OR `props-main`.`id` = 1642699 OR `props-main`.`id` = 1622885 OR `props-main`.`id` = 1663976 OR `props-main`.`id` = 1681567 OR `props-main`.`id` = 1684031 OR `props-main`.`id` = 1683518 OR `props-main`.`id` = 1683549 OR `props-main`.`id` = 1683581 OR `props-main`.`id` = 1682782 OR `props-main`.`id` = 1671761 OR `props-main`.`id` = 1683840 OR `props-main`.`id` = 1668924 OR `props-main`.`id` = 1684367 OR `props-main`.`id` = 1683927 OR `props-main`.`id` = 1677622 OR `props-main`.`id` = 1677617 OR `props-main`.`id` = 1677620 OR `props-main`.`id` = 1659680 OR `props-main`.`id` = 1681851 OR `props-main`.`id` = 1675291 OR `props-main`.`id` = 1651866 OR `props-main`.`id` = 1651867 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1664582 OR `props-main`.`id` = 1675216 OR `props-main`.`id` = 1675243 OR `props-main`.`id` = 1683737 OR `props-main`.`id` = 1683711 OR `props-main`.`id` = 1674114 OR `props-main`.`id` = 1673439 OR `props-main`.`id` = 1680800 OR `props-main`.`id` = 1680787 OR `props-main`.`id` = 1684358 OR `props-main`.`id` = 175921 OR `props-main`.`id` = 1683795 OR `props-main`.`id` = 1683670 OR `props-main`.`id` = 1683792 OR `props-main`.`id` = 1682311 OR `props-main`.`id` = 1658262 OR `props-main`.`id` = 1650607 OR `props-main`.`id` = 1653182 OR `props-main`.`id` = 1684296 OR `props-main`.`id` = 1656550 OR `props-main`.`id` = 1656714 OR `props-main`.`id` = 1656726 OR `props-main`.`id` = 1674413 OR `props-main`.`id` = 1672924 OR `props-main`.`id` = 1683421 OR `props-main`.`id` = 258606 OR `props-main`.`id` = 1683349 OR `props-main`.`id` = 1683356 OR `props-main`.`id` = 1683949 OR `props-main`.`id` = 1645895 OR `props-main`.`id` = 155874)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25196876' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-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.