We really loved our stay at the Sands of Kahana resort. This condo is one of about 50 units that are privately owned in this complex, the rest are time shares. I mention that because it's truly a resort, not someone's home, and all the guests are there to vacation and have fun, splash and make noise, so there's no worry that you will annoy the neighbors/locals living next door.
The location is great, Kahana is about 10 minutes north of Lahaina, so it's easy to drive there and visit and get back without it being a huge effort. Down the street from a very nice public beach, we generally went to the beach at the resort though. The beach just outside the resort is a great place to swim and snorkel, no need to drive or walk somewhere just to go swimming in the ocean, which was great.
The unit is on the ground floor and looks right out onto the ocean, beautiful view, it was the reason we decided on this particular place to stay. I wanted to hear the ocean and be able to enjoy the view whenever I wanted. I was not disappointed! The unit is also really close to the beach, pool, and restaurant, so the kids could even run down there by themselves and we could watch them from the balcony.
The amenities in the place are standard, nothing is super updated but we didn't mind, we just wanted a good value and location, and didn't care about granite countertops or anything fancy. The furniture on the patio has been replaced with nicer items, and the beds in the spare room have also been updated, it's a bunk with full sized beds, and one queen size bed. So that room could accommodate adults or kids - We could have easily had our family of 4 sleep in there comfortably. That room also has a mobile air conditioner, the rest of the house has no AC (but we didn't need it). One cool thing is the ice maker in the fridge is super strong and makes TONS of ice. In case you want to cool down or make a smoothie or something, or use it to keep an ice chest cool for the day.
The unit is stocked with boogie boards, beach chairs, laundry detergent, towels, etc. We used the washer and dryer a lot to clean towels mostly, but also clothes during our stay so we didn't have to pack as much. It would be great if they had an ice chest in there for day trips - we ended up just putting ice in a ziplock bag to keep our food cool when we went out on a trip. Or you could buy one there, or bring one...
All in all I highly recommend this location mostly for the view and the resort amenities and the fact that it was very family friendly. I would say if you are a couple looking to have a quiet, romantic getaway, this place is definitely crawling with kids that scream and sometimes cry and splash and make a lot of noise, so just beware. It was perfect for us, maybe not so much for honeymooners.