Our stay at Maui Sands was great. The condo was well stocked and we loved having access to chairs, boogie boards, and extra flippers if we needed. The condo is definitely in more of a residential area. It was hard to tell exactly, but it seemed like most of the other residents lived at the location full time. I should note that although it technically is water front, and has access, the beach in front of the condo isn't one that you'd want to spend all day at lounging and swimming. There were a few things that weren't perfect- like the AC unit was broken when we were there but the host had replaced it with two standalone units for the time being which was totally sufficient. The condo sits pretty equally between Lahaina to the south and Kapalua to the north. I would recommend having a car in order to access the local beaches and restaurants, as most destinations we went to were about a 10 minute drive away. Overall, I would recommend Jay's place!