Reading through past reviews, I'd say we experienced a lot of the same things as everyone else.
Pros: The view is absolutely incredible - I've seen Diamond Head from other angles when staying in Waikiki, but this view was unreal. The rental is very spacious and was the perfect size for my family (5 of us). Having free guaranteed parking was great, but it was a little tight for a minivan and we needed to pull out of the carport to open the passenger doors. It was a quiet neighborhood that felt very safe, and it wasn't too far a drive to most places on that side of the island. Chandler was very responsive and was super helpful whenever we needed anything.
Cons: Like many others have mentioned, there were some issues with the appliances. The dishwasher was broken when we arrived and got repaired our second to last day there. The freezer and refrigerator both quit while we were there, causing us to throw out some of the food we had purchased (Chandler did let us use her fridge to store some of our items until the fridge was repaired - took about a day).
I've stayed at a few different places on Oahu (mostly in Waikiki) and this was by far the nicest. The amount of space at the rental is worth it if you're traveling with your family. The view is fantastic and the rental comes fully furnished with just about everything you'll need in the kitchen, bathroom, etc. Thanks for a wonderful stay!