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

119-43 189th Street
Saint Albans, NY 11412

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1930
Notes: Space, style & modern luxury come together at 119-43 189 Street. A Turn key, move in ready newly renovated fully detached single family sitting on a 40?100 lot on a beautiful tree lined street of Saint Albans. Featuring a wide private driveway, and tons of yard space to enjoy outdoor gatherings. Large family looking for space? Look no further, your search ends here. Open the door and enter an expansive sun drenched modern open concept living/dining area which provides great space for entertaining. Towards the rear of the property the stunning chefs granite kitchen awaits you. Kitchen features floor to ceiling custom cabinetry, adorned with a full fleet of stainless steel appliances, and leads out into lush rear yard. 1/2 bath on the first floor for your guest. Up a flight of stairs onto the second floor 3 spacious bedrooms awaits you, each equipped with ample closet space. Down the hall a fully tiled bathroom awaits you, that boast sate of the art wall & floor tiles. Up an additional flight of stairs the high ceiling full finished attic can be used as an additional bedroom or the perfect home office. The high ceiling full finished basement is equipped with interior and exterior access and can be used as the perfect in-law suite, media den, storage space or additional recreational space. This turn key move in ready single family has been fully gutted and remodeled by an expert team of contractors and designers featuring select wide oak wood flooring, recessed lighting, brand new electrical, heating, and plumbing systems throughout. 119-43-189 Street is conveniently located with close proximity to major transportation which makes commuting a breeze. Just off Farmers Blvd, 120 Avenue, Linden Blvd, Springfield Blvd. Stones throw to schools, shopping centers, restaurants, cafes, parks and many other vibrant neighborhood amenities.
MlsNumber: 3542441


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