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

24-18 36 Street
Long Island City, NY 11103

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,999,999
Beds: 6
Baths: 6
Status: Active
SqFt: --
Agency: WINZONE REALTY INC.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: MultiFamily
Year Built: 1930
Notes: A newly constructed two-dwelling townhouse that marries urban luxury with breathtaking Manhattan skyline views. Situated on the desirable Ditmars side of Astoria, this property is a testament to sophistication and convenience, appealing to those in pursuit of a premier living experience in one of New York's most dynamic neighborhoods. This townhouse spans nearly 4,000 gross square feet across three meticulously designed floors, blending modern aesthetics with functional living spaces. Every detail has been considered with precision, aimed at the most discerning homeowner. The residence boasts a thoughtful layout to maximize space, functionality, and natural light. It features an open floor plan with high ceilings, smart lighting, heated smart bathroom floors, a smart toilet, a heated towel rack, smart shades, a built-in multi-zone speaker system, wide-plank oak hardwood floors, and floor-to-ceiling windows. The closets, electric gate, and in-unit washer-dryer add layers of comfort and convenience. The kitchen is a chef's delight, equipped with custom European cabinetry, quartz waterfall countertops, under-counter smart lighting, and premium stainless steel Bertazzoni appliances, ensuring both functionality and style. Elevate your lifestyle with the stunning Manhattan skyline views from the roof deck and the master bedroom on the second floor. These panoramic vistas provide a daily backdrop of serenity or sparkling nightlife, depending on the moment. Designed as a two-dwelling townhouse, this property offers flexibility and potential. The fully finished basement introduces an additional layer of luxury, providing ample space for a home office, gym, entertainment area, or a 2-bedroom unit. The craftsmanship and high-quality finishes are consistent and evident throughout every corner of the home.
MlsNumber: 3540870


Listing Provided By: WINZONE REALTY INC., original listing
Name: WINZONE REALTY INC.
Phone: (HOM) ES3-68GM xAILCOM
Office Name: Winzone Realty Inc
Office Phone: (HOM) ES3-68GM xAILCOM
Agent Name: Eyal Robichek
Disclaimer: Copyright © 2024 OneKey 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