Aux Berges Du Lac Castor

Establishment and lodging at 3800 Chemin des Allumettes, Saint-Paulin, QC J0K 3G0, Canada. Here you will find detailed information about Aux Berges Du Lac Castor: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging  

Address:
3800 Chemin des Allumettes
Saint-Paulin
Quebec J0K 3G0
Canada
Get directions

Website:
laccastor.com

Photos

Reviews of Aux Berges Du Lac Castor

Sorry, but now we haven't any revews about Aux Berges Du Lac Castor.

Add review

About laccastor.com

Aux berges du Lac Castor - Auberge, yourtes, chalets, huttes et campings
La coopérante équipe du Lac Castor, vous souhaite la bienvenue dans sa forêt de la Mauricie. Hébergement, auberge, chalet, huttes, camping et activités.

1SELECT * FROM `item` WHERE url = 'aux-berges-du-lac-castor-2' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('178') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('18229') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('46464')
0SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
1SELECT * FROM `locality` WHERE url = 'saint-paulin-qc' LIMIT 1
1SELECT * FROM `region` WHERE id = 178 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 46464 AND `date` < '2024-04-23 20:19:58' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('46464')
2SELECT * FROM `item` WHERE id IN ('46336','408261','408362','408346','408335','408265') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('178') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('18229') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('46336','408261','408265','408335','408346','408362')
0SELECT * FROM `category` WHERE id IN ('96','99','106','107','108','130','131','115','118') LIMIT 9
0SELECT * FROM counts where updated="2024-04-23" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-23" 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
0SELECT * FROM `region` WHERE id IN ('169','172') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('14663','14878','15716','14744') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('352363','352364','352365','352366')
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