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-22T13:10:15.523-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/MjAvMTY5NjUvMTc5MDA4NTYxMQ/98DDVCW_qWoDIAUx0-qlf-hXnpQhjDoHtK6o9jS1IoE"
["_media_0_url"]=>
string(19) "field_665e0818bfa66"
["media_1_url"]=>
string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/6/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc5MDA4NTYxMQ/LAGJ6onqoUB9kwiGaovsArgpHvbNwj7WHGdWl6xBkwA"
["_media_1_url"]=>
string(19) "field_665e0818bfa66"
["media_2_url"]=>
string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/3/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc5MDA4NTYxMQ/9CIi___fv4bXV9-7hdMSMiYe7-ahdTuBQp4cozjR_u4"
["_media_2_url"]=>
string(19) "field_665e0818bfa66"
["media_3_url"]=>
string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/10/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc5MDA4NTYxMQ/ZL0z3m7w3A9GlcniS5OWGDnsMHTcKz8OSfgVhT7mL5M"
["_media_3_url"]=>
string(19) "field_665e0818bfa66"
["media_4_url"]=>
string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/5/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc5MDA4NTYxMQ/2Uedd7KicJRQOL4jAe_IOR56i6E0_gbKNzZQZOigLqA"
["_media_4_url"]=>
string(19) "field_665e0818bfa66"
["media_5_url"]=>
string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/4/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc5MDA4NTYxMQ/KkgfH0sj4P_fcgtnBJ1-8W3Zgau1Am19XAkAw-2RFjc"
["_media_5_url"]=>
string(19) "field_665e0818bfa66"
["media_6_url"]=>
string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/12/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc5MDA4NTYxMQ/j8SritmRqc98FhQTPLpj-6r3CT16D795ceZrU7v5Sjk"
["_media_6_url"]=>
string(19) "field_665e0818bfa66"
["media_7_url"]=>
string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/13/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc5MDA4NTYxMQ/nEEY31IUlqmGpsq5LnDjJ99t_Nrczz751ZMxBXvqw1w"
["_media_7_url"]=>
string(19) "field_665e0818bfa66"
["media_8_url"]=>
string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/7/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc5MDA4NTYxMQ/ioSD5U29JaOQRbN1Lwlyu9oee7gdftf2NXlvdNohigE"
["_media_8_url"]=>
string(19) "field_665e0818bfa66"
["media_9_url"]=>
string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/11/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc5MDA4NTYxMQ/v9sYZpRqrWhikvSUf4QzmDtLYItbwRfo-172kn-OYMo"
["_media_9_url"]=>
string(19) "field_665e0818bfa66"
["media_10_url"]=>
string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/9/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc5MDA4NTYxMQ/YQeOVYQZ-MFcLcyUe_y_0_Ap5FJ6YyKJ03NOm9zhJ8E"
["_media_10_url"]=>
string(19) "field_665e0818bfa66"
["media_11_url"]=>
string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/1/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc5MDA4NTYxMQ/736EphhtXbN6XWVdpJb2fck2BPo4SHHTlQblb2Vo3Yo"
["_media_11_url"]=>
string(19) "field_665e0818bfa66"
["media_12_url"]=>
string(162) "https://api.cotality.com/trestle/Media/Property/DOCUMENT-Jpeg/1178479445/1/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc5MDA4NTYxMQ/XXFCBW8c8sNJfmyJJJMtJh0cJiwp_txW8B1MhgCZ6g8"
["_media_12_url"]=>
string(19) "field_665e0818bfa66"
["media_13_url"]=>
string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1178479445/8/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc5MDA4NTYxMQ/TR81eg0twwzCgQKCmCRFsGRPuZfcDzA0QyKTiIlPkd4"
["_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"
}
$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
See your best matches daily!