The location is great, the noise is indeed extremely loud and just accept you will not get much sleep before 2am from Thursday to Saturday. I had silicone earplugs but that does not help when even the bed vibrates! But I had been warned so it really was my choice.
About 10 mins walk from Third St Promenade and lots of shops and restaurants so if you don't mind loud music on weekends, this was a good option. I believe there is paking too although I did not need it.