Connor's Irish Pub

Establishment, food and bar at 2401 Saint Joseph Boulevard, Orléans, Ottawa, ON K1C 1E9, Canada. Here you will find detailed information about Connor's Irish Pub: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Food   Bar  

Address:
2401 Saint Joseph Boulevard
Orléans
Ottawa
Ontario K1C 1E9
Canada
Get directions

Phone:
+1 613-837-5050

Website:
connorspubs.com

Reviews of Connor's Irish Pub

Sorry, but now we haven't any revews about Connor's Irish Pub.

Add review

About connorspubs.com

Connors Pubs - Ottawa's Authentic Gaelic Eatery and Pub
Connors Pubs has two locations to serve you, Orleans and Centretown. Come dine with us!
Ottawa, Irish Pub, Irish Eatery, Orleans, Orleans bar, Centretown bar, Orleans restaurant

0SELECT * FROM `item` WHERE url = 'connors-irish-pub' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17033') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('433745')
0SELECT * FROM `category` WHERE id IN ('96','99','144') LIMIT 3
0SELECT * FROM `locality` WHERE url = 'ottawa-on' LIMIT 1
0SELECT * FROM `region` WHERE id = 176 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 433745 AND `date` < '2024-04-25 08:26:35' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('433745')
0SELECT * FROM `item` WHERE id IN ('436175','434287','435330','435129','433870','434496') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17033') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('433870','434287','434496','435129','435330','436175')
0SELECT * FROM `category` WHERE id IN ('96','100','151','152','99','115','97','118','131','175','128') LIMIT 11
0SELECT * FROM counts where updated="2024-04-25" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-25" 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 ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17253','17036','16510','17084') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('14670','14671','14672','14673')
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