Our family of 4 had a wonderful stay in this condo. The view out the front/ off the lanai is fantastic. We would sit out on it every morning and have coffee & breakfast and watch the activity on the water (including spinner dolphins a few mornings!).
We were there in the summer (late Aug), and although the condo doesn't have air conditioning, it wasn't a problem. First, it wasn't horribly hot (85 during the day) and not very humid. Once the house was opened up (windows open), there was a strong, constant breeze through the house from the trade winds. There are also a couple fans in each bedroom to use.
The kitchen was well stocked, and we found beach chairs, beach towels, snorkel gear, cooler, boogie boards, etc. to use while we were there. The kids spent a few hours each afternoon playing in the pool. The house is comfortable, with all the amenities you'll need, and decorated in Hawaiian décor.
The condo is well situated within Kona, just under a mile walk to the downtown area. It's a 5-10 min drive from Safeway and Target. There is a terrific coffee shop on site -The Green Flash. The location allowed us to explore beaches up and down the coast (Maini'owali and Hapuna were 2 gems). Two Step and Kahalu'u were both great snorkel spots, and at least during the summer, calm enough for the kids. The host recommended a stop at the Hilton lagoons, which the kids loved.
Overall, a fantastic vacation, a great condo, and we wouldn't hesitate to stay there again.