The apartment is well located in the center of the old town. It is very clean and spacious enough for out family. I would be happy to stay here again.
I would say that the noise issue is a bit overblown. You are in the center of a town, loaded with bars and restaurants so of course it will be noisy. If you are a light sleeper, it may not be the place for you. But if you are used to the sounds of the city and you have some headphones, it is a non-issue.