Explore details about location Sidney Avenue. Sidney Avenue is a location situated within the Town of Waterford alongside other areas such as Barratt Drive, Erie Court, Mallards Landing North. Additionally, some smaller parts of Sidney Avenue include specific areas like Hudson Avenue, Lansing Avenue, Hudson River Road adding to the diversity of its landscape.