The calculated distance (air line) between Cologne and Erstein is approximately 176 miles respectively 284 kilometers.
By car or train, the actual journey to Erstein is certainly longer, as only the direct route (as the crow flies) between Cologne and Erstein has been calculated here.