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

2808 Sand Trap Lane
Hope Mills, NC 28348
Kandy Benton with Mark Spain Real Estate, original listing - (855) 299-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $545,999
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3454 Square Feet
Agency: Mark Spain Real Estate
Agency Phone: (855) 299-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2011
Notes: **For Sale: Stunning 4 Bedroom, 3.5 Bath Home in Hope Mills**<br /> <br /> Discover your dream home nestled on a spacious .36-acre lot in a tranquil cul-de-sac neighborhood. This beautifully maintained 2011 home boasts numerous upgrades and modern amenities for comfortable suburban living.<br /> <br /> **Key Features:**<br /> <br /> - **Bedrooms/Baths:** 4 Bedrooms, 3.5 Baths<br /> - **Office Space:** Conveniently located downstairs; perfect for remote work or study<br /> - **Living Space:** <br /> - Spacious media room featuring surround sound, projector screen, and movie-style seating for ultimate entertainment <br /> - High ceilings in the foyer create an inviting entryway<br /> - Large secondary bedrooms and bathrooms located upstairs<br /> - **Kitchen:** <br /> - Gourmet kitchen with two-story granite countertops and tile backsplash<br /> - Stainless steel appliances included (washer, dryer, and refrigerator)<br /> - Dual vanity sinks and walk-in shower in the master bath, plus a soaking tub for relaxation<br /> - Designed for culinary enthusiasts, this kitchen has been the birthplace of some of the finest Creole cuisine<br /> - **Additional Living Spaces:**<br /> - Screened-in sunroom wired for electric and equipped with a ceiling fan; perfect for enjoying the outdoors year-round<br /> - Terry laundry room located on the main floor for added convenience<br /> - **Outdoor Features:**<br /> - Partially furnished fenced backyard, ideal for pets and gatherings<br /> - Landscaped yard with compost included for gardening enthusiasts<br /> - Two-car garage with ample storage space<br /> - **Utilities:** Public water, septic, and propane fireplace<br /> - **Interior Design:** <br /> - Luxury vinyl flooring downstairs; carpeted upstairs for comfort<br /> - Beautiful wainscoting in the master bedroom and barn doors for a stylish touch<br /> - Tons of closet space throughout the home, including walking closets for added convenience<br /> - **Community:** Conveniently located close to various amenities while still offering a peaceful suburban lifestyle<br /> <br /> This home is truly a gem that has been well taken care of by its original owner. Schedule a tour today to experience all the features and charm this property has to offer!
MlsNumber: --
ListingId: 10067231


Listing Provided By: Mark Spain Real Estate, original listing
Phone: (855) 299-7653
Office Phone: (855) 299-7653
Agent Name: Kandy Benton
Disclaimer: Copyright © 2024 Doorify MLS of North Carolina. 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 = 1910 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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;
Wayne Wheeler
ASCIIRealty One Group Liberty
Call Today!: (910) 286-4907

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App