static caravans for sale in sand bay