Canberra City YHA, Akuna Street, Canberra ACT, Australia

DISTINCT wp_posts.post_title destination_to, ( SELECT MIN(price_share) FROM wp_transfers_availability a_m_p1 WHERE price_share IS NOT NULL AND (a_m_p1.destination_from_id = 181 OR a_m_p1.destination_from_id = 0) AND (a_m_p1.destination_to_id = wp_posts.ID OR a_m_p1.destination_to_id = 0) AND DATE(a_m_p1.end_datetime) > now() AND price_share > 0 ) price_share_min, ( SELECT MIN(price_private) FROM wp_transfers_availability a_m_p2 WHERE price_private IS NOT NULL AND (a_m_p2.destination_from_id = 181 OR a_m_p2.destination_from_id = 0) AND (a_m_p2.destination_to_id = wp_posts.ID OR a_m_p2.destination_to_id = 0) AND DATE(a_m_p2.end_datetime) > now() AND price_private > 0 ) price_private_min, wp_posts.ID as destination_to_id

AUSTRALIAN NATIONAL UNIVERSITY is an inner suburb of Canberra, Canberra, Australia,2.1 km of Canberra’s Central Business District.
We provide luxury car hire melbourne from AUSTRALIAN NATIONAL UNIVERSITY to Canberra & Canberra Airport chauffeur driven transfers.