Our family of four had a great stay at Moreno's place. The location was in our opinion truly unbeatable. A literal 2 minute walk to the Queen's marketplace provided a grocery store, food court, and other shops to browse. The Waikoloa area is a great base to explore many of the island's top beaches (including Kua Bay, Hapuna, and Anaehoomalu all very close by).
We would not hesitate to return.