The house is small but efficient and comfortable, 3 people can adequately stay in there. It's furnished with all the basic needs and it's well ventilated, so you can sleep comfortably even in summer.
The neighborhood is lively as there are plenty of markets, bars, shops and restaurants nearby, within walking distance. The street is isolated and usually quiet, but there might be some noise at night from people returning from bars, etc. especially in weekends and in summer.
Public transport is easily reached by foot (tram and bus stops less than 5 mins away, train station 10 mins away).
I didn't meet Nino in person, but he's very responsive, helpful and easy to communicate with.
In conclusion, I'd say this house is great for both nightlife and tourism as everything you need is pretty much within walking distance.