All types
 
Français

Lord Sheffield Tail Ship

Establishment and travel agency at 72 Beach Rd, Saint John, NB E2K 5H5, Canada. Here you will find detailed information about Lord Sheffield Tail Ship: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Travel agency  

Address:
72 Beach Rd
Saint John
New Brunswick E2K 5H5
Canada
Get directions

Phone:
+1 506-333-7697

Website:
lordsheffield.com

Photos

Lord Sheffield Tail Ship

Reviews of Lord Sheffield Tail Ship

Sorry, but now we haven't any revews about Lord Sheffield Tail Ship.

Add review

About lordsheffield.com

Lord Sheffield - Memories of St Maarten's Pirate Ship
Lord Sheffield Consulting collects and maintains digital memories of the Lord Sheffield, St Maarten's Sophisticated Pirate Ship.

Share this page

Additional actions

Today's weather in Saint John

22:00 3 ℃ 1008 hPa 89 % 7 m/s

Nearest places

1SELECT * FROM `item` WHERE url = 'lord-sheffield-tail-ship' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15607') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('79910')
0SELECT * FROM `category` WHERE id IN ('96','159') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'saint-john-nb' LIMIT 1
0SELECT * FROM `region` WHERE id = 171 LIMIT 1
0SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 79910 AND `date` < '2024-04-25 20:45:28' ORDER BY `date` DESC
1SELECT * FROM `photos` WHERE `item_id` IN ('79910')
1SELECT * FROM `item` WHERE id IN ('37432','37712','42370','37919','38087','37395') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15607') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('37395','37432','37712','37919','38087','42370')
0SELECT * FROM `category` WHERE id IN ('96','107','159','97','98','118','132','128','152','175','99') LIMIT 11
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
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 ('178','174','176') LIMIT 3
0SELECT * FROM `locality` WHERE id IN ('17441','16314','17501','17217') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('382785','382786','382787','382788')
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