We had an excellent time at Geoff's place. the location was very central to both Waimea/Haleiwa as well as Kahuku and Laei. The parking was close to the unit. The condo pool was usually quite empty. We did use the Turtle Bay resort pool once (not part of the host unit), but we preferred the Resort Beach which was publicly accessible.
The unit was clean and modern although the top bunk beds are a bit hard to get into for younger kids and there is only 1 ladder.
The oversized fridge and dishwasher allowed for lots of storage and easy clean up.
There are windows that are screened but don't close all the way so can be noisy during rain storms or when there are people outside.
Grocery stores are nearby but if you want specialy or diet specific items I recommend stopping at Whole Foods en route.
Geoff was very easy to reach during the stay and we would definitely stay there again.
Highly recommend this place for couples or families.