St Martins Ice Cream Parlor Fresh Lobster Rolls

Establishment and food at 1B4, 34-36 Main Street, Saint Martins, NB E5R 1B3, Canada. Here you will find detailed information about St Martins Ice Cream Parlor Fresh Lobster Rolls: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Food  

Address:
1B4
34-36 Main Street
Saint Martins
New Brunswick E5R 1B3
Canada
Get directions

Opening hours

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

Photos

Reviews of St Martins Ice Cream Parlor Fresh Lobster Rolls

Sorry, but now we haven't any revews about St Martins Ice Cream Parlor Fresh Lobster Rolls.

Add review

1SELECT * FROM `item` WHERE url = 'st-martins-ice-cream-parlor-fresh-lobster-rolls' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15609') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('111112')
0SELECT * FROM `category` WHERE id IN ('96','99') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'saint-martins-nb' LIMIT 1
0SELECT * FROM `region` WHERE id = 171 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 111112 AND `date` < '2024-04-28 04:39:55' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('111112')
0SELECT * FROM `item` WHERE id IN ('110987','111159','110958','110970','111079','111065') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15609') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('110958','110970','110987','111065','111079','111159')
0SELECT * FROM `category` WHERE id IN ('96','99','115','114','120','121','104') LIMIT 7
0SELECT * FROM counts where updated="2024-04-28" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-28" 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 ('178') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('18433','17772','18120') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('367641','367642','367643','367644')
1SELECT * 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