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

380 Poillon Avenue
Staten Island, NY 10312

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,288,000
Beds: 4
Baths: 4
Status: Active
SqFt: 2880
Agency: Better Homes and Gardens Real Estate Safari Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: MultiFamily
Year Built: 1987
Notes: Welcome to this wonderful 4 total bedroom home featuring a range of desirable amenities. The property includes a basement with a four-piece bathroom including an air jetted tub, making for a relaxing and spa-like experience. The basement also houses a summer kitchen with a sink, microwave, providing a convenient space for preparing meals or entertaining guests. Sliding doors from family room provide easy access to the outdoors and an enhanced $ 250,000 customized oasis for your pleasure and delight. A 14x28 salt water pool generous lounge area for sun bathing plus hot tub to wash away the tension of the day. Additionally there is a full outdoor kitchen, breakfast bar and entertainment center along with private lounge area featuring a gas fueled firepit. But wait there is more..... The home is sitting Approximately 50 feet above sea level, with a short walk to the ocean. In the evening you can sit in your hot tub and hear the ocean waves lapping at the shoreline. The windows at the back of the house have been replaced approximately five years ago, offering improved energy efficiency and aesthetics. The kitchen boasts granite countertops, large windows overlooking your rear yard oasis which enhances your kitchen experience and adds elegance and durability to the space. A pantry closet and kitchen island provide ample storage and workspace, making cooking and organizing a breeze. Hardwood floors throughout the house create a warm and inviting atmosphere, while crown molding and two-panel doors add a touch of sophistication. The family room features a gas insert fireplace, perfect for cozy gatherings. Additionally, a half bath on this level adds convenience for guests. This home also includes a kitchen, dining room, and living room with wood floors. The stove and fridge are included. An apartment on the second floor, located over the garage, offers versatility and potential as additional living space / income producer. This home checks all the boxes.
MlsNumber: 1162898


Listing Provided By: Better Homes and Gardens Real Estate Safari Realty, original listing
Name: Better Homes and Gardens Real Estate Safari Realty
Phone: (718) 442-5200
Office Name: Better Homes and Gardens Real Estate Safari R
Office Phone: (718) 442-5200
Agent Name: Francine Reali
Disclaimer: Copyright © 2024 Better Homes and Gardens Real Estate. 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