The good: three large beds for what we paid at Turtle Bay is a good deal. Great for a family with 2 kids. 10 min walk to Turtle Bay Resort (where you could sit at the nice oceanside/poolside bar for sunset), private, quiet, very clean and just like the pictures. The A/C unit was enough to cool it down in the evening and sleep well in combo with plenty of fans. Keep in mind our trip was during the late fall, so I cannot speak about summertime. I think there were also boogie boards and beach chairs but we didn't use them.
The only minor issues were that its a bit dark inside (again just like the pictures, but who goes to Hawaii to sit inside?!?), its a bit light on a few items (no laundry detergent, just a couple small bars of hotel soap) and it took a few minutes to find the right condo at night (numbers are small, not lit and on the side of the building).
Overall a great spot, especially what you get at that location for the price.