Our family of eight adults had a great stay at Josh's place! Sitting in the front yard with our morning coffee or an early evening cocktail with the waves crashing in and the occasional turtle sighting in was a really great experience. The description of the home and area is accurate - you're not likely to be swimming out front and your activities will likely be a drive away but the location is very central - easy to get to the North Shore beaches (Baldwin was our favorite beach for swimming and just down the road, we saw about 60 turtles hanging out on the beach at Ho'okipa Beach Park). It was also easy to jump on Hwy 30 or 311 to get to Lahaina and Kihei/Wailea respectively.
A few members of our family were initially a bit uneasy with the proximity to the boarded up houses but quickly settled in and felt safe. Chatted with a few of the locals fishing or hanging out in the area and they were lovely.
All in all - we had a great experience. This is not the Ritz Carlton but if you want an oceanfront home in Maui, you're not likely to find a better value than this.