The apartment was in the most stupendous location, 3m walking from the Ribeira where there was plenty of life and around 15 minutes to the main attractions. We didn't feel the need to take any transportation at all.
The apartment was squeaky clean, there were only a few amenities missing upon the check in but that was quickly fixed by the host after we mentioned it.
For a weekend it is perfect, perhaps for longer stays mostly for the lack of a kitchen another place would be best suited.