We had a mixed experience here. The property was great; we loved the pool and hot tub in the beautiful courtyard. But the room itself was perhaps the dirtiest Airbnb I've ever stayed in. The bathroom rug was badly stained, the fan was filthy, the walls all need a scrubbing and perhaps repainting. If you're not bothered by cleanliness issues, then you'll probably like this place a lot.
As far as location, Queen's Bath and Hideaways beach are both awesome destinations within walking distance (and both have parking challenges, so walking is a big advantage). Be aware that a lot of the most popular tourist destinations/activities are far away, especially with part of the North Shore currently closed. Waimea Canyon is two hours away; most tours like flying and ziplining are 45+ minutes. The nearby grocery store (Princeville Foodland) is the most expensive place on the island so stock up on groceries closer to the airport.