We stayed for 2 weeks and I felt like a local by the time we left. It's great for exploring Honolulu - almost everything is within walking distance if you enjoy walks, and you're literally 2 minutes away from Kuhio, where you can catch a bus to any destination on the island. It's secluded enough that it's quiet when you sleep, but close enough to walk to any restaurant, pub or attraction you want to visit. Make sure to go to Island Vintage Coffee in the Royal Hawaiian Center for their amazing lattes and food! There's a reason everyone orders their acai bowl.
If you're lucky enough to book a stay with Olivier, look high and low around the apartment because we didn't discover the snorkel gear and laundry basket until the last night!