Adorable single story home in a quiet established neighborhood. Don't miss this 3 bedroom 2 bath home with a large backyard ready for your imagination and summer get togethers. Don't wait or it maybe to late. Make your appt. today.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1965
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Unknown
Stories
1
Home Warranty
No
Directions to Property
Standiford to Coffee Rd right on Coffee, right on Athens home is on the right
Cross Street
Coffee Rd
County
Stanislaus
Special Listing Conditions
None
Main Level
Kitchen
Construction Materials
Stucco
Foundation
Slab
Roof
Shingle
Heating
Central
Cooling
Central
Laundry Features
In Garage
Full Bathrooms
2
Bath Features
Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Family Room, Gas Starter
Flooring
Laminate, Tile, Wood
Kitchen Features
Breakfast Area
Dining Room Features
Space in Kitchen, Formal Area
Living Room Features
Other
Pool
Yes
Pool Features
Above Ground
Spa
No
ADU/2nd Unit
No
Utilities
Other
Electric
Other
Irrigation
Other
Water Source
Other
Sewer
Other
Parking Features
Garage Facing Front
Garage Spaces
2.00
Lot Features
Curb(s)/Gutter(s)
APN
120 020 024 000
Horse Property
No
Zoning Description
R1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Modesto City
Middle or Junior School District
Modesto City
Senior High School District
Modesto City
Census Tract
9.09
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 418950 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) >= 947 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1447 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` = 1747906 OR `props-main`.`id` = 1727990 OR `props-main`.`id` = 1749418 OR `props-main`.`id` = 1723551 OR `props-main`.`id` = 1698031 OR `props-main`.`id` = 1734251 OR `props-main`.`id` = 1748496 OR `props-main`.`id` = 1736164 OR `props-main`.`id` = 1725704 OR `props-main`.`id` = 1745230 OR `props-main`.`id` = 1737123 OR `props-main`.`id` = 1745352 OR `props-main`.`id` = 1746442 OR `props-main`.`id` = 1744337 OR `props-main`.`id` = 1746872 OR `props-main`.`id` = 1725523 OR `props-main`.`id` = 1736670 OR `props-main`.`id` = 1725325 OR `props-main`.`id` = 1737342 OR `props-main`.`id` = 1736600 OR `props-main`.`id` = 1723565 OR `props-main`.`id` = 1723651 OR `props-main`.`id` = 1736806 OR `props-main`.`id` = 1748980 OR `props-main`.`id` = 1713035 OR `props-main`.`id` = 1737964 OR `props-main`.`id` = 1726313 OR `props-main`.`id` = 1714720 OR `props-main`.`id` = 1728433 OR `props-main`.`id` = 1726500 OR `props-main`.`id` = 1747099 OR `props-main`.`id` = 1723305 OR `props-main`.`id` = 1745109 OR `props-main`.`id` = 1739199 OR `props-main`.`id` = 1738587 OR `props-main`.`id` = 1744056 OR `props-main`.`id` = 1714510 OR `props-main`.`id` = 1728802 OR `props-main`.`id` = 1746830 OR `props-main`.`id` = 1749423 OR `props-main`.`id` = 1739541 OR `props-main`.`id` = 1743351 OR `props-main`.`id` = 1739663 OR `props-main`.`id` = 1748420 OR `props-main`.`id` = 1727024 OR `props-main`.`id` = 1723554 OR `props-main`.`id` = 1737967 OR `props-main`.`id` = 1737966 OR `props-main`.`id` = 1728933 OR `props-main`.`id` = 1747432 OR `props-main`.`id` = 1747740 OR `props-main`.`id` = 1726019 OR `props-main`.`id` = 1746043 OR `props-main`.`id` = 1749005 OR `props-main`.`id` = 1725762 OR `props-main`.`id` = 1738314 OR `props-main`.`id` = 1746135 OR `props-main`.`id` = 1727299 OR `props-main`.`id` = 1745742 OR `props-main`.`id` = 1736178 OR `props-main`.`id` = 1740679 OR `props-main`.`id` = 1744338 OR `props-main`.`id` = 1745645 OR `props-main`.`id` = 1727834 OR `props-main`.`id` = 1737270 OR `props-main`.`id` = 1747732 OR `props-main`.`id` = 1728177 OR `props-main`.`id` = 1735297 OR `props-main`.`id` = 1738667 OR `props-main`.`id` = 1732001 OR `props-main`.`id` = 1744702 OR `props-main`.`id` = 1733579 OR `props-main`.`id` = 1747177 OR `props-main`.`id` = 1747147 OR `props-main`.`id` = 1742695 OR `props-main`.`id` = 1736355 OR `props-main`.`id` = 1724411 OR `props-main`.`id` = 1738174 OR `props-main`.`id` = 1741904 OR `props-main`.`id` = 1740841 OR `props-main`.`id` = 1744580 OR `props-main`.`id` = 1746287 OR `props-main`.`id` = 1715680 OR `props-main`.`id` = 1749624 OR `props-main`.`id` = 1741685 OR `props-main`.`id` = 1728232 OR `props-main`.`id` = 1728179 OR `props-main`.`id` = 1747706 OR `props-main`.`id` = 1723462 OR `props-main`.`id` = 1746930 OR `props-main`.`id` = 1720807 OR `props-main`.`id` = 1714968 OR `props-main`.`id` = 1738997 OR `props-main`.`id` = 1715603 OR `props-main`.`id` = 1743738 OR `props-main`.`id` = 1745332 OR `props-main`.`id` = 1749842 OR `props-main`.`id` = 1747524 OR `props-main`.`id` = 1743991 OR `props-main`.`id` = 1735300 OR `props-main`.`id` = 1747356 OR `props-main`.`id` = 1727422 OR `props-main`.`id` = 1737854 OR `props-main`.`id` = 1721984 OR `props-main`.`id` = 1721978 OR `props-main`.`id` = 1727944 OR `props-main`.`id` = 1730671 OR `props-main`.`id` = 1748119 OR `props-main`.`id` = 1707870 OR `props-main`.`id` = 1747796 OR `props-main`.`id` = 1724573 OR `props-main`.`id` = 1724659 OR `props-main`.`id` = 1739235 OR `props-main`.`id` = 1741825 OR `props-main`.`id` = 1747859 OR `props-main`.`id` = 1748978 OR `props-main`.`id` = 1728139 OR `props-main`.`id` = 1712982 OR `props-main`.`id` = 1740601 OR `props-main`.`id` = 1728412 OR `props-main`.`id` = 1729130 OR `props-main`.`id` = 1749602 OR `props-main`.`id` = 1749740 OR `props-main`.`id` = 1741701 OR `props-main`.`id` = 1741309)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226012097' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-16' 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();
2
Similar Properties
$418,000
3
2
1,098
0.16
209 Tokay Ave
Modesto, CA 95350
$399,777
3
2
1,075
0.14
1820 Celeste Dr
Modesto, CA 95355
Courtesy of Kristin Semone, PMZ Real Estate 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.
