I stayed João's apartment for a week or so. It is very stylish, recently renovated apartment. The view from the balcony is amazing! The location is perfect, I didn't use public transport at all, you can easily walk around. It gets a bit noisy during the night as apartment is located on a popular street. Bedroom is situated on the opposite side of the building, so it is quiet, the noise didn't bother me at all.
João is an excellent host, he offered many local tips and was very quick to respond to any request. Highly recommend this place!