We enjoyed our stay at this condo very much. Very clean, well equipped kitchen, lots of towels. The beach equipment was helpful, but some items (one of the beach chairs and one umbrella) were broken and nearly unusable. But there were brand new beach towels (tags still on) which was awesome.
The condo is about 10-15 minutes away from the main stretch of Kona on Ali'i drive, and right off of one of the major highways so very decent location, but you need to plan on driving pretty much everywhere - not a ton within walking distance besides a tiny convenience store.
One thing to note is this is a second story unit with no elevator, so you will need to plan on carrying all your luggage up and down two rather long flights of stairs. The views make it worth it, but if someone in your party struggles with stairs, keep that in mind.