Our expectations were very high, and Resoritca's Vista Waikoloa property delivered in every way. The place was clean, everything worked, all the expected kitchen gadgets (and more - including a blender for frozen drinks) were there. We made lots of Pina Coladas and Margaritas, and the refridgerator's ice maker was able to keep up. The maps of the area were helpful, even though we've been to Waikoloa several times. The lanais, with their high-end furniture, lighting, fans, wet bar, and closet full of beach/pool gear, were very nice also.
The unit came with a pass for the pool area at the Hilton, which is just a 7 minute walk away. Also, quick access to the Marriott with it's beautiful beach that has coral for snorkeling on the RH side.
The Vista Waikoloa has its own pool, which is nice, and quiet. Also has a good fitness centre available 24/7, and an outdoor covered BBQ area (we didn't use this, but it looked nice - and there were multiple BBQs - I'd guess 6 or more).
Lots of shopping and restaurants in the area. They're all within an easy drive (2-3 minutes), but there were lots of people out walking at all hours - you could walk to most restaurants in the Waikoloa Beach area in about 10-15 minutes. If you go here, be sure to eat at the Lava Lava beach club, but make sure you get a reservation. Great food and atmosphere.
Nothing in Waikoloa is cheap, but most places are reasonable and inline with what you'd expect to pay in a premium resort area like this. The grocery store in the Queen's Marketplace is a bit pricey, so you may want to buy groceries in Kona.
Overall - I'd highly recommend this place, and plan to return.