The condo unit is a great and affordable spot for a short stay. (we were there for our first night on the island.) As far as location goes, it's perfect for those that want to be in the middle of Kona and be able to walk everywhere. It's close to the waterfront, restaurants, and shops.
We always stay in Kona our first night on the island and our preferred motel isn't allowing guests to stay only one night anymore, so Nev's place was a great find and substitution for us.