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;

2303 N Grant Avenue
Wilmington, DE 19806

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,495,000
Beds: 5
Baths: 4
Status: Active
SqFt: 4047
Agency: Compass

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1989
Notes: Experience timeless luxury in this meticulously maintained home, built in 1989 and continuously enhanced. Nestled in the highly coveted Rockford Park area, just off Kentmere Parkway, this residence offers unparalleled tranquility while being a mere 5-minute drive to downtown Wilmington and Route 95.<br /> <br /> Situated on a spacious lot of approximately 0.44 acres, this property boasts mature trees, a cleared rear yard, and landscaped grounds. Enjoy outdoor living with a patio adjacent to three sets of French doors and a second slate patio beneath a canopy of trees.<br /> <br /> Inside, discover five spacious bedrooms, with potential for two more on the finished third floor with separate heating and air conditioning. Three and a half fully renovated baths and expansive closets provide modern comfort, and the home is complemented by two gas fireplaces with remotes, hardwood floors, and his and hers private offices located on the first floor off the main living areas.<br /> <br /> The generous master bedroom suite features a sitting area with a gas fireplace, dual walk-in closets and a third cedar closet, and a lavish master bath with a jacuzzi soaking tub. The entire third floor unfolds into an expansive teen/au pair/guest/in-law suite, complete with a bedroom, full bath, kitchenette, living room, game area, office/study area, yoga/workout space, and ample storage.<br /> <br /> The open kitchen, dining, and family room area is a focal point, featuring a fully renovated kitchen with quartz countertops, including a larger center island, Viking 6-burner gas stove, and other high-end appliances. The family room boasts a gas fireplace, built-in wet bar, and double French doors leading to the rear patio.<br /> <br /> This residence also offers a 2-story open foyer, a 2-car attached heated garage, off-street parking for 6+ cars, a full basement, and a upgraded wireless security system. Enjoy proximity to Brandywine Park and Rockford Park, providing direct access to biking, hiking, running trails, tennis, pickleball, and outdoor activities.<br /> <br /> With a recently replaced roof, new front porch, walkway, driveway, and recessed lighting throughout, this home seamlessly blends elegance, functionality, and modern amenities in an idyllic location amidst historic homes. Welcome home to luxury living at its finest.
MlsNumber: DENC2058046


Listing Provided By: Compass, original listing
Name: Compass
Office Name: Compass
Office Phone: (302) 202-9855
Agent Name: Davis McDermott
Disclaimer: Copyright © 2024 Bright MLS. 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