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;

304 Sandalwood Drive
Staten Island, NY 10308

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,050,000
Beds: 5
Baths: 4
Status: Active
SqFt: 2470
Agency: RE/MAX Real Estate Professiona

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1985
Notes: Welcome to this charming 2 Family High Ranch nestled in the heart of Great Kills, Staten Island. This meticulously modern home offers both comfort and convenience with its spacious layout and desirable location. As you step inside, you're greeted by an inviting foyer leading to the main living area upstairs. The UPPER LEVEL features an open concept layout with high ceilings. The living room boasts abundant natural light and adjacent is the well-appointed kitchen, complete with modern appliances, ample cabinet space, and a convenient breakfast bar. Down the hall you will find 3 Bedrooms 2 Bath completing the upper level. The LOWER LEVEL features the second apartment, great for an extra income source boasting 2 Bedroom 1 Bath, Kitchen and Living Room. The FINISHED BASEMENT features a versatile family room perfect for movie nights, Gym station, and Home office. The 4th bathroom and laundry room adds to the convenience of this basement level. Outside, this corner property boasts a beautifully landscaped yard, providing the perfect backdrop for outdoor entertaining with a built-in heated pool size 14x20FT and 8FT deep. A driveway and attached garage offer ample parking space for multiple vehicles. Well maintained and renovated throughout the years. New windows, and Flooring have been replaced with hardwood floors and scratch resistant Vinyl. Updated central air and water system within 1-3 years, Roof done 3 Years ago with solar panels installed for the upper level unit help saving the electricity bill. Built-in speakers throughout the house with a smart light switch setup.<br /> Located in the highly sought-after neighborhood of Great Kills, this home offers easy access to a variety of amenities, including shops, restaurants, parks, and top-rated schools. With its spacious layout, desirable features, and prime location, this high ranch house is ready to welcome you home.
MlsNumber: 481208


Listing Provided By: RE/MAX Real Estate Professiona, original listing
Name: RE/MAX Real Estate Professiona
Phone: (718) 532-2000
Office Name: Re/Max Real Estate Professiona
Office Phone: (718) 872-5522
Agent Name: Susana Chen Chong
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