The Waikoloa Beach Villas are a great location right next to A Bay, there is a shopping plaza next to the condo which is great for grabbing quick groceries or coffee. The grocery store is very expensive ($10 for 5 bagels).
The villas are fully equipped with kitchen utensils, pots/ pans, washer dryer etc. The complex pool and jacuzzi are a 2 minute walk from the room. The private garage was nice to have and had some beach chairs available for use.
The only downside to this condo is that you will hear your upstairs neighbors footsteps. The floors seem to be very thin so you will hear every step they take.