Forget Florida or California, your next US beach holiday is closer to home in more ways than one