Black Knight Inn

Establishment and lodging at 2929 50 Avenue, Red Deer, AB T4R 1H1, Canada. Here you will find detailed information about Black Knight Inn: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging  

Address:
2929 50 Avenue
Red Deer
Alberta T4R 1H1
Canada
Get directions

Phone:
+1 403-343-6666

Website:
blackknightinn.ca

Photos

Reviews of Black Knight Inn

Sorry, but now we haven't any revews about Black Knight Inn.

Add review

About blackknightinn.ca

Black Knight Inn - A Home away from home
We offer a choice of deluxe accommodations from the 98 spacious rooms throughout our newly renovated interior, including our Business Class floor, elegant Executive suites, Jacuzzi suites and family accommodations with adjoining rooms.

1SELECT * FROM `item` WHERE url = 'black-knight-inn' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('168') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14542') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('223949')
0SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'red-deer-ab' LIMIT 1
0SELECT * FROM `region` WHERE id = 168 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 223949 AND `date` < '2024-04-28 04:10:37' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('223949')
1SELECT * FROM `item` WHERE id IN ('247755','223899','223823','223966','223985','223973') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('168') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14542') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('223823','223899','223966','223973','223985','247755')
0SELECT * FROM `category` WHERE id IN ('96','174','128','152','148','122','118') LIMIT 7
0SELECT * FROM counts where updated="2024-04-28" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-28" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
1SELECT * 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 ('169','176','168') LIMIT 3
0SELECT * FROM `locality` WHERE id IN ('14783','16868','17013','14330') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('388226','388227','388228','388229')
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 ('178') LIMIT 1