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=4066 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 | |
---|---|---|---|---|---|---|---|---|---|---|
PG44 - BACK PROBE KIT | thexton | 40.87 | CAT4066XZ |
C$ 40.87
In Stock
| Yes | No | ||||
1 | PG43 - 12-PC MASTER BACK PROBE KIT | sandg-tool-aid | 32.39 | CAT4066XZ |
C$ 32.39
In Stock
| Yes | No | |||
2 | PG43 - 2-PC FLEXIBLE BACK PROBE KIT, FOR TESTING UP TO 30 VOLTS | sandg-tool-aid | 8.62 | CAT4066XZ |
C$ 8.62
In Stock
| Yes | No | |||
3 | PG43 - 20 PIECE BACK PROBE KIT | sandg-tool-aid | 36.84 | CAT4066XZ |
C$ 36.84
In Stock
| Yes | No | |||
4 | PG44 - FLEXIBLE BACK PROBES | lisle-corporation | 18.86 | CAT4066XZ |
C$ 18.86
In Stock
| Yes | No | |||
5 | PG44 - 17 PIECE BACK PROBE KIT | lisle-corporation | 65.15 | CAT4066XZ |
C$ 65.15
In Stock
| Yes | No | |||
6 | PG44 - 11 PIECE BACK PROBE KIT | lisle-corporation | 42.05 | CAT4066XZ |
C$ 42.05
In Stock
| Yes | No | |||
7 | PG44 - 10-PC BACK PROBE KIT | es-inc-electronic-specialties | 59.99 | CAT4066XZ |
C$ 59.99
In Stock
| Yes | No | |||
8 | PG44 - SPOON PROBE BACKPROBERS | es-inc-electronic-specialties | 20.21 | CAT4066XZ |
C$ 20.21
In Stock
| Yes | No | |||
9 | PG43 - 2-PC CURVED BACK PROBE KIT, FOR TESTING UP TO 25 VOLTS | sandg-tool-aid | 8.62 | CAT4066XZ |
C$ 8.62
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
10 | PG44 - TEST PROBE ADAPTER KIT | power-probe | 15.97 | CAT4066XZ |
C$ 15.97
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |