Explore details about location Main Street. Main Street is a location situated within the Columbia alongside other areas such as Assembly Street, Main Street, Lady Street. Additionally, some smaller parts of Main Street include specific areas like College Street adding to the diversity of its landscape.