We think this is the best locations in all of Poipu. Right next door to the beach at the Sheraton, gorgeous ocean and sunset views, away from the "big" roads, easy 10-15 minute walking distance to the best shops and restaurants. Some of the best snorkeling in Poipu is a 5 minute drive.
The condo is great — well-equipped with everything you need for a family or group, quiet corner location on the far end of the complex, wonderful trade wind breezes that make all the difference (we didn't use the AC at all). We watched sea turtles and manta rays from the lanai and the front bedroom. We took the 1 minute walk across the small road in the mornings to stand on the rocks at the water's edge and get a closer look at the turtles (just feet away) while we drank our coffee.
The property managers are great. Jessica in particular was wonderfully helpful. She helped us rearrange our booking dates when plans were disrupted by the pandemic. She provided great advice before we arrived (booking restaurants and rental cars well ahead of our trip, for example.) The checkin/checkout process was hassle-free (no waiting, could pick up/drop off keys onsite).
Would definitely stay here again (and again...)