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

855 Linden Road
Pinehurst, NC 28374

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,150,000
Beds: 5
Baths: 5
Status: Active
SqFt: 5619
Agency: REMAX Prime Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2021
Notes: Centered in Pinehurst, this beautiful French Country luxury home sits on a 2.99 acre lot and boasts a saltwater in-ground pool and separate accessory dwelling featuring approx. 988 sq.ft of living area. With just over 4700 sq.ft. of living space in the main house, this impeccably maintained home offers fine finishes and architectural details, inside and out. The exterior delivers a gorgeous brick and stone design. Step through the front door and enter a bright and open home plan. The foyer and formal dining room opens to a large family room with stone, gas log fireplace, and offers beautiful views and access to the outside pool and patio area. This home offers 8 ft. interior doors, crown molding, as well as tray ceilings, coffered-ceiling in the family room, and hardwood floors throughout. The spectacular gourmet kitchen has beautiful cabinetry, granite countertops, large island w/breakfast bar, Bosch stainless steel appliances, Zline, six-burner gas range and stove and large walk-in pantry. A secluded master suite features a spacious bedroom, large walk-in closet, en-suite bath with his and her vanities, walk-in tiled shower with rain-shower head, freestanding soaking tub, and tile flooring. The main level also includes a spacious formal living room/den, two guest bedrooms with a shared bathroom, and a third bedroom with an en-suite bath. The upper level has a large bonus room/bedroom with en-suite bath and walk-in closet, as well as an office nook. This level also houses a large walk-in attic storage space. An oversized three-bay, mini-split conditioned garage offers space for a workshop with custom wood cabinets. Other features include sealed crawl space with dehumidifier and tankless water heater. A 2 BR/1 BA accessory dwelling on the property has a large family room, custom kitchen with granite countertops and separate one stall mini-split conditioned garage. The backyard pool and entertainment area is fenced with wrought iron fence and beautiful landscaping.
MlsNumber: 100424908


Listing Provided By: REMAX Prime Properties, original listing
Name: REMAX Prime Properties
Phone: (910) 295-2535
Office Name: Re/Max Prime Properties
Office Phone: (910) 295-2535
Agent Name: Martha Gentry
Disclaimer: Copyright © 2024 NCRMLS/ 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

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 = 1947 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 Nicholas Eiberger
Nicholas Eiberger
ASCIIOnnit Realty Group
Call Today!: (785) 766-9508

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App