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;

6 Blueberry Ct
Hockessin, DE 19707
Kyle M McKean with Greenville, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1987
Notes: THIS is the house you have been waiting for in Ramsey Ridge! Meticulously maintained with updates to the interior, exterior, mechanicals and major systems, this large, light-filled home sits on 1 acre with beautiful mature trees. It offers 4-6 bedrooms, 3.5 baths, over 3,200+ square feet, a finished basement with 1,000+ square feet and endless storage! The floor plan allows for multiple configurations to suit a variety of needs. When you approach the home, you'll notice the impressive covered entry which is craftsman in style but is a perfect compliment to the contemporary low-maintenance exterior. A grand two-story foyer with oversized slate tiles welcomes you and sets the scale for the high ceilings and spacious rooms which continue throughout. A dining room to the right is perfect for holiday gatherings or family meals. The living room to the left is cozy and serene. Continue into the kitchen where an open layout includes an eat-in area, granite countertops, custom cabinets, a walk-in pantry, a built-in bar, a built-in desk, and a large center island. If you love to cook, this kitchen has copious storage for all of your small appliances, gadgets, and prep tools. Just off the kitchen is the family room which has a stone fireplace with a gas-insert for chilly nights or ambiance and new skylights (2022) with remote controlled shades. Through the kitchen, the three-season room, which was added in 2012, has big windows that allow lots of natural light to shine in. From here, you can step outside to the deck or enjoy the expansive backyard! Also on the first floor is a large room which is currently used as a home office, but could easily serve as a convenient main-floor bedroom. In the hallway leading up to this is the laundry room and a half bath. As you head upstairs, you'll notice the custom metalwork spindles of the railing, and a custom slate-topped built-in cabinet that offers even more storage. The primary bedroom has a walk-in closet and an en-suite bathroom with two sinks, a soaking tub, a walk-in tiled shower, and custom built- in shelves and storage. There are three additional bedrooms each with generous closets, and a full bathroom with two sinks and additional built-in storage. In the finished basement, there is a large open space that would be ideal for hanging out, a playroom or a dedicated work-at-home space. In addition, there is a room that could be used as a 5th or 6th bedroom, a full bathroom, plus a separate workout room, a pristine workshop, and a storage area! Finally, the grounds and exterior of this property are just as immaculate as the interior. New gutter guards (2024), new vinyl siding (2021), a new roof (2021), super clean epoxy floors in the garage (2016, and a recently installed septic system (2015), make this home truly move-in ready. Pride of ownership is evident from the moment you arrive and will be noticed in all the custom, thoughtful details this property offers!
MlsNumber: --
ListingId: DENC2061752


Listing Provided By: Greenville, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Kyle M McKean
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