WP_Query Object ( [query] => Array ( [post_type] => product [tax_query] => Array ( [relation] => AND [0] => Array ( [0] => Array ( [taxonomy] => product_cat [field] => term_id [terms] => Array ( [0] => 19 ) ) [1] => Array ( [taxonomy] => product_type [field] => name [terms] => Array ( [0] => simple [1] => variable ) ) ) ) [posts_per_page] => 20 [paged] => 7 ) [query_vars] => Array ( [post_type] => product [tax_query] => Array ( [relation] => AND [0] => Array ( [0] => Array ( [taxonomy] => product_cat [field] => term_id [terms] => Array ( [0] => 19 ) ) [1] => Array ( [taxonomy] => product_type [field] => name [terms] => Array ( [0] => simple [1] => variable ) ) ) ) [posts_per_page] => 20 [paged] => 7 [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 ( ) [ignore_sticky_posts] => [suppress_filters] => [cache_results] => 1 [update_post_term_cache] => 1 [update_menu_item_cache] => [lazy_load_term_meta] => 1 [update_post_meta_cache] => 1 [nopaging] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => product_cat [term_id] => 19 [order] => DESC ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [relation] => AND [0] => Array ( [0] => Array ( [taxonomy] => product_cat [terms] => Array ( [0] => 19 ) [field] => term_id [operator] => IN [include_children] => 1 ) [1] => Array ( [taxonomy] => product_type [terms] => Array ( [0] => simple [1] => variable ) [field] => name [operator] => IN [include_children] => 1 ) [relation] => AND ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => rev4b9_term_relationships [1] => tt1 ) [queried_terms] => Array ( [product_cat] => Array ( [terms] => Array ( [0] => 19 ) [field] => term_id ) [product_type] => Array ( [terms] => Array ( [0] => simple [1] => variable ) [field] => name ) ) [primary_table] => rev4b9_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( ) [relation] => [meta_table] => [meta_id_column] => [primary_table] => [primary_id_column] => [table_aliases:protected] => Array ( ) [clauses:protected] => Array ( ) [has_or_relation:protected] => ) [date_query] => [request] => SELECT SQL_CALC_FOUND_ROWS rev4b9_posts.ID FROM rev4b9_posts LEFT JOIN rev4b9_term_relationships ON (rev4b9_posts.ID = rev4b9_term_relationships.object_id) LEFT JOIN rev4b9_term_relationships AS tt1 ON (rev4b9_posts.ID = tt1.object_id) WHERE 1=1 AND ( ( rev4b9_term_relationships.term_taxonomy_id IN (19) AND tt1.term_taxonomy_id IN (2,4) ) ) AND ((rev4b9_posts.post_type = 'product' AND (rev4b9_posts.post_status = 'publish'))) GROUP BY rev4b9_posts.ID ORDER BY rev4b9_posts.post_date DESC LIMIT 120, 20 [posts] => Array ( [0] => WP_Post Object ( [ID] => 208063 [post_author] => 2 [post_date] => 2022-06-20 21:40:20 [post_date_gmt] => 2022-06-20 21:40:20 [post_content] => Mampara de ducha con perfilería en acero inoxidable, altura de 2 metros y vidrio templado de 8 milímetros. No tiene perfilería inferior y sus puertas se pueden liberar para una fácil limpieza. [post_title] => Slim Frente de Ducha Fijo + Puerta Corredera Decorado [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => slim-frente-de-ducha-fijo-puerta-corredera-decorado [to_ping] => [pinged] => [post_modified] => 2023-10-23 18:41:46 [post_modified_gmt] => 2023-10-23 18:41:46 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.azulejoshermanosrosa.com/producto/slim-frente-de-ducha-fijo-puerta-corredera-decorado/ [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 208062 [post_author] => 2 [post_date] => 2022-06-20 21:40:15 [post_date_gmt] => 2022-06-20 21:40:15 [post_content] => Mampara de ducha con perfilería en acero inoxidable, altura de 2 metros y vidrio templado de 8 milímetros. No tiene perfilería inferior y sus puertas se pueden liberar para una fácil limpieza. [post_title] => Slim Frente de Ducha Fijo + Puerta Corredera Transparente [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => slim-frente-de-ducha-fijo-puerta-corredera-transparente [to_ping] => [pinged] => [post_modified] => 2023-10-23 18:38:58 [post_modified_gmt] => 2023-10-23 18:38:58 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.azulejoshermanosrosa.com/producto/slim-frente-de-ducha-fijo-puerta-corredera-transparente/ [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 2 [current_post] => -1 [before_loop] => 1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 208063 [post_author] => 2 [post_date] => 2022-06-20 21:40:20 [post_date_gmt] => 2022-06-20 21:40:20 [post_content] => Mampara de ducha con perfilería en acero inoxidable, altura de 2 metros y vidrio templado de 8 milímetros. No tiene perfilería inferior y sus puertas se pueden liberar para una fácil limpieza. [post_title] => Slim Frente de Ducha Fijo + Puerta Corredera Decorado [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => slim-frente-de-ducha-fijo-puerta-corredera-decorado [to_ping] => [pinged] => [post_modified] => 2023-10-23 18:41:46 [post_modified_gmt] => 2023-10-23 18:41:46 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.azulejoshermanosrosa.com/producto/slim-frente-de-ducha-fijo-puerta-corredera-decorado/ [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 122 [max_num_pages] => 7 [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] => [is_search] => [is_feed] => [is_comment_feed] => [is_trackback] => [is_home] => [is_privacy_policy] => [is_404] => [is_embed] => [is_paged] => 1 [is_admin] => [is_attachment] => [is_singular] => [is_robots] => [is_favicon] => [is_posts_page] => [is_post_type_archive] => 1 [query_vars_hash:WP_Query:private] => bab04970aa594fc7c947244523019fd8 [query_vars_changed:WP_Query:private] => [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 ) )
Mamparas de Ducha
Uno de nuestros elementos más importantes, las mamparas de ducha que ofrecemos cuentan con los elementos necesarios para hacer que su baño quede perfecto. Nuestro amplio catálogo en mamparas de ducha y baño hace que elegirnos sea siempre la mejor opción.
Envio Rápido
Envíos nacionales e internacionales con los mejores tipos de entrega
Calidad de producto
Las mejores materias primas de fabricación nacional utilizadas en nuestros productos
Las mejores ofertas
Ofertas nuevas cada semana en toda nuestra grama de productos
Pago seguro
Utilizamos las pasarelas de pago más seguras del mercado