$5,950,000
●
House -
Off Market
12 Berkeley
Cambridge, MA 02138
6 Beds
3 Baths,
1
Half Bath
4,379 Ft²
$6,300,000
RealtyHop Estimate
0.00%
Since Dec 1, 2023
MA-Boston
Primary Model
About This Property
Gracious 1882 sunny Queen Anne residence located at corner of
cul-de-sac in Brattle area toward center of coveted tree-lined
residential side street close to Harvard Law, Harvard science
center, & Lesley, away from traffic, & set amidst other lovely
residences & gardens. Harvard Square, Red Line, many restaurants &
shops, & ART are nearby. 6 bedrooms/studies, superb sun
exposures, many oversized windows, 5 bay windows, 7 fireplaces.
.30-acre landscaped lot. Open eat-in kitchen: 2 sinks, 2 ovens,
lots of storage, cross-ventilation. Large butler's pantry: huge
storage & 3rd sink. 2 large decks overlook large garden. Ample
1,853 s.f. 1st floor makes flexible family & entertaining space.
1st floor ceiling height is 9'10", 9' on 2nd, & 13'3" in 3rd-floor
bedroom/studio. Elevator serves LL,1, Street, & 2. Two garage
spaces + 2 side-by-side spaces. Beautiful views from the windows in
all directions. Exceptional house and grounds at a stellar
location.
Unit Size
4,379 Ft²
Days on Market
-
Land Size
0.30 acres
Price per sqft
$1,439
Property Type
House
Property Taxes
$2,252
HOA Dues
-
Year Built
1882
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 #73169298)
Price History
| Date / Event | Date | Event | Price |
|---|---|---|---|
| Dec 17, 2025 | Sold | ||
| Sold | |||
| Nov 19, 2025 | In contract | - | |
| In contract | |||
| Oct 24, 2025 | Price Decreased |
$6,450,000
↓ $335K
(4.9%) | |
| Price Decreased | |||
| Sep 10, 2025 | Listed by Coldwell Banker Realty - Cambridge | $6,785,000 | |
| Listed by Coldwell Banker Realty - Cambridge | |||
   | |||
|
A legacy property rich in character, location, and historical pedigree. Rare opportunity to customize your Queen Anne Victorian dream home at the Earnest Longfellow House, located on one of West Cambridge’s most sought-after streets. Note: some listing images are renderings showing the potential after renovation, based on approvals already in place. Set on a large corner lot walkable to Harvard Square, this historic residence includes fully transferable approvals from the Cambridge Historical Commission for stucco removal, a comprehensive renovation, a large rear addition, and a carriage house. A complete build-ready package is included: plans by AIA Fellow Frank Shirley, design team, survey, and vetted contractor. Approved to restore original clapboard and shingle detail. Whether executing the full vision or a more modest scope, the flexibility and value-add potential are unmatched. Paint colors are customizable; the yellow and green shown are for illustrative purposes only.
| |||
| Nov 29, 2023 | Sold | ||
| Sold | |||
Show More
Property Highlights
Garage
Parking Available
Air Conditioning
Fireplace
Elevator
Building Info
Data used for valuation calculations is provided by RealtyHop, and other third party sources
Comparables
Unit
Status
Status
Type
Beds
Baths
ft²
Price/ft²
Price/ft²
Asking Price
Listed On
Listed On
Closing Price
Sold On
Sold On
HOA + Taxes
Your Privacy Choices
Phone: 425-283-2930
Address: 335 Madison Avenue, New York, NY 10017