My wife and two children stayed at the Aston Kona by the Sea over New Year's 2012/2013 for 8 days.
We stayed in a two bedroom condo. All I can say is that I was 100% happy with the apartment.
We were in unit 220, which is a two bedroom unit. The master bedroom is off of the living room and has sliding doors that can be opened. It had its own bathroom The second bedroom had two single beds and its own bathroom. The bedrooms were quite large and had ample room to store clothes in both closets and dressers.
The unit must have been recently renovated, because it was spotless and extremely well appointed.
There is a full kitchen with all the amenities including microwave, full stove, full fridge and a dishwasher. In addition, all of the kitchen utensils you could ever want are there right down to a rice cooker.
It is an open concept apartment. There was a large dining room table with four chairs.
All of the furniture was very nice and clean. There was a large screen flat screen television in the living room and a smaller flat screen in the second bedroom.
On the front was a balcony that overlooked the pool and had a view of the ocean (not a direct view, but at about 45 degrees. You can easily see all of the pool and the pool area.
There are barbecues by the pool area as well.
The beach in front of the building is a rocky one, they therefore have an area with chairs in a sanded area in front of the pool.
I wouldn't say it is a great spot if you want to lay on a true beach. However, if you like a pool next to the ocean, this is it.
There is no restaurant in the complex and really nothing very close. It is about 2km to the nearest set of restaurants.
I would definitely rent a car, as it will be needed in order to go to the local beaches and to go to restaurants. There is some under the building parking available and also an outdoor parking lot with ample parking.
There was daily maid service to clean the apartment and to change out the towels.
Expedia has a concierge travel advisor on site. We used her to book two of our outings. She was very knowledgable and pleasent to deal with.
Overall, I was extremely pleased with and have not hesitation recommended this complex.
The only caveats being that it is not close to a true beach and not close to restaurants.

We spent 10 nights in unit 420. It was clean, spacious and bright. We left the veranda door to the master bedroom open at night to listen to the surf and waking up to it was a highlight every single day. The staff were knowledgeable and helpful and having an on site 'Expedia Advisor' was great for figuring out what we wanted to do. As part of their training, they get to go on every adventure or to every location that they recommend.

For the room itself, there could have been more kitchen supplies; the knives were atrocious and we constantly ran out of cutlery and dishes (family of 4), but this is a small gripe. The only major issue I had was the master bed that clearly had gone past its due date by a few years and was collapsed in the middle on the left side. Made for very uncomfortable sleeps and a 'very good' instead of 'exceptional' review.

We were lucky to get unit 122. Beautifully redone, and so comfortable. The kitchen was very well equipped, making meals fun. The guys worked the BBQ, depending on how many mai tais the results were delicious. We traveled with my dear cousin and her hubby, and we were very comfortable. (need to find out the details on the Master Bedroom mattress, as we are shopping for a new one). The only drawback, was the bed in the second room. Would be nicer if it was a king as well, but we switched bedrooms midway through the week, so we each had the master for 5 nights. Loved the wonderful ocean sounds at night.

I needed to do payroll for our employees while we were on our trip, and the internet connection was iffy at best (not the fault of anyone involved in the condo), but we finally got all things done that needed to be done, and back on vacation mode. The office staff were most helpful. Rhoda our housekeeper was a gem!

Again, cooking was a treat in that well equipped kitchen, the furniture was so comfortable and really attractive. No negatives about the rooms or the facility.

We will certainly consider this location in the future. We travel to Kailua-Kona often.

Wonderful setting. Complete condos, so large rooms, lots of space and full kitchen. Patio directly overlooking the ocean. Very pretty view in the mornings. I would have stayed longer.

I didn't realize that there was no restaurant anywhere near the hotel, so the first morning was a little bit of a shock. They didn't think to mention that when we checked in. We only ate breakfast in that area, so by the second morning we had bought some coffee and rolls to eat.

The shuttle bus only goes by the hotel hourly (in both directions), so we had to take taxis a couple times.

Nothing to do there except relax (horrors!) by the ocean. No beach; just lava rocks. But they have lounges all over the ocean front, so it was very pleasant.

We spent most of the time away from the hotel. Lots of good restaurants at Kailua-Kona. And there's lots of things to see and do there.

Staff not terribly helpful. It's really a place to stay; their responsibility seemed to be to take care of the place, not the residents. But we didn't plan to do much there anyway.