We've stayed at the place for 4 nights during our visit to Porto. It is in very close walking distance to all the wine cellars which we really liked, it is also walkable from the city center. However, if you don't feel like walking all the way a taxi is about 5 Euros (depending on from where) which is absolutely reasonable. The apartment itself is exactly like in the pictures described and overlooks the Douro river and on to the city center of Porto in a very unique way.