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;

210 Barbara Street
Staten Island, NY 10306

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $889,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2055
Agency: RE/MAX City Square

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1965
Notes: Welcome to this spacious Colonial-style home located on a large corner lot in the Richmondtown section. This property offers a perfect blend of generous space and classic charm. On the main floor, you are greeted by a foyer which leads to an enormous living space which includes: a living room, a large dining room, a family/sun lounge with sliding doors, an open kitchen layout with a second dining area. The custom kitchen boasts countertops, and an island for added workspace, stainless steel appliances, dishwasher and garbage disposal. The sliding doors lead to a beautiful sunny porch/barbecue area and a backyard which had a wrap around deck. Continuing on this main floor, you will notice a segregated bathroom and laundry area with a full size washer and dryer. Upstairs, you'll find what seems like 3 similar bedrooms, and a beautifully tiled full bathroom, a full double size hall closet plus a pull down stairway which leads to a full size attic for even more storage. As you enter the first bedroom, you will immediately notice the size is equal to the other two bedrooms combined as this is actually the master bedroom. This impression will be enhanced by the included en-suite full bath. While each bedroom has spacious closets for storage, the master bedroom boasts 2 double closets plus a massive walk-in/pass through changing/closet area. The other fully tiled bathroom includes a jacuzzi with a separate shower room adorned with windows and skylights that provides a year-round sun filled atmosphere. Access to the basement is on the main level, where there's also an additional outside side entrance. The huge basement, while unfinished, has multiple areas which includes: an exercise/pantry area, flows into a workshop which conveniently flows into the updated boiler and central air duct unit. There is extra storage space and a full size refrigerator, and direct access to a well lit double car garage with a wide driveway which leads out directly to the sidewalk. There is also a newly installed redundant drainage system along the inside edge of the garage to proactively manage any drainage needs. Fully fenced-in property, attached indoor access garage, patio, minutes to shopping, transportation and highway. Schedule a tour today and experience the perfect blend of comfort, functionality at this large property.
MlsNumber: 3530460


Listing Provided By: RE/MAX City Square, original listing
Name: RE/MAX City Square
Phone: (917) 578-9622
Office Name: RE/MAX City Square
Office Phone: (718) 570-7690
Agent Name: Samuel Wong
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