Ultramar

Establishment at 5 route 172, Upper Letang, NB E5C 3S9, Canada. Here you will find detailed information about Ultramar: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment  

Address:
5 route 172
Upper Letang
New Brunswick E5C 3S9
Canada
Get directions

Phone:
+1 506-755-2622

Website:
ultramarcst.ca

Opening hours

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

Photos

Reviews of Ultramar

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

Add review

6SELECT * FROM `item` WHERE url = 'ultramar-320' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15673') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('27822')
0SELECT * FROM `category` WHERE id IN ('96') LIMIT 1
0SELECT * FROM `locality` WHERE url = 'upper-letang-nb' LIMIT 1
0SELECT * FROM `region` WHERE id = 171 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 27822 AND `date` < '2024-04-27 23:31:38' ORDER BY `date` DESC
1SELECT * FROM `photos` WHERE `item_id` IN ('27822')
8SELECT * FROM `item` WHERE id IN ('27926','28031','308063','27648','307800','28003') LIMIT 6
3SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
9SELECT * FROM `locality` WHERE id IN ('15606','15563') LIMIT 2
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('27648','27926','28003','28031','307800','308063')
0SELECT * FROM `category` WHERE id IN ('96','99','144','129') LIMIT 4
5SELECT * FROM counts where updated="2024-04-27" and table_name like 'news'
1SELECT * FROM counts where updated="2024-04-27" and table_name like 'news'
8SELECT * FROM `category` ORDER BY name
11SELECT * 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
4SELECT * FROM `region` WHERE id IN ('178','172') LIMIT 2
4SELECT * FROM `locality` WHERE id IN ('18087','15893','15938','15775') LIMIT 4
4SELECT * FROM `photos` WHERE `item_id` IN ('119543','119544','119545','119546')
4SELECT * 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
4SELECT * FROM `region` WHERE id IN ('168') LIMIT 1