Quick Availability Search

Arrival Date
(dd)-(mm)-(yyyy)
 

Need Assistance?
Activities
Call 1300 793 759 or +61 5665 8170
Accommodation
Call 1300 733 274 or +61 5665 8175

 
Adventures Today
BookToday
Restaurants Today

Holiday In Australia Australia Accomodation Apartments

Holiday In Australia Booktoday Australia Accomodation Apartments

Featured Accommodation

There is error in the sql query
SELECT * FROM `hotel` INNER JOIN `featured` ON `hotel`.`hotelID`=`featured`.`featuredHotelID` INNER JOIN location ON hotel.hotelLocation=location.locationID WHERE `featured`.`featuredExpiry` >= '2012-01-28' AND `featured`.`featuredCurrent` = 1 AND `featured`.`featuredLocationID` = `hotel`.`hotelLocation` AND `hotel`.`hotelCurrent` = 1 AND (hotelLocation = ) AND locationCurrent = '1' ORDER BY `hotel`.`hotelRating` DESC,`hotel`.`hotelName` ASC