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

12660 Boyce Milll Road
Raleigh, NC 27613
Angela Drum with Angela Drum Team Realtors, original listing - (919) 819-3852

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $10,000,000
Beds: 7
Baths: Full: 8, ½: 3
Status: Active
SqFt: 13746 Square Feet
Agency: Angela Drum Team Realtors
Agency Phone: (919) 819-3852

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: Welcome to Raleigh's premier luxury estate on an extraordinary gated 14+ acres featuring a helicopter landing area, 11-car garage, heated saltwater pool & pool house, basketball court, finished basement, salon, gym with sauna, and theatre. This stunning property has been completely renovated with custom additions, boasting 7 bedrooms, 8.3 bathrooms, 6 fireplaces, geothermal heating and cooling, a whole-house generator, RO system, central vacuum, tankless water heaters, a state-of-the-art Control4 system, and an estimated 13,700+ square feet of living space. Upon entry, you are greeted by a grand foyer with soaring ceilings, spiral staircase, and exquisite custom woodwork throughout, setting the stage for the unparalleled craftsmanship found throughout the home. The spacious living areas fill with natural light and feature custom design interior, creating an ambiance of sophistication and comfort. The kitchen is a culinary dream, featuring top-of-the-line appliances, custom cabinetry, a large island, keeping room and open flow to four seasons porch. The primary wing introduces a retreat of it's own, showcasing a separate seating area for nursery/study, linear fireplace, private 4 season room, personal laundry room, and a lavish marble bath featuring jetted tub, double water closets, heated floors, extended shower for extra height, 2 expansive custom closets with private entry, center island, and crystal chandeliers. Each additional bedroom is generously sized and features its own ensuite bathroom, providing comfort and privacy for family and guests. An additional private entry guest/in-law suite is perfect for extended stays and includes kitchenette, full bath, and private balcony. Outside, the resort-style grounds include a basketball court, playground, saltwater pool with limestone & waterfalls, custom grill & cooler, greenhouse, and 6-bay temperature control kennel with wash station, storage garage for golf cart, huge attic and basement bunker for storage. The expansive lawn is perfect for hosting events/event venue, equestrian, hunting, or simply enjoying the serene surroundings in total privacy. Additional features of this exceptional estate include an elevator shaft, landscape lighting, and abundant parking. Located just minutes from RTP, RDU, shopping, dining, universities, and entertainment, this is a rare opportunity to own a truly exceptional property in one of the Triangle area's most coveted locations. Experience the embodiment of luxury living and discover the extraordinary lifestyle that awaits you!
MlsNumber: --
ListingId: 10053772


Listing Provided By: Angela Drum Team Realtors, original listing
Phone: (919) 819-3852
Office Phone: (919) 819-3852
Agent Name: Angela Drum
Disclaimer: Copyright © 2024 Doorify MLS of North Carolina. 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 = 3440 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 Molly & Colin Williams
Molly & Colin Williams
ASCIINavigate Realty
Molly: (919) 694-1475
Colin: (984) 733-1780

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App