Stayed here for a week while in Maui. The location is pretty good if you want to stay in Lahaina, pretty low key area. There wasn't a lot of things to see/do in Lahaina, so we mostly drove towards Kihei, Paia, Kahului area for sightseeing, hikes etc. The condo is close to front street where shops and restaurants are ( about 10 min away by car). Around the condo itself there's plenty of restaurants food trucks, coffee shops to keep you happy if you decided not to drive anywhere. The beach right in front of the condo isn't accessible but if you walk 5 min down in front of the farmers market area, there's a small little beach area to enjoy if u have little ones. There's also a park right in front with a small play ground. There's also plenty of sandy beach towards the hotels on the opposite side, though I don't know how the waves/water is on that side as we mostly drove towards kihei and paia for our beach days.
The condo itself was spacious, the balcony faces the pool area but you get privacy from the trees in front. The AC throughout the condo was nice to have during really hot days. The beds were comfortable. There was only 1 bathroom but we managed to make it work with 6 adults staying in the condo. The kitchen had plenty of things to use if you decide to cook at home. The condo itself was clean except for the floors which are carpeted. But I guess that's expected as there are plenty of guests that stay there ( I would bring house slippers if you're particular about that). The throw pillows on the bed were visibly dirty and could use a wash but I just took those off the bed and put them away. Plenty of beach towels for the beach, some kids life jackets, snorkeling equipment and boogie boards to take to the beach. Overall a good place to stay.