A Canadian Company
filters
Select pa.*,
b.title bnm, b.title_seo bnmseo, b.discount bdiscount,
c.title cnm, c.title_seo cnmseo, c.discount cdiscount,
c1.title scnm, c1.title_seo scnmseo, c1.discount scdiscount
from pa
LEFT JOIN brands b ON pa.brand_id = b.id and b.visible=0
LEFT JOIN categories c ON pa.category_id = c.id and c.visible=0
LEFT JOIN categories c1 ON pa.subcategory_id = c1.id and c1.visible=0
where pa.visible=0 and pa.delflag=0 and pa.category_id=4051 and pa.subcategory_id=4054 order by pa.featured desc,pa.sort_order,FIELD(status,1,3,6,5,1,4,2)
Showing 1 to x of xx results
| # | name | brand | price | category | stock | sale | OilType | OilVol | OilGrade | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG45 - 2-PC CLAMP PROBE SET, RED & BLACK | sandg-tool-aid | 55.49 | CAT4054XZ |
C$ 55.49
In Stock
| Yes | No | ||||
| 1 | PG45 - PERMA-COIL JUMPER LEADS | sandg-tool-aid | 29.53 | CAT4054XZ |
C$ 29.53
In Stock
| Yes | No | |||
| 2 | PG45 - GOLD SERIES LEAD SET | power-probe | 107.87 | CAT4054XZ |
C$ 107.87
In Stock
| Yes | No | |||
| 3 | PG44 - ORANGE PIN TIP BANANA | lisle-corporation | 6.26 | CAT4054XZ |
C$ 6.26
In Stock
| Yes | No | |||
| 4 | PG45 - 7 PC. RETR TEST LEAD SET - 2 LEADS X 15 FT. WITH BANANA PLUGS | lang-tools | 84.8 | CAT4054XZ |
C$ 84.80
In Stock
| Yes | No | |||
| 5 | PG45 - MAGNETIC RETRACTABLE TEST LEADS - 3 LEADS X 10 FT. | lang-tools | 39.61 | CAT4054XZ |
C$ 39.61
In Stock
| Yes | No | |||
| 6 | PG45 - RETRACTABLE TEST LEADS - 1 LEAD X 30 FT. | lang-tools | 22.81 | CAT4054XZ |
C$ 22.81
In Stock
| Yes | No | |||
| 7 | PG45 - RETRACTABLE TEST LEADS - 3 LEADS X 10 FT. | lang-tools | 25.67 | CAT4054XZ |
C$ 25.67
In Stock
| Yes | No | |||
| 8 | PG44 - 70-PC DIAGNOSTIC TEST & TERMINAL SET | es-inc-electronic-specialties | 245.29 | CAT4054XZ |
C$ 245.29
In Stock
| Yes | No | |||
| 9 | PG44 - 6-PC AUTOMOTIVE TEST PROBE KIT | es-inc-electronic-specialties | 43.25 | CAT4054XZ |
C$ 43.25
In Stock
| Yes | No | |||
| 10 | PG44 - TEST LEAD SERVICE CENTER | es-inc-electronic-specialties | 278.77 | CAT4054XZ |
C$ 278.77
In Stock
| Yes | No | |||
| 11 | PG45 - LEADS W/SCREW ON ALLIGATOR CLIP | es-inc-electronic-specialties | 17.23 | CAT4054XZ |
C$ 17.23
In Stock
| Yes | No | |||
| 12 | PG45 - WIRE PIERCING CLIPS | es-inc-electronic-specialties | 46.13 | CAT4054XZ |
C$ 46.13
In Stock
| Yes | No | |||
| 13 | PG45 - LOADPRO DYNAMIC TEST LEADS | es-inc-electronic-specialties | 106.07 | CAT4054XZ |
C$ 106.07
In Stock
| Yes | No | |||
| 14 | PG44 - DEUTSCH TEST CONNECTOR KIT | es-inc-electronic-specialties | 156.47 | CAT4054XZ |
C$ 156.47
In Stock
| Yes | No | |||
| 15 | PG62 - AUTO CONNECTOR KIT - ESI-147 | es-inc-electronic-specialties | 154.39 | CAT4054XZ |
C$ 154.39
In Stock
| Yes | No | |||
| 16 | PG44 - AUTO CONNECTOR KIT | es-inc-electronic-specialties | 205.15 | CAT4054XZ |
C$ 205.15
In Stock
| Yes | No | |||
| 17 | PG45 - AUTOMOTIVE TEST LEAD KIT | es-inc-electronic-specialties | 63.41 | CAT4054XZ |
C$ 63.41
In Stock
| Yes | No | |||
| 18 | PG45 - FUSE LEAD | es-inc-electronic-specialties | 26.51 | CAT4054XZ |
C$ 26.51
In Stock
| Yes | No | |||
| 19 | PG45 - 2-PC CLAMP PROBE SET, RED & BLACK | sandg-tool-aid | 55.49 | CAT4054XZ |
C$ 55.49
In Stock
| Yes | No | |||
| 20 | PG45 - LOADPRO & BACK PROBE KIT WITH 4MM TIP ADAPTERS AND AN ASSORTMENT OF BACK PROBES AND CLIPS | es-inc-electronic-specialties | 140.09 | CAT4054XZ |
ES Inc. (Electronic Specialties)
PG45 - LOADPRO & BACK PROBE KIT WITH 4MM TIP ADAPTERS AND AN ASSORTMENT OF BACK PROBES AND CLIPSPart# ESI-187C$ 140.09
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 21 | PG45 - PIERCING PROBE KIT | power-probe | 31.09 | CAT4054XZ |
C$ 31.09
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 22 | PG45 - MAGNETIC RETRACTABLE TEST LEADS - 2 LEADS X 30 FT. | lang-tools | 58.34 | CAT4054XZ |
C$ 58.34
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |