Su oferta ha sido aceptada, por favor revise su bandeja de entrada.
Utilice punto en lugar de coma
Atención telefónica para información antes de comprar.
Embalaje reforzado para reducir daños en el transporte.
Asistencia post-venta para la instalación del producto.
Nous fournissons toutes les pièces détachées de ce produit.
Descripción
Se recomienda para bombear agua limpia y líquidos químicamente no agresivos para los materiales que componen la bomba.
Por sus características constructivas, esta bomba centrífuga está recomendada para su uso en el sector doméstico, agrícola e industrial.
Todos los componentes en contacto con el líquido bombeado están fabricados en acero inoxidable AISI 316L para garantizar una higiene total y la máxima resistencia a la corrosión.
La instalación debe realizarse en lugares cerrados o en todo caso protegidos de la intemperie.
SELECT DISTINCT `name`, `short_description`, `options`, `related_products_keywords`, display_cat_prd.`id_product` as `display_category_product_id`, `product_id` as `display_product_id`, `products_keywords`, `is_keywords_rules_active`, `is_keywords_rules_reference`, `is_keywords_rules_name`, `is_keywords_rules_description`, `order_display` FROM `peadditionalproducttabs` apt LEFT JOIN `category_product` apt_cat ON (apt_cat.`id_category` = apt.`category_id`) LEFT JOIN `category_shop` as apt_cat_shop ON (apt_cat.`id_category` = apt_cat_shop.`id_category` AND apt_cat_shop.`id_shop` = 1) LEFT JOIN `category_product` display_cat_prd ON (display_cat_prd.`id_category` = apt.`category_products_id`) LEFT JOIN `category_shop` as display_cat_prd_shop ON (display_cat_prd.`id_category` = display_cat_prd_shop.`id_category` AND display_cat_prd_shop.`id_shop` = 1) WHERE ((apt.`id_shop_group` is null and apt.`id_shop` is null) or (apt.`id_shop_group` = 1 and apt.`id_shop` is null) or (apt.`id_shop` = 1)) AND (NULLIF(apt.`hooks`, '') IS NULL OR apt.`hooks` LIKE ('%OPP%')) AND ( ( apt.`category_id` is null AND apt.`related_product_id` is null AND `related_products_keywords` is null )OR ( apt.`category_id` is not null AND apt_cat.`id_product` in (6421) ) OR ( apt.`related_product_id` is not null AND apt.`related_product_id` in (6421) ) ) UNION SELECT DISTINCT `name`, `short_description`, `options`, `related_products_keywords`, null as `display_category_product_id`, `related_product_id` as `display_product_id`, `products_keywords`, `is_keywords_rules_active`, `is_keywords_rules_reference`, `is_keywords_rules_name`, `is_keywords_rules_description`, `order_display` FROM `peadditionalproducttabs` apt WHERE ((apt.`id_shop_group` is null and apt.`id_shop` is null) or (apt.`id_shop_group` = 1 and apt.`id_shop` is null) or (apt.`id_shop` = 1)) AND (NULLIF(apt.`hooks`, '') IS NULL OR apt.`hooks` LIKE ('%OPP%')) AND apt.`is_reciprocity` = 1 AND apt.`related_product_id` is not null AND apt.`product_id` is not null AND apt.`product_id` in (6421) ORDER BY `order_display` ASC