Explore details about location Fairview Street. Fairview Street is a location situated within the Hartford alongside other areas such as Waterman Hill Road, Wilder Dam Road, Connecticut River Road.