Midway convence

Establishment and shopping mall at 456-472 J. W. Pickersgill Boulevard, Centreville-Wareham-Trinity, NL A0G 4P0, Canada. Here you will find detailed information about Midway convence: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment Shopping mall

Address:
456-472 J. W. Pickersgill Boulevard
Centreville-Wareham-Trinity
Newfoundland and Labrador A0G 4P0
Canada
Get directions

Phone:
+1 709-678-2825

Opening hours

Sunday	10:00am — 11:00pm
Monday	10:00am — 11:00pm
Tuesday	10:00am — 11:00pm
Wednesday	10:00am — 11:00pm
Thursday	10:00am — 11:00pm
Friday	10:00am — 11:00pm
Saturday	10:00am — 11:00pm

Reviews of Midway convence

Sorry, but now we haven't any revews about Midway convence.

Add review

Share this page

Additional actions

Today's weather in Centreville-Wareham-Trinity

04:00 -1 ℃ 1025 hPa 75 % 3 m/s 07:00 1 ℃ 1024 hPa 74 % 5 m/s 10:00 0 ℃ 1020 hPa 94 % 3 m/s 13:00 1 ℃ 1016 hPa 96 % 5 m/s 16:00 3 ℃ 1012 hPa 98 % 4 m/s 19:00 6 ℃ 1010 hPa 100 % 3 m/s 22:00 10 ℃ 1006 hPa 98 % 5 m/s

1	SELECT * FROM `item` WHERE url = 'midway-convence' LIMIT 1
0	SELECT * FROM `region` WHERE id IN ('172') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('15739') LIMIT 1
0	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('159634')
0	SELECT * FROM `category` WHERE id IN ('96','122') LIMIT 2
0	SELECT * FROM `locality` WHERE url = 'centreville-wareham-trinity-nl' LIMIT 1
0	SELECT * FROM `region` WHERE id = 172 LIMIT 1
1	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 159634 AND `date` < '2024-04-24 20:36:31' ORDER BY `date` DESC
0	SELECT * FROM `photos` WHERE `item_id` IN ('159634')
0	SELECT * FROM `item` WHERE id IN ('159589','159544','159756','159562','159540','159848') LIMIT 6
0	SELECT * FROM `region` WHERE id IN ('172') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('15739','15738') LIMIT 2
0	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('159540','159544','159562','159589','159756','159848')
0	SELECT * FROM `category` WHERE id IN ('96','100','97','98','144','104') LIMIT 6
0	SELECT * FROM counts where updated="2024-04-24" and table_name like 'news'
0	SELECT * FROM counts where updated="2024-04-24" and table_name like 'news'
0	SELECT * FROM `category` ORDER BY name
1	SELECT * 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
0	SELECT * FROM `region` WHERE id IN ('168','169','179') LIMIT 3
0	SELECT * FROM `locality` WHERE id IN ('14297','14937','14452','18728') LIMIT 4
0	SELECT * FROM `photos` WHERE `item_id` IN ('330274','330275','330276','330277')
0	SELECT * 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
0	SELECT * FROM `region` WHERE id IN ('176') LIMIT 1