Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3379 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3379 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3379 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

60 East 127th Street
New York, NY 10035

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $6,550,000
Beds: 10
Baths: 9
Status: Active
SqFt: --
Agency: Keller Williams NYC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: MultiFamily
Year Built: --
Notes: THE MERCER ? UNIQUE INVESTMENT OPPORTUNITY. An epitome of luxury modern NYC living, This newly constructed building, situated in the charming Central Harlem neighborhood, provides a range of amenities that will enhance your living experience. With the added convenience of a garage, parking in this bustling area has never been more stress-free.6 story building with an elevator with direct access to a common roof deck with expansive views to the north, as well as to the cellar, storage room, bicycle storage area, and garbage/recycling room. 1ST AND 2ND FLOOR: Duplex with single-car garage and two studio Apts. the duplex is a 1465 sqft 2 bedroom, 2 bath, with a windowed home office/den, private 560 sqft rear patio/garden, keyed second-floor elevator entry.THIRD FLOOR: Two studio apartments, open kitchen, with balconies. 4TH FLOOR: Two studio apartments, open kitchen with balconies.5TH FLOOR: Two studio apartments, open kitchen with balconies.6TH FLOOR: keyed entry elevator to the Penthouse, (1000 sqft) two bedrooms, living room, open kitchen, one bathroom, electrically operable skylights in the second bedroom, private roof deck, and huge rear balcony. BUILDING FEATURES? Washer and Dryer? Hardwood Floors? Heating Floors? Tankless Water ? Bicycle Storage? Cellar Storages? Recycling Room? Garagelivable building sqft 6,295livable building dimension 18.77x59 Lot dimensions 18.75x99.92lot sqft 1,873The entire building is offered at $6,550,00
MlsNumber: 11253223


Listing Provided By: Keller Williams NYC, original listing
Name: Keller Williams NYC
Phone: (212) 838-3700
Office Name: Keller Williams NYC
Office Phone: (212) 301-1140
Agent Name: Reginald Louissaint
Disclaimer: Copyright © 2024 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App