Cairns Flights

Cheap Flights to Cairns

Book a flight to Cairns without pushing your finances too hard, with the assistance of experienced travel consultants find the best airfare deals for flights to Cairns, Search and browse through prices from range of airlines to ensure you have the cheapest offer on any available flights to Cairns. Cheap flights and airline tickets are offered by leading European and Fareastn airlines, just make your choice and reserve your flight to any destination in Cairns with Travel House UK.

Fare shows are based on the lowest price obtained from search through our search engine during last week. As fares can fluctuate, there is no guarantee that a fare will be available at the price stated and therefore should be used as a guide only. prices are exclusive of taxes.
Travelhouseuk on iGoogle

You can now add our Flight Search Gadget to your iGoogle homepage. Search for cheap flights from your Google homepage!
 


1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-15, 15' at line 1

SELECT `page_offers`.*, `regions`.`region_name`, `destinations`.`destination_title`, `destinations`.`destination_code`, `destinations`.`destination_slug`, `airlines`.`airline_title`, `departures`.`departure_title`, `departures`.`departure_IATA`, `departures`.`departure_fullname`, `airlines`.`airline_code` FROM `page_offers` INNER JOIN `destinations` ON (`page_offers`.`city_id`=`destinations`.`destination_id`) INNER JOIN `airlines` ON (`page_offers`.`offer_airline`=`airlines`.`airline_id`) INNER JOIN `departures` ON (`page_offers`.`offer_departure`=`departures`.`departure_IATA`) INNER JOIN `regions` ON (`destinations`.`region_id`=`regions`.`region_id`) WHERE `page_offers`.`offer_status` = 'Active' AND `page_offers`.`offer_class` != 'Business Class' AND `page_offers`.`offer_class` != 'Business Direct' AND `page_offers`.`city_id` = 22 AND (`page_offers`.`offer_for` = 'F-A' OR `page_offers`.`offer_for` = 'O4F') AND `page_offers`.`offer_validtill` > DATE_SUB(CURDATE(),INTERVAL 1 DAY) AND `page_offers`.`offer_mdestination` IS NULL ORDER BY `page_offers`.`offer_featured` DESC, `page_offers`.`offer_amount` ASC LIMIT -15, 15

[ S T O P ]