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 = 1908 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 = 1908 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 = 1908 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;

51 Shaw Road
Riegelwood, NC 28456
Brandon Edens with Keller Williams Innovate-Wilmington, original listing - (910) 777-2200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $295,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2708 Square Feet
Agency: Keller Williams Innovate-Wilmington
Agency Phone: (910) 777-2200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Manufactured Home
Year Built: 2000
Notes: Welcome to 51 Shaw Rd - The Dream Home You've Been Waiting For!<br /> <br /> Get ready to fall in love with this incredible 4-bedroom, 3-bathroom home that delivers everything you've been searching for—and more! Nestled on a 1-acre lot, this immaculate 2,700-square-foot triplewide manufactured home offers the space, comfort, and features you've always dreamed of.<br /> <br /> From the moment you step inside, you'll be wowed by the open and inviting floor plan. Boasting two oversized family rooms, there's no shortage of space to entertain, relax, or spend quality time with family. The kitchen offers plenty of counter space and storage to make cooking and entertaining a breeze. Whether you're preparing a weeknight dinner or hosting a dinner party, this kitchen has you covered!<br /> <br /> The spacious master suite provides the ultimate retreat with a private bathroom, while the additional three bedrooms are perfect for kids, guests, or even a home office. With three full bathrooms, there's no need to wait in line during the busy mornings!<br /> <br /> But the excitement doesn't stop inside—outside is where this home truly shines. Imagine spending your evenings on the 1-acre lot, enjoying the peace and privacy that comes with owning your own slice of paradise. Plus, with a durable metal roof, you'll have peace of mind knowing your home is built to withstand the elements for years to come.<br /> <br /> And here's the real gem—this home includes a paved driveway with a parking pad, a rare find in the country! No more mud or gravel—just smooth, easy access and plenty of room for all your vehicles, guests, and toys.<br /> <br /> This home has it all: spacious living, modern features, outdoor freedom, and that rare country convenience. Don't miss your chance to make 51 Shaw Rd your own. Schedule a showing today and discover the ultimate in country living!
MlsNumber: --
ListingId: 100476477


Listing Provided By: Keller Williams Innovate-Wilmington, original listing
Phone: (910) 777-2200
Office Phone: (910) 777-2200
Agent Name: Brandon Edens
Disclaimer: Copyright © 2024 Hive MLS / Cape Fear Realtors MLS, Inc. 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 = 1908 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;
Real Estate Expert Photo for J. Ray Realty
J. Ray Realty
Call Today!: (910) 641-2676

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App