Выберите город, кликнув метку на карте

Иркутск

В городе Иркутске расположен центральный офис нашей компании, а также основные склады. Всего в Иркутске расположено пять торговых точек "Финестра" в разных частях города и района.

Улан-Удэ

В Улан-Удэ нас очень просто найти: проспект Автомобилистов, 16/4
Наши склады в столице солнечной Бурятии позволяют держать существенные запасы основных отделочных материалов, поэтому мы можем предложить большой ассортимент материалов в наличии.

Хабаровск

Склад и магазин расположен по адресу: ул. Ленинградская, 28 лит 1К
Новый склад-магазин: расположен по адресу: ул. Артемовская, 55 г/1

Красноярск

В Красноярске наша торговая точка находится в промышленном центре города: на Северном Шоссе (17К/1).
Наглядная экспозиция в магазине и в кровельном уличном парке очень удобна для тех, кто выбирает материалы для обшивки своего частного дома. Непосредственная близость склада делает процесс покупки максимально быстрым, что очень ценится нашими дилерами.

Ангарск

В Ангарске наш магазин расположен на торговой базе "Сатурн", 7. Добраться от цента до этой части города совсем просто.
У ангарской торговой точки есть собственный склад, что позволяет держать основной ассортимент товаров в наличии.

Владивосток

Во Владивостоке наша торговая точка и склады расположены по адресу ул. 2 Шоссейная, дом 1/2.

