Visita Playa Yundigua ida y regreso en lancha - ViveGorgona

Isla Gorgona, Colombia

$22.000

Check Availability

Available
Not Available
Seleccionado
Tour type: Daily Tour
Duración:
Maximum number of people: Ilimitado
Ubicación:
Tasa:
Departure date:
Arrive date:
Personas:

Overview

Tour's Location

Loading Maps

Tour's Program

Reviews

No se encontraron calificaciones todavía

Escribe una reseña

  • Service

WordPress database error: [Unknown column 'tb.adult_price' in 'field list']
SELECT SQL_CALC_FOUND_ROWS eEuYSZaYposts.*,CASE WHEN tb.adult_price > 0 and tb.adult_price != '' THEN CASE WHEN tb.is_sale_schedule = 'on' AND tb.discount != 0 AND tb.discount != '' AND tb.sale_price_from <= CURDATE() AND tb.sale_price_to >= CURDATE() THEN CAST(tb.adult_price AS DECIMAL) - ( CAST(tb.adult_price AS DECIMAL) / 100 ) * CAST(tb.discount AS DECIMAL) WHEN tb.is_sale_schedule != 'on' AND tb.discount != 0 AND tb.discount != '' THEN CAST(tb.adult_price AS DECIMAL) - ( CAST(tb.adult_price AS DECIMAL) / 100 ) * CAST(tb.discount AS DECIMAL) ELSE tb.adult_price END WHEN tb.child_price > 0 and tb.child_price != '' THEN CASE WHEN tb.is_sale_schedule = 'on' AND tb.discount != 0 AND tb.discount != '' AND tb.sale_price_from <= CURDATE() AND tb.sale_price_to >= CURDATE() THEN CAST(tb.child_price AS DECIMAL) - ( CAST(tb.child_price AS DECIMAL) / 100 ) * CAST(tb.discount AS DECIMAL) WHEN tb.is_sale_schedule != 'on' AND tb.discount != 0 AND tb.discount != '' THEN CAST(tb.child_price AS DECIMAL) - ( CAST(tb.child_price AS DECIMAL) / 100 ) * CAST(tb.discount AS DECIMAL) ELSE tb.child_price END WHEN tb.infant_price > 0 and tb.infant_price != '' THEN CASE WHEN tb.is_sale_schedule = 'on' AND tb.discount != 0 AND tb.discount != '' AND tb.sale_price_from <= CURDATE() AND tb.sale_price_to >= CURDATE() THEN CAST(tb.infant_price AS DECIMAL) - ( CAST(tb.infant_price AS DECIMAL) / 100 ) * CAST(tb.discount AS DECIMAL) WHEN tb.is_sale_schedule != 'on' AND tb.discount != 0 AND tb.discount != '' THEN CAST(tb.infant_price AS DECIMAL) - ( CAST(tb.infant_price AS DECIMAL) / 100 ) * CAST(tb.discount AS DECIMAL) ELSE tb.infant_price END ELSE 0 END AS st_tour_price FROM eEuYSZaYposts INNER JOIN eEuYSZaYpostmeta ON ( eEuYSZaYposts.ID = eEuYSZaYpostmeta.post_id ) WHERE 1=1 AND ( eEuYSZaYpostmeta.meta_key = 'is_featured' ) AND eEuYSZaYposts.post_type = 'st_tours' AND (eEuYSZaYposts.post_status = 'publish') GROUP BY eEuYSZaYposts.ID ORDER BY eEuYSZaYpostmeta.meta_value DESC LIMIT 0, 4

Similar Tours