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 = 11582 and ( QCA.control_id = 15 ) and QCA.show = 1
Directions: Esperance Beachfront Resort is located on the Esplanade mid way between the Tanker Jetty and the town centre. From Norseman/ Kalgoorlie follow Norseman Rd until you reach the ocean and turn left into the Esplanade. We are located 300 metres on the right. From Perth enter from Sheldon Rd, follow to the end (Ford dealership is on the corner) turn right and follow the road to the Esplanade. We are located 300 metres on the right. A three minute scenic walk from the centre of town. Situated between the historic Tanker Jetty and the town centre right on the Esplanade.
Tariffs range from $120
to $180 AUD (Australian
Arrival Time 14:00
Departure Time 10:00
Internet Access Available
Iron/ Ironing Board
Cafe/ Coffee Shop
Mini Clothes Line
Non Smoking Establishment
Non Smoking Indoors
Cancellation Policy / Terms & Conditions If there is a cancellation within 24 hours of the arrival date the full amount is non refundable unless the unit can be re-booked for the cancelled dates.
PLEASE NOTE OUR CANCELLATION POLICY FOR SCHOOL HOLIDAYS AND LONG WEEKENDS:
if booking is cancelled less than 7 days before arrival one night accommodation fee is charged if cancelled less than 24 hours prior to arrival the full amount will be charged unless the room can be re-booked.