You will not find a better location than the Sand (#144). My lanai was directly across the street from the ocean! Half a block walk to restaurants, farmers' market, ABC convenience store, and a small beachfront.
It was comfortably and attractively furnished and very clean. Coffee maker, microwave, electric skillet provided. I only used the microwave, but it was nice to know that the others were there to use if I chose.
I will certainly stay again if it is available next time I come to Kona.