It's a great place to stay, especially considering its location. It's in the middle of all the excitement in this area. We didn't have much trouble with the noise though.
The only downside was the second smaller bed. It feels a bit like sleeping on a bag of rocks.