André's place was a gem. Thoughtful and cozy decor (a breath of fresh air from all of the out-of-the-box IKEA you see everywhere), clean, strong Wi-Fi, and has everything you need for a comfortable stay. The bathroom is on the small side, but there's plenty of hot water and good water pressure. A word of caution, the stairs are more narrow and steep than what you might be used to. Take care and walk slowly!
André personally welcomed me when I arrived late at night to Lisbon, and was happy to answer all my questions and provided some great local tips. The Madragõa neighborhood is old and quiet, and well situated: a little bit away from downtown but very close to buses, trains, the 28 tram, and walkable to almost all the areas of interest. Lisbon is very compact, so don't let what you see on the map discourage you. And as a solo female traveler, I never once felt unsafe in the neighborhood, even walking around late at night.
The last thing is around noise sensitivity, which is obviously very subjective, so I'll just say that you should have reasonable expectations. The house is old and not totally sound proof. It is also next to a small restaurant so you may hear some street noise on busy nights (if you live in a city, it probably won't bother you).
Overall, I had a great time staying here and would recommend it to anyone who wants to avoid the tourist traps and experience a really special slice of Lisbon.