The apartment is great, the view on the river is amazing and the hosts are very welcoming & gave us a lot of advices about Porto, what and where to eat, etc.
It might be a bit noisy in the mornings because of screaming seagulls, but I bet it applies to any house near the river.