The flat was totally renewed in 2014, in a simplistic way it answers all your demands. It is located on the south margin of Douro River, Gaia is where all the wine tasting gets done, and the place to get the perfect photo of Ribeira, Porto.
2 min walking to Devesas Train station. From there, each 15min you can take the train to downtown Porto, São Bento train (8min trip)
14 min walking to River Douro
20 min walking to João de Deus metro station and El Corte Inglés.