Unit 2 of this new custom renovation is the penthouse duplex offering 2,107 SF of living space, 4 bedrooms and 3 full bathrooms. This home features an open living/dining area that leads to the fully custom kitchen including an extra-large island, quartz counter tops, JennAir appliances and ample cabinet space. There is an additional family room extended off the kitchen with a fully equipped wet bar and 4 custom sky lights ideal for entertaining. A bedroom and full bathroom complete the first floor, which acts as a perfect guest room. The second floor includes the over-sized master suite featuring 3 closets, en-suite bathroom with custom double vanity and beautiful rain shower. The home is complete with custom light fixtures throughout, Nest thermostat, and 1 parking space that has an electronic car charging station. All just steps from the Red Line and everything vibrant Davis Square has to offer!
As the MLS and public records start to fill up, we'll list the details here.
Public record
Public record
Zoning
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Condo/Co-op
County
Middlesex County
APN
—
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 29, 2025.
NR
Neighborhood Residence District
To implement the objectives of the Comprehen Sive Plan of the City of Somerville.; To conserve already established areas of detached and semi-detached residential buildings.
Permitted uses
Include but are not limited to:
Religious facility
Day care facility
Public service
Educational/school
Recreation
Property details
Parking
Parking Information
Parking Spaces: 1
Parking Features: Tandem
Interior
Bathroom Information
# of Bathrooms (Full): 3
Master Bathroom Features: Yes
Basement Information
Basement: N
Interior Features
# of Rooms (Total): 6
Exterior
Building Information
Building Area (Total): 2,107
StructureType: Detached
Stories (Total): 2
Year Built Source: Builder
Year Built Details: Approximate
Property Information
PropertySubType: Condominium
Entry Level: 2
Entry Location: Unit Placement(Upper)
Security Features: Intercom
Financial
Tax Information
Tax Annual Amount: $99,999
Tax Year: 2019
Utilities
Utility Information
Sewer: Public Sewer
Water Source: Public
Heating & Cooling
Has Heating
Has Cooling
Heating: Central
Cooling: Central Air
Location
HOA Information
Association Fee: $99,999
Association Fee Frequency: Monthly
Association Fee Includes: Sewer, Insurance, Maintenance Grounds, Snow Removal
Location Information
Directions: GPS
UnparsedAddress: 38-40 Windsor Rd. # 2, Somerville MA 02144
Community Information
Senior CommunityYN: No
Community Features: Public Transportation, Shopping, Park, Walk/Jog Trails, Medical Facility, Laundromat, Bike Path, Highway Access, House of Worship, Private School, Public School, T-Station, University
Pets Allowed: Yes w/ Restrictions
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Condo/Co-op
Year Built: —
Year Renovated: —
County: Middlesex County
APN: —
Home facts updated by county records on Jul 29, 2025
Other
Listing Information
StandardStatus: Closed
Around this home
Schools
John F. Kennedy Elementary School
Public PreK-8 • Assigned • 0.3mi
8/10
Somerville High School
Public 9-12 • Assigned • 1.2mi
6/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Local insights from Redfin agents
The densest city in New England and the birthplace of Marshmallow Fluff! Somerville will continue to be a competitive Seller's market due to limited new inventory. With many T stops, mixed-use spaces, and close proximity to Cambridge and Boston,...