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;

103 Hickory Circle
Hampstead, NC 28443

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $650,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3472
Agency: Coldwell Banker Sea Coast Advantage-Hampstead

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1994
Notes: PRICE IMPROVEMENT AND 1 YEAR HOME WARRANTY! Welcome home to this spectacular 4 bedroom, 3 bathroom custom built home located in the highly desirable neighborhood of Belvedere Plantation! New paint, New flooring, Granite countertops, New stainless steel appliances, Double ovens, Built in microwave, Floor to ceiling cabinetry, New light fixtures & ceiling fans, Updated Heating/Air system, New deck, this home is ready for its new owners! Step into luxury through the grand foyer, where the formal dining room greets you on the left, and the expansive living room with a cathedral ceiling beckons straight ahead in the natural light from 5 large skylights above. The large living room is an inviting atmosphere perfect for friendly gatherings and cozy evenings by the fireplace. Connecting seamlessly, the spacious kitchen is a culinary haven, featuring ample storage, an inviting eating bar, a charming breakfast nook, and a generously sized walk in pantry. Separate from the other bedrooms, the private primary suite features high vaulted ceilings and a large walk-in closet! The en suite bathroom provides dual vanity sinks and dual rain shower heads offering a luxurious retreat. The well-thought-out design places the other two bedrooms on the opposite side of the home, ensuring privacy. Enjoy the comfort of your heated sunroom and covered patio to view the Nixon River as you watch wild life passing by. This home has a beautiful backyard, perfect for moments of relaxation, complemented by a spacious new deck to enjoy the captivating views. Upstairs, you'll find the 4th bedroom, finished room over garage (FROG) with its own full bathroom. Additionally the upstairs includes a versatile bonus room space, a loft area for added functionality or office, and ample storage room. This upper level adds a layer of versatility to the home, providing extra room for various needs and preferences. Notably, this home is equipped with Fiber to the Home (FTTH) optics, ensuring lightning-fast internet and ample bandwidth for all your internet needs. NO HOA & NO CITY TAXES! Why is Hampstead, North Carolina so captivating? Hampstead is more than a beautiful coastal community; it's a haven where its sought-after school system, an ideal location, and delightful weather converge to create your way of life- it's an idyllic town that truly invites you home. If you are out of state, contact me or your realtor to schedule your virtual tour today.
MlsNumber: 100420274


Listing Provided By: Coldwell Banker Sea Coast Advantage-Hampstead, original listing
Name: Coldwell Banker Sea Coast Advantage-Hampstead
Phone: (910) 270-8880
Office Name: Coldwell Banker Sea Coast Advantage-Hampstead
Office Phone: (910) 270-8880
Agent Name: Holly Griffith
Disclaimer: Copyright © 2024 NCRMLS/ Jacksonville Board of Realtors NC. 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