Not sure about November rates... should be lower - one good option is La Vue which is locally owned and up above Sandy Ground - not on water but great view and nice rooms....

As noted prior Turtle's Nest could be good choice or Shoal Bay Villas if interested in staying at the other end of the island....