Nine-Unit Apartment
For Sale
Contact for pricing
Pending
239 Columbia Street, Cambridge, MA 02139
Nine two-bedroom units feature a den on upper floors and are 100% occupied.
Property Size8,460 SF
Days on Market102
Property Features for 239 Columbia Street
General Information
Standard status
Pending
Size
8,460 SF
Property subtype
Retail, Multifamily
Zoning
C-1
Occupancy
100%
Site & Location
Neighborhood
Neighborhood Four
Additional Details
Multifamily Units
9
Building Details
Year Built
1900
Buildings
1
Units
9
Listing Agency:
Hunneman
Listed By:
Carl Christie · License #MA 9521806
(617) 942-1137
Source:
Crexi
Added: Jul 24
Changed: Nov 1
Last Checked: Nov 1 at 2:17AM
Displayed information is deemed reliable but is not guaranteed and should be independently verified. All listing content including descriptions, pricing, images are the copyrighted material of Hunneman
Ask AI about this property
Review the available facts, identify missing information and prepare questions for the agent.
Investment Insights
Based on property information with market context.
239-243 Columbia Street is a nine-unit apartment building built in 1900. The property offers nine spacious two-bedroom apartments, and each upper-floor unit includes an additional den that can function as a home office or a smaller third bedroom.
The building is 100% occupied, providing immediate in-place cash flow supported by a history of occupancy and long-term ownership. With this consistent occupancy and the flexible den layout, the property is positioned to serve tenants seeking extra room within their unit.
The asset’s existing unit configuration provides a practical rental mix across the nine units, including upper-floor den space, while maintaining the overall two-bedroom foundation for day-to-day living needs.
The building is 100% occupied, providing immediate in-place cash flow supported by a history of occupancy and long-term ownership. With this consistent occupancy and the flexible den layout, the property is positioned to serve tenants seeking extra room within their unit.
The asset’s existing unit configuration provides a practical rental mix across the nine units, including upper-floor den space, while maintaining the overall two-bedroom foundation for day-to-day living needs.
Key Highlights
- Nine‑unit apartment building
- Nine spacious two‑bedroom apartments
- Upper‑floor units include a den for office or smaller third bedroom
Financial Insights
Estimated NOI and Cap Rate
NOI / Yr
$198,329
Cap Rate
4.51%
Suggested Prices Based on Cap Rates
Cap Rate 5%
$3,966,580
$4.0M
Cap Rate 7%
$2,833,271
$2.8M
Cap Rate 9%
$2,203,656
$2.2M
Market Conditions
NOI Build-Up for 8,460 SF
Gross rent
$375.6K $44.40/SF
− Vacancy
−$15.0K −$1.78/SF
EGI
$360.6K $42.62/SF
− OpEx
−$162.3K −$19.18/SF
NOI
$198.3K $23.44/SF
Area
Cambridge, MA
Vacancy
4.00%
Lease Rate
$44.40 /SF/Yr
Expense Ratio
45.00%
Simulate Cap Rate and NOI
Suggested Prices Based on Cap Rates
Cap Rate 5%
$3,966,580
Cap Rate 7%
$2,833,271
Cap Rate 9%
$2,203,656
Alternative Uses
Best Use
Apartment 5plus
$2.83M
$2.48M – $3.31M
NOI $198,329 @ 7.0% cap · market cap 4.51%
Second Best
—
—
no second resolved use
Theoretical Best
Office A
$6.52M
$5.71M – $7.61M
NOI $456,557 @ 7.0% cap · market cap 10.39%
Zoning and permitted uses should be independently verified with authorities.
How Realmo checks its estimates
Property Analytics
Lease Details
9
Residential units
100%
Occupancy
Location Intelligence
Trade Area within ½ mile
5,115
Businesses Nearby
Explore this area
Business Placement
Demographics for 02139, MA
39,525
Population
16,930
Households
2.3
Avg Household Size
30
Median Age
78%
College-Educated
94%
High-School Grad
1.6 sq mi
ZIP Area
24,703
Density / Sq Mi
$124,648
Median Household Income
$61,025
Median Earnings
$2,613
Median Rent
$1,066,200
Median Home Value
Market
Vacancy Rate% for Multifamily in Northeast region
Frequently Asked Questions
What type of property is this?
Apartment building - Nine two-bedroom units feature a den on upper floors and are 100% occupied.
Where is this apartment building located?
The property is located at 239 Columbia Street Cambridge, MA.
What is the asking price?
The asking price for this property is $4,395,999.
What are key features of this property?
This property features: Nine‑unit apartment building; Nine spacious two‑bedroom apartments; Upper‑floor units include a den for office or smaller third bedroom
