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
React
Comment
Invite
No Comments Yet
Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.
Recent Activity
2 months ago
Listing updated with changes from the MLS®
2 months ago
Listing 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
Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.