Иркутск
Улан-Удэ
Хабаровск
Красноярск
Ангарск
Владивосток
FILE: /home/bitrix/www/bitrix/modules/iblock/classes/mysql/iblockelement.php
LINE: 803
MySQL Query Error: SELECT DISTINCT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,BE.NAME as NAME, FPEN0.VALUE as PROPERTY_PRIMENENIE_VALUE, FPEN0.ID as PROPERTY_PRIMENENIE_ENUM_ID, FPV0.ID as PROPERTY_PRIMENENIE_VALUE_ID, FPEN1.VALUE as PROPERTY_DIZAYN_VALUE, FPEN1.ID as PROPERTY_DIZAYN_ENUM_ID, FPV1.ID as PROPERTY_DIZAYN_VALUE_ID, FPV2.VALUE as PROPERTY_PO_FORME_VALUE, FPV2.ID as PROPERTY_PO_FORME_VALUE_ID, FPV3.VALUE as PROPERTY_BRAND_VALUE, FPV3.ID as PROPERTY_BRAND_VALUE_ID, FPEN2.VALUE as PROPERTY_PO_TEKSTURE_VALUE, FPEN2.ID as PROPERTY_PO_TEKSTURE_ENUM_ID, FPV4.ID as PROPERTY_PO_TEKSTURE_VALUE_ID, FPEN3.VALUE as PROPERTY_PO_MATERIALU_VALUE, FPEN3.ID as PROPERTY_PO_MATERIALU_ENUM_ID, FPV5.ID as PROPERTY_PO_MATERIALU_VALUE_ID, FPV6.VALUE as PROPERTY_PO_NAZNACHENIYU_VALUE, FPV6.ID as PROPERTY_PO_NAZNACHENIYU_VALUE_ID, FPEN4.VALUE as PROPERTY_PO_SPOSOBU_MONTAZHA_VALUE, FPEN4.ID as PROPERTY_PO_SPOSOBU_MONTAZHA_ENUM_ID, FPV7.ID as PROPERTY_PO_SPOSOBU_MONTAZHA_VALUE_ID, FPEN5.VALUE as PROPERTY_NAREZKA_VALUE, FPEN5.ID as PROPERTY_NAREZKA_ENUM_ID, FPV8.ID as PROPERTY_NAREZKA_VALUE_ID, FPEN6.VALUE as PROPERTY_SROK_GARANTII_VALUE, FPEN6.ID as PROPERTY_SROK_GARANTII_ENUM_ID, FPV9.ID as PROPERTY_SROK_GARANTII_VALUE_ID, FPEN7.VALUE as PROPERTY_PO_KOLICHESTVU_SLOEV_VALUE, FPEN7.ID as PROPERTY_PO_KOLICHESTVU_SLOEV_ENUM_ID, FPV10.ID as PROPERTY_PO_KOLICHESTVU_SLOEV_VALUE_ID, FPEN8.VALUE as PROPERTY_PO_VIDU_VALUE, FPEN8.ID as PROPERTY_PO_VIDU_ENUM_ID, FPV11.ID as PROPERTY_PO_VIDU_VALUE_ID, FPEN9.VALUE as PROPERTY_PO_POKRYTIYU_VALUE, FPEN9.ID as PROPERTY_PO_POKRYTIYU_ENUM_ID, FPV12.ID as PROPERTY_PO_POKRYTIYU_VALUE_ID, FPEN10.VALUE as PROPERTY_TOLSHCHINA_VALUE, FPEN10.ID as PROPERTY_TOLSHCHINA_ENUM_ID, FPV13.ID as PROPERTY_TOLSHCHINA_VALUE_ID, FPEN11.VALUE as PROPERTY_PO_PROFILYU_VALUE, FPEN11.ID as PROPERTY_PO_PROFILYU_ENUM_ID, FPV14.ID as PROPERTY_PO_PROFILYU_VALUE_ID FROM b_iblock B INNER JOIN b_lang L ON B.LID=L.LID INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID LEFT JOIN b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND FP0.CODE='PRIMENENIE' LEFT JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.CODE='DIZAYN' LEFT JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND FP2.CODE='PO_FORME' LEFT JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID = B.ID AND FP3.CODE='BRAND' LEFT JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID = B.ID AND FP4.CODE='PO_TEKSTURE' LEFT JOIN b_iblock_property FP5 ON FP5.IBLOCK_ID = B.ID AND FP5.CODE='PO_MATERIALU' LEFT JOIN b_iblock_property FP6 ON FP6.IBLOCK_ID = B.ID AND FP6.CODE='PO_NAZNACHENIYU' LEFT JOIN b_iblock_property FP7 ON FP7.IBLOCK_ID = B.ID AND FP7.CODE='PO_SPOSOBU_MONTAZHA' LEFT JOIN b_iblock_property FP8 ON FP8.IBLOCK_ID = B.ID AND FP8.CODE='NAREZKA' LEFT JOIN b_iblock_property FP9 ON FP9.IBLOCK_ID = B.ID AND FP9.CODE='SROK_GARANTII' LEFT JOIN b_iblock_property FP10 ON FP10.IBLOCK_ID = B.ID AND FP10.CODE='PO_KOLICHESTVU_SLOEV' LEFT JOIN b_iblock_property FP11 ON FP11.IBLOCK_ID = B.ID AND FP11.CODE='PO_VIDU' LEFT JOIN b_iblock_property FP12 ON FP12.IBLOCK_ID = B.ID AND FP12.CODE='PO_POKRYTIYU' LEFT JOIN b_iblock_property FP13 ON FP13.IBLOCK_ID = B.ID AND FP13.CODE='TOLSHCHINA' LEFT JOIN b_iblock_property FP14 ON FP14.IBLOCK_ID = B.ID AND FP14.CODE='PO_PROFILYU' LEFT JOIN b_iblock_property FP15 ON FP15.IBLOCK_ID = B.ID AND FP15.CODE='AVAILIBLE_IN_SITIES' LEFT JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV1 ON FPV1.IBLOCK_PROPERTY_ID = FP1.ID AND FPV1.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV2 ON FPV2.IBLOCK_PROPERTY_ID = FP2.ID AND FPV2.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV3 ON FPV3.IBLOCK_PROPERTY_ID = FP3.ID AND FPV3.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV4 ON FPV4.IBLOCK_PROPERTY_ID = FP4.ID AND FPV4.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV5 ON FPV5.IBLOCK_PROPERTY_ID = FP5.ID AND FPV5.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV6 ON FPV6.IBLOCK_PROPERTY_ID = FP6.ID AND FPV6.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV7 ON FPV7.IBLOCK_PROPERTY_ID = FP7.ID AND FPV7.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV8 ON FPV8.IBLOCK_PROPERTY_ID = FP8.ID AND FPV8.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV9 ON FPV9.IBLOCK_PROPERTY_ID = FP9.ID AND FPV9.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV10 ON FPV10.IBLOCK_PROPERTY_ID = FP10.ID AND FPV10.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV11 ON FPV11.IBLOCK_PROPERTY_ID = FP11.ID AND FPV11.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV12 ON FPV12.IBLOCK_PROPERTY_ID = FP12.ID AND FPV12.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV13 ON FPV13.IBLOCK_PROPERTY_ID = FP13.ID AND FPV13.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV14 ON FPV14.IBLOCK_PROPERTY_ID = FP14.ID AND FPV14.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV15 ON FPV15.IBLOCK_PROPERTY_ID = FP15.ID AND FPV15.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_property_enum FPEN0 ON FPEN0.PROPERTY_ID = FPV0.IBLOCK_PROPERTY_ID AND FPV0.VALUE_ENUM = FPEN0.ID LEFT JOIN b_iblock_property_enum FPEN1 ON FPEN1.PROPERTY_ID = FPV1.IBLOCK_PROPERTY_ID AND FPV1.VALUE_ENUM = FPEN1.ID LEFT JOIN b_iblock_property_enum FPEN2 ON FPEN2.PROPERTY_ID = FPV4.IBLOCK_PROPERTY_ID AND FPV4.VALUE_ENUM = FPEN2.ID LEFT JOIN b_iblock_property_enum FPEN3 ON FPEN3.PROPERTY_ID = FPV5.IBLOCK_PROPERTY_ID AND FPV5.VALUE_ENUM = FPEN3.ID LEFT JOIN b_iblock_property_enum FPEN4 ON FPEN4.PROPERTY_ID = FPV7.IBLOCK_PROPERTY_ID AND FPV7.VALUE_ENUM = FPEN4.ID LEFT JOIN b_iblock_property_enum FPEN5 ON FPEN5.PROPERTY_ID = FPV8.IBLOCK_PROPERTY_ID AND FPV8.VALUE_ENUM = FPEN5.ID LEFT JOIN b_iblock_property_enum FPEN6 ON FPEN6.PROPERTY_ID = FPV9.IBLOCK_PROPERTY_ID AND FPV9.VALUE_ENUM = FPEN6.ID LEFT JOIN b_iblock_property_enum FPEN7 ON FPEN7.PROPERTY_ID = FPV10.IBLOCK_PROPERTY_ID AND FPV10.VALUE_ENUM = FPEN7.ID LEFT JOIN b_iblock_property_enum FPEN8 ON FPEN8.PROPERTY_ID = FPV11.IBLOCK_PROPERTY_ID AND FPV11.VALUE_ENUM = FPEN8.ID LEFT JOIN b_iblock_property_enum FPEN9 ON FPEN9.PROPERTY_ID = FPV12.IBLOCK_PROPERTY_ID AND FPV12.VALUE_ENUM = FPEN9.ID LEFT JOIN b_iblock_property_enum FPEN10 ON FPEN10.PROPERTY_ID = FPV13.IBLOCK_PROPERTY_ID AND FPV13.VALUE_ENUM = FPEN10.ID LEFT JOIN b_iblock_property_enum FPEN11 ON FPEN11.PROPERTY_ID = FPV14.IBLOCK_PROPERTY_ID AND FPV14.VALUE_ENUM = FPEN11.ID INNER JOIN ( SELECT DISTINCT BSE.IBLOCK_ELEMENT_ID FROM b_iblock_section_element BSE INNER JOIN b_iblock_section BSubS ON BSE.IBLOCK_SECTION_ID = BSubS.ID INNER JOIN b_iblock_section BS ON (BSubS.IBLOCK_ID=BS.IBLOCK_ID AND BSubS.LEFT_MARGIN>=BS.LEFT_MARGIN AND BSubS.RIGHT_MARGIN<=BS.RIGHT_MARGIN) WHERE ((BS.ID IN (1433))) ) BES ON BES.IBLOCK_ELEMENT_ID = BE.ID WHERE 1=1 AND ( ((((BE.IBLOCK_ID = '3')))) AND ( ( ((((FPV15.VALUE_NUM = '12309')))) ) OR ( (((FPV15.VALUE_NUM IS NULL))) ) ) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) [[2006] MySQL server has gone away]

