Nice surroundings and near the Porto best areas. However it is overpriced and the construction is not soundproof. So for light sleepers it might be an issue.
Re the room, it requires a painting and a new mattress.