Ours was right by the pool and near to the beach but we had a garden and grass between us so not too close to the pool!! It felt as though we had our own garden which was lovely in that heat. I am sure we would have been equally happy with a balcony though as you get different views, I am not sure if any of the select rooms are upstairs or not though, sorry.
If you go on the photos we put some on last April and there is one from our room to the pool and to the beach, in the Coral Sea album, I think we called them CSR April..have a look, might give you more idea!