Deadhive Overrun is a ruin of a town which has been overtaken by Fogmen. This location is in the Okran's Gulf zone, to the north near the Fog Islands. Aside from potentially a Fog Prince Head, there is no major loot here.
Deadhive Overrun likely used to be a town controlled by The Holy Nation.
Hive villages can be turned into something similar to this if the faction's Hive Queen is harmed.