Royal Tire New Liskeard Ltd.

Establishment and car repair at 100 Craven Drive, New Liskeard, Temiskaming Shores, ON P0J 1P0, Canada. Here you will find detailed information about Royal Tire New Liskeard Ltd.: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Car repair  

Address:
100 Craven Drive
New Liskeard
Temiskaming Shores
Ontario P0J 1P0
Canada
Get directions

Phone:
+1 705-647-5500

Website:
fountaintire.com

Reviews of Royal Tire New Liskeard Ltd.

Sorry, but now we haven't any revews about Royal Tire New Liskeard Ltd..

Add review

About fountaintire.com

Fountain Tire - Car Service, Tire, & Auto Repair Shop
Fountain Tire offers a wide range of tires for Cars, SUVs, Minivans, Trucks, and Trailers, as well as complete automotive service & repairs for all makes & models.

1SELECT * FROM `item` WHERE url = 'royal-tire-new-liskeard-ltd' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17236') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('84723')
0SELECT * FROM `category` WHERE id IN ('96','100') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'temiskaming-shores-on' LIMIT 1
0SELECT * FROM `region` WHERE id = 176 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 84723 AND `date` < '2024-04-26 14:32:40' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('84723')
1SELECT * FROM `item` WHERE id IN ('84803','361889','84706','84786','84748','361719') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17236') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('84706','84748','84786','84803','361719','361889')
0SELECT * FROM `category` WHERE id IN ('96','100') LIMIT 2
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'
0SELECT * 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 ('174','176') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('16186','16279','17011') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('13648','13649','13650','13651')
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