Property Search

Save
Ask
Tour
Hide
Share
$450,000
57 Days On Site

4707 MERMAID BOULEVARD
WILMINGTON, DE 19808

For Sale|Single Family Residence|Active
4
Beds
3
Total Baths
2
Full Baths
1
Partial Bath
2,200
SqFt
$205
/SqFt
1973
Built
Subdivision:
LINDEN HEATH
County:
NEW CASTLE
Listing courtesy of Crown Homes Real Estate
Call Now: (703) 898-3565
Is this the listing for you? We can help make it yours.
(703) 898-3565
4707 MERMAID BOULEVARD4707 MERMAID BOULEVARD4707 MERMAID BOULEVARD4707 MERMAID BOULEVARD
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

Enter an interest rate to see your estimated monthly payment.
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

Opportunity knocks in the heart of Pike Creek! This spacious 4-bedroom, 2.5-bath Colonial offers approximately 2,200 square feet of living space and an excellent opportunity for a buyer who wants to renovate a home to match their own style, build equity over time, or explore its potential as a long-term rental investment. Inside, the home offers hardwood flooring, generously sized living areas, a family room with a fireplace, an eat-in kitchen, spacious bedrooms and plenty of room to create a modern, personalized interior. Additional features include an attached garage, an unfinished basement providing valuable storage and future possibilities, and a private backyard framed by mature trees. Rather than paying a premium for someone else’s renovation choices, bring your own vision and transform this well-located Pike Creek property into the home or investment you have been searching for. The location is a major advantage. The home is approximately one-quarter mile from Pike Creek Shopping Center, placing ACME Markets, The Edge Fitness Clubs, Orangetheory Fitness, Pike Creek Wine & Spirits, a community hardware store, banking, urgent care, cafés and numerous restaurants just around the corner. The shopping center’s current directory includes more than 30 businesses and services. Based on current business and shopping-center directories, buyers will find approximately 20 or more retail and service destinations, 12 or more restaurants and eateries, two bar or pub options and a full-service grocery store within roughly one mile. Within approximately five miles are an estimated 75 or more shopping and service destinations, 30 or more dining options, 20 or more bars and bar-serving restaurants, and eight or more grocery and specialty-market options. Amenity totals are approximate and may change as businesses open, close or relocate. Convenient access to Limestone Road, Kirkwood Highway, Newark, Wilmington and major employment centers further strengthens the appeal for both homeowners and prospective tenants. Whether you are a value-conscious buyer, renovation enthusiast, owner-occupant or investor seeking a potential Wilmington rental property, 4707 Mermaid Boulevard delivers the space, location and upside needed to create lasting value.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$450,000
Days On Site 
57 Days
Bedrooms 
4
Inside Area (SqFt) 
2,200 sqft
Total Baths 
3
Full Baths 
2
Partial Baths 
1
Lot Size 
0.22 Acres
Year Built 
1973
MLS® Number 
DENC2108692
Status 
Active
Property Tax 
$3,900
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
Assessor
Friends & Family
Recent Activity
2 months agoListing updated with changes from the MLS®
2 months agoListing first seen on site
General Features
Acres 
0.22
Attached Garage 
Yes
Foundation 
Concrete Perimeter
Garage 
Yes
Garage Spaces 
2
Levels 
Two
Parking 
On StreetGarageDrivewayInside EntranceAttached
Parking Spaces 
2
Property Sub Type 
Single Family Residence
Sewer 
Public Sewer
Special Circumstances 
Standard
SqFt Above 
2200
SqFt Total 
2200
Style 
Colonial
Water Source 
Public
Zoning 
NC6.5
Interior Features
Appliances 
Electric RangeElectric OvenRange HoodRefrigeratorDishwasher
Basement 
Partial
Cooling 
Central AirElectric
Fireplace 
Yes
Fireplaces 
1
Flooring 
Wood
Heating 
OilBaseboard
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
AsbestosBrick
Pool Features 
None
Roof 
Shingle
Community Features
MLS Area 
Hockssn/Greenvl/Centrvl (30902)
School District 
RED CLAY CONSOLIDATED
Schools
School District
RED CLAY CONSOLIDATED
Elementary School
NORTH STAR
Middle School
HENRY B. DU PONT
High School
ALEXIS I. DUPONT
Listing courtesy of Crown Homes Real Estate



The real estate listing information is provided by Bright MLS is for the consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Any information relating to real estate for sale or lease referenced on this web site comes from the Internet Data Exchange (IDX) program of the Bright MLS. This web site references real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. The accuracy of all information is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals. Properties in listings may have been sold or may no longer be available. The data contained herein is copyrighted by Bright MLS and is protected by all applicable copyright laws. Any unauthorized collection or dissemination of this information is in violation of copyright laws and is strictly prohibited. Copyright © 2020 Bright MLS. All rights reserved.

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share
Popular areas we serve

Northern Virginia Communities

  1. Aldie
  2. Alexandria
  3. Annandale
  4. Arlington
  5. Ashburn
  6. Bluemont
  7. Brambleton
  8. Bristow
  9. Broadlands
  10. Burke
  11. Centreville
  12. Chantilly
  13. Fairfax
  14. Falls Church
  15. Gainesville
  16. Great Falls
  17. Herndon
  18. Leesburg
  19. Manassas
  20. Manassas Park
  21. McLean
  22. Middleburg
  23. Oakton
  24. Reston
  25. South Riding
  26. Springfield
  27. Sterling
  28. Stone Ridge
  29. Vienna
  30. Winchester
  31. Woodbridge

Browse by Area

Start A Custom Search