Property photo 1
Property photo 2
Property photo 3
Property photo 4
Property photo 5
4 Beds
2 Baths
1,658 sqft

$525,000

415 Sycamore Avenue, Modesto CA, 95354

Price per sqft$316.65
Built in1922
Property size1,658 sqft
Property typeResidential

Overview

Active

Listed Oct 9, 2026

Updated 3h ago

Charming Craftsman Home with Income-Producing Studio ADU! Welcome to 415 Sycamore Avenue in Modesto, where timeless Craftsman charm meets modern updates and incredible versatility! This beautiful 4-bedroom, 2-bathroom home showcases the character and warmth of traditional Craftsman architecture while offering thoughtful improvements throughout. The front yard has been partially renovated with low-maintenance turf, enhancing curb appeal while preserving the home's classic charm. One of the property's standout features is the detached garage that has been converted into an income-producing studio ADU, providing an excellent opportunity for additional rental income, multigenerational living, or flexible guest accommodations. But there's more! The home also features a partially finished basement offering endless possibilities. Imagine transforming this unique space into your own wine bar, man cave, entertainment lounge, or children's playroom! With four spacious bedrooms, two bathrooms, a separate studio ADU, and additional basement space, this property offers a rare combination of character, functionality, and income potential. Homes with this much charm and versatility don't come around often. This one won't last long! Schedule your private showing today!

$3,493/mo

Est. mortgage payment based on a $525,000 home price.

All estimates are provided by Luxury Presence for informational purposes only. Actual amounts may vary.

Additional information

MLS® ID
226126407

Interior Features

Bedrooms
4
Bathrooms
2
Fireplace
Yes
Cooling
Yes
Heating
Yes
Basement
Yes

Exterior Features

Lot Size
0.09 Acres

Other Property Details

Garage
Yes
55+/Senior Community
No
MLS provider logo

Courtesy of PMZ Real Estate, Yesenia Jamison,
Listing Contact:  

Data maintained by METROLIST® may not reflect all real estate activity in the market. All information has been provided by seller/other sources and has not been verified by broker. All measurements and all calculations of area (i.e., Sq Ft and Acreage) are approximate. All interested persons should independently verify the accuracy of all information. All real estate advertising placed by anyone through this service for real properties in the United States is subject to the US Federal Fair Housing Act of 1968, as amended, which makes it illegal to advertise 'any preference, limitation or discrimination because of race, color, religion, sex, handicap, family status or national origin or an intention to make any such preference, limitation or discrimination.' This service will not knowingly accept any advertisement for real estate which is in violation of the law. Our readers are hereby informed that all dwellings, under the jurisdiction of U.S. Federal regulations, advertised in this service are available on an equal opportunity basis. 

©2026 METROLIST®. All rights reserved.

Data last updated 3:55 PM UTC

 

Powered by Luxury Presence