The Aqua Bamboo is on a very busy and noisy street. It is nice, overall, and you can get discounts to about $75 per night. Just search online.
We are staying in a privately-owned condo in the hotel and would not recommend this to anyone. The carpet is stained and smelly, the AC leaks all over the Lanai, and the bathroom sink is plugged up. The owner doesn't take a lot of care with cleaning, and the refrigerator was not working when we got in for our month-long stay. We are paying $1,875 for the month. The owner did drop off a new dorm-style refrigerator within three days of us letting her know that the built-in one wasn't working, but she had to have known that it was not operational before we started our month stay.
The location of the hotel is only a block from the beach (and to the Duke webcam that you can find on the Internet.) The bus runs right up the street and there is a lot to do within walking distance.
Besides being somewhat old, the hotel is in good condition and if you stay up in the higher floors, I imagine the road noise is not so bad.
They have one hour free happy hour on Thursdays that is not so bad, and the staff seems friendly. The hotel seems to be full on Fridays and Saturdays, but has open rooms during the week.
Oh, and they have a ground-level pool and small hot tub (only big enough for one couple at a time.)