This is a primo location. Walking distance to queen's bath and hideaways beach, which is excellent since these spots are awesome but have limited parking (you will see cars littered with parking tickets around these locations). Hideaways is a nice secluded spot which is great to swim and tan but also has surprisingly good snorkeling.
Great access to all north shore locations from the unit, including Tunnels, Ke'e, the Princeville airport, Kilauea, and Hanalei.
The unit itself is a beautiful, small studio with a very nice bathroom. The kitchenette is small but effective with a minifridge and a microwave. Plenty of room to store fresh fruit and cook some pineapple bacon kielbasa from the farmer's market. The outdoor patio is private but has a nice view of some local vegetation behind the golf course. Great place to read or have a glass of wine.