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

806 Lighthouse Drive
Corolla, NC 27927
Susan Ayers with Home Zu, original listing - (888) 875-4218

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,250,000
Beds: 12
Baths: Full: 12, ½: 2
Status: Active
SqFt: 7642 Square Feet
Agency: Home Zu
Agency Phone: (888) 875-4218

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: --
Notes: This brand-new semi-oceanfront estate in popular Whalehead Beach is sure to impress. Designed and built by Finch & Company, this fully furnished 12-bedroom home features spectacular unobstructed ocean views, and each bedroom includes its own private, custom tiled bathroom. With over 7600 square feet, there is an abundance of gathering spaces and oversized bedrooms for large groups to spread out and enjoy themselves, along with an elevator to easily navigate throughout the home. The layout features three spacious, coastal-inspired levels, professionally designed for both comfort and entertainment. The top floor offers an open concept with cathedral ceilings and large picture windows, bringing in an abundance of natural light and offering sweeping ocean views. The spacious gourmet kitchen includes a large center island, double ovens, 6 burner professional cooktop, two dishwashers and refrigerators, quartz counters, custom shaker cabinets, and 15ft custom dining table with seating for 18. The living area includes custom built bench seating, conversation seating area for 4, and extra-large sectional sofa, perfect for gathering around the large screen TV or taking in the amazing views from the large picture windows. Rounding out the top floor includes front and back decks for alfresco dining, separate sitting area, and three master ensuites. The mid-level includes six well appointed ensuite bedrooms all of which were designed for space and comfort, including an oversized custom built bunk room with four twin and four full sized bunks. A large media room with wet bar, private office, and plenty of front and back deck seating round out the mid-level. The ground floor offers a nicely sized theater room with Italian leather seats, 85-inch TV, and Sonos sound system. The rec room includes a pool table, shuffleboard table, stand up arcade with 10,000 games, 75-inch TV, conversation seating, wet bar, professional ice maker, and full-sized refrigerator. There is also a custom installed Sonos sound system inside and out which operates easily from an app on your phone. Outside amenities abound with a heated salt water pool with sun shelf and in-pool bar stools, perfect for staying cool on those warm summer days. Two large covered cabanas include bar and lounge seating, perfect for keeping the party going all day long. Enhancing your poolside experience includes a large flat-screen TV, outdoor speakers, hot tub, ping pong table, cornhole boards, and outdoor shower. The exterior was professionally landscaped with drip irrigation and easy to maintain plants ensuring the grounds look great with minimal supervision. All this while located in an X flood zone. Welcome Home.
MlsNumber: --
ListingId: 125445


Listing Provided By: Home Zu, original listing
Phone: (770) 935-4219
Office Phone: (888) 875-4218
Agent Name: Susan Ayers
Disclaimer: Copyright © 2024 Outer Banks 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 = 1911 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 Janel Hansen
Janel Hansen
ASCIIBerkshire Hathaway HomeServices
Call Today!: (703) 328-8028

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App