Skip to content
Bean Group
← Back to search
Browse photos

Active

174 Walnut Street

Somerville, MA 02145

Offered at$3,300,000

Residential Income · Active · MLS #73542693
Listing Courtesy of KM Real Estate Group | Kirsten Mceleney

11Bedrooms
8Bathrooms
5,921Square feet
1900Year built

Bean Group guidance

Useful next steps

Request property information

Select a document or report and Bean Group will help track it down.

Availability varies by property and source. Documents are requested from the appropriate source and may not be immediately available.

Considering this property?

Decide whether it deserves a closer look.

A local Bean Group agent can help you compare nearby inventory, understand the listing details, and identify the questions worth answering before you visit.

Compare nearby homes

MLS PIN data

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 information

Details at a glance

Interior

Rooms
20

Building

Style
3 Family
Year built
1900
Parking
3
Foundation
Stone
Roof
Shingle

Land & utilities

Lot size
0.1 acres
Water
Public
Sewer
Public Sewer
Zoning
NR

Financial

Annual taxes
$15,766
Assessment year
2026

Listing history

Price and status timeline

  1. New

    $6,500 · Sep 1, 2026

  2. New

    $899,000 · Jun 5, 2026

  3. New

    $799,000 · Jun 5, 2026

Property value estimate

An informed starting point

Estimated value$3,196,153

Estimated range $2,906,485$3,485,820

Request a professional valuation →

Automated estimates are not appraisals or guarantees of market value.

Comparable sales

Recent properties for context

Recent comparable sales are not available for this property.

Photo insights

Condition signals

Overall presentationexcellent

Generated from listing photography; not a substitute for an inspection.

Local market context

How this home compares in Somerville

MetricThis propertySomerville
List price$3,300,000$1,599,000106% above local
Price / sq ft$557$50610% above local
Days on market46594% below local
Explore homes in Somerville

Active city listing statistics from MLS PIN as of September 6, 2026. Asking prices are not completed-sale values.

Keep exploring

Similar homes nearby

Common questions

About 174 Walnut Street

Can I schedule a private showing?

Yes. Request a tour of 174 Walnut Street and a Bean Group agent will help coordinate an available time with the listing side.

Can you help me evaluate this property?

Yes. We can discuss condition, comparable sales, offer strategy and the questions worth asking before you decide whether to proceed.

Are property documents available?

Availability varies by property and source. Request the documents you need and we will help obtain what is available.