The location is great for the airport, not bad for the touristy Kailua Kona, and some great beaches (though the best one requires a jeep to get to).
The apartment, at least when we were there, is a work in progress. The furniture hadn’t arrived, so it was rather spartan— you wouldn’t want to hang out there. The kitchen is nice, but without a stove, rather wasted. But we were there to sleep after a day’s activities, and the bed was comfortable, the bathroom has a nice shower and amenities.
So overall, a good place with great potential.