Explore details about location North Fairview Road. North Fairview Road is a location situated within the Columbia alongside other areas such as Granite Springs Court, Katy Woods Court, Myrtle Oak Drive. Additionally, some smaller parts of North Fairview Road include specific areas like Laurel Drive, Appalachian Drive, Park de Ville Place adding to the diversity of its landscape.