array(90) { ["streetname"]=> string(8) "Columbus" ["_streetname"]=> string(19) "field_6675aa8b47c8f" ["neighborhood"]=> string(4) "4315" ["_neighborhood"]=> string(19) "field_665dee7122fa3" ["bedrooms"]=> string(2) "20" ["_bedrooms"]=> string(19) "field_665deeaa47d7d" ["listprice"]=> string(7) "5500000" ["_listprice"]=> string(19) "field_665dee2822fa2" ["streetsuffix"]=> string(6) "Avenue" ["_streetsuffix"]=> string(19) "field_6675aabf47c93" ["listagentmlsid"]=> string(6) "128330" ["_listagentmlsid"]=> string(20) "field_665e09aksdf789" ["laundryfeatures"]=> string(10) "SeeRemarks" ["_laundryfeatures"]=> string(19) "field_665e095bbfa67" ["streetnumber"]=> string(3) "949" ["_streetnumber"]=> string(19) "field_6675aa9b47c90" ["mlsid"]=> string(11) "RLS20106083" ["_mlsid"]=> string(19) "field_666771355b150" ["storiestotal"]=> string(1) "5" ["_storiestotal"]=> string(19) "field_665e0b339000e" ["modified"]=> string(29) "2026-09-03T15:42:05.820-00:00" ["_modified"]=> string(19) "field_667359b200d6b" ["bathrooms"]=> string(2) "11" ["_bathrooms"]=> string(19) "field_665deeb447d7e" ["yearbuilt"]=> string(4) "1900" ["_yearbuilt"]=> string(19) "field_665e0b3b9000f" ["listing_key"]=> string(10) "1178479445" ["_listing_key"]=> string(19) "field_65d642d31b95f" ["exteriorfeatures"]=> string(29) "PrivateOutdoorSpaceOver60Sqft" ["_exteriorfeatures"]=> string(19) "field_665e099ebfa6c" ["state"]=> string(2) "NY" ["_state"]=> string(19) "field_6656331ef053c" ["petsallowed"]=> string(0) "" ["_petsallowed"]=> string(19) "field_665e0b4390010" ["publicremarks"]=> string(1104) "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." ["_publicremarks"]=> string(19) "field_665dee9522fa4" ["city"]=> string(8) "New York" ["_city"]=> string(19) "field_66563315f053b" ["floor"]=> string(1) "1" ["_floor"]=> string(19) "field_665def17897b5" ["listagentfullname"]=> string(14) "Tashi Dhargyal" ["_listagentfullname"]=> string(19) "field_665e09a4bask3" ["zipcode"]=> string(5) "10025" ["_zipcode"]=> string(19) "field_66563322f053d" ["livingarea"]=> string(4) "7750" ["_livingarea"]=> string(19) "field_665deec247d7f" ["address"]=> string(19) "949 Columbus Avenue" ["_address"]=> string(19) "field_6656330af053a" ["propertysubtype"]=> string(11) "MultiFamily" ["_propertysubtype"]=> string(19) "field_665e168921ace" ["structuretype"]=> string(8) "MixedUse" ["_structuretype"]=> string(19) "field_665e0ce590014" ["taxannualamount"]=> string(9) "117794.04" ["_taxannualamount"]=> string(19) "field_665e164421acc" ["listofficename"]=> string(7) "Compass" ["_listofficename"]=> string(18) "field_665e2334f789" ["media_0_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/2/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc4ODQ1MTIxOA/mk-XDXrctrwWhB2EMk9d97-T3Sp9_R_1Krs_EM_kO5g" ["_media_0_url"]=> string(19) "field_665e0818bfa66" ["media_1_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/6/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc4ODQ1MTIxOA/hiIkv3tvs_sAqh6AMLkeRYUTDcjVmE1dX5xyHr1nNno" ["_media_1_url"]=> string(19) "field_665e0818bfa66" ["media_2_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/3/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc4ODQ1MTIxOA/TT1UzYYOZB_Ou8aVDN8CKPUhtLoPwFkq8cQsZGjtWoQ" ["_media_2_url"]=> string(19) "field_665e0818bfa66" ["media_3_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/10/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc4ODQ1MTIxOA/xHceKXpxZal6ULhUC-uAnlTGCpNcYLLHPCRlE8ZQVLo" ["_media_3_url"]=> string(19) "field_665e0818bfa66" ["media_4_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/5/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc4ODQ1MTIxOA/6uIagUH3ybw_ANLERIUWzjiCNDZdN9komNmfNd1hz_4" ["_media_4_url"]=> string(19) "field_665e0818bfa66" ["media_5_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/4/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc4ODQ1MTIxOA/eqQYNxjXK53i8GHjzMURQ0E0XDMm5We149ToyT2mVns" ["_media_5_url"]=> string(19) "field_665e0818bfa66" ["media_6_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/12/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc4ODQ1MTIxOA/GWxmV53D3U75SU0HsqOXqJonu0WsVefoWNj6UawOg84" ["_media_6_url"]=> string(19) "field_665e0818bfa66" ["media_7_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/13/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc4ODQ1MTIxOA/v8Fz5C7RQZfUJLxioPAKUBLQJ0xEcPF0TFDsl4i8MBw" ["_media_7_url"]=> string(19) "field_665e0818bfa66" ["media_8_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/7/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc4ODQ1MTIxOA/fC0ZxzXHm7_cHlkloPgFSOcNNdTMkEFZPO9qo_R0KIw" ["_media_8_url"]=> string(19) "field_665e0818bfa66" ["media_9_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/11/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc4ODQ1MTIxOA/dEjnLwSXJJ91egriE-TvH47SKa3NOzhiPohqJSInYW0" ["_media_9_url"]=> string(19) "field_665e0818bfa66" ["media_10_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/9/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc4ODQ1MTIxOA/zOTWUp3yBx9-HTkxW9u4eDCVo-QDgpcE8JoX8NpYG8M" ["_media_10_url"]=> string(19) "field_665e0818bfa66" ["media_11_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/1/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc4ODQ1MTIxOA/R0hiY7CEBGyYv10oQDHisvOSzZlmMdKjT-dMqRKGvAA" ["_media_11_url"]=> string(19) "field_665e0818bfa66" ["media_12_url"]=> string(162) "https://api.cotality.com/trestle/Media/Property/DOCUMENT-Jpeg/1178479445/1/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc4ODQ1MTIxOA/rYwzd7TXA6-rYeGLID0ivoclR5VksrZ2WMWDacT_WBY" ["_media_12_url"]=> string(19) "field_665e0818bfa66" ["media_13_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/8/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc4ODQ1MTIxOA/2IBKcUJMBC5pl_zpcXXtzXSQFPB_LFe9mGWXTX1wUKM" ["_media_13_url"]=> string(19) "field_665e0818bfa66" ["media"]=> string(2) "14" ["_media"]=> string(19) "field_665dfc55bfa65" ["latitude"]=> string(10) "40.7995647" ["_latitude"]=> string(19) "field_65cfb7b05bfc2" ["longitude"]=> string(11) "-73.9623811" ["_longitude"]=> string(19) "field_65d3a87704862" }
14 Photos
Save

949 Columbus Avenue

$5,500,000/mo Upper West Side | 20 beds | 11 baths | 7750 sqft | Floor 1

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. 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.

Read More

Apartment Features

  • Laundry - See Remarks
  • Private Outdoor Space Over60 Sqft

Building Features

  • 5 stories

See your best matches daily!

By submitting contact information on this website, you are consenting to receive calls, SMS, and emails from Loftey and its affiliates. You certify that you are the owner of the contact information provided.

Related listings