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

89 N Burgher Avenue
Staten Island, NY 10310

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $998,888
Beds: 11
Baths: 5
Status: Active
SqFt: 2709
Agency: Lucblue Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: --
Notes: Attention to all investors and first-time homebuyers looking to live and generate income! Don't miss out on this incredible opportunity in the excellent up-and-coming West Brighton location! Situated on a spacious 50 x 145 lot, this property is a rare find.<br /> This two family detached home boasts a spacious 7,250 sqft with hardwood and tile floors. The property is divided into two separate apartments, with a total of 18 rooms. The first level has been recently renovated, offering a 4-bedroom setup, 2 full bathrooms, a living room, and a kitchen with front and back entrances. Moving to the second level, you'll find a generous 5-bedroom configuration with 2 full bathrooms and a kitchen that requires updating. This apartment also features front and back entrances.<br /> The attic has 2 bedrooms, one bathroom, living room, and a small kitchenette, Each apartment gets lots of sunlight through its windows and has plenty of storage with many closets.The property includes a full unfinished basement, and outside, you'll appreciate the extra-large front, back, and side yards. Parking is convenient with three detached garages and a private driveway that can accommodate an impressive 20+ cars.<br /> Take advantage of the numerous amenities in the area, including quick access to establishments along Richmond Terrace and Castleton Ave. Nearby attractions include P.S. 018, Corporal Thompson Park, Heritage Park, Walker Park, Snug Harbor Cultural Center and Botanical Garden, and much more!<br /> Transportation options are abundant, with immediate access to the S40, S44, S46, S53, S54, S94, and S96 buses. Act now to secure this fantastic investment and living opportunity in a prime West Brighton location!
MlsNumber: 479610


Listing Provided By: Lucblue Realty LLC, original listing
Name: Lucblue Realty LLC
Phone: (718) 500-1919
Office Name: Lucblue Realty LLC
Office Phone: (718) 500-1919
Agent Name: Lucy Badwan
Disclaimer: Copyright © 2024 Brooklyn New York Multiple Listing Service. 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