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 = 65439 and ( QCA.control_id = 15 ) and QCA.show = 1
Fully self-contained two storey house that sleeps up to 8 people, town central, very close to the beaches, the shops, restaurants and cinema. The house offers 2 bedrooms downstairs (one king size bed, one single bed and one double ), with a bathroom (shower and spa bath), fully equipped kitchen with de Longhi coffee machine amongst the various appliances to make your holiday that much easier and comfortable. Also downstairs a very comfortable lounge, a washing machine and dryer, BBQ, double car port and room for a boat, and fully enclosed garden (accommodation is dog-friendly by prior arrangement, conditions apply). Upstairs is a third large sleeping area with a king size bed and two king single beds, bathroom and separate toilet, lovely balcony. The TV’s have Foxtel. And the house is air-conditioned.
Directions: From the post office, follow Dempster street going south, through the William street roundabout, then trn left into Taylor street, number 8 is on the right hand side.
Tariffs range from $100
to $260 AUD (Australian
Arrival Time 14:00
Departure Time 10:00
Non Smoking Indoors
Pets by Arrangement
Iron/ Ironing Board
Fishing Groups Welcome
Non Smoking Establishment
Cancellation Policy / Terms & Conditions If cancelled 24 hours prior to your arrival date there is no cancellation fee. This excludes Christmas and Easter. Christmas and Easter you need to cancel 28 days before your arrival date to avioud a cancellation fee or one night will be non refundable (there is also a $22 cancellation fee for the Visitor Centre booking service).
The owner will require credit card details on arrival as a security for any damages and/or cleaning above the norm. Please leave the house as you found it on arrival thank you in advance.