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 = 50362 and ( QCA.control_id = 15 ) and QCA.show = 1
With its four bedrooms (two queen beds, two single beds, two bunks and two sofa beds to sleep 12), fully equipped kitchen, two comfortable lounges (one to watch TV and one to relax) and sundeck, this house will ensure a comfortable stay for large families/group bookings near the most beautiful beaches of Australia.
The whole property is non smoking (including outside the house).
Directions: From the post office, drive along Andrew Street towards the foreshore and at the roundabout with the fountain turn right onto the Esplanade. Drive past the railway into Smith street straight across at the stop sign, the house is the last one on the left hand side at number 36.
Tariffs range from $250
to $250 AUD (Australian
Arrival Time 14:00
Departure Time 10:00
Non Smoking Establishment
Non Smoking Indoors
Iron/ Ironing Board
TV Lounge Area
Cancellation Policy / Terms & Conditions Terms and Conditions.
Minimum 2 nights stay. Bond of $200 required. This will be returned upon satisfactory property condition report. Bond will not be returned if premises are not left in as clean a condition as on arrival or damages are evident. Any extra cleaning will be at a charge of $35/hour this includes emptying dishwasher cleaning out oven wiping out fridge or taking rubbish to refuse site if bins not put out on Sunday evening. Any extra beds used above that required for booking will be at a charge of $20/bed/night for duration of stay. A late checkout will incur a charge of half a days tarriff for the booking. Bank details for the bond will be sent in the itinerary after full payment has been made.
One nights accomodation payable if booking cancelled 1-4 weeks prior arrival.
One nights accomodation plus no bond return payable if booking is cancelled less than 1 week prior to arrival.
No refund if booking cancelled less than 24 hours prior arrival or until premises are rebooked.