Tuckamore Lodge & Outfitters

Establishment and lodging at Canada, Main Brook, NL A0K 3N0, Canada. Here you will find detailed information about Tuckamore Lodge & Outfitters: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging  

Address:
Canada
Main Brook
Newfoundland and Labrador A0K 3N0
Canada
Get directions

Phone:
+1 709-865-6361

Website:
tuckamorelodge.com

Photos

Reviews of Tuckamore Lodge & Outfitters

Sorry, but now we haven't any revews about Tuckamore Lodge & Outfitters.

Add review

About tuckamorelodge.com

Tuckamore Lodge - Home
Luxury first-class, Scandinavian style accommodations in Newfoundland wilderness, coupled with some of the highest quality outfitting, hunting and fly fishing experiences in Atlantic Canada.

1SELECT * FROM `item` WHERE url = 'tuckamore-lodge-outfitters' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('172') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15842') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('208794')
6SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
1UPDATE locality SET weather = '{\"date\":\"2024-04-19\",\"data\":{\"2024-04-18\":{\"22\":{\"temp\":-1,\"pressure\":1019,\"humidity\":79,\"icon\":\"04n\",\"wind\":8}},\"2024-04-19\":{\"01\":{\"temp\":-1,\"pressure\":1019,\"humidity\":81,\"icon\":\"03n\",\"wind\":7},\"04\":{\"temp\":-1,\"pressure\":1021,\"humidity\":81,\"icon\":\"04d\",\"wind\":6},\"07\":{\"temp\":0,\"pressure\":1022,\"humidity\":68,\"icon\":\"04d\",\"wind\":6},\"10\":{\"temp\":3,\"pressure\":1021,\"humidity\":58,\"icon\":\"04d\",\"wind\":5},\"13\":{\"temp\":3,\"pressure\":1021,\"humidity\":59,\"icon\":\"04d\",\"wind\":2},\"16\":{\"temp\":1,\"pressure\":1021,\"humidity\":69,\"icon\":\"03d\",\"wind\":4},\"19\":{\"temp\":-1,\"pressure\":1022,\"humidity\":78,\"icon\":\"03n\",\"wind\":3},\"22\":{\"temp\":-1,\"pressure\":1021,\"humidity\":76,\"icon\":\"03n\",\"wind\":3}},\"2024-04-20\":{\"01\":{\"temp\":-1,\"pressure\":1019,\"humidity\":76,\"icon\":\"02n\",\"wind\":3},\"04\":{\"temp\":-0,\"pressure\":1018,\"humidity\":81,\"icon\":\"03d\",\"wind\":4},\"07\":{\"temp\":4,\"pressure\":1017,\"humidity\":64,\"icon\":\"04d\",\"wind\":4},\"10\":{\"temp\":7,\"pressure\":1015,\"humidity\":53,\"icon\":\"04d\",\"wind\":5},\"13\":{\"temp\":8,\"pressure\":1013,\"humidity\":56,\"icon\":\"04d\",\"wind\":7},\"16\":{\"temp\":5,\"pressure\":1012,\"humidity\":75,\"icon\":\"04d\",\"wind\":1},\"19\":{\"temp\":4,\"pressure\":1012,\"humidity\":84,\"icon\":\"04n\",\"wind\":1},\"22\":{\"temp\":4,\"pressure\":1010,\"humidity\":84,\"icon\":\"10n\",\"wind\":4}}}}' WHERE id = 15842 LIMIT 1
0SELECT * FROM `locality` WHERE url = 'main-brook-nl' LIMIT 1
0SELECT * FROM `region` WHERE id = 172 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 208794 AND `date` < '2024-04-19 00:30:16' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('208794')
1SELECT * FROM `item` WHERE id IN ('209072','208777','208850','208875','208919','208809') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('172') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15842') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('208777','208809','208850','208875','208919','209072')
0SELECT * FROM `category` WHERE id IN ('96','164','99','114','133','104') LIMIT 6
0SELECT * FROM counts where updated="2024-04-19" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-19" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
3SELECT * 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 ('168') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14393','14452') LIMIT 2
0SELECT * FROM `photos` WHERE `item_id` IN ('269520','269521','269522','269523')
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