The location is great for exploring Lisbon, but the noise from the bars and the streets will keep you up till 2 am every night - no exceptions (only Friday when they close at 3 am).
Also, the apartment does not look like the pictures. The yard is disgusting and the mirror in the bathroom is broken. There are stains and cracks on the walls. There are brown stains in the ceiling. Generally, you should stay here if you want a base for exploring the city, but not a place to hang out.