Explore details about location Mansion Avenue. Mansion Avenue is a location situated within the Narragansett Pier alongside other areas such as Ocean Road, Westmoreland Street, Knight Street.