We (family + 1) stayed in this condo for 2 weeks in mid-July and had a great time - kids each got their own bedroom, my 13 year old loved the loft with its dedicated bathroom. Really nice lanai with a beautiful view of the ocean and the golf course. It is pretty centrally located if you have a car - Kona is 10 min away and there is a beach within a 10 min walk as well. The kitchen is pretty well stocked as well with plenty of pots and pans and accessories - we made breakfast every day and cooked a few dinners as well with no problem.
The owners were responsive and quick to fix any issues - our screen door wasn't closing right and they got a handyman out the same day to fix it. There is some beach equipment there - chairs, some flippers, beach towels, etc - we bought snorkel gear at costco which was almost the same price as renting it. There is a Longs Drugs and supermarket within a 3-5 min drive as well, but do note that most stores and restaurants close down around 9pm, and almost nothing is open after 11.
The community pool and hot tub are nice, but they are kind of strict on no toys in the pool and no excessive noise - if you are looking for a party condo this is not the place, def more towards quiet relaxing time (which was fine with us). The only thing that bugged us is once a week the workers use gas powered leaf blowers at 8am, and since you have to have the windows open to cool down it will wake everyone up, but it just happened a few times. The 2 bedrooms have AC but we only used them a few times when it got really hot, most of the time ceiling and vertical fans were able to keep everyone cool enough.
All in all a great condo to rent, esp if you have older kids that want their own bedrooms. Definitely recommended!