BMN Boston

Get our mobile app!

Download on the App Store

174 Elm Street North # 1, Cambridge MA 02140

Cambridge, MA 02140
$925,000
Est. $5,859/month
2
Beds
1.5
Baths
1,200
Sq Ft
$771
Price/Sq Ft
1891
Year Built
17 hours 34 minutes
Time on Market
Active Open House Listed May 28, 2026 • MLS# 73526278 Copied!

About this home

This spacious two-to-three-bedroom condominium is ideally situated between Davis and Porter Squares in a charming Queen Anne Victorian. The property offers a comfortable living experience with 1.5 baths, central air conditioning, a large flexible layout, high ceilings, and oversized windows that fill the home with natural light. Additional features include an eat-in kitchen with new appliances and an adjoining laundry room, a private rear deck, off-street parking, and extensive basement storage. The condominium has been freshly painted, the floors have been refinished, and the home is truly move-in ready. All this is just a short distance from coffee shops, grocery stores, restaurants, MBTA Red Line stops, trails, and the many other amenities the neighborhood has to offer.

View in the App

Save this property, schedule tours instantly, and get alerts when the price drops

Scan to download BMN Boston app Scan with phone
Get the full experience in the BMN Boston app

Public Records

Current Owner

Owner ESDAILE, MICHAEL J.
Mailing Address 174 ELM ST UNIT N 2, CAMBRIDGE, MA, 02140

Land Use

Use Code 102
Description Condominium
Style FLAT

Tax Information

Assessed Value $1,045,000
Tax Rate $5.86 per $1,000
Base Tax $6,124
CPA Surcharge 3% ($166)
Estimated Annual Tax $6,290

Assessment History

Year Land Building Total Change
FY2026 $0 $1,045,000 $1,045,000

Sale History

Date Price Book/Page
Aug 6, 2021 $970,000 78422/0400
May 15, 2015 $716,500 65373/0561
Jul 8, 2009 $511,500 53165/0285
Sep 9, 2008 $1,055,000 51664/0555

Municipal Context: CAMBRIDGE

Median Home Value $925,000
Avg SF Tax Bill $8,175
Residential Tax Rate $5.86/1000
CPA Surcharge 3%
County Middlesex

Property Data Comparison

Field Assessor MLS Match
Sqft 1,215 1,200
Year built 1,891 1,891
Match: address_condo (90.0% confidence) · Data as of Apr 8, 2026

Property Overview

Property Type
Condominium
Listing Type
For Sale
Year Built
1891
Bedrooms
2
Full Bathrooms
1
Half Bathrooms
1
Living Area
1,200 sq ft
Total Rooms
5
Stories
1
Entry Level
1

Open House Schedule

31
May
Sunday, May 31
11:00 AM - 12:30 PM EDT
30
May
Saturday, May 30
1:00 PM - 2:30 PM EDT

Facts & Features

Central AC

Home Facts

Type Residential
Style Condominium
Year Built 1891
Living Area 1,200 sq ft
Bedrooms 2
Full Baths 1
Half Baths 1
Total Rooms 5

Interior

Heating Central, Forced Air
Cooling Central Air
Flooring Wood
Appliances Range, Dishwasher, Disposal, Microwave, Refrigerator, Washer, Dryer
Fireplace None
Basement Y
Laundry In Unit
Features None

Exterior

Construction None
Architecture None
Roof None
Features Deck
Pool None
Spa None
Fencing None
Patio/Porch Deck

Parking

Features Off Street, Deeded
Total Spaces 1

Utilities

Electric Circuit Breakers
Water Public
Sewer Public Sewer
Gas None
Other For Gas Range

Financial

Annual Tax $6,980
Assessed Value $1,018,900

Interior Features

Flooring: Wood
Appliances: Range, Dishwasher, Disposal, Microwave, Refrigerator, Washer, Dryer
Interior Features:
Windows:
Basement: Y
Laundry: In Unit
Security:

Construction & Materials

Year Built: 1891
Effective Year (Renovated): 2009
Structure Type: 2/3 Family
Exterior Materials:
Roof:
Foundation:
Stories: 1

Heating, Cooling & Utilities

Heating: Central, Forced Air
Heating Zones: 1
Cooling: Central Air
Cooling Zones: 1
Hot Water:
Water Source: Public
Sewer: Public Sewer
Energy Features:

Exterior & Lot

Exterior Features: Deck
Patio & Porch: Deck
Fencing:
Other Structures:
Lot Features:
Road Surface:

Parking & Garage

Total Parking Spaces: 1
Parking Features: Off Street, Deeded

Location

Loading map...

Neighborhood

174 Elm Street North # 1, Cambridge MA 02140

Cambridge, MA 02140

Walkability

Loading Walk Score...

Nearby Schools

School District
Cambridge School District local
A-
🎓 Where Graduates Go Class of 2021
65% attend college
58% 4-Year 7% 2-Year 23% Out of State 7% Working
School Safety 2024-25
1.2% Low
0.8% Suspensions 0.2% In-School 0.4% Emergency
4.3% below state avg
E

Elementary Schools

