Смесители

Смеситель — это сантехнический прибор, который регулирует напор и температуру воды, при помощи смешивания горячей и холодной воды. Помимо этого, смесители для ванной комнаты направляют воду к душевой лейке. Качественные долговечные смесители изготавливают из латуни и нержавеющей стали. Чтобы защитить наружные части смесителей от коррозии их никелируют, покрывают хромом, стеклом, эмалью, поверх которых наносится гальваническое покрытие. Современное трендовое покрытие для смесителей - PVD (микроскопические пылеобразные частицы покрытия наносится на корпус смесителя в камере высокого давления). Смесители с порошковым окрашиванием в различные матовые цвета не менее популярный тренд последних лет.

Что ещё нового и интересного предлагают нам производители смесителей? Водосберегающие картриджи, новые, обогащающие водяную струю воздухом, аэраторы, кнопочные дивертеры и многое-многое другое.

Для более подробного изучения современных смесителей - оставьте заявку на сайте или позвоните по телефону 8 (916) 109 79 76 по будням – наши менеджеры готовы ответить на все ваши вопросы и помочь с выбором.

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 17 ) ) AS `tmp`' at line 58
Error No: 1064
SELECT MIN(`price`) AS `p_min`, MAX(`price`) AS `p_max` FROM( SELECT `price_tmp` AS `price` FROM( SELECT IFNULL( ( SELECT `price` FROM `oc_product_special` AS `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND ((`ps`.`date_start` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW())) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1 ), IFNULL( ( SELECT `price` FROM `oc_product_discount` AS `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '1' AND `pd2`.`quantity` >= '1' AND ((`pd2`.`date_start` = '0000-00-00' OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` = '0000-00-00' OR `pd2`.`date_end` > NOW())) ORDER BY `pd2`.`priority` ASC, `pd2`.`price` ASC LIMIT 1 ), `p`.`price` ) ) AS `price_tmp` ,`p`.`product_id` FROM `oc_product` AS `p` INNER JOIN `oc_product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 1 INNER JOIN `oc_product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0 INNER JOIN `oc_product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` INNER JOIN `oc_category_path` AS `cp` ON `cp`.`category_id` = `p2c`.`category_id` WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(66) ) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 17 ) ) AS `tmp` in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/system/library/mfilter_core.php on line 1

Фильтр

  • Фабрика
    0
    0
    0
    0
    0
    0
    0
  • Статус
    0
    0
    0
    0
  • Цвет
  • Коллекция
  • Страна
    0
    0
    0
    0
  • Материал
  • Стиль
Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 17 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(67) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(67)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 17 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 17 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(68) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(68)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 17 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 17 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(69) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(69)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 17 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 17 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(70) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(70)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 17 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 17 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(71) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(71)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 17 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 17 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(182) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(182)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 17 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 17 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(204) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(204)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 17 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 17 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(203) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(203)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 17 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 17 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(193) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(193)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 17 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 17 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(194) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(194)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 17 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 17 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(218) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(218)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 17 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 17 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(196) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(196)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 17 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 17 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(219) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(219)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 17 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `language_id` = 1 AND `attribute_id` = 17 )' at line 7
Error No: 1064
SELECT COUNT(DISTINCT `product_id`) AS `total` FROM(SELECT DISTINCT `p`.`product_id` FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() AND `cp`.`path_id` IN(199) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND `cp`.`path_id` IN(199)) AS `tmp` WHERE `product_id` IN( SELECT `product_id` FROM `oc_product_attribute` WHERE ( ) AND `language_id` = 1 AND `attribute_id` = 17 ) in /home/h706062319/whitesealshop.ru/docs/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h706062319/whitesealshop.ru/docs/vqmod/vqcache/vq2-system_storage_modification_catalog_model_catalog_product.php on line 724