Abrir Modal
Palmeira Bolas Flutuantes
Promociones
WP_Query Object
(
    [query] => Array
        (
            [post_type] => pacote
            [posts_per_page] => 6
            [lang] => es
            [paged] => 1
            [tax_query] => Array
                (
                    [0] => Array
                        (
                            [taxonomy] => categorias_pacotes
                            [field] => slug
                            [terms] => especiales
                        )

                )

            [meta_query] => Array
                (
                    [0] => Array
                        (
                            [key] => data_final
                            [compare] => >=
                            [type] => DATE
                            [value] => 20250215
                        )

                    [1] => Array
                        (
                            [relation] => OR
                            [0] => Array
                                (
                                    [key] => exibicao_do_pacote
                                    [value] => ambos
                                    [compare] => =
                                )

                            [1] => Array
                                (
                                    [key] => exibicao_do_pacote
                                    [value] => desktop
                                    [compare] => =
                                )

                        )

                )

        )

    [query_vars] => Array
        (
            [post_type] => pacote
            [posts_per_page] => 6
            [lang] => es
            [paged] => 1
            [tax_query] => Array
                (
                    [0] => Array
                        (
                            [taxonomy] => categorias_pacotes
                            [field] => slug
                            [terms] => especiales
                        )

                )

            [meta_query] => Array
                (
                    [0] => Array
                        (
                            [key] => data_final
                            [compare] => >=
                            [type] => DATE
                            [value] => 20250215
                        )

                    [1] => Array
                        (
                            [relation] => OR
                            [0] => Array
                                (
                                    [key] => exibicao_do_pacote
                                    [value] => ambos
                                    [compare] => =
                                )

                            [1] => Array
                                (
                                    [key] => exibicao_do_pacote
                                    [value] => desktop
                                    [compare] => =
                                )

                        )

                )

            [error] => 
            [m] => 
            [p] => 0
            [post_parent] => 
            [subpost] => 
            [subpost_id] => 
            [attachment] => 
            [attachment_id] => 0
            [name] => 
            [pagename] => 
            [page_id] => 0
            [second] => 
            [minute] => 
            [hour] => 
            [day] => 0
            [monthnum] => 0
            [year] => 0
            [w] => 0
            [category_name] => 
            [tag] => 
            [cat] => 
            [tag_id] => 
            [author] => 
            [author_name] => 
            [feed] => 
            [tb] => 
            [meta_key] => 
            [meta_value] => 
            [preview] => 
            [s] => 
            [sentence] => 
            [title] => 
            [fields] => 
            [menu_order] => 
            [embed] => 
            [category__in] => Array
                (
                )

            [category__not_in] => Array
                (
                )

            [category__and] => Array
                (
                )

            [post__in] => Array
                (
                )

            [post__not_in] => Array
                (
                )

            [post_name__in] => Array
                (
                )

            [tag__in] => Array
                (
                )

            [tag__not_in] => Array
                (
                )

            [tag__and] => Array
                (
                )

            [tag_slug__in] => Array
                (
                )

            [tag_slug__and] => Array
                (
                )

            [post_parent__in] => Array
                (
                )

            [post_parent__not_in] => Array
                (
                )

            [author__in] => Array
                (
                )

            [author__not_in] => Array
                (
                )

            [search_columns] => Array
                (
                )

            [orderby] => menu_order
            [order] => ASC
            [update_post_term_cache] => 1
            [ignore_sticky_posts] => 
            [suppress_filters] => 
            [cache_results] => 1
            [update_menu_item_cache] => 
            [lazy_load_term_meta] => 1
            [update_post_meta_cache] => 1
            [nopaging] => 
            [comments_per_page] => 50
            [no_found_rows] => 
            [taxonomy] => categorias_pacotes
            [term] => especiales
        )

    [tax_query] => WP_Tax_Query Object
        (
            [queries] => Array
                (
                    [0] => Array
                        (
                            [taxonomy] => categorias_pacotes
                            [terms] => Array
                                (
                                    [0] => especiales
                                )

                            [field] => slug
                            [operator] => IN
                            [include_children] => 1
                        )

                    [1] => Array
                        (
                            [taxonomy] => language
                            [terms] => Array
                                (
                                    [0] => es
                                )

                            [field] => slug
                            [operator] => IN
                            [include_children] => 1
                        )

                )

            [relation] => AND
            [table_aliases:protected] => Array
                (
                    [0] => wp_term_relationships
                    [1] => tt1
                )

            [queried_terms] => Array
                (
                    [categorias_pacotes] => Array
                        (
                            [terms] => Array
                                (
                                    [0] => especiales
                                )

                            [field] => slug
                        )

                    [language] => Array
                        (
                            [terms] => Array
                                (
                                    [0] => es
                                )

                            [field] => slug
                        )

                )

            [primary_table] => wp_posts
            [primary_id_column] => ID
        )

    [meta_query] => WP_Meta_Query Object
        (
            [queries] => Array
                (
                    [0] => Array
                        (
                            [key] => data_final
                            [compare] => >=
                            [type] => DATE
                            [value] => 20250215
                        )

                    [1] => Array
                        (
                            [0] => Array
                                (
                                    [key] => exibicao_do_pacote
                                    [value] => ambos
                                    [compare] => =
                                )

                            [1] => Array
                                (
                                    [key] => exibicao_do_pacote
                                    [value] => desktop
                                    [compare] => =
                                )

                            [relation] => OR
                        )

                    [relation] => AND
                )

            [relation] => AND
            [meta_table] => wp_postmeta
            [meta_id_column] => post_id
            [primary_table] => wp_posts
            [primary_id_column] => ID
            [table_aliases:protected] => Array
                (
                    [0] => wp_postmeta
                    [1] => mt1
                )

            [clauses:protected] => Array
                (
                    [wp_postmeta] => Array
                        (
                            [key] => data_final
                            [compare] => >=
                            [type] => DATE
                            [value] => 20250215
                            [compare_key] => =
                            [alias] => wp_postmeta
                            [cast] => DATE
                        )

                    [mt1] => Array
                        (
                            [key] => exibicao_do_pacote
                            [value] => ambos
                            [compare] => =
                            [compare_key] => =
                            [alias] => mt1
                            [cast] => CHAR
                        )

                    [mt1-1] => Array
                        (
                            [key] => exibicao_do_pacote
                            [value] => desktop
                            [compare] => =
                            [compare_key] => =
                            [alias] => mt1
                            [cast] => CHAR
                        )

                )

            [has_or_relation:protected] => 1
        )

    [date_query] => 
    [request] => SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					 FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)  LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )  INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )
					 WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (377) 
  AND 
  tt1.term_taxonomy_id IN (77)
) AND ( 
  ( wp_postmeta.meta_key = 'data_final' AND CAST(wp_postmeta.meta_value AS DATE) >= '20250215' ) 
  AND 
  ( 
    ( mt1.meta_key = 'exibicao_do_pacote' AND mt1.meta_value = 'ambos' ) 
    OR 
    ( mt1.meta_key = 'exibicao_do_pacote' AND mt1.meta_value = 'desktop' )
  )
) AND ((wp_posts.post_type = 'pacote' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')))
					 GROUP BY wp_posts.ID
					 ORDER BY wp_posts.menu_order ASC
					 LIMIT 0, 6
    [posts] => Array
        (
        )

    [post_count] => 0
    [current_post] => -1
    [before_loop] => 1
    [in_the_loop] => 
    [comment_count] => 0
    [current_comment] => -1
    [found_posts] => 0
    [max_num_pages] => 0
    [max_num_comment_pages] => 0
    [is_single] => 
    [is_preview] => 
    [is_page] => 
    [is_archive] => 1
    [is_date] => 
    [is_year] => 
    [is_month] => 
    [is_day] => 
    [is_time] => 
    [is_author] => 
    [is_category] => 
    [is_tag] => 
    [is_tax] => 1
    [is_search] => 
    [is_feed] => 
    [is_comment_feed] => 
    [is_trackback] => 
    [is_home] => 
    [is_privacy_policy] => 
    [is_404] => 
    [is_embed] => 
    [is_paged] => 
    [is_admin] => 
    [is_attachment] => 
    [is_singular] => 
    [is_robots] => 
    [is_favicon] => 
    [is_posts_page] => 
    [is_post_type_archive] => 1
    [query_vars_hash:WP_Query:private] => 9b4a4003eb7308e36ac1a461eb3e888c
    [query_vars_changed:WP_Query:private] => 1
    [thumbnails_cached] => 
    [allow_query_attachment_by_filename:protected] => 
    [stopwords:WP_Query:private] => 
    [compat_fields:WP_Query:private] => Array
        (
            [0] => query_vars_hash
            [1] => query_vars_changed
        )

    [compat_methods:WP_Query:private] => Array
        (
            [0] => init_query_flags
            [1] => parse_tax_query
        )

)
Ningún resultado encontrado.
Palmeira Bolas Flutuantes
VEA A CONTINUACIÓN

Algunas Opiniones

El resort es maravilloso pero lo que más llamó la atención fue la organización del personal y el excelente servicio de los funcionarios, con énfasis en el servicio de la playa de Muro Alto, que se encuentra a escasos metros, y donde el resort...

Melissa

Fuimos del 17 al 28 de julio, con mucha lluvia y viento fuerte. Sin embargo ... fue una delicia. Empleados que hacen la experiencia aún mejor, así como el mesero Alexandro de la barra, es MUY atento y servicial, llama la atención por la calidad...

Amanda V

Muy buen hotel, los colaboradores son muy atentos siempre se poniendo a disposcicion para poder ayudar. Mi quarto ya estava completamente listo incluyendo con una cuna para mi hija, no necessite pedir nada!!!!! Recomiendo para vacaciones em...

Sabra05

Nunca fui tan bien recibido en un hotel como ló fui en el Summerville Beach Resort! El local es muy encantador, los empleados super atentos y amigables, y para completer me exelente esada tuve un pastel de cumpleaños sorpresa oferecido por el...

Nserenojr

Tuve el placer de quedarme con mis hijos en el hotel, funcionarios muy educados y atentos, piscina fenomenal, muy buena comida, maravillosa recreación. Simplemente uno de los mejores resort en los que me he alojado.

Fabiano1997

Todas las vezes que venimos fueron perfectas. La atencion esta mas acogedora. Me quedo mas cômodo. Apoio náutico muy Bueno con sillas y sombrillas. Muy buena comida. Eventos muy Buenos. Somo habituales y ya iremos a programar nuestro regresso.

João Vitor F

El Resort es lindo con una piscina grande. El diferencial fureon los empleados, muy educados y atentos desde la recepcion has el equipo que limpia la piscina. La recreacion fue maravillosa con Todinho, a Miojo e los otros, muy responsables, nos...

Emilia G

El mejor hotel que ya estuve en mi vida! Todo perfecto! Mi esposa amo todo tambien! Mi hija amo el clube de los niños. Exelente equipe de recreacion! Por encima de la média! La tencion em los 7 dias que nos quedamos fue perfecta tambien! Los...

Felipe F