For Sale
For Rent
Blog
Property Records
Schools
SEARCH
Property Records
For Sale
For Rent
MORE
Blog
Schools
See Home Value
Cambridge 02139 Area IV
208 Windsor Street #0
Photo of Unit 0 at 208 Windsor Street

26

Map

Photo of Unit 0 at 208 Windsor Street
Photo of Unit 0 at 208 Windsor Street
$1,624,000
● Condo - Off Market

208 Windsor Street #0

Cambridge, MA 02139
bedrooms
3 Beds
bathrooms
3 Baths
square feet
1,261 Ft²
$8,697
Est. Monthly
2.11%
Cap Rate

About This Property

Why settle for a condo? A period front door beneath a Charleston gas lantern. Private. Detached. Yours. A truly exceptional single family in the heart of Cambridge - architect-designed, gut-renovated in 2023, built without a single compromise. For the buyer who has been searching, it is the option that was never on the list. The kitchen is the center of the home and was designed that way. Handcrafted Maine walnut cabinetry, marble island, coffered ceiling, pot filler, integrated coffee bar and wet bar. A working Rumford fireplace - rare in Cambridge - anchors the living space. The spa baths were finished by the same Maine artisans who built the kitchen. Every detail was commissioned. Vaulted primary suite, skylight, California closet, spa marble bath. Two further bedrooms, cathedral ceilings. Full laundry. Finished lower level 288sf. Finished attic storage. Private fenced patio. No HOA. No condo fees. No shared walls.Abuts Rose park offering playgrounds & tennis
Unit Size
1,261 Ft²
Days on Market
-
Land Size
-
Price per sqft
$1,288
Property Type
Condo
Property Taxes
$723
HOA Dues
-
Year Built
1886

Payment Calculator

Home Price
Down Payment
%
Loan Term
Interest %

Your Estimated Monthly Payment

Principal + Interest:
Property Tax:
HOA:
Home Insurance:
Mortgage Insurance:

Cap Rate Calculator

Purchase Price
Monthly Property Taxes
Monthly Rental Income
Maintenance & HOA
Income Per Year
Expenses Per Year
Operating Profit Per Year
Cap Rate 100% Occupancy
N/A (extreme outlier)

What does this mean?

Based on our analysis, the cap rate of this property is 1.25%. A negative cap rate indicates that the property might not be feasible as an income-producing asset. The median cap rate for a near zip code 11238 is 4.23%.

How much can I actually make?

Actual monthly rental income may vary between $4,760 and $7,140 depending on unit-specific characteristics. You can change the amount using the slider to further explore.

How is cap rate calculated?

Cap Rate = Net Operating Income (NOI) / Property Asset Value.

When calculating the cap rate, we assume 100% occupancy. Leverage (mortgage) is not considered.

Cap Rate provided by RealtyHop and RentHop, learn more about cap rate here.

