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