SPRAVMER.RU

Эффект

Полная информация об организации Эффект по адресу улица Софьи Перовской, 31/11, в Мурманске, Мурманской области: адрес, телефон, официальный сайт, отзывы, фотографии.

Парикмахерская  


Контакты

Адрес:
улица Софьи Перовской, 31/11, Мурманск, Мурманская область

Телефоны:
+7 (8152) 60-06-25

Время работы

ежедневно
9:00–21:00

Социальные сети

Вконтакте: https://vk.com/effect51


Вы владелец?

Фотографии



Отзывы

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

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

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

27.04.2024 -1 — 0 ℃
2 — 4 м/с
28.04.2024 -5 — 1 ℃
1 — 4 м/с
29.04.2024 -9 — 2 ℃
0 — 2 м/с

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


3SELECT * FROM `item` WHERE url = 'effekt-murmansk' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('30') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('560') LIMIT 1
3SELECT item_id, category_id, sub_category_id, sub_sub_category_id FROM `sub_sub_category_item` WHERE item_id IN ('444438')
0SELECT * FROM `category` WHERE id IN ('20') LIMIT 1
0SELECT * FROM `sub_category` WHERE id IN ('81') LIMIT 1
0SELECT * FROM `sub_sub_category` WHERE id IN ('130') LIMIT 1
0SELECT * FROM `metro_item` WHERE item_id IN ('444438') ORDER BY distance
0SELECT * FROM `locality` WHERE url = 'murmansk' LIMIT 1
0SELECT * FROM `region` WHERE id = 30 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 444438 AND `date` < '2024-04-27 19:46:26' ORDER BY `date` DESC
30SELECT * FROM `item` WHERE id IN ('443604','447019','445056','446877','446891','446050') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('30') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('560') LIMIT 1
37SELECT item_id, category_id, sub_category_id, sub_sub_category_id FROM `sub_sub_category_item` WHERE item_id IN ('443604','445056','446050','446877','446891','447019')
1SELECT * FROM `category` WHERE id IN ('7','14','5','1','6') LIMIT 5
0SELECT * FROM `sub_category` WHERE id IN ('66','100','29','34','19','11','14') LIMIT 7
0SELECT * FROM `sub_sub_category` WHERE id IN ('283','309','40','200','201','576','56','12','16','133','134') LIMIT 11
1SELECT * FROM `metro_item` WHERE item_id IN ('443604','445056','446050','446877','446891','447019') ORDER BY distance
2SELECT * FROM counts where updated="2024-04-27" and table_name like 'item'
10SELECT * FROM `item` WHERE id IN ('676713','841305','231113','228505','2038','237022','571469','1044171','328905','1015950','726197','774263','830305','1003999') LIMIT 4
1SELECT * FROM `region` WHERE id IN ('1','21') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('2','332','340','365') LIMIT 4
26SELECT item_id, category_id, sub_category_id, sub_sub_category_id FROM `sub_sub_category_item` WHERE item_id IN ('2038','228505','231113','237022')
0SELECT * FROM `category` WHERE id IN ('12','13','16','1') LIMIT 4
0SELECT * FROM `sub_category` WHERE id IN ('54','26','115','118','28','70','40') LIMIT 7
0SELECT * FROM `sub_sub_category` WHERE id IN ('82','264','610','602','326','265','226','57') LIMIT 8
0SELECT * FROM `metro_item` WHERE item_id IN ('2038','228505','231113','237022') ORDER BY distance
0SELECT * FROM counts where updated="2024-04-27" and table_name like 'locality'
0SELECT * FROM `locality` WHERE id IN ('515','1207','818','1115','1107','717','1037','465','805','498','966','1096','1146','605','499','1033','1187') LIMIT 7
0SELECT * FROM `region` WHERE id IN ('27','29','32','39','45') LIMIT 5
0SELECT * FROM counts where updated="2024-04-27" and table_name like 'sub_sub_category_item'
5SELECT * FROM `sub_sub_category_item` WHERE id IN ('50783','1635625','1471107','248450','680949','1170945','208433','1537220','1342466','1445068','589756','898914','367525','264286','1637974','1060203','1022694') LIMIT 7
0SELECT * FROM `region` WHERE id IN ('58','69','75','1','73','29','74') LIMIT 7
0SELECT * FROM `locality` WHERE id IN ('966','1171','1270','2','1253','473','1266') LIMIT 7
1SELECT * FROM `category` WHERE id IN ('4','9','5','13','19','6','11') LIMIT 7
1SELECT * FROM `sub_category` WHERE id IN ('5','18','35','40','51','14','69') LIMIT 7
1SELECT * FROM `sub_sub_category` WHERE id IN ('5','43','55','57','73','134','166') LIMIT 7
1SELECT * FROM counts where updated="2024-04-27" and table_name like 'sub_sub_category_item'
8SELECT * FROM `sub_sub_category_item` WHERE id IN ('853254','874556','999661','1284386','1411330','1418967','1606176','994972','712756','933738','1134068','220606','642054','734977','1313968','1015415','969909') LIMIT 7
0SELECT * FROM `region` WHERE id IN ('16','43','38','50','28','55') LIMIT 6
0SELECT * FROM `locality` WHERE id IN ('250','751','700','864','469','911') LIMIT 6
1SELECT * FROM `category` WHERE id IN ('5','20','8','1','12') LIMIT 5
0SELECT * FROM `sub_category` WHERE id IN ('35','81','71','70','4','54') LIMIT 6
0SELECT * FROM `sub_sub_category` WHERE id IN ('50','148','175','182','223','231','264') LIMIT 7
0SELECT * FROM counts where updated="2024-04-27" and table_name like 'sub_sub_category_item'
12SELECT * FROM `sub_sub_category_item` WHERE id IN ('505496','1140936','1353505','400742','1590262','1346892','944191','1481831','208708','555397','106882','458442','197853','1596803','1570816','588199','742908') LIMIT 7
0SELECT * FROM `region` WHERE id IN ('57','60','72','55','50','62','49') LIMIT 7
1SELECT * FROM `locality` WHERE id IN ('931','999','1248','917','864','1023','838') LIMIT 7
0SELECT * FROM `category` WHERE id IN ('2','14','9','12','18','1','7') LIMIT 7
1SELECT * FROM `sub_category` WHERE id IN ('16','29','18','54','46','4','17') LIMIT 7
1SELECT * FROM `sub_sub_category` WHERE id IN ('18','40','43','82','105','114','125') LIMIT 7