We stayed here the week between Christmas and New Year's. The apartment was super spacious, great location, and the ease of checking in and out at weird times was much appreciated. The kitchen was well-stocked with a coffee maker, water filtration system, as well as cleaning and paper products. The hot water worked OK for us (though you definitely can't use the showers at the same time), as did the Wifi.
Most of the nights we were there the neighborhood was quiet and peaceful - some normal city apartment noise but nothing out of the ordinary. But, the hotel across the street has a dance club on the roof, and on New Year's Eve they had a very loud dance party, including a flashing light that lit up the bedroom of the apartment past 2 AM (I have no idea why they were pointing a bright light across the street, but they were). It didn't bother us that much, but we also live in a noisy city and have a pretty high noise/light tolerance, but beware big party nights if you do not!