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','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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','gahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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;

170 East End Avenue
New York, NY 10028
Wendy Greenbaum with Coldwell Banker Warburg, original listing - (212) 439-4500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $14,200,000
Beds: 6
Baths: Full: 6, ½: 1
Status: Active
SqFt: 5000 Square Feet
Agency: Coldwell Banker Warburg
Agency Phone: (212) 439-4500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Apartment
Year Built: 2008
Notes: This splendid 5000 square foot duplex exudes style and sophistication in a home offering extraordinary views and light. Enjoy the outdoors on the 2000+ square feet of superbly landscaped terraces. Move right into this perfectly renovated home designed with meticulous attention to detail in East End Avenue's most distinguished condominium. The gracious foyer opens into a grandly proportioned living room with 20' ceilings and floor-to-ceiling windows providing panoramic views of Carl Schurz Park, the East River and more. The vast expanse of sun filled entertaining space overlooking the river, is comprised of the living room with wood burning fireplace, paneled corner library, study and the formal dining room. Adjacent to the library is the home office with a wet bar. There is a powder room off the foyer and a sauna off the study. The massive corner eat in kitchen has windows facing east and north providing river and park views. The windowed breakfast area comfortably accommodates eight. The chef's kitchen with custom lacquer cabinets is outfitted with a vented Wolf stove, SubZero refrigerator, Corian counters, two sinks, garbage disposal and two dishwashers. There is temperature-controlled wine storage for 150 bottles. A large anteroom perfect for homework or as a playroom leads to the private quarters on this level. This bedroom wing has four bedrooms, three bathrooms and a large laundry room. These bedrooms have access to the enormous, landscaped terrace. This spectacular outdoor space, perfect for large scale entertaining or quiet relaxation, has multiple seating areas, a gazebo, custom lighting and irrigation. The sculptured wood staircase leads to the upper level of the residence, with a large landing overlooking the living room below. The large primary suite has floor to ceiling windows facing south and east. The luxurious primary bathroom has a double sink, deep soaking tub and steam shower. The custom dressing area is
MlsNumber: --
ListingId: 23384358


Listing Provided By: Coldwell Banker Warburg, original listing
Phone: (646) 431-3090
Office Phone: (212) 439-4500
Agent Name: Wendy Greenbaum
Disclaimer: Copyright © 2025 RealPlus LLC. 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