Scott's Discount Store #76

Establishment and department store at 328 Main Street, Mattawa, ON P0H 1V0, Canada. Here you will find detailed information about Scott's Discount Store #76: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Department store  

Address:
328 Main Street
Mattawa
Ontario P0H 1V0
Canada
Get directions

Phone:
+1 705-744-1485

Website:
gianttiger.com

Reviews of Scott's Discount Store #76

Sorry, but now we haven't any revews about Scott's Discount Store #76.

Add review

About gianttiger.com

Giant Tiger
Giant Tiger, GTxpress, Tigre Géant, Canadian Retail, Family Discount Store, Canada, GT Boutique, Save money, community, products, Smart Savings, surprises, Canada Proud since forever, grocery, family needs, home fashions, trendy fashion, Canada's low price Giant, price match, claw backs, no limit in-store return policy

1SELECT * FROM `item` WHERE url = 'scotts-discount-store-76' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('16913') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('38617')
0SELECT * FROM `category` WHERE id IN ('96','165') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'mattawa-on' LIMIT 1
1SELECT * FROM `region` WHERE id = 176 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 38617 AND `date` < '2024-04-24 07:21:37' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('38617')
1SELECT * FROM `item` WHERE id IN ('37867','37756','37724','37950','37963','38299') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('16913') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('37724','37756','37867','37950','37963','38299')
0SELECT * FROM `category` WHERE id IN ('96','97','99','102','128','148','115','137','136') LIMIT 9
0SELECT * FROM counts where updated="2024-04-24" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-24" and table_name like 'news'
1SELECT * 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 ('169','178','170') LIMIT 3
0SELECT * FROM `locality` WHERE id IN ('14853','17771','17710','15089') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('123969','123971','123972','123973')
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