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;

7 Furman Street
Staten Island, NY 10312

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $905,000
Beds: 4
Baths: 2
Status: Active
SqFt: 2392
Agency: DiTommaso Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1970
Notes: LOCATION! ANNADALE! Picturesque High Ranch. Corner property on a quiet, tree lined, cul de sac. The front of the house will greet you with a combination brick and iron fence. Welcome to a beautiful paved front entrance space and an oak door with a beveled glass. Upon entering the first floor, you will be greeted by a large foyer that leads to a den, an extra bedroom, 3/4-bathroom, laundry room, and glasses sliders that lead to a patio with a grassed backyard, waiting for your personal touch. Included, an attached 1 car garage with an entrance to the den. Come to the second floor, there is the prettiest tall, narrow, corner window allowing sunlight into the stair landing. Continuing on the second floor is a large eat in kitchen with oak cabinets. There is a formal living and dining room with a big bay window peering in the background. There are 3 bedrooms on the 2nd floor. The master bedroom has a full primary bath and a large pull-down attic with very generous storage and a roof fan. <br /> <br /> Parkay flooring throughout, many walk-in closets. Outside has a front garden, a well-kept lawn, some hedging and a side gate. Backyard is completely fenced in. There is an alarm system, plus a chair lift attached to the staircase. There is a carport on Annadale Road with a double gated entrance. <br /> <br /> Access to all major highways, express buses and public transportation. Close to all houses of worship, schools, both public and private, and very close to many shopping areas and restaurants.<br /> <br /> To be sold in AS IS condition.
MlsNumber: 482344


Listing Provided By: DiTommaso Real Estate, original listing
Name: DiTommaso Real Estate
Phone: (718) 667-8000
Office Name: DiTommaso Real Estate
Office Phone: (718) 667-8000
Agent Name: Prudence Goffredo
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