Title Page Background
DEBUG FN args: Array ( [0] => 1947 [1] => [2] => [3] => agent ) BEFORE: Site: 1947 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1947 Igate: njhud LocID: 1947 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1947 AND i.igate IN ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1947 [1] => [2] => [3] => lender ) BEFORE: Site: 1947 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1947 Igate: njhud LocID: 1947 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1947 AND i.igate IN ('cahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1947 [1] => [2] => [3] => other ) BEFORE: Site: 1947 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1947 Igate: njhud LocID: 1947 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1947 AND i.igate IN ('cahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

16 Mulbren Court
Pinehurst, NC 28374
Hazlette Burns with Berkshire Hathaway HS Pinehurst Realty Group/PH, original listing - (910) 295-5504

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,499,000
Beds: 4
Baths: Full: 4, ½: 2
Status: Active
SqFt: 6457 Square Feet
Agency: Berkshire Hathaway HS Pinehurst Realty Group/PH
Agency Phone: (910) 295-5504

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: This exquisite brick home is tucked away on a cul-de-sac within the distinguished Pinewild community. The home's bold architectural details are immediately apparent, from the sophisticated molding to the custom domed family room featuring intricate hand-painted designs. The primary suite includes an office with built-in bookcases, his and her walk-in closets, separate commode rooms and vanities, and a luxurious jetted tub and walk-in shower. The Brazilian cherry hardwood floors throughout the first-floor living areas add a touch of warmth and sophistication. In the kitchen, culinary enthusiasts will appreciate the double ovens, sub-zero refrigerator, 6-burner gas range, beverage and wine coolers, walk-in pantry, bar seating, and elegant glass-front cabinetry. The central island with prep sink and granite countertops enhances the kitchen's functionality, and a convenient wet bar just off the dining room ensures seamless entertaining. The family room windows, adorned with plantation shutters, frame expansive views of the backyard and golf course, enhancing the home's natural beauty.<br /> <br /> Step outside to a meticulously designed outdoor haven, ideal for relaxation and entertainment. A grand brick patio with freshly painted railings overlooks the picturesque hole #7 of the Holly course and is adjacent to a saltwater pool with attached hot tub. Additional amenities include a recently updated irrigation system, energy-efficient solar panels, and a crawl space with room for a workshop and storage, or a convenient spot for golf cart parking. A circular driveway and a generous 3-car garage accommodate a variety of parking needs. Water heater 2019, Bosch dishwasher 2024, new roof 2021, kitchen granite counters 2023, bathroom granite counters 2024, 5-year salt cell in pool 2023.
MlsNumber: --
ListingId: 100503301


Listing Provided By: Berkshire Hathaway HS Pinehurst Realty Group/PH, original listing
Phone: (704) 322-0969
Office Phone: (910) 295-5504
Agent Name: Hazlette Burns
Disclaimer: Copyright © 2025 Hive MLS / Mid Carolina Regional MLS. 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => moore [3] => NC [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: moore State: NC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: moore State: NC Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1947 AND i.igate IN ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Jessica G Mcinnis
Jessica G Mcinnis
ASCIIA Place in the Pines Realty LLC
Call Today!: (910) 691-5170

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App