20 beds7,750 sqft$710/sqft
949 Columbus Avenue, Upper West Side
Building Info: 949 Columbus Ave, 5 stories, Built 1900
Est: $41,266/moGet pre-approved

Description

A 7,750 SF mixed-use walk-up with nine free-market three-bedroom apartments over two commercial spaces: an operating restaurant with basement dining and a retail storefront leased to a shoe store.
The headline: six of the nine apartments will be delivered vacant on September 1, and every unit in the building is free-market. An investor can start renovating the majority of the residential portion on day one, with no buyouts to negotiate and no regulated leases to work around.
The value-add math is straightforward.
...A 7,750 SF mixed-use walk-up with nine free-market three-bedroom apartments over two commercial spaces: an operating restaurant with basement dining and a retail storefront leased to a shoe store.

The headline: six of the nine apartments will be delivered vacant on September 1, and every unit in the building is free-market. An investor can start renovating the majority of the residential portion on day one, with no buyouts to negotiate and no regulated leases to work around.

The value-add math is straightforward. Each apartment is a three-bedroom, one-bath layout. Add a second bathroom, in-unit laundry, and updated finishes, and these units rent at a different number. The two commercial tenants keep paying while the work happens, so the building produces income through the entire reposition.

The location does the rest: two short blocks to Central Park, roughly ten blocks to Columbia University, with the 1, B, and C trains nearby and the restaurants of Columbus and Amsterdam at the doorstep.

Most value-add deals make you wait years for the vacancy. This one hands it to you at closing.
LISTING UPDATED: 07/29/2026 07:23 PM

Property Details for 949 Columbus Avenue

Status
Days on Market
7
Taxes
$9,816 / month
Maintenance
-
Min. Down Pymt
10%
Total Rooms
40.0
Property Type
MLS Type
House/Building
Year Built
1900
Lot Size
1,875 SF / 25' x 75'
Buyer's Agent Compensation
2%

Amenities

  • Walk Up
  • Voice Intercom
  • Midrise
  • Lowrise

Location

Listing Courtesy of: .

Add your commute

Virtual Tour

Building Information for 949 Columbus Avenue

Stories5Residences9Year Built1900Building Size25' x 64'Building Sq. Ft8,000 SFLot Size1,875 SF / 25' x 75'Building AgePre-warBuilding TypeLowrise

Payment Calculator

$41,266 per month

30 year fixed, 6.55% Interest

Principal and Interest

$31,450

Property Taxes

$9,816

Maintenance/Common Charges

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property History for 949 Columbus Avenue

DateEvent & SourcePriceAppreciationLink
Jul 28, 2026

Listed (Active)

Manual

$5,500,000
Aug 18, 2004

Sold (Public Record)

ACRIS #2004082402694001

$2,800,000
DateEvent & SourcePrice
07/28/2026

Listed (Active)

Manual

$5,500,000
08/18/2004

Sold (Public Record)

ACRIS #2004082402694001

$2,800,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 949 Columbus Avenue

Taxable ValueLand$270,000Additions$882,450Total$1,152,450
Home Facts
Total Finished SqFt7,750 SqFtLot Size1,875 SqFtYear Built1900ZoningR8BAPN1018420064

Schools near 949 Columbus Avenue

This home is within New York City Geographic District # 3.
Rating
School
Type
Grades
Distance
Public - PK to 5
Public - 6 to 8
Public - 6 to 12
Public - 6 to 8
Rating
School
Distance
P.S. 165 Robert E Simon
PublicPK to 5

Jhs 54 Booker T Washington
Public6 to 8

Young Women's Leadership School
Public6 to 12

West Prep Academy
Public6 to 8

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Upper West Side
Upper West Side
A cultural enclave with edge. Nestled between Riverside and Central Park, the Upper West Side is one of the greenest parts of Manhattan. The Upper West Side is known for popular attractions like the Natural History Museum and Lincoln Center, but relaxed bistros and a lively bar scene defy...

Neighborhood Map and Transit

Similar Homes

949 Columbus Avenue is a multi-family home for sale in Upper West Side. This property was listed for sale on July 28, 2026 by Compass, it's currently listed at $5,500,000. It has been on the market for a total of 7 days and was last sold on August 18, 2004. This listing's school district is New York City Geographic District # 3. Nearby schools include P.S. 165 Robert E Simon, Jhs 54 Booker T Washington and Young Women's Leadership School. 949 Columbus Avenue is a 20-bed, 11-bath, 7,750 sqft multi-family home built in 1900.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

This information is not verified for authenticity or accuracy and is not guaranteed and may not reflect all real estate activity in the market. ©2026 The Real Estate Board of New York, Inc., All rights reserved. The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. This information is provided exclusively for consumers’ personal, non-commercial use. The data relating to real estate for sale on this website comes in part from the IDX Program of OneKey® MLS. Information Copyright 2026, OneKey® MLS. All data is deemed reliable but is not guaranteed accurate by Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties. See Terms of Service for additional restrictions. Compass · Tel: 212-913-9058 · New York, NY Listing information for certain New York City properties provided courtesy of the Real Estate Board of New York’s Residential Listing Service (the "RLS"). The information contained in this listing has not been verified by the RLS and should be verified by the consumer. The listing information provided here is for the consumer’s personal, non-commercial use. Retransmission, redistribution or copying of this listing information is strictly prohibited except in connection with a consumer's consideration of the purchase and/or sale of an individual property. This listing information is not verified for authenticity or accuracy and is not guaranteed and may not reflect all real estate activity in the market. ©2026 The Real Estate Board of New York, Inc., all rights reserved. This information is not guaranteed, should be independently verified and may not reflect all real estate activity in the market. Offers of compensation set forth here are for other RLSParticipants only and may not reflect other agreements between a consumer and their broker.©2026 The Real Estate Board of New York, Inc., All rights reserved.