We stayed for 2 weeks in October, was a great condo, anything you needed was available within the condo, fully equipped kitchen, coffee machine, beach gear etc. Walking distance to the Sheraton and very short drive to shopping area.
It was a great base to explore the Island and only a 15-20 min drive to Kona. We also used the Sheraton trolley shuttle, $2 per trip, kids loved it!
I would recommend this condo, and would definitely stay there again. Does not have AC, but the condo stays cool being ground floor and plenty of ceiling fans. The outdoor area is great to chill out! The pool area is perfect for adults and children.