Few things you should expect:
1. It's a private community, so there is a gate guard checking your pass/vehicle when you arrive. It also adds another layer of safety.
2. It's about an hour drive into Honolulu and maybe 1:15 to Waikiki. If you want to spend most of your time in Waikiki, you should just stay in Waikiki.
3. This is the drier side of the island. it's not as wet, and therefore, sunnier days. (Read: A lot hotter!). There's no AC in the unit, so it can get Incredibly hot in the place mid-day, but semi-cool down during evenings.
4. You'll be greeted by a few Gecko's; they're harmless, and quite cute.
5. Good space that can accommodate 4 people, comfortably.
6. Shower pressure is powerful; you should have no sand left on you when you hop out.
7. Master bed was quite comfortable.
8. Cable TV was a nice surprise.
9. Internet is fast; one of the better ones we had stayed at.
10. Kitchen equipment and utensils were a bit disorganized; but if you use them, you'll probably use the same ones over and over and just wash those.
11. Roosters and Peacocks make their respective noised around the clock. This is common in the outer islands but not as common on O'ahu, except here.
There IS a bus (#40) that departs outside the gate, and travels all the way into Waikiki (Ala Moana). It departs 2x / hour, and cost $2.75 per person. The trip from the Airbnb to the last stop in Waikiki takes about 2hr 45 mins during mid-day (departing at 3pm)... so just an FYI. But, it is doable.