Being an Airbnb host myself, I felt that Miguel truly outdid himself. Our flight landed a bit late and he was waiting at the entrance of the building at 10PM to welcome us, and gave us a full personal tour of the apartment and things to do in the vicinity before handing the keys over. The flat is exactly as described in the photos. We had a short stay but it was a great one. It is not exactly next to the Ribeira/Duoro (Riverfront) but its a 15 minute (ish) walk and not too bad at all. The Balhao metro station is only a few minutes walk from the apartment, with a direct connection to the airport. There is a huge Balhao market a few minutes walk (a tourist attraction) with souvenirs and all the stuff you need. Restaurants are in the vicinity and cheap, along with a huge shopping mall.