We stayed here for the Ironman World Champs. The location was perfect - close enough, but not right amongst all the noise. Very close to the supermarket, and walking distance (200m) to the main Kona shops, restaurants, and all things to do with the Ironman Event.
The apartment had EVERYTHING we needed, and more than we expected - didn't expect such a well equipped kitchen. The pool and laundry area were nice and easy. The local residents were all friendly. There wasn't much noise after dark, except air con units next door, but it didn't bother us. We didn't use the air-con in the unit, as having the windows open and fans on was enough. The lanai/ balcony is secure and we also kept the sliding door open most of the time. We didn't spend a lot of time at the unit, as we were out a lot during the day.
The host has a policy of no bikes in the unit but was kind enough to agree on letting us keep a race bike inside as long as it was in a cover, which we respected.
We would definitely stay here again.