The location was great, and overall our experience was great. The only two heads-up we'd give to other guests are that:
1) the free onsite parking was limited (we never managed to get one of the free onsite parking spots, so we often parked offsite at the Kona Free Parking lot, across the street from the farmer's market), and
2) the bathroom's sliding door was broken (what was in its place was a shower curtain to provide some limited privacy).
Overall, we'd stay here again, and would recommend it to anyone looking to stay close to the heart of Kailua-Kona.