This is an agency-managed AirBnB a ~10-15 minute walk from the touristy part of Vila Nova de Gaia, or a ~30 minute walk to the centre of the old city of Porto. The view is as stunning as it looks in the photographs — although otherwise the photographs are about 6 or 8 years out of date, and while the furnishings and bedding is well-updated, the floors in the apartment are really starting to show their age and have aged badly. The windows are still in good shape, which is probably the most important, and they're relatively clean although not spotless — but that's forgivable as I can't even imagine how hard it must be for them to keep those massive windows clean, as there's no easy way to access them from the outside or inside!
In general this was a great place to spend 3 days discovering Porto, the only real inconvenience was the lack of any sort of grocery store or even convenience store even remotely nearby, which is not a fault of the AirBnB owners of course, but it is annoying that the city of Vila Nova de Gaia can't get a single grocery store anywhere close to the tourist area, making it a challenge to cook yourself breakfast if you don't have a car. (Basically, you'd need to walk quite a distance, maybe 30 minutes, including a steep uphills, to the closest Auchuan by the autoroute, and then uber back — or uber both ways.) There is a grocery store in Vila Nova de Gaia at the boardwalk, but you have to be a restaurant owner to use it!
This whole area seems like it must have had a massive gentrification project in the past few years. The Castelo region behind the apartment is in a beautiful state of collapsing and decay, with amazing old mansions in an utter state of ruin just above the place, including one that looks like a full castle and miniature Pena palace that is currently a total ruin on Rua de Entre-Quintas. But, very safe -- absolutely no concern for safety, the mostly-ruined area of Castelo still has a few elderly residents living there, giving it an incredible quiet atmosphere in contrast to the rapidly-gentrifying downtown of Porto.
Based on the HUGE amounts of reconstruction going on in Porto, I could imagine this place being ideally situated in about 5 years. As it is, it's a bit frustrating that it's like 100m from the centre of the city, but it takes you 40 minutes to walk there, as there is no taxi boat or bridge crossing the river just in front! There is also no public transport of any kind along the road in front of the apartment; you have to walk about 10-12 minutes to the closest public transport. Fortunately, Uber is extremely cheap in Porto, so we made ample use of that, and for 2 people it cost less to Uber into downtown (~€3.50) than two bus tickets would have, in any case.
The welcoming carafe of Porto was a nice touch!