Explore details about location Queen's Avenue. Queen's Avenue is a location situated within the Little Houghton CP alongside other areas such as John Street, Queen's Avenue. Additionally, some smaller parts of Queen's Avenue include specific areas like Dearne Valley Parkway, Ings Lane, Rotherham Road adding to the diversity of its landscape.