This north shore retreat was literally a block away from the ocean including a beach park that was less than a five minute walk from the condo. Most mornings, my wife and I sat out on the deck (on the fourth floor) to eat breakfast and watch the ocean. The condo is as described and pictured, including a washer and dryer, and tv with dvd player and wii. And even better, there were boogie boards and a snorkel set in the closet.
I would recommend having a car. We managed to check out most of the major north shore sites and beach spots, and the condo acted as a nice home base. The turtle beach was roughly 15 minutes away, and Waialua, (~10 minutes) had some great shrimp trucks (Mack's was our preference). And we ended up going to the Sugar Mill (~5 minutes) every morning for iced coffee and back in the afternoons for real fruit shaved ice.
Karen was very responsive and easy to coordinate with. She was even quick to respond and quickly resolve an issue that arose.
If we were looking to escape to a quiet north shore retreat again, we'd pick this condo because of it's accessibility, ease, and affordability.