Explore details about location Fairview Avenue. Fairview Avenue is a location situated within the Columbia alongside other areas such as Locust Street, Avenue P, Perry Street.