Sports J M Cyr Inc

Establishment and bicycle store at 1252 Chemin de la Vernière, L'Étang-du-Nord, QC G4T 3E6, Canada. Here you will find detailed information about Sports J M Cyr Inc: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Bicycle store  

Address:
1252 Chemin de la Vernière
L'Étang-du-Nord
Quebec G4T 3E6
Canada
Get directions

Phone:
+1 418-986-6161

Reviews of Sports J M Cyr Inc

Sorry, but now we haven't any revews about Sports J M Cyr Inc.

Add review

3SELECT * FROM `item` WHERE url = 'sports-j-m-cyr-inc' LIMIT 1
5SELECT * FROM `region` WHERE id IN ('178') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17685') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('83067')
4SELECT * FROM `category` WHERE id IN ('96','178') LIMIT 2
1SELECT * FROM `locality` WHERE url = 'letang-du-nord-qc' LIMIT 1
1SELECT * FROM `region` WHERE id = 178 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 83067 AND `date` < '2024-04-19 20:23:55' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('83067')
3SELECT * FROM `item` WHERE id IN ('367488','82950','82883','367433','367528','367773') LIMIT 6
1SELECT * FROM `region` WHERE id IN ('178') LIMIT 1
2SELECT * FROM `locality` WHERE id IN ('17685') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('82883','82950','367433','367488','367528','367773')
1SELECT * FROM `category` WHERE id IN ('96','166','132','103','118','97') LIMIT 6
1SELECT * FROM counts where updated="2024-04-19" and table_name like 'news'
1SELECT * FROM counts where updated="2024-04-19" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
4SELECT * 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
1SELECT * FROM `region` WHERE id IN ('176','172') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('16896','17210','15932') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('115864','115865','115866','115867')
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
1SELECT * FROM `region` WHERE id IN ('168') LIMIT 1