Skip main navigation
Active
  • $5,500,000

    949 Columbus Ave, New York, NY 10025

    20beds
    7,750sqft
    Loading
    Rental Unit
    Built in 1900
    -- sqft lot
    $-- Zestimate®
    $710/sqft
    $-- HOA

    What's special

    Nine free-market three-bedroom apartments
    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.
    1 day
    |
    107
    |
    7
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Compass 347-603-2205,

    Tashi Dhargyal,

    Martin Eiden

    Source: StreetEasy,MLS#: S1840079

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 20
      • Bathrooms: 11
      • Full bathrooms: 11
      Features
      • Has fireplace: No
      Interior area
      • Total structure area: 7,750
      • Total interior livable area: 7,750 sqft
      Video & virtual tour

      Property

      Details
      • Special conditions: Resale

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Rental Unit
      Condition
      • Year built: 1900

      Community & HOA

      Community
      • Subdivision: Manhattan Valley
      Location
      • Region: New York

      Financial & listing details

      • Price per square foot: $710/sqft
      • Date on market: 7/28/2026

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        7/28/2026Listed for sale$5,500,000$710/sqft
        Source: StreetEasy #S1840079 Report a problem

        Public tax history

        Tax history is unavailable.

        Monthly payment

        Estimated monthly payment$1,822
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: Upper West Side

        Getting around

        94 / 100
        Walker's Paradise
        100 / 100
        Rider's Paradise
        76 / 100
        Very Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes