The apartment offers views of Diamond Head and Waikiki but is just above a bar which is open till late