$3,300,000
About this home
Rare opportunity to own a newly renovated three-family investment property in a high-demand Somerville location. 174 Walnut Street offers approx. 5,921 total gross SF across three spacious residences: a massive duplex Unit 1 with approx. 3,044 SF, 6 effective bedrooms, 3 full baths, private deck access, and excellent rental flexibility; Unit 2 with approx. 1,532 SF, 3 bedrooms, 2 full baths, in-unit laundry, and a modern kitchen/living layout; and top-floor Unit 3 with approx. 1,345 SF, 2 bedrooms, 2 full baths, skylights, in-unit laundry, and efficient living/dining space. The property includes driveway/off-street parking, outdoor/exclusive-use areas, and strong access to Somerville amenities, transit, restaurants, shopping, and major employment centers. A compelling asset for investors or owner-occupants seeking scale, flexibility, and long-term upside.
Property details
- MLS #
- 73542693
- Property type
- 3 Family
- Subdivision
- N/A
- Status
- Active
- Days on market
- 89
- On market date
- June 27, 2026
- Stories
- 4
- Total bathrooms
- 8
- Garage spaces
- N/A
- Parking spaces
- 3
- Lot size
- 0.1 acres
Location
Get directions →Nearby schools
Within 10 miles · public school directory data (NCES)
- Enrollment
- 418
- Student:teacher ratio
- 10.2:1
- District
- Somerville
- Enrollment
- 18
- Student:teacher ratio
- 9.0:1
- District
- Somerville
- Enrollment
- 52
- Student:teacher ratio
- 5.8:1
- District
- Somerville
Walkability
Blended score for Somerville's center: EPA's National Walkability Index (street network, transit, land-use mix) combined with nearby-amenity density. 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).
Market position
How this listing compares to current activity in Somerville, from live MLS data.
Mortgage calculator
Estimate only - actual rate and payment depend on your lender, credit, and loan program.
Adjust tax / insurance estimates
Similar homes you might like
Data source: Listing information provided by MLS Property Information Network via Trestle/CoreLogic. Last updated 2 days ago.
Information herein deemed reliable but not guaranteed; all measurements, school assignments, HOA fees, taxes, and feature lists are approximate and should be independently verified. Equal Housing Opportunity.