Being south of New River also cuts your commute to the beach.
Married? Lejuene base housing (not MCAS). Or, Williamsburg Plantation on Gum Branch--why not, all the other married officers live there!
Actually Sneads Ferry's treated me pretty well. My subdivision has a pool, a boat ramp, club house, dock, etc. Quick walk to the river, 5-10 min from the beach.
Single? Go Buffett-style and rent a beach condo in Topsail Island/Surf City, or live in Wilmington, either downtown or near Wrightsville Beach.