All types
 
Français

Saint John Hyundai

Establishment and car dealer at 403 Westmorland Road, Saint John, NB E2J 3S9, Canada. Here you will find detailed information about Saint John Hyundai: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Car dealer  

Address:
403 Westmorland Road
Saint John
New Brunswick E2J 3S9
Canada
Get directions

Phone:
+1 506-652-2277

Website:
sjhyundai.com

Opening hours

Monday 08:00am — 08:00pm
Tuesday 08:00am — 08:00pm
Wednesday 08:00am — 08:00pm
Thursday 08:00am — 08:00pm
Friday 08:00am — 06:00pm
Saturday 09:00am — 04:00pm

Photos

Saint John Hyundai

Reviews of Saint John Hyundai

Sorry, but now we haven't any revews about Saint John Hyundai.

Add review

About sjhyundai.com

Saint John Hyundai

Share this page

Additional actions

Today's weather in Saint John

22:00 5 ℃ 1028 hPa 48 % 1 m/s

Nearest places

0SELECT * FROM `item` WHERE url = 'saint-john-hyundai' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
1SELECT * FROM `locality` WHERE id IN ('15607') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('38069')
0SELECT * FROM `category` WHERE id IN ('96','124') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'saint-john-nb' LIMIT 1
0SELECT * FROM `region` WHERE id = 171 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 38069 AND `date` < '2024-04-28 02:32:35' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('38069')
1SELECT * FROM `item` WHERE id IN ('38023','38208','37649','38057','38460','37572') LIMIT 6
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 ('37572','37649','38023','38057','38208','38460')
0SELECT * FROM `category` WHERE id IN ('96','100','128','136','99','118','143','124') LIMIT 8
5SELECT * FROM counts where updated="2024-04-28" and table_name like 'news'
1SELECT * 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 ('176','174') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('16516','16020','16832') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('304739','304740','304741','304742')
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