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 = 3377 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 = 3377 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 = 3377 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;

149-37 9th Avenue
Whitestone, NY 11357

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,480,000
Beds: 4
Baths: 5
Status: Pending
SqFt: 5150
Agency: E REALTY INTERNATIONAL CORP.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2004
Notes: Welcome to 149-37 9th Ave, a luxurious and contemporary gem in the heart of Whitestone. This south-facing single-family home offers a sophisticated blend of style and modern convenience that's truly captivating. With 4 bedrooms and 4.5 bathrooms spread across a 50 x 111 lots size and generous 5,150 Sqft of living space, it's a residence that leaves a lasting impression. As you step inside, the spacious 1st floor feature with a spacious living room, a family room featuring a cozy gas fireplace, and a dining room complete with a convenient cooking top island, smart thermostat-controlled AC, and radiant heating powder bathroom and foyer. The custom spiral staircase leading to the 2nd floor impressive 20" high ceiling adorned with a graceful chandelier and two skylights, is a work of art in itself, . Here on the 2nd floor, you'll discover 4 bedrooms and 3 bathrooms including the master bedroom. This master suite boasts a spacious bathroom, a walk-in closet, a custom-built wall closet, a gas fireplace and private balcony. What's more, all three bathrooms on this floor feature the indulgent luxury of radiant heated floors. Descending to the basement with entertainment/gym room, a full bathroom with a hinged shower, and plenty of storage space. The radiant heating extends throughout the basement, With a separate walkout entrance, this space is perfect for various needs. The backyard offering a delightful swimming pool, with gas heater and saltwater system, pool lighting. The house also come with outdoor gas-powered generator providing electricity to the entire house, 3 separate central A/C units, 2 large storage room, and a garage with radiant heated floors. Additional highlights include a new roof, skylights, and a comprehensive camera system that enhances both security and peace of mind. This property redefines the concept of luxury living, blending style with modern amenities seamlessly. What's more, it offers a stunning and breathtaking view of the bridge. You won't find elsewhere. A must see!
MlsNumber: 3518829


Listing Provided By: E REALTY INTERNATIONAL CORP., original listing
Name: E REALTY INTERNATIONAL CORP.
Phone: (718) 886-8110
Office Name: E Realty International Corp
Office Phone: (718) 886-8110
Agent Name: June Chang
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