SELECT
SQL_CALC_FOUND_ROWS
product.*,
product_language.*,
product.id,
temp_product_certificate.serialNumber,
temp_product_certificate.partnerSerialNumber,
temp_product_certificate.product_id,
temp_product_certificate.partner_id
FROM
product
LEFT JOIN product_language ON product_language.id = product.id
LEFT JOIN product_movablething ON product_movablething.id = product.id
LEFT JOIN product_giftcertificate AS temp_product_certificate ON temp_product_certificate.id = product.id WHERE product.id = 3429871 LIMIT 0,1
SELECT
SQL_CALC_FOUND_ROWS
product.*,
product_language.*,
product.id,
temp_product_certificate.serialNumber,
temp_product_certificate.partnerSerialNumber,
temp_product_certificate.product_id,
temp_product_certificate.partner_id
FROM
product
LEFT JOIN product_language ON product_language.id = product.id
LEFT JOIN product_movablething ON product_movablething.id = product.id
LEFT JOIN product_giftcertificate AS temp_product_certificate ON temp_product_certificate.id = product.id WHERE product.id = 3750299 LIMIT 0,1
SELECT
SQL_CALC_FOUND_ROWS
product.*,
product_language.*,
product.id,
temp_product_certificate.serialNumber,
temp_product_certificate.partnerSerialNumber,
temp_product_certificate.product_id,
temp_product_certificate.partner_id
FROM
product
LEFT JOIN product_language ON product_language.id = product.id
LEFT JOIN product_movablething ON product_movablething.id = product.id
LEFT JOIN product_giftcertificate AS temp_product_certificate ON temp_product_certificate.id = product.id WHERE product.id = 4136417 LIMIT 0,1
Дозатор для жидкого мыла Blanco Livia манган 521293
SELECT
SQL_CALC_FOUND_ROWS
product.*,
product_language.*,
product.id,
temp_product_certificate.serialNumber,
temp_product_certificate.partnerSerialNumber,
temp_product_certificate.product_id,
temp_product_certificate.partner_id
FROM
product
LEFT JOIN product_language ON product_language.id = product.id
LEFT JOIN product_movablething ON product_movablething.id = product.id
LEFT JOIN product_giftcertificate AS temp_product_certificate ON temp_product_certificate.id = product.id WHERE product.id = 3452825 LIMIT 0,1
Blanco »
Дозаторы »
Livia
26 900 руб
Варианты Blanco Livia
SELECT
SQL_CALC_FOUND_ROWS
product.*,
product_language.*,
product.id,
temp_product_certificate.serialNumber,
temp_product_certificate.partnerSerialNumber,
temp_product_certificate.product_id,
temp_product_certificate.partner_id
FROM
product
LEFT JOIN product_language ON product_language.id = product.id
LEFT JOIN product_movablething ON product_movablething.id = product.id
LEFT JOIN product_giftcertificate AS temp_product_certificate ON temp_product_certificate.id = product.id WHERE product.id = 2982408 LIMIT 0,1
SELECT
SQL_CALC_FOUND_ROWS
product.*,
product_language.*,
product.id,
temp_product_certificate.serialNumber,
temp_product_certificate.partnerSerialNumber,
temp_product_certificate.product_id,
temp_product_certificate.partner_id
FROM
product
LEFT JOIN product_language ON product_language.id = product.id
LEFT JOIN product_movablething ON product_movablething.id = product.id
LEFT JOIN product_giftcertificate AS temp_product_certificate ON temp_product_certificate.id = product.id WHERE product.id = 3452825 LIMIT 0,1
SELECT
SQL_CALC_FOUND_ROWS
product.*,
product_language.*,
product.id,
temp_product_certificate.serialNumber,
temp_product_certificate.partnerSerialNumber,
temp_product_certificate.product_id,
temp_product_certificate.partner_id
FROM
product
LEFT JOIN product_language ON product_language.id = product.id
LEFT JOIN product_movablething ON product_movablething.id = product.id
LEFT JOIN product_giftcertificate AS temp_product_certificate ON temp_product_certificate.id = product.id WHERE product.id = 2982409 LIMIT 0,1
SELECT
SQL_CALC_FOUND_ROWS
product.*,
product_language.*,
product.id,
temp_product_certificate.serialNumber,
temp_product_certificate.partnerSerialNumber,
temp_product_certificate.product_id,
temp_product_certificate.partner_id
FROM
product
LEFT JOIN product_language ON product_language.id = product.id
LEFT JOIN product_movablething ON product_movablething.id = product.id
LEFT JOIN product_giftcertificate AS temp_product_certificate ON temp_product_certificate.id = product.id WHERE product.id = 3452825 LIMIT 0,1
SELECT
SQL_CALC_FOUND_ROWS
product.*,
product_language.*,
product.id,
temp_product_certificate.serialNumber,
temp_product_certificate.partnerSerialNumber,
temp_product_certificate.product_id,
temp_product_certificate.partner_id
FROM
product
LEFT JOIN product_language ON product_language.id = product.id
LEFT JOIN product_movablething ON product_movablething.id = product.id
LEFT JOIN product_giftcertificate AS temp_product_certificate ON temp_product_certificate.id = product.id WHERE product.id = 3443847 LIMIT 0,1
SELECT
SQL_CALC_FOUND_ROWS
product.*,
product_language.*,
product.id,
temp_product_certificate.serialNumber,
temp_product_certificate.partnerSerialNumber,
temp_product_certificate.product_id,
temp_product_certificate.partner_id
FROM
product
LEFT JOIN product_language ON product_language.id = product.id
LEFT JOIN product_movablething ON product_movablething.id = product.id
LEFT JOIN product_giftcertificate AS temp_product_certificate ON temp_product_certificate.id = product.id WHERE product.id = 3452825 LIMIT 0,1
хром
полированная латунь
манган
Артикул: | 521293 |
Производитель: | Blanco |
Модель: | Livia |
Страна производства: | Германия |
Объем: | 500 мл |
Отверстие для установки: | 3.5 см |
Максимальная толщина столещницы: | 5 см |
Официальная гарантия: | 1 год |
- Современный дизайн с контрастными декоративными элементами
- Единое стилевое решение ручки клапана-автомата и смесителя
- Легкое заполнение емкости сверху
- Размеры 7.9 x 11.5 см