I will be staying at the Half moon at the end of July. I know that its off season, so im going to keep my fingers crossed for an upgrade. Either way, i want to have a great location, does anyone know of any specific rooms to recommend... Closest to the water would be great! Thanks!