If you don't want to stay at a resort in Koloa/Poipu (which I definitely didn't!) it's hard to imagine a better place to stay. The villa has been beautifully updated with new flooring and kitchen. Air conditioning is a godsend when it's really hot outside, and the lanai is wonderful when it's not. Kitchen is well stocked. Bathrooms had shampoo, conditioner, and body wash, but no hand soap (may want to request this as we had to go buy some.)
Location is ideal, walking distance to the beaches, resorts, Long's, shops, and the local market. The only issue I had was a miscommunication with the management company. (They sent the cleaning crew in before the negotiated checkout time, which they resolved, no harm done.) Other than that the management company was communicative and seemed like they'd be great to deal with.