Richard is correct. Emerald Isle and Atlantic Beach are probably closest for you but really are best for S/SW winds and is mostly ocean riding unless you have a boat.
We are in Wrightsville Beach and we can ride any wind direction except NW. We ride ocean a lot but do have some flat water spots depending on the wind direction.
If you are thinking about coming down this way feel free to contact us at the shop 910-509-9989 or firstname.lastname@example.org
and we can let you know what the wind is doing and where is best to ride.
You can check out http://www.surfchex.com
for live local wind conditions.
Hatteras does have more flat water and is good on any wind direction but it will be a much longer drive so up to you.
Hope that helps.
Blowing in the Wind