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;

163-15 86 Street
Howard Beach, NY 11414
Gabriel Lian with GAMA GROUP LLC, original listing - (718) 717-7727

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,675,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4000 Square Feet
Agency: GAMA GROUP LLC
Agency Phone: (718) 717-7727

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1950
Notes: VIRTUAL TOUR AVAILABLE UPON REQUEST! Proudly presenting this custom-built property, unlike any you've ever seen before. One of Howard Beach's finest properties- All brick, redeveloped in 2006. Boasting 4 large bedrooms and 4 bathrooms across 4,000 sqft of living space on a massive 61.5x100 lot. This property is an entertainer's dream! The dramatic entrance welcomes you with imported Mexican steel double doors into an exposed brick atrium, highlighting the grand staircase, all wrapped in matching Mexican steel. The ground level is dedicated exclusively as an entertaining and living space. The entire floor is stamped with unique stained concrete radiant floors. The full custom bar with Uba Tuba granite can easily be adapted to a second kitchen. The ground level is equipped with a gas fireplace, coffee station, access to the finished garage with split unit. The resort-style bathroom includes a TV, large jetted jacuzzi tub, and a massive steam shower. The double sliding doors give way to the large backyard with a 6' deep heated pool with spa jets and a dedicated poolside bathroom for your guests. When climbing the grand staircase, you are surrounded by the formal dining room and the chef's kitchen. Equipped with top-of-the-line Sub-Zero fridge, Viking gas range, warming tray, and microwave, Kitchen-Aid dishwasher- all in immaculate condition and wrapped in Labradorite granite. The first level also includes the Master Suite with a massive walk-in closet and the newly updated dream-like Master Bathroom featuring double sinks and a double shower. The 2 large bedrooms with custom closets share a newly updated bathroom. The level includes a fabulous dedicated laundry room, with radiant and baseboard heat throughout the entire floor, surrounded by Marvin windows, each room has a thermostat. The top level overlooks the entire home. It is currently used as the home office but can easily be used as a bedroom. This level also includes clever storage in all 4 corners for your seasonal needs with attic space above. This property is a must-see! The round-about front provides ample parking with easy entrance and exit, and the opportunity to add many more spaces. Don't miss your chance to experience incredible features and charm in person. Please contact us directly for additional specifics or to schedule a flexible private tour!
MlsNumber: --
ListingId: 11483930


Listing Provided By: GAMA GROUP LLC, original listing
Phone: (718) 717-7727
Office Phone: (718) 717-7727
Agent Name: Gabriel Lian
Disclaimer: Copyright © 2025 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