Chateau Daigle

Establishment and lodging at 4s5, 1499 Saint-Charles-Nord Road, Saint-Charles, NB E4W 4S5, Canada. Here you will find detailed information about Chateau Daigle: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging  

Address:
4s5
1499 Saint-Charles-Nord Road
Saint-Charles
New Brunswick E4W 4S5
Canada
Get directions

Phone:
+1 506-876-4784

Website:
chateaudaigle.ca

Photos

Reviews of Chateau Daigle

Sorry, but now we haven't any revews about Chateau Daigle.

Add review

About chateaudaigle.ca

Chateau Daigle Rooms Rate, Guest rooms in Saint Charles, Chateau Daigle Saint Charles, Chateau Daigle North Saint Charles, Chateau Daigle St Charles, NB Canada
Chateau Daigle Guestroom is situated inside one of the Château's four large turrets thus creating additional privacy and tranquility for guests
Château Daigle, Rooms in Saint Charles, Chateau Daigle Saint Charles, Chateau Daigle North Saint Charles, Chateau Daigle St Charles

1SELECT * FROM `item` WHERE url = 'chateau-daigle' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15613') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('58004')
0SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'saint-charles-nb' LIMIT 1
0SELECT * FROM `region` WHERE id = 171 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 58004 AND `date` < '2024-04-25 19:20:45' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('58004')
1SELECT * FROM `item` WHERE id IN ('58359','72928','72977','58041','72811','72957') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15613','15616') LIMIT 2
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('58041','58359','72811','72928','72957','72977')
0SELECT * FROM `category` WHERE id IN ('96','100','136','99','115') LIMIT 5
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
1SELECT * 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','179') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('17710','18604','18509') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('128474','128475','128477','128478')
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