We stayed in a 6-person private room (4 guys 2 girls), which had ensuite shower but shared toilet. Our experience wasn't as bad as some of the reviews, but maybe its because we had a room to ourselves. Most of the clientele appeared to be 20-30 year old guys who probably never ventured out of the red light district. I would not consider for one second staying in a shared dorm here--seems like it could be too rowdy or shady.
The room was unexpectedly clean with spotless sheets, and no weird smells. The stairwells/hallways, however, sometimes smelled like marijuana and fried chicken, of which remnants could be found on the floor at at 3am.
Pub on ground floor was never an issue with noise. Same with the street--it was at the edge of a canal, a stones throw from the red lights. It was only populated with drinkers during football matches. Staff was anal about security, but thats a necessary inconvenience for staying near the red light district. Only one key per room and we had to leave it with the receptionist when the room was empty. Also, you had to be buzzed in by the staff to get up to the rooms.