My roommate and I were in Kona for the Ironman and had the fortune to stay at David's lovely studio. The room is just how the photos appear and comes with a full kitchen (microwave, blender, oven, etc), including dish wear and utensils. There is a shopping center with a grocery store and restaurants nearby, which is within walking distance (about 1.3miles). There is a steep hill to climb to get there but the views are great at sunset.
The place is conveniently located between 2 great (but busy) beaches. Both beaches are within walking distance so it's nice if you don't have a car. If you don't mind the crowd these beaches are totally worth it! David even has beach gear to use, so we were able to go snorkeling and bodyboarding. He also let us borrow his coolers so we could have drinks on the beach :)
David was wonderful and promptly responded to any and all of my questions and was very accommodating with my schedule. I would definitely recommend this place to anyone who is wanting a relaxing stay on the Big Island.