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=4078 and pa.subcategory_id=4135 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| DIGITAL DIAGNOSTIC MIRROR WITH MAGNETIC BASE MOUNT ACCESSORY AND TELESCOPING HANDLE | ullman | 223.48 | CAT4135XZ |
Ullman
DIGITAL DIAGNOSTIC MIRROR WITH MAGNETIC BASE MOUNT ACCESSORY AND TELESCOPING HANDLEPart# ULL-E-DM-1MBC$ 223.48
In Stock
| Yes | No | ||||
| 1 | PG50 - DIGITAL INSPECTION MIRROR FOR USE WITH SMART PHONES | ullman | 139.15 | CAT4135XZ |
C$ 139.15
In Stock
| Yes | No | |||
| 2 | PG50 - 4.4X MAGNIFYING GLASS WITH LED LIGHT | titan-tools | 14.24 | CAT4135XZ |
C$ 14.24
In Stock
| Yes | No | |||
| 3 | PG50 - INSPECTION TELESCOPING ACRYLIC MIRROR, 1-3/4" X 2-1/2" | mayhew | 18.95 | CAT4135XZ |
C$ 18.95
In Stock
| Yes | No | |||
| 4 | PG50 - INSPECTION TELESCOPING ACRYLIC MIRROR, 2-1/4" X 3.6" | mayhew | 27.77 | CAT4135XZ |
C$ 27.77
In Stock
| Yes | No | |||
| 5 | PG50 - 7-PC TELEFLEX INSPECTION & PICKUP TOOL KIT | mayhew | 116.98 | CAT4135XZ |
C$ 116.98
In Stock
| Yes | No | |||
| 6 | PG50 - RECTANGULAR 2-1/4" X 3-1/2" TELESCOPING LED LIGHTED INSPECTION MIRROR | ullman | 23.74 | CAT4135XZ |
Ullman
PG50 - RECTANGULAR 2-1/4" X 3-1/2" TELESCOPING LED LIGHTED INSPECTION MIRRORPart# ULL-HTK-2LTC$ 23.74
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 7 | PG50 - ROUND 2-3/8" TELESCOPING LED LIGHTED INSPECTION MIRROR | ullman | 22.31 | CAT4135XZ |
C$ 22.31
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 8 | PG50 - 5-PC TELEMULTI INSPECTION TOOL KIT | mayhew | 81.28 | CAT4135XZ |
C$ 81.28
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |