WP_Query Object
(
[query] => Array
(
[post_type] => product
[meta_query] => Array
(
[relation] => AND
[0] => Array
(
[0] => Array
(
[key] => attribute_pa_azulejos-estancia
[value] => Array
(
[0] => 303
)
[compare] => IN
)
)
)
[fields] => ids
[tax_query] => Array
(
[0] => Array
(
[0] => Array
(
[taxonomy] => product_cat
[field] => term_id
[terms] => Array
(
[0] => 17
)
)
[1] => Array
(
[taxonomy] => product_type
[field] => name
[terms] => Array
(
[0] => variable
)
)
)
)
[posts_per_page] => 20
[paged] => 1
)
[query_vars] => Array
(
[post_type] => product
[meta_query] => Array
(
[relation] => AND
[0] => Array
(
[0] => Array
(
[key] => attribute_pa_azulejos-estancia
[value] => Array
(
[0] => 303
)
[compare] => IN
)
)
)
[fields] => ids
[tax_query] => Array
(
[0] => Array
(
[0] => Array
(
[taxonomy] => product_cat
[field] => term_id
[terms] => Array
(
[0] => 17
)
)
[1] => Array
(
[taxonomy] => product_type
[field] => name
[terms] => Array
(
[0] => variable
)
)
)
)
[posts_per_page] => 20
[paged] => 1
[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] =>
[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
(
[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] => 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] => variable
)
[field] => name
)
)
[primary_table] => rev4b9_posts
[primary_id_column] => ID
)
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
[0] => Array
(
[0] => Array
(
[key] => attribute_pa_azulejos-estancia
[value] => Array
(
[0] => 303
)
[compare] => IN
)
[relation] => OR
)
[relation] => OR
)
[relation] => AND
[meta_table] => rev4b9_postmeta
[meta_id_column] => post_id
[primary_table] => rev4b9_posts
[primary_id_column] => ID
[table_aliases:protected] => Array
(
[0] => rev4b9_postmeta
)
[clauses:protected] => Array
(
[rev4b9_postmeta] => Array
(
[key] => attribute_pa_azulejos-estancia
[value] => Array
(
[0] => 303
)
[compare] => IN
[compare_key] => =
[alias] => rev4b9_postmeta
[cast] => CHAR
)
)
[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) INNER JOIN rev4b9_postmeta ON ( rev4b9_posts.ID = rev4b9_postmeta.post_id )
WHERE 1=1 AND (
(
rev4b9_term_relationships.term_taxonomy_id IN (17)
AND
tt1.term_taxonomy_id IN (4)
)
) AND (
(
( rev4b9_postmeta.meta_key = 'attribute_pa_azulejos-estancia' AND rev4b9_postmeta.meta_value IN ('303') )
)
) 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 0, 20
[posts] => Array
(
[0] => 230625
[1] => 230622
[2] => 230619
[3] => 230617
[4] => 230615
[5] => 230612
[6] => 230609
[7] => 230607
[8] => 230605
[9] => 230602
[10] => 230599
[11] => 230596
[12] => 230593
[13] => 230590
[14] => 230587
[15] => 230584
[16] => 230581
[17] => 230578
[18] => 230575
[19] => 230573
)
[post_count] => 20
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[comment_count] => 0
[current_comment] => -1
[found_posts] => 805
[max_num_pages] => 41
[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] =>
[is_admin] =>
[is_attachment] =>
[is_singular] =>
[is_robots] =>
[is_favicon] =>
[is_posts_page] =>
[is_post_type_archive] => 1
[query_vars_hash:WP_Query:private] => 07f2aaf1aaa82ee9b8d85d85aa9daf3e
[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
)
)
Suelos para interior
cocina, interior y exterior
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.
Suelos de interiores baratos
El gres porcelánico es uno de los materiales más utilizado en las reformas de viviendas. Su resistencia, dureza y aspecto estético hacen de este material el preferido por muchos para colocar en cualquier lugar o estancia.
Los suelos para interiores porcelánicos ofrecen una gran lista de características técnica inmejorables, así como una amplia variedad de diseños y formatos: imitación madera, mármol, mate, brillo…etc.
¿Buscas cambiar tus suelos interiores?
En Azulejos Hermanos Rosa somos expertos en azulejos y pavimentos. Nuestra experiencia todos estos años nos han convertido en uno de los principales proveedores de colecciones de azulejos del mercado.
Nuestro compromiso es garantizarte la calidad de nuestros servicios. Por ello colaboramos con las mejores marca y fábricas de España.
Si buscas espacios únicos y convertir tu hogar en un lugar mágico, Azulejos Hermanos Rosa es tu sitio. Entra en nuestra web y descubre nuestra gran variedad de diseños y materiales cerámicos. Disponemos de un sinfín de colores, acabados, tamaños y texturas.
No lo pienses más y confía en la profesionalidad de Azulejos Hermanos Rosa. Si necesitas más información, no lo dudes y ¡llámanos! Nuestros profesionales se encargarán de asesorarte a elegir los azulejos que más te gusten. ¡Te esperamos!
Conoce nuestras colecciones de baños
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
