I would 2nd the Azure Hotel. Nothing fancy but affordable and right on the waters of Simpson Bay Beach. Not sure if you can get just 1 night or not. I would think it would be possible if there are any openings.


mgh