Crown & Tower Pub

Establishment, food and bar at 11 Bellerose Drive, St. Albert, AB T8N 5E1, Canada. Here you will find detailed information about Crown & Tower Pub: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Food   Bar  

Address:
11 Bellerose Drive
St. Albert
Alberta T8N 5E1
Canada
Get directions

Phone:
+1 780-419-6754

Website:
thecrownandtower.com

Photos

Reviews of Crown & Tower Pub

Sorry, but now we haven't any revews about Crown & Tower Pub.

Add review

About thecrownandtower.com

The Crown & Tower | Delicious Cuisine in a Fun Atmosphere!
Welcome to The Crown & Tower! We are located at 11 Bellerose Drive in St. Albert, AB T8N 5C9. Our phone number is 780-419-6754. We look forward to seeing you!

1SELECT * FROM `item` WHERE url = 'crown-tower-pub' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('168') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14590') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('333601')
0SELECT * FROM `category` WHERE id IN ('96','99','144') LIMIT 3
0SELECT * FROM `locality` WHERE url = 'st-albert-ab' LIMIT 1
0SELECT * FROM `region` WHERE id = 168 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 333601 AND `date` < '2024-04-28 05:30:39' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('333601')
1SELECT * FROM `item` WHERE id IN ('331286','333756','331422','331463','254424','333975') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('168') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14590') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('254424','331286','331422','331463','333756','333975')
0SELECT * FROM `category` WHERE id IN ('96','99','158','97','123','118','138','141','126','127') LIMIT 10
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'
0SELECT * FROM `category` ORDER BY name
2SELECT * 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 ('172','168') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('15734','14262','14392') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('251141','251142','251143','251144')
0SELECT * 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