BAYVIEW

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 = 191 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 = 191 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

BAYVIEW is an inner suburb of Darwin, Northern Territory, Australia,4.1 km of Darwin’s Central Business District.
We provide wedding cars from BAYVIEW to Darwin & Darwin Airport chauffeur driven transfers.