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.