Last updated: 4 months ago (MLSPIN #73509900)

Price History

Date / Event Date Event Price
Jul 30, 2026 No longer available -
No longer available
Jul 8, 2026 Price Decreased $1,624,000
↓ $75K (4.4%)
Price Decreased
Jun 4, 2026 Relisted $1,699,000
Relisted
May 18, 2026 Withdrawn -
Withdrawn
Apr 29, 2026 Listed by RE/MAX Real Estate Center $1,699,000
Listed by RE/MAX Real Estate Center

Property Highlights

Parking Available
Air Conditioning
Fireplace

Building Info

Overview

    General

  • Year Built: 1886
  • Effective Year Built: 1886
  • Building Count: 1
  • Total Rooms: 6
  • Bedroom Count: 4
  • Bathroom Count: 2
  • Full Bathrooms: 1
  • Partial Bathrooms: 2
  • Building Condition: 2
  • Building Quality: 0
  • Construction Type: 2
  • Building Style: 15
  • Exterior Walls Type: 21
  • Interior Walls Type: 0
  • Roof Shape Type: 1
  • Roof Cover Type: 15
  • Floor Count: 200
  • Living Units: 1
  • Floor Cover: 0
  • Basement Type: 7
  • Basement Area: 560
  • Garage Type: 0
  • Parking Space Count: 0
  • Patio Type: 0
  • Porch Type: 0
  • Pool Type: 0

    Dimensions

  • Lot Size Square Feet: 1,906
  • Total Building Area: 1,120
  • Gross Building Area: 1,680
  • Building Area: 1,120
  • Building Area Measurement: L

    Heating and Cooling

  • Air Conditioning: 13
  • Heating: 4
  • Heated Square Feet: 1,120
  • Heating Fuel Type: 3

    Utilities

  • Sewer System: 0
  • Water Service: 0

Building

  • Building Type: 0
  • Property Class: R
  • Land Acres: 0000000044
  • Standard Land Use Code: 1001
  • County Land Use Code: 101

Neighborhood

  • School District Name: Cambridge School District
  • Census Tract: 352400

Zoning

  • Zoning: C-1

Geography

  • Parcel: CAMB M:00076 L:00092
  • Lot: 92
  • Municipality: CAMBRIDGE
  • Latitude: 42.3663
  • Longitude: -71.0953

    Address

  • Full Address: 208 Windsor St
  • Address - House Number: 208
  • Address - Street Name: Windsor
  • Address - Suffix Type: St
  • State: MA
  • City Name: Cambridge
  • Carrier Code: C024
  • 4-Digit Zip Code: 1914
  • Zip Code: 02139

Valuation

    Tax

  • Tax Year: 2024
  • Tax Amount: $459,700

    Appraisal Valuation

  • Standard Deviation: 0.2214
  • Valuation Date: Feb 07, 2024
  • Confidence Score: 69
  • Final Value: 908,486
  • High Value: 1,109,652
  • Low Value: 707,320

    Assessments Valuation

  • Assessed Year: 2024
  • Assessed Total Value: $776,600
  • Assessed Land Value: $590,900
  • Assessed Improvements Value: $185,700

    Sales

  • Current Sale Contract Date: Aug 31, 2021
  • Current Sale Recording Date: Aug 31, 2021
  • Current Sale Price:
    Premium
  • Current Sale Document Type: O
  • Current Sale Input Document Number: 194530
  • Previous Sale Recording Date: Jan 05, 1988
  • Previous Sale Amount: $120,000
  • Previous Sale Document Type: 27
Data used for valuation calculations is provided by RealtyHop, and other third party sources
Request mortgage information redaction

Comparables

Unit
Status
Type
Beds
Baths
ft²
Price/ft²
Asking Price
Listed On
Closing Price
Sold On
HOA + Taxes

About Area IV

Stats & Trends

Median Asking:

$1,495,000

Sale Price/ft²

$896

Below Asking

0.03%

Average Days on Market

72

Average Home Size

5426 ft²

Average Home Age

128.7 years

Currently For Sale

6 Listings
Based on RH Advisors, Inc. calculations of home data from MLS and/or public records.

Similar Homes for Sale

Currently no similar homes around

Nearby Rentals

Unit for rent at 285 Third Street, Cambridge, MA, 02142

$4,055 /mo

  • 1 Bed
  • 1 Bath
  • 842 ft²
285 Third Street #1 Bed (North)- 842, Cambridge, MA, 02142 Listing by Equity Residential
Unit for rent at 249 Third St., Cambridge, MA, 02142

$3,817 /mo

  • 2 Beds
  • 1 Bath
  • 950 ft²
249 Third St. #The Lofts 2 Bedrooms U, Cambridge, MA, 02142 Listing by Equity Residential
Unit for rent at 205 Walden St, Cambridge, MA, 02140

$3,585 /mo

  • 2 Beds
  • 1 Bath
  • 963 ft²
205 Walden St #The Chilton 2P, Cambridge, MA, 02140 Listing by Equity Residential

Rentals Near You

Click here to view more rentals in the neighborhood.
Last Updated: 4 months ago
Data Source: MLS PIN, MLS# 73509900

Frequently Asked Questions

When was property at 208 Windsor Street built and last sold?
The property at 208 Windsor Street was built in 1886 and last sold on Aug 31, 2021 for $810,000.
How much is this home worth?
The estimated value of the home located at 208 Windsor Street is $1,590,655.
What are some comparable homes to 208 Windsor Street?
There are currently no comparable homes to 208 Windsor Street.
Recent Neighborhood News
Haunted NYC Real Estate: 6 Spooky Stories Behind the Addresses
Lake House Prices Near NYC in 2026: What Waterfront Actually Costs (Labor Day Buyer's Guide)
9 New York City Seafood and Raw Bars
Why Some NYC Tenement Apartments Had Bathtubs in the Kitchen
Popular Searches
Cambridge Homes for Sale
Cambridge Houses for Sale
Cambridge Condos for Sale
Cambridge Co-Ops for Sale
Cambridge Townhouses for Sale
Cambridge Multifamily for Sale
Cambridge Land for Sale
Cambridge Commercial for Sale
Nearby Cities
Boston Homes for Sale
Newton Homes for Sale
Somerville Homes for Sale
Brookline Homes for Sale
Medford Homes for Sale
Waltham Homes for Sale
Arlington Homes for Sale
Malden Homes for Sale
Nearby Property Records
Suffolk County, MA Property Records
Middlesex County, MA Property Records
Norfolk County, MA Property Records
Essex County, MA Property Records
Worcester County, MA Property Records
Plymouth County, MA Property Records
Providence County, RI Property Records
Bristol County, MA Property Records
Neighborhoods
South End Real Estate
Back Bay Real Estate
Maplewood Real Estate
Coolidge Corner Real Estate
D Street - West Broadway Real Estate
West Revere Real Estate
Thompson Square - Bunker Hill Real Estate
Watertown West End Real Estate
Nearby Counties
Boston Homes for Sale
Newton Homes for Sale
Somerville Homes for Sale
Brookline Homes for Sale
Medford Homes for Sale
Waltham Homes for Sale
Arlington Homes for Sale
Malden Homes for Sale
Top Real Estate Agents
Top Agents in Area IV
Top Agents in Cambridge
Top Agents in Boston
Top Agents in Boston
Top Agents in Newton
Top Agents in Newton
Top Agents in Somerville
Top Agents in Somerville