John Bear Hamilton

Establishment and car dealer at 1200 Upper James Street, Hamilton, ON L9C 3B1, Canada. Here you will find detailed information about John Bear Hamilton: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Car dealer  

Address:
1200 Upper James Street
Hamilton
Ontario L9C 3B1
Canada
Get directions

Phone:
+1 905-575-9400

Website:
johnbearhamilton.com

Opening hours

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

Photos

Reviews of John Bear Hamilton

Sorry, but now we haven't any revews about John Bear Hamilton.

Add review

About johnbearhamilton.com

Chevrolet, Buick, Cadillac, GMC Dealership | John Bear Hamilton
New and used cars available at John Bear Hamilton. Discover our new Chevrolet, Buick, Cadillac, GMC lineup near Ancaster. We specialize in service & parts.

1SELECT * FROM `item` WHERE url = 'john-bear-hamilton' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('16748') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('5314')
0SELECT * FROM `category` WHERE id IN ('96','124') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'hamilton-on' LIMIT 1
0SELECT * FROM `region` WHERE id = 176 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 5314 AND `date` < '2024-04-26 00:20:40' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('5314')
2SELECT * FROM `item` WHERE id IN ('5246','5383','314187','5423','292777','5435') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('16748') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('5246','5383','5423','5435','292777','314187')
0SELECT * FROM `category` WHERE id IN ('96','107','99','144','116','145','155','124') LIMIT 8
0SELECT * FROM counts where updated="2024-04-26" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-26" 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 ('176','168','169') LIMIT 3
0SELECT * FROM `locality` WHERE id IN ('16631','17175','14288','14746') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('163001','163003','163004','163005')
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