We loved staying on this part of the island! Although you're not technically on the North Shore, you might as well be. If you drive for about 10 minutes it starts to feel like you're stereotypical North Shore vibe. We were there in January and the weather was great for swimming, surfing, walking around, whatever you want to do. The house was nice and tidy, Geoff met us when we got there and was very nice, and they had tons of boogie boards, surf boards, and toys for our kids to take to the beach.
Also... The peninsula just a five minute walk down the street is STUNNING. I loved coming home from a day at the beach and just sitting there and looking at the huge waves crash into the rock formations around the peninsula.
There is a grocery store very close. The Polynesian Cultural center is super close if you want something more touristy, and just like anywhere in Oahu... you're close to amazing beaches that are empty and close to amazing beaches that are also full. You pick.