The apartment was stunning from the very moment we walked in! The wifi works great! Massive choice of entertainment, including a ~60 in TV (with Roku like device w/ YouTube, Netflix, Spotify, etc), and a fully operable custom computer with usb/card readers (I couldn't get my camera card to read, but it was still great for looking up important travel information! Not to forget the custom speaker system in the bathroom (plays jazz music).
The back window opens right on to the alley behind the apartment with lots of wonderful people and food. Very nice hustle and bustle; I liked to leave the window open during the day. At night time, you definitely can hear a bit of noise from the bars down the back alley, but it definitely wasn't a problem (my girlfriend is a light sleeper, and she never once woke up).
Overall an awesome place extremely well located. It's near a university so there's tons of hip atmosphere.
Also, if you need to print, there is a internet/laundromat down the back alley.