DB query error.
Please try later.





Fatal error: Uncaught Bitrix\Main\DB\SqlQueryException: Mysql query error: (2006) MySQL server has gone away in /home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection.php:137 Stack trace: #0 /home/bitrix/www/bitrix/modules/main/lib/db/connection.php(330): Bitrix\Main\DB\MysqliConnection->queryInternal('SELECT \n\t`main_...', Array, NULL) #1 /home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php(3222): Bitrix\Main\DB\Connection->query('SELECT \n\t`main_...') #2 /home/bitrix/www/bitrix/modules/main/lib/orm/query/query.php(810): Bitrix\Main\ORM\Query\Query->query('SELECT \n\t`main_...') #3 /home/bitrix/www/bitrix/modules/main/lib/orm/data/datamanager.php(500): Bitrix\Main\ORM\Query\Query->exec() #4 /home/bitrix/www/bitrix/modules/main/lib/analytics/sitespeed.php(95): Bitrix\Main\ORM\Data\DataManager::getList(Array) #5 /home/bitrix/www/bitrix/modules/main/lib/analytics/counter.php(92): Bitrix\Main\Analytics\SiteSpeed::isIntranetSite('s1') #6 /home/bitrix/www/bitrix/modules/main/classes/general/module.php(490): Bit in /home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection.php on line 137