All types
 
Français

Companies in Dead Man's Flats, Canada

List of companies in Dead Man's Flats, Alberta: find addresses, phone numbers, email, social networks, photos, customer reviews and more.

Last reviews about companies in Dead Man's Flats, Canada

  •  
    Barinderpal Nanuan Added 2018-11-07
    ★ ★ ★ ★ ☆
    Had the 2 bedroom suite for a night. Everything was clean. Didn't have any problems like the other guests. Felt like it was overpriced especially for ...
    Feedback on Big Horn Motel
  •  
    Tracey B Added 2018-10-31
    ★ ☆ ☆ ☆ ☆
    The walls are thin. The bar is next door. This is a very loud area in general. For what we paid, extremely overpriced for a bed with a musty comforte...
    Feedback on Big Horn Motel
  •  
    Nima Mostofi Added 2018-10-22
    ★ ☆ ☆ ☆ ☆
    Checked in late, the hotel manager, was very poor in speaking english and communicating. Wore dirty close and shuffled around. It all seemed that we w...
    Feedback on Big Horn Motel

Popular companies in Dead Man's Flats

Share this page

Types of companies in Canada

0SELECT * FROM `locality` WHERE url = 'dead-mans-flats-ab' LIMIT 1
1UPDATE locality SET weather = '{\"date\":\"2024-04-18\",\"data\":{\"2024-04-18\":{\"04\":{\"temp\":-6,\"pressure\":1038,\"humidity\":94,\"icon\":\"04n\",\"wind\":1},\"07\":{\"temp\":-9,\"pressure\":1039,\"humidity\":95,\"icon\":\"04n\",\"wind\":2},\"10\":{\"temp\":-4,\"pressure\":1035,\"humidity\":75,\"icon\":\"02d\",\"wind\":1},\"13\":{\"temp\":-0,\"pressure\":1032,\"humidity\":53,\"icon\":\"03d\",\"wind\":2},\"16\":{\"temp\":1,\"pressure\":1031,\"humidity\":58,\"icon\":\"13d\",\"wind\":2},\"19\":{\"temp\":-0,\"pressure\":1031,\"humidity\":66,\"icon\":\"13d\",\"wind\":1},\"22\":{\"temp\":-4,\"pressure\":1034,\"humidity\":84,\"icon\":\"13n\",\"wind\":2}},\"2024-04-19\":{\"01\":{\"temp\":-7,\"pressure\":1038,\"humidity\":87,\"icon\":\"04n\",\"wind\":1},\"04\":{\"temp\":-8,\"pressure\":1039,\"humidity\":89,\"icon\":\"04n\",\"wind\":1},\"07\":{\"temp\":-10,\"pressure\":1041,\"humidity\":93,\"icon\":\"04n\",\"wind\":1},\"10\":{\"temp\":-4,\"pressure\":1037,\"humidity\":69,\"icon\":\"04d\",\"wind\":1},\"13\":{\"temp\":0,\"pressure\":1033,\"humidity\":56,\"icon\":\"04d\",\"wind\":2},\"16\":{\"temp\":2,\"pressure\":1031,\"humidity\":52,\"icon\":\"04d\",\"wind\":2},\"19\":{\"temp\":2,\"pressure\":1029,\"humidity\":49,\"icon\":\"04d\",\"wind\":2},\"22\":{\"temp\":-4,\"pressure\":1034,\"humidity\":88,\"icon\":\"04n\",\"wind\":1}},\"2024-04-20\":{\"01\":{\"temp\":-6,\"pressure\":1035,\"humidity\":89,\"icon\":\"03n\",\"wind\":1},\"04\":{\"temp\":-7,\"pressure\":1035,\"humidity\":89,\"icon\":\"02n\",\"wind\":1},\"07\":{\"temp\":-8,\"pressure\":1033,\"humidity\":90,\"icon\":\"01n\",\"wind\":2},\"10\":{\"temp\":-0,\"pressure\":1027,\"humidity\":64,\"icon\":\"01d\",\"wind\":1},\"13\":{\"temp\":6,\"pressure\":1021,\"humidity\":49,\"icon\":\"01d\",\"wind\":1},\"16\":{\"temp\":9,\"pressure\":1016,\"humidity\":46,\"icon\":\"01d\",\"wind\":1},\"19\":{\"temp\":8,\"pressure\":1013,\"humidity\":50,\"icon\":\"01d\",\"wind\":2},\"22\":{\"temp\":1,\"pressure\":1016,\"humidity\":85,\"icon\":\"01n\",\"wind\":3}}}}' WHERE id = 14321 LIMIT 1
0SELECT * FROM `region` WHERE id = 168 LIMIT 1
7SELECT * FROM `item` WHERE `locality_id` = 14321 ORDER BY count_views LIMIT 12
0SELECT * FROM `region` WHERE id IN ('168') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14321') LIMIT 1
1SELECT * FROM `photos` WHERE `item_id` IN ('339250','197483','195961','195793','197519','197608','197636','197831','197664','338322','339255')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('339250','197483','195961','195793','197519','197608','197636','197831','197664','338322','339255')
0SELECT * FROM `category` WHERE id IN ('96','107','103','110','99','97') LIMIT 6
20SELECT * FROM `reviews` WHERE `status` = 1 AND `locality_id` = 14321 AND `date` < '2024-04-18 06:45:48' ORDER BY `date` DESC LIMIT 3
1SELECT * FROM `region` WHERE id IN ('168') LIMIT 1
1SELECT * FROM `locality` WHERE id IN ('14321') LIMIT 1
1SELECT * FROM `item` WHERE id IN ('195961') LIMIT 1
8SELECT locality_id, category_id FROM `category_item` WHERE locality_id = 14321 GROUP BY locality_id, category_id
1SELECT * FROM `category` WHERE `id` IN ('96','97','99','103','107','110') ORDER BY name
0SELECT * FROM counts where updated="2024-04-18" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-18" and table_name like 'news'
0SELECT * FROM `category` ORDER BY name
4SELECT * FROM `item` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `item`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 4
0SELECT * FROM `region` WHERE id IN ('170','169') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('15371','14708','14677') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('194726','194727','194728','194729')
1SELECT * FROM `locality` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `locality`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 7
0SELECT * FROM `region` WHERE id IN ('168') LIMIT 1