10 schools
A
Benjamin Banneker Charter Public School
0.6 mi | #100 of 824 | Score: 59.4
Dropped 79 spots from last year
+1.2 above state avg
352 students Less Diverse
Grades PK-06
Cambridge Friends School
0.6 mi
Grades PK-08
Cambridge Montessori School
0.8 mi
Grades PK-06
St. Peter Elementary School
0.9 mi
Grades PK-08
Lycee International de Boston/International School of Boston, Inc.
0.9 mi
Grades 01-12
Fayerweather Street School
1.7 mi
Grades PK-08
Shady Hill School
1.8 mi
Grades PK-08
C
Prospect Hill Academy Charter School
2.0 mi | #253 of 346 | Score: 45.9
Improved 29 spots from last year
-12.3 below state avg
890 students Diverse
High Graduation Rate Rising School College Ready Curriculum Diverse Student Body
Grades PK-12
A
Amigos School
2.1 mi | #45 of 352 | Score: 57.8
Improved 14 spots from last year
-0.5 below state avg
413 students Diverse
Diverse Student Body
Grades PK-08
B+
Peabody School
0.4 mi | #278 of 824 | Score: 51.4
Improved 84 spots from last year
-6.8 below state avg
314 students Very Diverse
Rising School Diverse Student Body
Grades PK-05
M

Middle Schools

5 schools
Allium Montessori School
1.0 mi
Grades 01-06
A
Rindge Avenue Upper School
0.4 mi | #67 of 352 | Score: 54.3
Dropped 2 spots from last year
-3.9 below state avg
292 students Diverse
Diverse Student Body
Grades 06-08
A-
Putnam Avenue Upper School
1.8 mi | #103 of 352 | Score: 49.1
Dropped 24 spots from last year
-9.1 below state avg
283 students Very Diverse
Diverse Student Body
Grades 06-08
C+
Cambridge Street Upper School
2.0 mi | #214 of 352 | Score: 39.8
Dropped 26 spots from last year
-18.4 below state avg
301 students Very Diverse
Diverse Student Body
Grades 06-08
B+
Darby Vassall Upper School
2.3 mi | #118 of 352 | Score: 47.5
Improved 26 spots from last year
-10.7 below state avg
298 students Very Diverse
Rising School Diverse Student Body
Grades 06-08
H

High Schools

3 schools
Farr Academy School
2.2 mi
Grades 07-12
NuVu Innovation School
2.2 mi
Grades 08-12
B-
Community Charter School of Cambridge
2.5 mi | #178 of 346 | Score: 53.1
Dropped 57 spots from last year
-5.2 below state avg
251 students Diverse
7 sports • 202 athletes
High Graduation Rate College Ready Curriculum
Grades 06-12
Learn about these ratings

Monthly Payment Calculator

Monthly Payment
$0
Principal, interest, taxes & insurance
Loan Amount
$0
After down payment
Total Interest
$0
Over life of loan
Total Cost
$0
Including down payment
%
Down: $0
%

Monthly Payment Breakdown

Principal & Interest $0
Property Tax $582
Homeowners Insurance $200
HOA Fee $400/mo
PMI (if <20% down) $0

Loan Summary

Total of 360 payments $0
Total principal paid $0
Total interest paid $0

Rate Impact

-0.5% Rate
$0/mo
Save $0/mo
Current Rate
$0/mo
+0.5% Rate
$0/mo
Cost $0/mo

Payment Over Time

Interest
Principal
Year 1
95% Interest
Year 15
50/50
Year 30
95% Principal
* Estimates only. Actual payments may vary. Consult with a lender for accurate figures.

Property History

Property Timeline

🏠
Listed for Sale
May 28, 2026
$925,000
Original listing
Agent: John O'Neil Office: Gibson Sotheby's International Realty

Price & Status History

Date Event Price Change
May 28, 2026 New Listing Added $925,000

Market Statistics

Time on Market
17 hours 34 minutes
Price per Sq Ft
$771

Tax History

Year Taxes Assessment
2026 $6,980 $1,018,900

Financial Details

Annual Property Tax
$6,980
Tax Year 2026
HOA Fee
$400
Monthly
Assessed Value
$1,018,900

Listing Information

Listing Agent John O'Neil
Listing Office Gibson Sotheby's International Realty
Agent MLS ID BB901255
Office MLS ID AN2064
Listing Data Updated May 29, 2026 3:30 AM EDT
Listing information is deemed reliable but not guaranteed. Data provided by MLS Property Information Network, Inc. All information should be independently verified.

Comparable Properties

Customize Comparable Search

Finding comparable properties...

Market Analytics for Cambridge, MA

Real-time market trends and pricing data for this area

174 Elm Street North # 1, Cambridge MA 02140 - Photo 1 174 Elm Street North # 1, Cambridge MA 02140 - Photo 2 174 Elm Street North # 1, Cambridge MA 02140 - Photo 3 174 Elm Street North # 1, Cambridge MA 02140 - Photo 4 174 Elm Street North # 1, Cambridge MA 02140 - Photo 5 174 Elm Street North # 1, Cambridge MA 02140 - Photo 6 174 Elm Street North # 1, Cambridge MA 02140 - Photo 7 174 Elm Street North # 1, Cambridge MA 02140 - Photo 8 174 Elm Street North # 1, Cambridge MA 02140 - Photo 9 174 Elm Street North # 1, Cambridge MA 02140 - Photo 10 174 Elm Street North # 1, Cambridge MA 02140 - Photo 11 174 Elm Street North # 1, Cambridge MA 02140 - Photo 12 174 Elm Street North # 1, Cambridge MA 02140 - Photo 13 174 Elm Street North # 1, Cambridge MA 02140 - Photo 14 174 Elm Street North # 1, Cambridge MA 02140 - Photo 15 174 Elm Street North # 1, Cambridge MA 02140 - Photo 16 174 Elm Street North # 1, Cambridge MA 02140 - Photo 17 174 Elm Street North # 1, Cambridge MA 02140 - Photo 18 174 Elm Street North # 1, Cambridge MA 02140 - Photo 19 174 Elm Street North # 1, Cambridge MA 02140 - Photo 20
BMN Boston Real Estate

BMN Boston Real Estate

Douglas Elliman

Your message will be sent to BMN Boston Real Estate.

Schedule a Tour