The view is amazing and the beach right outside is great for snorkeling. There is some what of a natural breakwater about 30 ft off shore, making the water relatively calm most of the time. You will see quite a few sea turtles swim through the area, easy to see from the balcony, not so much while in the water.
The condo is nice, but do remember there is no AC, so you are relying on fans and an ocean breeze. We ended up sleeping on the pull out couch next to the balcony, as it got a bit uncomfortable in the back room. That being said, it is so relaxing to fall asleep hearing the waves crash on the shore. The building is relatively quiet and parking isn't an issue.
The area is close to a couple spots to eat (walking distance), a super market down the street and a few minute drive to the hotels is a great food truck lot. I highly recommend spending a day(s) at Kapalua Bay Beach, about a 10-15 min drive north.
All in all, a good place to stay. =)