What a view! The apartment was perfect for our stay in Porto. Just across the river from all the port bars, and it's a great starting point for seeing the city up the hill. Very close to tons of bars/restaurants, and it's a short walk (<5min) to a funicular that takes you up the hill into the middle of town. If you're a very light sleeper, be wary of the busy season as some people congregate at the riverfront late at night. It did not bother me at all (maybe thanks to lots of delicious wine).