Select QCA.*, ISNULL(NULLIF(LTRIM(RTRIM(Overrides.Amenities)), ''), QCA.Amenities) as Amenities, ISNULL(NULLIF(LTRIM(RTRIM(Overrides.Directions)), ''), QCA.Directions) as Directions, ISNULL(NULLIF(LTRIM(RTRIM(Overrides.Description)), ''), QCA.Description) as Description, ISNULL(NULLIF(LTRIM(RTRIM(Overrides.Special)), ''), QCA.Special) as Special from qrycustomersall QCA LEFT JOIN (SELECT CO.* FROM CustomerOverrides CO WITH(NOLOCK) INNER JOIN ControlModule CM WITH(NOLOCK) ON CO.ControlId = CM.Control_Id WHERE (CM.ModuleId = 94)) Overrides ON (15 = Overrides.ControlId AND QCA.CustomerId = Overrides.CustomerId) where QCA.customerid = 11605 and ( QCA.control_id = 15 ) and QCA.show = 1
Comfort Inn Bay of Isles is a 4 star premier motel located on the beach front in pristine Esperance. Features include Spa Suites, Executive and Deluxe rooms. Enjoy dinner in Eljays fully licenced restaurant and bar or chat with friends in the central atrium featuring an outdoor swimming pool
All rooms feature reverse cycle air conditioning, ensuite with separate bath and shower, 50 inch TV & includes Foxtel with 7 sports channels, 5 movie channels, as well as news, music, kids, and drama series , telephone and free WiFis.
Eljays a la carte restaurant and bar is open every evening. Both continental and fully cooked breakfast are served in the Eljays daily. Room service meals also available.
The Pool and Atrium area features an outdoor swimming pool .
The air conditioned conference room seats up to 30 in comfort with full conference facilities available.
Directions: Centrally located on The Esplanade in the town centre of Esperance. Follow the signs.
Our Opening Hours are 6.30 am to 10.00 pm
Tariffs range from $140
to $170 AUD (Australian
Arrival Time 14.00
Departure Time 10.00
Bar/ Cocktail Lounge
Internet Access Available
Cooked Breakfast Optional extra
Iron/ Ironing Board
Swimming Pool Outdoor
Non Smoking Indoors
Cancellation Policy / Terms & Conditions A 10% administration fee applies to any cancellations made up to 7 days prior to arrival. No refund is given on cancellations given within one week of arrival.