The apartment is in a residential area overlooking a canal, so the only noise is of distant traffic and trains (and the odd party boat, which is quite entertaining to watch from the balcony!). The double-glazed windows are very effective keeping the noise out but I kept them open in the lovely summer evenings.
I was lucky enough to borrow a friend's bicycle for my stay, which was great, but I think public transport would've been easy once you've done the walk down the street to the main road and/or central station. But if you like cycling, rent a bike: there are tons of cycle lanes and you can get everywhere within 30 minutes!
The apartment has everything you need - a nice table to work at, comfortable (hard) bed and bathroom with shower over the bath. The kitchen has a small fridge, dishwasher and cooking hob although I found it easier to pop out to recommended and local restaurants most of the time.
All in all, I'd recommend staying here. Check-in and out was super-easy and Franzi was excellent with all communications.