I have a lovely apartment in Cologne with a green balcony.
It's only 5 minutes by feed to the student center, with a lot of bars and clubs. You can catch the subway (18 or 9) and in around 10-15 minutes you are at the Cathedral (Dom).
No parties (this you can do much better in the clubs and bars)
No smoking (only on the balcony)