Rare opportunity in a sought-after Modesto-area location! This single-story home sits on a generous, private lot with mature landscaping, citrus trees, and a sparkling pool ready for your vision. Perfect for the investor, contractor, or homeowner looking to add value through updates and finish out this property to its full potential. Don't miss this chance to secure a unique layout in a location that rarely comes available bring your ideas and make it shine!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1972
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
1
Home Warranty
No
Directions to Property
College Ave to W. Rumble Rd, west on W. Rumble Rd, north on Coffee Rd, west on Yukon Dr, right on Roxbury Ln to property.
Cross Street
Sherwood Ave
County
Stanislaus
Special Listing Conditions
Offer As Is
Main Level
Bedroom(s), Living Room, Dining Room, Family Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Construction Materials
Stucco, Wood
Foundation
Raised
Roof
Shake, Wood
Heating
Central
Cooling
Central
Laundry Features
Hookups Only
Full Bathrooms
2
Bath Features
Tile
# of Fireplaces
1
Fireplace Features
Brick
Flooring
Carpet, Tile, Wood
Kitchen Features
Laminate Counter
Dining Room Features
Other
Living Room Features
Other
Pool
Yes
Pool Features
Built-In
Spa
No
ADU/2nd Unit
No
Utilities
Sewer In & Connected
Electric
220 Volts in Laundry
Irrigation
None
Water Source
Public
Sewer
Public Sewer
Parking Features
Private, Attached
Garage Spaces
2.00
Lot Features
Private, Landscape Back, Landscape Front
APN
059 037 022 000
Horse Property
No
Zoning Description
R-1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Sylvan Union
Middle or Junior School District
Modesto City
Senior High School District
Modesto City
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 402325 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 444675 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) >= 1786 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2286 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` = 1774065 OR `props-main`.`id` = 1768944 OR `props-main`.`id` = 1755687 OR `props-main`.`id` = 1755686 OR `props-main`.`id` = 1754680 OR `props-main`.`id` = 1728820 OR `props-main`.`id` = 1761311 OR `props-main`.`id` = 1771609 OR `props-main`.`id` = 1750637 OR `props-main`.`id` = 1774211 OR `props-main`.`id` = 1723305 OR `props-main`.`id` = 1739199 OR `props-main`.`id` = 1759793 OR `props-main`.`id` = 1747619 OR `props-main`.`id` = 1762718 OR `props-main`.`id` = 1768935 OR `props-main`.`id` = 1764603 OR `props-main`.`id` = 1774100 OR `props-main`.`id` = 1748420 OR `props-main`.`id` = 1766938 OR `props-main`.`id` = 1763588 OR `props-main`.`id` = 1723554 OR `props-main`.`id` = 1773316 OR `props-main`.`id` = 1773603 OR `props-main`.`id` = 1774326 OR `props-main`.`id` = 1773604 OR `props-main`.`id` = 1768091 OR `props-main`.`id` = 1726019 OR `props-main`.`id` = 1765817 OR `props-main`.`id` = 1772124 OR `props-main`.`id` = 1754583 OR `props-main`.`id` = 1766365 OR `props-main`.`id` = 1754913 OR `props-main`.`id` = 1768901 OR `props-main`.`id` = 1727299 OR `props-main`.`id` = 1774031 OR `props-main`.`id` = 1769324 OR `props-main`.`id` = 1771908 OR `props-main`.`id` = 1766271 OR `props-main`.`id` = 1750006 OR `props-main`.`id` = 1774251 OR `props-main`.`id` = 1772220 OR `props-main`.`id` = 1757050 OR `props-main`.`id` = 1744338 OR `props-main`.`id` = 1772104 OR `props-main`.`id` = 1774293 OR `props-main`.`id` = 1765709 OR `props-main`.`id` = 1750106 OR `props-main`.`id` = 1767856 OR `props-main`.`id` = 1735297 OR `props-main`.`id` = 1768362 OR `props-main`.`id` = 1766892 OR `props-main`.`id` = 1764519 OR `props-main`.`id` = 1771783 OR `props-main`.`id` = 1761031 OR `props-main`.`id` = 1759879 OR `props-main`.`id` = 1765755 OR `props-main`.`id` = 1765608 OR `props-main`.`id` = 1762168 OR `props-main`.`id` = 1738174 OR `props-main`.`id` = 1771157 OR `props-main`.`id` = 1759392 OR `props-main`.`id` = 1753300 OR `props-main`.`id` = 1774388 OR `props-main`.`id` = 1752883 OR `props-main`.`id` = 1771866 OR `props-main`.`id` = 1750948 OR `props-main`.`id` = 1763008 OR `props-main`.`id` = 1771615 OR `props-main`.`id` = 1747706 OR `props-main`.`id` = 1723462 OR `props-main`.`id` = 1752212 OR `props-main`.`id` = 1726184 OR `props-main`.`id` = 1774577 OR `props-main`.`id` = 1714968 OR `props-main`.`id` = 1769032 OR `props-main`.`id` = 1759035 OR `props-main`.`id` = 1772156 OR `props-main`.`id` = 1715603 OR `props-main`.`id` = 1771870 OR `props-main`.`id` = 1772980 OR `props-main`.`id` = 1771869 OR `props-main`.`id` = 1774520 OR `props-main`.`id` = 1762456 OR `props-main`.`id` = 1772878 OR `props-main`.`id` = 1737840 OR `props-main`.`id` = 1769246 OR `props-main`.`id` = 1728688 OR `props-main`.`id` = 1766431 OR `props-main`.`id` = 1771241 OR `props-main`.`id` = 1774119 OR `props-main`.`id` = 1762980 OR `props-main`.`id` = 1726521 OR `props-main`.`id` = 1770980 OR `props-main`.`id` = 1744577 OR `props-main`.`id` = 1762736 OR `props-main`.`id` = 1765546 OR `props-main`.`id` = 1759723 OR `props-main`.`id` = 1772043 OR `props-main`.`id` = 1772894 OR `props-main`.`id` = 1771874 OR `props-main`.`id` = 1774481 OR `props-main`.`id` = 1773168 OR `props-main`.`id` = 1755086 OR `props-main`.`id` = 1753686 OR `props-main`.`id` = 1773735 OR `props-main`.`id` = 1755883 OR `props-main`.`id` = 1768951 OR `props-main`.`id` = 1725170 OR `props-main`.`id` = 1749242 OR `props-main`.`id` = 1754310 OR `props-main`.`id` = 1771884 OR `props-main`.`id` = 1741825 OR `props-main`.`id` = 1773841 OR `props-main`.`id` = 1764948 OR `props-main`.`id` = 1773776 OR `props-main`.`id` = 1770156 OR `props-main`.`id` = 1758019 OR `props-main`.`id` = 1721491 OR `props-main`.`id` = 1736609 OR `props-main`.`id` = 1726026 OR `props-main`.`id` = 1712982 OR `props-main`.`id` = 1771491 OR `props-main`.`id` = 1773070 OR `props-main`.`id` = 1761664 OR `props-main`.`id` = 1771528 OR `props-main`.`id` = 1771708 OR `props-main`.`id` = 1772160 OR `props-main`.`id` = 1773153 OR `props-main`.`id` = 1762627 OR `props-main`.`id` = 1773712 OR `props-main`.`id` = 1774207 OR `props-main`.`id` = 1737753 OR `props-main`.`id` = 1753106 OR `props-main`.`id` = 1769051)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226114390' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-10' 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();
1
Similar Properties
$419,900
3
2
1,810
0.17
1416 Tully Rd
Modesto, CA 95350
Courtesy of Alexander Espinoza, Atlantic Realty 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.
