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

78-13 79th Street
Glendale, NY 11385

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $929,000
Beds: 3
Baths: 3
Status: Active
SqFt: --
Agency: Keystone Realty USA

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1910
Notes: 78-13 79th Street, the rare gem you have been searching for! Newly renovated single family townhouse offers high end finishes, classic details as well as modern technology. Sitting on a 20' ? 95' lot on a picturesque block of burgeoning Glendale, featuring a wide driveway, garage, outdoor space. This meticulously renovated townhouse will captivate you from the moment you arrive with its warm & welcoming energy. Looking for space, your search ends here! Come explore all the possibilities of 78-13 79th Street. As you open the door you are greeted by an expansive sun drenched open concept living/dining area which provides great space for entertaining. The stunning chefs inspired granite kitchen features floor to ceiling custom cabinetry, boast a full fleet of state of the art stainless steel appliances, equipped with island for bar stool seating and leads out into lush rear yard. 1/2 bath on first floor for your guest. Upstairs onto the second floor you find three spacious bedrooms, each equipped with ample closet space. Down the hall a fully tiled bathroom awaits you that is adorned with state of the art wall & floor tiles. The high ceiling full finished basement has both interior and exterior access and can easily be used as additional recreational space or storage space. 78-13 79th Street has been fully gutted & remodeled by an expert team of contractors and designers featuring select wide oak wood flooring, Central HVAC, recessed lighting, brand new electrical, heating and plumbing systems throughout. This masterfully re-imagined townhouse is located in the heart of Glendale. Just moments away from major transportation which makes commuting a breeze. Myrtle Avenue, Cooper Avenue, Central Avenue, Jackie Robinson Parkway, Forest Park, schools, shopping centers, restaurants, cafes, parks and many other vibrant neighborhood amenities. Come explore all the possibilities of this turn key move in ready property and grab your opportunity to become apart of the Glendale Vibe.
MlsNumber: 3523408


Listing Provided By: Keystone Realty USA, original listing
Name: Keystone Realty USA
Phone: (631) 486-1126
Office Name: Keystone Realty USA Corp
Office Phone: (631) 261-2800
Agent Name: Gabriel Kashi
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