There are only two buildings that are waterfront..Marina and Flamboyant. I would think the only guaranteed way to get those would be a rental from an owner.

There are other units that have a nice view of Simpson Bay but are not ON the water (and strictly speaking I guess the Marina building is also not ON the water)

The SB Villas all face the Bay but do not have direct water access (like the Marina)