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

407 Arcadia Way
Wilmington, DE 19808
Ross Weiner with RE/MAX Associates-Wilmington, original listing - (302) 477-3900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,750,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 5475 Square Feet
Agency: RE/MAX Associates-Wilmington
Agency Phone: (302) 477-3900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: Welcome to the home you’ve been waiting for in the coveted Greenville Overlook neighborhood<br /> of Wilmington, Delaware. From the moment you step inside, you’ll be captivated by the elegant<br /> butterfly staircase adorned with a custom wool and silk runner and the rich oak hardwood floors<br /> that set the tone for the rest of the home. The gourmet kitchen is a chef’s dream, featuring soft-<br /> close Cherry cabinetry, a spacious center island, premium stainless-steel appliances—including a<br /> 6-burner Jenn-Air range and double wall ovens—granite countertops, a classic tile backsplash,<br /> and the convenience of hot water on demand. Two generous pantries provide abundant storage.<br /> The sun-drenched family room is a true showpiece, showcasing a dramatic two-story decorative<br /> Tudor ceiling, a cozy gas stone fireplace, and expansive windows that flood the space with<br /> natural light. A formal dining room near the entry is perfect for entertaining, while the first-floor<br /> office and formal living room offer refined spaces for work and relaxation.<br /> Just off the kitchen, the inviting sunroom offers a charming breakfast bar, extra cabinet storage, a<br /> gas fireplace, and sliding doors leading to a 36’ x 14’ Trex deck, paver patio, 20x12 feet garden<br /> and tall oak and beautiful Autum blaze maple trees in the back yard which shades most of deck<br /> the in the afternoon for BBQ dinner on the deck—ideal for seamless indoor-outdoor living. This<br /> home is uniquely distinguished by its two luxurious primary suites. The first-floor suite includes<br /> its own sitting area, spacious walk-in closets, a soaking tub, and a separate shower. The second-<br /> floor suite is even more expansive, featuring two oversized walk-in closets, a private sitting<br /> room, a dressing area, a jetted Jacuzzi tub, and a separate stand-alone shower. All bathrooms<br /> throughout the home are beautifully appointed with upgraded tile flooring, stylish tile surrounds,<br /> and decorative vanities. The partially finished basement includes a full bathroom and a walk-out<br /> to the patio, offering incredible versatility for entertaining, recreation, or guest accommodations.<br /> Additional features include. A three-car side-entry garage with dual EV charging hookups, first-<br /> floor laundry, three-zone HVAC systems, a lawn irrigation system, custom window treatments<br /> including Hunter Douglas Silhouette shades and Bali Day/Night cellular blinds and so much<br /> more. This exceptional home blends classic elegance with modern amenities in one of<br /> Delaware’s most desirable neighborhoods. Don’t miss your chance to make it yours.
MlsNumber: --
ListingId: DENC2079182


Listing Provided By: RE/MAX Associates-Wilmington, original listing
Phone: (302) 234-3800
Office Phone: (302) 477-3900
Agent Name: Ross Weiner
Disclaimer: Copyright © 2025 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','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 George Brown
George Brown
ASCIIPatterson-Schwartz
Call Today!: (302) 530-8867

Local Mortgage Pro

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','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 Ellsworth 'Brownie' Brown NMLS#1686479
Ellsworth 'Brownie' Brown NMLS#1686479
ASCIISuccess Mortgage
Call Today!: (757) 870-4943

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App