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 = 1894 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 = 1894 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 = 1894 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;

2914 Legends Drive
Southport, NC 28461

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,000
Beds: 3
Baths: 4
Status: Active
SqFt: 4250
Agency: St James Properties LLC, Marina Office

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2005
Notes: Great New Price for 2914 Legends Drive, where timeless charm meets modern luxury in this superbly designed custom-built home. Your are greeted with a stately entrance and will immediately appreciate the attention to detail and craftmanship that defines this residence.<br /> <br /> The captivating home boasts three generously sized bedrooms, each adorned with its own ensuite bathroom, offering a haven of comfort and seclusion. The primary bedroom indulges in tranquility with its private sitting room, providing the perfect sanctuary to unwind after a day's endeavors.<br /> <br /> At the heart of the residence lies an expansive chef's kitchen, a culinary masterpiece featuring top-of-the-line appliances such as the Wolf stove burner, Sub-Zero refrigerator, and stylish Zodiac countertops. The tile floors add an extra layer of sophistication, harmonizing seamlessly with the solid doors that grace each space throughout the home. The large pantry ensures that every culinary need is met, further enhancing the functionality and luxury of this remarkable home.<br /> <br /> Entertaining guests becomes a grand affair in the opulent dining room, adorned with trey ceilings, leading to a cozy deck and the inviting Carolina room equipped with a mini-split system for year-round comfort. This stately all-brick exterior and secluded setting create an enchanting ambiance, perfect for both intimate moments of relaxation and lavish entertaining.<br /> <br /> Discover a host of additional features that elevate the practicality and allure of this residence, including a spacious study/office, central vacumn system, and a vast attic walk-in storage area. The newer HVAC Trane systems ensure optimal climate control, while the home's design, adorned with the finest finishes, creates an atmosphere of unparalleled luxury.<br /> <br /> The property transcends the definition of a mere house. Immerse yourself in the flawless blend of sophistication and comfort of 2914 Legends Drive- where every detail has been carefully curated for a life of lux.
MlsNumber: 100433284


Listing Provided By: St James Properties LLC, Marina Office, original listing
Name: St James Properties LLC, Marina Office
Phone: (843) 475-1795
Office Name: St James Properties LLC
Office Phone: (910) 253-3001
Agent Name: Denise Hayes
Disclaimer: Copyright © 2024 NCRMLS/ Brunswick County Association of REALTORS. 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 = 1894 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 Corey Hunt
Corey Hunt
ASCIIColdwell Banker Sea Coast Realty
Call Today!: (910) 231-4710

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App