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] => 20250401
                        )

                    [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] => 20250401
                        )

                    [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] => 20250401
                        )

                    [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] => 20250401
                            [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) >= '20250401' ) 
  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] => 5749bce5111883eacf06eb31e67401bb
    [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

10 a todos los empleados, salva vidas (Amanda), meseros, mensageros (Cleioton y Wellington), suport nautiico (Carlos) muy atentos y Marco (gerente) que siempre se pone a nuestra dispocicion para qualquier situacion! Son TODOS super simpáticos, assi...

Ana Luiza A

Antes de elegir Summerville hice varias investigaciones sobre el alojamiento en Porto de Galinhas, sin duda la elección de Summerville fue excelente, el resort lo tiene todo, excelentes piscinas, un magnífico servicio por parte del personal,...

joaosilva1997

El hotel es lindo, los apartamientos son enormes, y tiene varias piscinas. La comida es muy buena, esta en mi playa favorita que es Muro Alto!! Ideal para famílias. Volvere, seguramente, para quedarme mas tiempo.

Franciscoz177

El hotel es acogedor, habitación limpia con aire acondicionado que funciona, buen baño, ducha estupenda. Actividades para niños a partir de 4 años, para menores es posible contratar niñera (no utilizamos este servicio). El restaurante es muy...

P798JFclaudiaf

El resort es muy Bueno! Nos quedamos uma semana en el quarto “standart” y el tamaño nos sorprendio: muy grande!! Nos quedamos en una área entre la recepcion y los bangalôs, mas caros. Confortable para una pareja, un ninño y un nenê. Tenia...

Marina B

Estuvimos en el resort entre el 13 y el 20 de julio, para unas vacaciones familiares... De las críticas que habíamos leído, ¡no esperábamos que el complejo fuera tan bueno! El personal muy atento, respondió y/o resolvió todo lo que se le...

Daielle B

Estada perfecta: atencion nota 1000. Empleados muy serviciales que creen, de verdad, en la empresa. Se destacan estos empleados.: Meiri, em la área de la piscina. Lucia en el restaurante. Marco, relaciones publicas nota 1000, refleja el exelente...

Fernanda Q

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