The location is fantastic in terms of proximity to all of the wonderful things to do on the North Shore. We loved beginning located within such an easy drive to so much of what we love to do on Maui.
The downside of the location is that the bedroom faces the highway. You must close the windows to sleep at night. It's not normal car noise -- it's on a sharp curve in the road which means that the large trucks that travel on weeknights use their air brakes around the bend at 1 and 2 and 3 in the morning. There's nothing that can be done about this. You might not mind it for a night or two, but we stayed for a week and by the end of our trip we were bleary-eyed from sleeping so poorly for so long.
I do not recommend staying for as long as we did in this condo (seven nights) as it is not very comfortable. The futon is a rock, so don't count that as a sleeping space (we went and bought an air mattress for my ten year old to sleep on the floor because the futon was impossibly uncomfortable), and the bed in the bedroom is actually two mattresses (no box spring) so it's very springing (we called it a trampoline bed).
For the location and the price, this is a fine place to stop over for a night or two, but not a place to settle in for longer. It's loud (traffic) and hot (no air conditioning) and there's no "ocean view porch" as the description states -- it's a yard facing porch with a five minute walk to ocean access that is difficult to find.