Windjammer Motel

Establishment and lodging at 4070 Nova Scotia Trunk 3, Chester, NS B0J 1J0, Canada. Here you will find detailed information about Windjammer Motel: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging  

Address:
4070 Nova Scotia Trunk 3
Chester
Nova Scotia B0J 1J0
Canada
Get directions

Phone:
+1 902-275-3567

Website:
windjammermotel.ca

Photos

Reviews of Windjammer Motel

Sorry, but now we haven't any revews about Windjammer Motel.

Add review

About windjammermotel.ca

Motel Accommodation in Chester Nova Scotia: Windjammer Motel
Windjammer Motel, Chester, Nova Scotia, offers cosy accommodations where you can truly enjoy the relaxing ambience of Chester, one of the prettiest villages in Nova Scotia, Canada.
motel chester nova scotia, motel chester canada, accommodation nova scotia, accommodation chester

1SELECT * FROM `item` WHERE url = 'windjammer-motel' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('174') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('16050') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('19978')
0SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'chester-ns' LIMIT 1
0SELECT * FROM `region` WHERE id = 174 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 19978 AND `date` < '2024-04-24 14:58:12' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('19978')
0SELECT * FROM `item` WHERE id IN ('375122','20214','20300','20116','375438','374567') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('174') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('16050') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('20116','20214','20300','374567','375122','375438')
0SELECT * FROM `category` WHERE id IN ('96','159','103','128','118','141','99') LIMIT 7
0SELECT * FROM counts where updated="2024-04-24" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-24" 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 ('174','169') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('16071','14809','14872') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('146901','146902','146903','146904')
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