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] => 17
)
)
[1] => Array
(
[taxonomy] => product_type
[field] => name
[terms] => Array
(
[0] => simple
[1] => variable
)
)
)
)
[posts_per_page] => 20
[paged] => 47
)
[query_vars] => Array
(
[post_type] => product
[tax_query] => Array
(
[relation] => AND
[0] => Array
(
[0] => Array
(
[taxonomy] => product_cat
[field] => term_id
[terms] => Array
(
[0] => 17
)
)
[1] => Array
(
[taxonomy] => product_type
[field] => name
[terms] => Array
(
[0] => simple
[1] => variable
)
)
)
)
[posts_per_page] => 20
[paged] => 47
[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] => all
[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] => 17
[order] => DESC
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[relation] => AND
[0] => Array
(
[0] => Array
(
[taxonomy] => product_cat
[terms] => Array
(
[0] => 17
)
[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] => 17
)
[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 (17)
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 920, 20
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 217202
[post_author] => 2
[post_date] => 2022-11-01 12:12:06
[post_date_gmt] => 2022-11-01 12:12:06
[post_content] =>
[post_title] => Flandes Caldera
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => flandes-caldera
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:35:38
[post_modified_gmt] => 2024-07-07 17:35:38
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/flandes-caldera/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 217201
[post_author] => 2
[post_date] => 2022-11-01 12:12:01
[post_date_gmt] => 2022-11-01 12:12:01
[post_content] =>
[post_title] => Flandes Beige
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => flandes-beige
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:35:36
[post_modified_gmt] => 2024-07-07 17:35:36
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/flandes-beige/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 217200
[post_author] => 2
[post_date] => 2022-11-01 12:11:56
[post_date_gmt] => 2022-11-01 12:11:56
[post_content] =>
[post_title] => Flandes Antracita
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => flandes-antracita
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:35:35
[post_modified_gmt] => 2024-07-07 17:35:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/flandes-antracita/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 217199
[post_author] => 2
[post_date] => 2022-11-01 12:11:49
[post_date_gmt] => 2022-11-01 12:11:49
[post_content] =>
[post_title] => Flandes Blanco
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => flandes-blanco
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:35:08
[post_modified_gmt] => 2024-07-07 17:35:08
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/flandes-blanco/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 217197
[post_author] => 2
[post_date] => 2022-11-01 12:11:39
[post_date_gmt] => 2022-11-01 12:11:39
[post_content] =>
[post_title] => Finlay Beige
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => finlay-beige
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:35:04
[post_modified_gmt] => 2024-07-07 17:35:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/finlay-beige/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 217196
[post_author] => 2
[post_date] => 2022-11-01 12:11:33
[post_date_gmt] => 2022-11-01 12:11:33
[post_content] =>
[post_title] => Finlay Gris
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => finlay-gris
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:34:34
[post_modified_gmt] => 2024-07-07 17:34:34
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/finlay-gris/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 217195
[post_author] => 2
[post_date] => 2022-11-01 12:11:23
[post_date_gmt] => 2022-11-01 12:11:23
[post_content] =>
[post_title] => Finlay Perla
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => finlay-perla
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:34:33
[post_modified_gmt] => 2024-07-07 17:34:33
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/finlay-perla/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 217194
[post_author] => 2
[post_date] => 2022-11-01 12:11:18
[post_date_gmt] => 2022-11-01 12:11:18
[post_content] =>
[post_title] => Dorne Marmol
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => dorne-marmol
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:34:32
[post_modified_gmt] => 2024-07-07 17:34:32
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/dorne-marmol/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 217192
[post_author] => 2
[post_date] => 2022-11-01 12:11:04
[post_date_gmt] => 2022-11-01 12:11:04
[post_content] =>
[post_title] => Dorne Beige
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => dorne-beige
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:34:08
[post_modified_gmt] => 2024-07-07 17:34:08
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/dorne-beige/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 217186
[post_author] => 2
[post_date] => 2022-11-01 12:10:24
[post_date_gmt] => 2022-11-01 12:10:24
[post_content] =>
[post_title] => Dauco Pizarra
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => dauco-pizarra
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:34:06
[post_modified_gmt] => 2024-07-07 17:34:06
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/dauco-pizarra/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 217185
[post_author] => 2
[post_date] => 2022-11-01 12:10:18
[post_date_gmt] => 2022-11-01 12:10:18
[post_content] =>
[post_title] => Dauco Madera
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => dauco-madera
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:34:05
[post_modified_gmt] => 2024-07-07 17:34:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/dauco-madera/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 217169
[post_author] => 2
[post_date] => 2022-11-01 12:08:36
[post_date_gmt] => 2022-11-01 12:08:36
[post_content] =>
[post_title] => Nevica Natural
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => nevica-natural
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:33:10
[post_modified_gmt] => 2024-07-07 17:33:10
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/nevica-natural/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[12] => WP_Post Object
(
[ID] => 217168
[post_author] => 2
[post_date] => 2022-11-01 12:08:32
[post_date_gmt] => 2022-11-01 12:08:32
[post_content] =>
[post_title] => Aspen Waves Blanco
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => aspen-waves-blanco
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 16:24:13
[post_modified_gmt] => 2024-07-07 16:24:13
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/aspen-waves-blanco/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[13] => WP_Post Object
(
[ID] => 217167
[post_author] => 2
[post_date] => 2022-11-01 12:08:27
[post_date_gmt] => 2022-11-01 12:08:27
[post_content] =>
[post_title] => Aspen Mosaic Blanco
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => aspen-mosaic-blanco
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:32:44
[post_modified_gmt] => 2024-07-07 17:32:44
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/aspen-mosaic-blanco/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[14] => WP_Post Object
(
[ID] => 217166
[post_author] => 2
[post_date] => 2022-11-01 12:08:19
[post_date_gmt] => 2022-11-01 12:08:19
[post_content] =>
[post_title] => Aspen Blanco
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => aspen-blanco
[to_ping] =>
[pinged] =>
[post_modified] => 2025-03-23 11:53:17
[post_modified_gmt] => 2025-03-23 11:53:17
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/aspen-blanco/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[15] => WP_Post Object
(
[ID] => 217165
[post_author] => 2
[post_date] => 2022-11-01 12:08:12
[post_date_gmt] => 2022-11-01 12:08:12
[post_content] =>
[post_title] => Vince Mosaic Blanco
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vince-mosaic-blanco
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:30:34
[post_modified_gmt] => 2024-07-07 17:30:34
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/vince-mosaic-blanco/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[16] => WP_Post Object
(
[ID] => 217163
[post_author] => 2
[post_date] => 2022-11-01 12:08:01
[post_date_gmt] => 2022-11-01 12:08:01
[post_content] =>
[post_title] => Vince Blanco
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => vince-blanco
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:30:32
[post_modified_gmt] => 2024-07-07 17:30:32
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/vince-blanco/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[17] => WP_Post Object
(
[ID] => 217160
[post_author] => 2
[post_date] => 2022-11-01 12:07:40
[post_date_gmt] => 2022-11-01 12:07:40
[post_content] =>
[post_title] => Kinsale Ice
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => kinsale-ice
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 16:48:14
[post_modified_gmt] => 2024-07-07 16:48:14
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/kinsale-ice/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[18] => WP_Post Object
(
[ID] => 217155
[post_author] => 2
[post_date] => 2022-11-01 12:07:13
[post_date_gmt] => 2022-11-01 12:07:13
[post_content] =>
[post_title] => Bibury Mosaic White
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => bibury-mosaic-white
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:29:06
[post_modified_gmt] => 2024-07-07 17:29:06
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/bibury-mosaic-white/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[19] => WP_Post Object
(
[ID] => 217154
[post_author] => 2
[post_date] => 2022-11-01 12:07:05
[post_date_gmt] => 2022-11-01 12:07:05
[post_content] =>
[post_title] => Bibury Mosaic Beige
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => bibury-mosaic-beige
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:29:05
[post_modified_gmt] => 2024-07-07 17:29:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/bibury-mosaic-beige/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 20
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 217202
[post_author] => 2
[post_date] => 2022-11-01 12:12:06
[post_date_gmt] => 2022-11-01 12:12:06
[post_content] =>
[post_title] => Flandes Caldera
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => flandes-caldera
[to_ping] =>
[pinged] =>
[post_modified] => 2024-07-07 17:35:38
[post_modified_gmt] => 2024-07-07 17:35:38
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.azulejoshermanosrosa.com/producto/flandes-caldera/
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 1670
[max_num_pages] => 84
[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] => 470be6c44cea48a4024349eb2b671f9b
[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
)
[query_cache_key:WP_Query:private] => wp_query:ff4b5fc32131d21b40b2e8ef2c9e9044:0.50825900 17609615100.44903900 1760961510
)
Revestimientos porcelánicos
Revestimietos para baño, cocina, exterior e interior
Construya espacios creativos con nuestra amplia gama de materiales cerámicos. Azulejos, pavimentos y revestimientos para decorar su hogar eligiendo entre todo tipo de texturas, colores, estilos y tamaños.
Revestimientos ceramicos y porcelánicos
La decoración del hogar debe contar con un diseño elegante, que ofrezca una imagen profesional y una sensación de comodidad y perfección.
Los azulejos pueden ser para pared o suelo en muchas ocasiones, combinando colores fríos y cálidos para dar una imagen sobria y perfecta. Descubra todos nuestros modelos que necesita para su hogar y haga de su vivienda algo increíble.
Filtro
Conoce nuestras colecciones de revestimientos
Nos caracterizamos por ser el proveedor de cerámica con más colecciones del mercado. Gracias a que colaboramos con los mejores fabricantes nacionales, podemos ofrecer una amplia gama de colecciones de todo tipo, incluyendo numerosos colores, estilos, tamaños, acabados y decorados. Esto nos permite ser líderes en el sector, pues nuestraamplia experiencia de tres décadas refleja nuestro gran trabajo durante este tiempo.
Todos nuestros productos han pasado rigurosos exámenes de calidad que cumplen todas las normativas vigentes en materia de resistencia a golpes, productos químicos, rayado, torsión, heladas y condiciones meteorológicas adversas. Gracias a ello nuestros clientes agradecen nuestra profesionalidad y dedicación por su reforma, haciendo que seamos enormemente reconocidos en el sector
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
