If your main reason for the visit is partying at Ballermann everyday until morning, the apartment should be fine for you. The location and proximity to Schinkenstraße is really perfect for that.
For us it was a bit too noisy and not comfortable enough. The lack of an AC was definitely not helping.