the hotel was situated along the walkway to the sydney opera house and the floor-to-ceiling windows overlooked circular quay , as well as giving a magnificent view of the great coathanger harbour bridge .