Explore details about location Clearview Avenue. Clearview Avenue is a location situated within the Columbia County alongside other areas such as Circle Drive, T396, Country Road. Additionally, some smaller parts of Clearview Avenue include specific areas like Montour Boulevard adding to the diversity of its landscape.