Overall I would recommend this budget rental.
location: two small blocks from the beach, very convenient.
noise from outside/street: very loud - the unit faces Kuhio one of the loudest/busiest streets in Waikiki. The windows provide very poor sound insulation.
noise from inside / other units: very quiet - over many years of traveling to Hawaii, we have stayed in about a dozen different hotels/airbnbs in Waikiki and this is probably the quietest in terms of noise from other units. The walls are thick concrete, which makes it hard to hear the neighbors. The condominium complex (Kuhio Village) also has extremely strict rules about many things, including noise.
air conditioner: it is very loud and not very strong. Probably should be repaired/replaced.
cleanliness: other reviews mention bugs/cockroaches. We spent 8 days in the unit and we did NOT see any bugs. The cleanliness was at the level of an average hotel room.
Overall, we had a good stay and I would recommend it.