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;

56 Crown Ave.
Staten Island, NY 10312

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,199,999
Beds: 4
Baths: 5
Status: Active
SqFt: 2376
Agency: NEUHAUS REALTY INC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: MultiFamily
Year Built: 1981
Notes: SPECTACULAR ANNADALE LOCATION! GORGEOUS, WELL-KEPT TWO-FAMILY, 4 BEDROOMS, 3 BATH HIGH RANCH HOME. THE MAIN HOME OFFERS VAULTED HIGH CEILINGS, NEWER FLOORING, NEWER WINDOWS. THE UPDATED EAT IN KITCHEN IS WELL-APPOINTED WITH NEWER STAINLESS STEEL APPLIANCES AND GRANITE COUNTERS. THE SUN-DRENCHED L-SHAPED LIVING ROOM DINING AREA WITH FRONT BAY WINDOW IS BRIGHT AND SPACIOUS. THE MAIN BEDROOM IS LARGE WITH PRIVATE HALF BATH. PLUS ADDITIONAL 2 BEDROOMS ON THE SAME FLOOR. THE MAIN 4 PIECE BATHROOM HAS BEEN UPDATED WITH VAULTED CEILING AND SKYLIGHT. THE GROUND LEVEL FAMILY ROOM HAS GAS FIREPLACE, ACCESS TO GARAGE, SEPERATE LAUNDRY ROOM & PELLA SLIDERS TO SIDE YARD. ENJOY YOUR MAINTENANCE FREE TREX BACKYARD COMPLETE WITH BEAUTIFUL IN-GROUND POOL! THE GROUND LEVEL UPDATED APARTMENT HAS SEPERATE PRIVATE SIDE ENTRANCE , EAT IN KITCHEN, 1 LARGE BEDROOM, AND VERY LARGE LIVING ROOM. THE HOME EXTERIOR HAS BEAUTIFUL CURB APPEAL WITH FRONT PAVERS AND PLENTY OF PARKING ON PROPERTY. TAKE HOME THE CROWN! MAKE 56 CROWN AVE YOUR HOME TO ENJOY AND ENTERTAIN. SHORT DISTANCE TO EXPRESSWAY, XPRESS BUS AND SHOPPING. MAKE YOUR APPOINTMENT TODAY!
MlsNumber: 11287310


Listing Provided By: NEUHAUS REALTY INC, original listing
Name: NEUHAUS REALTY INC
Phone: (718) 979-3400
Office Name: NEUHAUS REALTY INC
Office Phone: (718) 979-3400
Agent Name: Giovanna Cardinale
Disclaimer: Copyright © 2024 My State 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