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

160-16 92nd Street
Howard Beach, NY 11414

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,499,999
Beds: 4
Baths: 4
Status: Pending
SqFt: 2949
Agency: Keller Williams Realty of Greater Nassau

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1960
Notes: Welcome to the very best that Howard Beach has to offer! This stunning masterpiece located in the exclusive Rockwood Park enclave of New Howard Beach has been meticulously curated, landscaped and built out to perfection. As you approach this home you will immediately notice the beautiful stone facade and paving stones that adorn the driveway and walkways. As you pass through the landscaping and make your way up the entry way take notice of the ornate railings and grand crushed glass, custom front door. To the right of the stairs is a side entrance that leads to a convenient side entrance with a covered breezeway that leads to the back yard oasis. As you enter the home, the pride of ownership and quality of construction comes alive. As you head to the lower level you will enter the outstanding custom kitchen. In the front of the home is the family room/den. Towards the rear of the house and off the custom kitchen you will find a perfect open space concept that offers a dining area and living room as well as a powder room. This property enjoys a perfect blend of convenience and functionality throughout. Off the dining area, are sliding doors that open into the breathtaking outdoor back yard oasis. This resort style back yard is the perfect place to entertain and unwind. As you enter the upper level of the home, you will notice the beautiful hard wood flooring. As you go down the hall to the master suite, the luxury and beauty completely immerses you. The walk in closet and master bathroom are stunning. The upstairs has a total of 3 full bathrooms and 4 bedrooms, making the home a sight to behold with plenty of great space. This property is truly a magnificent space loaded with amenities, beautiful design elements coupled with an extremely well thought out floor plan that accentuates the best of style and functionality.
MlsNumber: 3534877


Listing Provided By: Keller Williams Realty of Greater Nassau, original listing
Name: Keller Williams Realty of Greater Nassau
Phone: (516) 865-1800
Office Name: Keller Williams Points North
Office Phone: (516) 865-1800
Agent Name: John Ricco
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