This was a good experience! Seeing the river in the morning is lovely!
The apartment is old, but it works well enough. We were there in august and even though there's no AC, there's a good crossbreeze and it doesn't get too hot. It's very spacious and I'd say it has everything necessary. The internet is a bit slow in the area, but we had no major issues. It's enough for one person to work online at a time, and it was also fine for streaming on Netflix or YouTube.
At night, I recommend keeping windows open only on one side of the house, it gets drafty and can slam the windows. Shower has good pressure and I liked the 2 mirrors in the bathroom.
There were a few hiccups here and there, but nothing to be mad about. Our host, Fernando, was very welcoming and friendly, and told us plenty about what one can do or find in the area. He was also easy to reach on Whatsapp. The apartment is close to the metro station, but we walked a lot anyway. Building is on an extra steep street and you have to go up 3 flights of stairs, so be aware of that. It wasn't an issue for us, but others might find it a bit much. There is a decent supermarket on the other side of the train station, and a couple of small shops down on Caminhos de Ferro.
All in all, I'd say it was good value for money and a positive experience !