Explore details about location Waterfront Road. Waterfront Road is a location situated within the Franklin County alongside other areas such as State Route 906, Whispering Pines, Grassy Hill Road.