Joao's place was great! It is in an excellent location. We had a fantastic view of the Douro and close to everything, including Sao Bento train station. There is lots of activity below on the riverfront but quiets down later in the evening. The stairs and hills are a bit of a challenge in the area so dont bring big suitcases, you have to walk to the apartment due to its location. We walked from the train station and it look about 10-15 minutes. Lots of restaurants nearby. We drank lots of great wine and port too. A must is a tour of the Douro Valley. There are plenty of tours.
Joao personally checked us in and gave us TONS of info on the city and communicated with us throughout our stay.