Skye Lodge

Establishment and lodging at 160 Nova Scotia Trunk 4, Port Hastings, NS B9A 1M5, Canada. Here you will find detailed information about Skye Lodge: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging  

Address:
160 Nova Scotia Trunk 4
Port Hastings
Nova Scotia B9A 1M5
Canada
Get directions

Phone:
+1 902-625-1300

Website:
skyelodge.com

Reviews of Skye Lodge

Sorry, but now we haven't any revews about Skye Lodge.

Add review

About skyelodge.com

Skye Lodge - Overlooking the Strait of Canso
Overlooking the Canso Causeway, Skye Lodge is the perfect destination when travelling to Cape Breton. Skye Lodge is conveniently located in Port Hastings, the outskirts of Port Hawkesbury, one of Nova Scotia's fastest growing towns.
cape breton, nova scotia, canso causeway, accommodations, motel, reservation, reservations, motels, skye lodge, port hawkesury, waterview rooms, Port Hastings museum, orangedale railway museum, granville green, ceilidh trail, cabot trail, ns, n.s.

1SELECT * FROM `item` WHERE url = 'skye-lodge' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('174') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('16266') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('91478')
0SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
1UPDATE locality SET weather = '{\"date\":\"2024-04-26\",\"data\":{\"2024-04-25\":{\"22\":{\"temp\":-0,\"pressure\":1023,\"humidity\":77,\"icon\":\"01n\",\"wind\":3}},\"2024-04-26\":{\"01\":{\"temp\":-0,\"pressure\":1024,\"humidity\":74,\"icon\":\"01n\",\"wind\":4},\"04\":{\"temp\":-0,\"pressure\":1026,\"humidity\":75,\"icon\":\"01n\",\"wind\":4},\"07\":{\"temp\":2,\"pressure\":1030,\"humidity\":60,\"icon\":\"01d\",\"wind\":5},\"10\":{\"temp\":3,\"pressure\":1030,\"humidity\":53,\"icon\":\"03d\",\"wind\":5},\"13\":{\"temp\":4,\"pressure\":1030,\"humidity\":50,\"icon\":\"03d\",\"wind\":6},\"16\":{\"temp\":3,\"pressure\":1030,\"humidity\":58,\"icon\":\"02d\",\"wind\":5},\"19\":{\"temp\":-1,\"pressure\":1032,\"humidity\":69,\"icon\":\"02n\",\"wind\":2},\"22\":{\"temp\":-2,\"pressure\":1032,\"humidity\":74,\"icon\":\"01n\",\"wind\":3}},\"2024-04-27\":{\"01\":{\"temp\":-2,\"pressure\":1031,\"humidity\":72,\"icon\":\"01n\",\"wind\":3},\"04\":{\"temp\":-2,\"pressure\":1032,\"humidity\":76,\"icon\":\"01d\",\"wind\":3},\"07\":{\"temp\":2,\"pressure\":1032,\"humidity\":56,\"icon\":\"02d\",\"wind\":5},\"10\":{\"temp\":4,\"pressure\":1031,\"humidity\":52,\"icon\":\"03d\",\"wind\":7},\"13\":{\"temp\":4,\"pressure\":1030,\"humidity\":56,\"icon\":\"03d\",\"wind\":8},\"16\":{\"temp\":3,\"pressure\":1029,\"humidity\":56,\"icon\":\"03d\",\"wind\":7},\"19\":{\"temp\":-1,\"pressure\":1030,\"humidity\":68,\"icon\":\"02n\",\"wind\":5},\"22\":{\"temp\":-2,\"pressure\":1028,\"humidity\":74,\"icon\":\"01n\",\"wind\":3}}}}' WHERE id = 16266 LIMIT 1
0SELECT * FROM `locality` WHERE url = 'port-hastings-ns' LIMIT 1
0SELECT * FROM `region` WHERE id = 174 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 91478 AND `date` < '2024-04-26 01:37:22' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('91478')
1SELECT * FROM `item` WHERE id IN ('315990','315971','91430','90363','90364','90409') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('174') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('16266') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('90363','90364','90409','91430','315971','315990')
0SELECT * FROM `category` WHERE id IN ('96','159','107') LIMIT 3
0SELECT * FROM counts where updated="2024-04-26" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-26" and table_name like 'news'
0SELECT * 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 ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17181','16968') LIMIT 2
0SELECT * FROM `photos` WHERE `item_id` IN ('405687','405688','405689','405690')
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