We loved our stay in this beautiful apartment right next to the Douro river and would definitely come again!
Just keep in mind that it is also right next to a busy street, which was quite noisy at night.