Pourvoirie Club Bataram

Establishment and lodging at 41 Rue Beauregard, Clermont, QC G4A 1H4, Canada. Here you will find detailed information about Pourvoirie Club Bataram: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging  

Address:
41 Rue Beauregard
Clermont
Quebec G4A 1H4
Canada
Get directions

Phone:
+1 418-439-1717

Website:
clubbataram.qc.ca

Opening hours

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

Reviews of Pourvoirie Club Bataram

Sorry, but now we haven't any revews about Pourvoirie Club Bataram.

Add review

About clubbataram.qc.ca

Pourvoirie Charlevoix, Chasse et Pêche, Club Bataram
Pourvoirie de Charlevoix qui regroupe une trentaine de lacs et offre des activités de pêche, de chasse dans Charlevoix et pour vos vacances en famille.

1SELECT * FROM `item` WHERE url = 'pourvoirie-club-bataram' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('178') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17532') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('77581')
0SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'clermont-qc' LIMIT 1
0SELECT * FROM `region` WHERE id = 178 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 77581 AND `date` < '2024-04-25 12:07:15' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('77581')
1SELECT * FROM `item` WHERE id IN ('362764','87999','77602','88141','88041','87879') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('178') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17532') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('77602','87879','87999','88041','88141','362764')
0SELECT * FROM `category` WHERE id IN ('96','100','124','103','107','108') LIMIT 6
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
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 ('178','176') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('18431','16661','16658') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('431546','431547','431548','431549')
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