Hotel Le Château de pierre

Establishment and lodging at 17 Avenue Sainte Geneviève, Ville de Québec, QC G1R 4A8, Canada. Here you will find detailed information about Hotel Le Château de pierre: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging  

Address:
17 Avenue Sainte Geneviève
Ville de Québec
Quebec G1R 4A8
Canada
Get directions

Phone:
+1 418-694-0429

Website:
chateaudepierre.com

Opening hours

Sunday 07:00am — 10:00pm
Monday 07:00am — 10:00pm
Tuesday 07:00am — 10:00pm
Wednesday 07:00am — 10:00pm
Thursday 07:00am — 10:00pm
Friday 07:00am — 10:00pm
Saturday 07:00am — 10:00pm

Photos

Reviews of Hotel Le Château de pierre

Sorry, but now we haven't any revews about Hotel Le Château de pierre.

Add review

About chateaudepierre.com

Accueil - Château de Pierre

1SELECT * FROM `item` WHERE url = 'hotel-le-chateau-de-pierre' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('178') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('18455') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('51758')
0SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'ville-de-quebec-qc' LIMIT 1
0SELECT * FROM `region` WHERE id = 178 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 51758 AND `date` < '2024-04-20 10:32:48' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('51758')
1SELECT * FROM `item` WHERE id IN ('80427','51521','51929','80438','51632','51546') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('178') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('18455') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('51521','51546','51632','51929','80427','80438')
0SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
0SELECT * FROM counts where updated="2024-04-20" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-20" 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') LIMIT 1
1SELECT * FROM `locality` WHERE id IN ('17776','17833','18229','17980') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('46324','46325','46326','46327')
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