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 (40 = Overrides.ControlId AND QCA.CustomerId = Overrides.CustomerId) where QCA.customerid = 11536 and ( QCA.control_id = 40 ) and QCA.show = 1
Comfortable clean accommodation.With on-site licensed restaurant. Parking at your door. BBQ and pool area. Set in lovely cottage gardens.
Our Opening Hours are Restaurant open daily from 6pm
Tariffs range from $90
to $160 AUD (Australian
Arrival Time 14:00
Departure Time 10:00
Internet Access Available
Cooked Breakfast Optional extra
Non Smoking Establishment
Non Smoking Indoors
Wine Glass/Bottle Opener
Cancellation Policy / Terms & Conditions A cancellation fee applies to all cancellations. Fee being $25.00. Cancellations within 24 hours of arrival date are charged at 1 nights stay. A no show forfeits all payments. Thankyou for co-operation in this matter.