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

1943 Melson Way
Hockessin, DE 19707
Michael E McKee with Greenville, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $900,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: --
Agency: Greenville
Agency Phone: (888) 536-0216

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Situated on a private lane in Hockessin, this elegant home spans over 4,200 square feet with elevated features and valuable upgrades throughout. Highlights include nine-foot ceilings, dual staircases, main floor office/den, designer interior & exterior lighting, upgraded wood trim, a full walk-out basement, 3-car garage, and a peaceful & private setting to enjoy for years to come! Step inside this home to the grand entryway with hardwood floors extending throughout the main level and a two-story turned staircase with custom solid oak handrails. Flow into the bright & open living room and dining room combination with elegant columns and wood detail and beautiful plantation shutters offering a welcoming space for holidays and gatherings. On the other side of the foyer, French doors lead into the spacious office/den with recessed lighting and plantation shutters. Flow into the gracious main living space joining the grand kitchen, breakfast room/dining area, and the great room with soaring ceiling, cozy gas fireplace, and a wall of windows with a lovely view outdoors. This kitchen offers 42-inch cabinetry, granite countertops, stone backsplash, and stainless steel appliances including Wolf oven and stovetop. From the main living space, step outside to the private patio & soothing outdoor space to grill, dine, relax, and entertain. Back inside and completing the main level is a powder room for guests and a well-equipped laundry/mudroom off the garage. Upstairs, you will find all 4 bedrooms, each with an en-suite bath including two bedrooms which share a Jack-and-Jill bathroom. The impressive primary quarters feature a tray ceiling, sitting room, and large primary bath with jetted tub, double vanity, and glass shower. The lower level of this home offers endless potential with an enormous walk-out full basement to finish as a huge entertaining space, additional family space, or whatever your needs require. Valuable upgrades & updates include (but are not limited to): dual zone HVAC (Zone 2 replaced in 2023), roof with original 30-year warranty, new gutters, gutter guards, and downspouts (2020), new water treatment system and sump pump (2021), new hot water heater (2021), new well tank (2021), security system, high efficiency direct vent gas furnace, water saver toilets and shower heads, an extensive air filtration package, weatherproofed exterior outlets, and more! Tucked in The Oaks at Hockessin, yet close to everything this area has to offer; the location is ideal. Be sure to view the Virtual Tour and Floorplans, and schedule a showing of this impressive home today!
MlsNumber: --
ListingId: DENC2070618


Listing Provided By: Greenville, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Michael E McKee
Disclaimer: Copyright © 2024 Long & Foster 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.


Local Real Estate Expert

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 = 318 AND i.igate IN ('usahud','dehud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'dehud', 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;
Real Estate Expert Photo for Sharon Stewart
Sharon Stewart
ASCIIeXp Realty
Call Today!: (302) 275-4291

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App