Explore details about location Acorn Cove. Acorn Cove is a location situated within the Madison County alongside other areas such as Sowell Rd, Brown Road West, McMillon Road. Additionally, some smaller parts of Acorn Cove include specific areas like North Oak Drive adding to the diversity of its landscape.