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

213 Ravenswood Road
Hampstead, NC 28443

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3100
Agency: Coldwell Banker Sea Coast Advantage

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1996
Notes: Welcome to this freshly remodeled and one-of-a-kind gem nestled on over a half acre lot and surrounded by breath-taking gardens. <br /> <br /> As you enter the grand foyer, you will immediately notice rich hardwood floors, modern new light fixtures and that the entire home was painted with a modern calming grey color. On your left is a den and on your right is situated a formal dining room waiting for the new owners to host their holiday dinners. A large and bright living room with vaulted ceiling welcomes you and feels as though it was made for cozy evenings with a nice glass of wine, reading your favorite author, playing family games, conducting deep conversations or just watching movies around a gas fireplace. <br /> A gourmet kitchen with solid surface counter tops, cabinetry which provides a wealth of storage space, an eat-in breakfast bar, a working island, a pantry and a breakfast nook will please every chef and make any cooking experience much more enjoyable. <br /> From the private Master Suite you can access a covered patio where you can sit down and enjoy watching the sunrise. The Master Suite also offers a large walk-in closet, remodeled double vanity with new granite countertops, jacuzzi tub and a walk-in tiled shower. A laundry room is situated conveniently next to the Master bedroom with a washer and dryer ready for the new owners. A second Master Suite and two more spare bedrooms with a full bathroom are located on the opposite side of the home. A bright Carolina sunroom with a built-in bar is ready for entertainment with your friends. From here you can also access the covered patio where you can enjoy your afternoon cup of tea while overlooking your backyard and watching golfers hitting the ball and wildlife passing by - an abundance of birds, butterflies, fox, deer, owls, turtles, bunnies and opossums. <br /> For additional entertainment you can use the bonus room located on the second floor. This piece of paradise is loaded with evergreens and perineal plants which offers Southern Living at its finest!<br /> This home also features a newly installed carpet, a full house generator is ready for stormy days, a water softener, a tankless gas water heater and hurricane panels for windows. The owners are also offering a one-year home warranty.<br /> <br /> Looking for more fun and activities? Join the Olde Point Country Club for their golf, pool and social events. And let's not forget about the deeded access to the Intracoastal waterway via the community launch ramp. This property has it all!<br /> The absolutely amazing location of this property is another attractive feature to consider. Situated in the coastal town of Hampstead, with a short commute to fabulous Kiwanis Park, highly rated schools, shopping, restaurants, many golf courses, ICWW access, Topsail Island and Wrightsville beaches, and the city of Wilmington with a world class university, a tremendously growing network of businesses, and a historic river district.
MlsNumber: 100450014


Listing Provided By: Coldwell Banker Sea Coast Advantage, original listing
Name: Coldwell Banker Sea Coast Advantage
Phone: (910) 799-3435
Office Name: Coldwell Banker Sea Coast Advantage-Hampstead
Office Phone: (910) 799-3435
Agent Name: Irena Kohler
Disclaimer: Copyright © 2024 NCRMLS/ 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 = 1955 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 Sheila Garcia Holloway
Sheila Garcia Holloway
ASCIIThe Nesting Group - ERA
Call Today!: (910) 238-6341

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App