We absolutely loved our stay! The apartment is in the main hip area for locals with amazing cafes and restaurants in every direction.
It is out of the central station area, but is much more family friendly and is only a 5 min (maybe less) tram ride right into the heart of the red light district and central tourist area. It is one street all the way up to the central station.