SPRAVMER.RU

Кафе у Камина

Полная информация об организации Кафе у Камина по адресу улица 17 Стрелковой Дивизии, 8, в Малоярославеце, Калужской области: адрес, телефон, официальный сайт, отзывы, фотографии.

Кондитерская   Кафе   Пиццерия  


Контакты

Адрес:
улица 17 Стрелковой Дивизии, 8, Малоярославец, Калужская область

Телефоны:
+7 (48431) 2-67-01

Время работы

ежедневно
10:00–20:00


Вы владелец?

Фотографии



Отзывы

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

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

Погода в Малоярославеце, Калужской области

27.04.2024 9 — 13 ℃
2 — 4 м/с
28.04.2024 6 — 15 ℃
2 — 3 м/с
29.04.2024 6 — 18 ℃
1 — 3 м/с

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


2SELECT * FROM `item` WHERE url = 'kafe-u-kamina-maloyaroslavec' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('15') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('237') LIMIT 1
2SELECT item_id, category_id, sub_category_id, sub_sub_category_id FROM `sub_sub_category_item` WHERE item_id IN ('147498')
0SELECT * FROM `category` WHERE id IN ('1','3') LIMIT 2
0SELECT * FROM `sub_category` WHERE id IN ('4','3') LIMIT 2
0SELECT * FROM `sub_sub_category` WHERE id IN ('232','3','334') LIMIT 3
0SELECT * FROM `metro_item` WHERE item_id IN ('147498') ORDER BY distance
0SELECT * FROM `locality` WHERE url = 'maloyaroslavec' LIMIT 1
0SELECT * FROM `region` WHERE id = 15 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 147498 AND `date` < '2024-04-27 19:46:23' ORDER BY `date` DESC
4SELECT * FROM `item` WHERE id IN ('147530','147411','147544','147493','147601','147689') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('15') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('237') LIMIT 1
4SELECT item_id, category_id, sub_category_id, sub_sub_category_id FROM `sub_sub_category_item` WHERE item_id IN ('147411','147493','147530','147544','147601','147689')
0SELECT * FROM `category` WHERE id IN ('16','14','3','8','5') LIMIT 5
0SELECT * FROM `sub_category` WHERE id IN ('149','96','47','107','35','105') LIMIT 6
0SELECT * FROM `sub_sub_category` WHERE id IN ('774','808','81','874','136','701','606') LIMIT 7
0SELECT * FROM `metro_item` WHERE item_id IN ('147411','147493','147530','147544','147601','147689') ORDER BY distance
0SELECT * FROM counts where updated="2024-04-27" and table_name like 'item'
10SELECT * FROM `item` WHERE id IN ('900229','149678','404092','497674','271048','725974','302274','301152','318679','357','1030082','833897','262587','866235') LIMIT 4
1SELECT * FROM `region` WHERE id IN ('1','15','22','23') LIMIT 4
0SELECT * FROM `locality` WHERE id IN ('2','241','402','412') LIMIT 4
28SELECT item_id, category_id, sub_category_id, sub_sub_category_id FROM `sub_sub_category_item` WHERE item_id IN ('357','149678','262587','271048')
0SELECT * FROM `category` WHERE id IN ('2','5','7','1','17') LIMIT 5
0SELECT * FROM `sub_category` WHERE id IN ('2','37','39','82','48','90','50') LIMIT 7
0SELECT * FROM `sub_sub_category` WHERE id IN ('19','673','496','616','142','68','164','186') LIMIT 8
0SELECT * FROM `metro_item` WHERE item_id IN ('357','149678','262587','271048') ORDER BY distance
0SELECT * FROM counts where updated="2024-04-27" and table_name like 'locality'
0SELECT * FROM `locality` WHERE id IN ('779','582','1016','238','132','166','118','903','997','533','1113','1199','1338','315','580','881','688') LIMIT 7
0SELECT * FROM `region` WHERE id IN ('7','9','15','21','29','31') LIMIT 6
0SELECT * FROM counts where updated="2024-04-27" and table_name like 'sub_sub_category_item'
1SELECT * FROM `sub_sub_category_item` WHERE id IN ('530805','866693','124379','148408','818329','1262049','731699','480666','110355','1037443','1638979','377876','744878','1160329','1519473','353837','1262131') LIMIT 7
1SELECT * FROM `region` WHERE id IN ('76','28','72','21','61','47') LIMIT 6
0SELECT * FROM `locality` WHERE id IN ('1292','469','1223','381','1007','1249','824') LIMIT 7
0SELECT * FROM `category` WHERE id IN ('2','9','17','16','12','1') LIMIT 6
0SELECT * FROM `sub_category` WHERE id IN ('16','2','18','50','52','23','72') LIMIT 7
0SELECT * FROM `sub_sub_category` WHERE id IN ('18','20','23','71','78','112','120') 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 ('428195','1482602','1070161','1046547','1560439','1440341','802956','199859','1545335','254124','21251','795513','59938','1526932','871097','1620860','567839') LIMIT 7
0SELECT * FROM `region` WHERE id IN ('24','55','21','29','18','12') LIMIT 6
0SELECT * FROM `locality` WHERE id IN ('417','901','319','540','271','183','516') LIMIT 7
0SELECT * FROM `category` WHERE id IN ('3','5','8','1','4','20') LIMIT 6
0SELECT * FROM `sub_category` WHERE id IN ('3','6','30','19','61','81','34') LIMIT 7
0SELECT * FROM `sub_sub_category` WHERE id IN ('3','6','41','56','92','130','200') LIMIT 7
0SELECT * FROM counts where updated="2024-04-27" and table_name like 'sub_sub_category_item'
1SELECT * FROM `sub_sub_category_item` WHERE id IN ('435962','670014','1217686','316994','1312057','755359','904974','286335','186550','539861','1440508','1478864','1318308','1454134','74039','921505','529742') LIMIT 7
0SELECT * FROM `region` WHERE id IN ('30','55','7','39','64','35','37') LIMIT 7
0SELECT * FROM `locality` WHERE id IN ('555','902','117','713','1070','650','679') LIMIT 7
0SELECT * FROM `category` WHERE id IN ('1','13','7','16','4','9') LIMIT 6
0SELECT * FROM `sub_category` WHERE id IN ('1','25','42','44','27','72','22') LIMIT 7
0SELECT * FROM `sub_sub_category` WHERE id IN ('11','35','60','62','93','120','122') LIMIT 7