Магазин сантехники и слесарно-монтажного инструмента

Полная информация об организации Магазин сантехники и слесарно-монтажного инструмента по адресу улица Стара Загора, 141, в Самаре, Самарской области: адрес, телефон, официальный сайт, отзывы, фотографии.

Магазин сантехники  


Контакты

Адрес:
улица Стара Загора, 141, Самара, Самарская область

Телефоны:
+7 (927) 207-39-33

Время работы

пн-сб 9:00–20:00
вс 10:00–19:00


Вы владелец?

Фотографии



Отзывы

В данный момент отзывов не оставлено.

Как бы вы оценили эту компанию?

Погода в Самаре, Самарской области

27.04.2024 16 — 27
2 — 7 м/с
28.04.2024 16 — 24
3 — 5 м/с
29.04.2024 9 — 15
4 — 6 м/с

Ближайшие компании


2SELECT * FROM `item` WHERE url = 'magazin-santehniki-i-slesarno-montazhnogo-instrumenta-samara' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('60') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('999') LIMIT 1
5SELECT item_id, category_id, sub_category_id, sub_sub_category_id FROM `sub_sub_category_item` WHERE item_id IN ('776367')
0SELECT * FROM `category` WHERE id IN ('5') LIMIT 1
0SELECT * FROM `sub_category` WHERE id IN ('35') LIMIT 1
0SELECT * FROM `sub_sub_category` WHERE id IN ('199') LIMIT 1
1SELECT * FROM `metro_item` WHERE item_id IN ('776367') ORDER BY distance
0SELECT * FROM `locality` WHERE url = 'samara' LIMIT 1
0SELECT * FROM `region` WHERE id = 60 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 776367 AND `date` < '2024-04-27 19:46:25' ORDER BY `date` DESC
4SELECT * FROM `item` WHERE id IN ('779583','771572','763848','761858','764901','770589') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('60') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('999') LIMIT 1
36SELECT item_id, category_id, sub_category_id, sub_sub_category_id FROM `sub_sub_category_item` WHERE item_id IN ('761858','763848','764901','770589','771572','779583')
0SELECT * FROM `category` WHERE id IN ('7','16','1','17','18','20','8') LIMIT 7
0SELECT * FROM `sub_category` WHERE id IN ('91','149','48','90','50','46','81','57','10','114','19') LIMIT 11
0SELECT * FROM `sub_sub_category` WHERE id IN ('535','767','826','68','164','186','187','66','310','337','275','303','859') LIMIT 13
2SELECT * FROM `metro_item` WHERE item_id IN ('761858','763848','764901','770589','771572','779583') ORDER BY distance
0SELECT * FROM counts where updated="2024-04-27" and table_name like 'item'
8SELECT * FROM `item` WHERE id IN ('473791','380755','653384','351840','863016','127373','766855','148737','455465','726297','304797','959673','277228','1039748') LIMIT 4
0SELECT * FROM `region` WHERE id IN ('14','15','24','26') LIMIT 4
0SELECT * FROM `locality` WHERE id IN ('204','241','417','462') LIMIT 4
14SELECT item_id, category_id, sub_category_id, sub_sub_category_id FROM `sub_sub_category_item` WHERE item_id IN ('127373','148737','277228','304797')
0SELECT * FROM `category` WHERE id IN ('13','9','5') LIMIT 3
0SELECT * FROM `sub_category` WHERE id IN ('89','18','37','32') LIMIT 4
0SELECT * FROM `sub_sub_category` WHERE id IN ('162','23','52','170') LIMIT 4
0SELECT * FROM `metro_item` WHERE item_id IN ('127373','148737','277228','304797') ORDER BY distance
0SELECT * FROM counts where updated="2024-04-27" and table_name like 'locality'
1SELECT * FROM `locality` WHERE id IN ('822','929','1297','555','807','567','976','672','357','625','615','1086','643','1210','340','711','944') LIMIT 7
0SELECT * FROM `region` WHERE id IN ('21','30','33','35') LIMIT 4
0SELECT * FROM counts where updated="2024-04-27" and table_name like 'sub_sub_category_item'
2SELECT * FROM `sub_sub_category_item` WHERE id IN ('125576','1544753','1431129','242731','185620','706123','668076','1125995','744172','1210367','6027','1124652','704012','438255','98089','1631258','1127350') LIMIT 7
0SELECT * FROM `region` WHERE id IN ('51','8','37','21','76','58','67') LIMIT 7
0SELECT * FROM `locality` WHERE id IN ('871','142','675','332','1307','977','1145') LIMIT 7
0SELECT * FROM `category` WHERE id IN ('1','6','2','13','15','7') LIMIT 6
0SELECT * FROM `sub_category` WHERE id IN ('1','15','2','25','38','62','89') LIMIT 7
0SELECT * FROM `sub_sub_category` WHERE id IN ('1','17','20','35','53','94','162') LIMIT 7
0SELECT * FROM counts where updated="2024-04-27" and table_name like 'sub_sub_category_item'
3SELECT * FROM `sub_sub_category_item` WHERE id IN ('454673','120835','449479','639631','1328887','347019','857606','1199207','858645','1365066','734945','24201','960043','1633397','1060356','1412529','1378320') LIMIT 7
0SELECT * FROM `region` WHERE id IN ('37','18','22','62','12','29','49') LIMIT 7
3SELECT * FROM `locality` WHERE id IN ('672','258','392','1027','190','514','851') LIMIT 7
0SELECT * FROM `category` WHERE id IN ('3','2','1','7','20') LIMIT 5
0SELECT * FROM `sub_category` WHERE id IN ('3','2','48','64','66','81','70') LIMIT 7
0SELECT * FROM `sub_sub_category` WHERE id IN ('3','20','68','97','101','148','182') LIMIT 7
0SELECT * FROM counts where updated="2024-04-27" and table_name like 'sub_sub_category_item'
3SELECT * FROM `sub_sub_category_item` WHERE id IN ('389210','475968','1096713','43902','969268','1169860','304817','1394297','294214','89323','168134','1599326','703359','1603660','755443','316254','1467832') LIMIT 7
0SELECT * FROM `region` WHERE id IN ('31','51','72','32','71','29','4') LIMIT 7
0SELECT * FROM `locality` WHERE id IN ('586','871','1245','598','1214','478','63') LIMIT 7
0SELECT * FROM `category` WHERE id IN ('4','7','10','16','3') LIMIT 5
0SELECT * FROM `sub_category` WHERE id IN ('5','12','24','42','44','47') LIMIT 6
0SELECT * FROM `sub_sub_category` WHERE id IN ('5','14','29','60','62','81') LIMIT 6