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=3974 and pa.subcategory_id=3980 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG285 - 3-PC BUMPER DENT REMOVER ROLLERS KIT | polyvance | 161.41 | CAT3980XZ |
C$ 161.41
In Stock
| Yes | No | ||||
| 1 | PG285 - 9-PC BODY REPAIR KIT FOR STEEL BODY VEHICLES | sandg-tool-aid | 300.18 | CAT3980XZ |
C$ 300.18
In Stock
| Yes | No | |||
| 2 | PG208 - JUNIOR SLUGGER DENT PULLER & SLIDE HAMMER | sandg-tool-aid | 78.92 | CAT3980XZ |
C$ 78.92
In Stock
| Yes | No | |||
| 3 | PG208 - THE SLUGGER IN A TOOL BOX | sandg-tool-aid | 384.85 | CAT3980XZ |
C$ 384.85
In Stock
| Yes | No | |||
| 4 | PG285 - SHAPE TIP TOOL | lti-tools-lock-technology | 51.88 | CAT3980XZ |
C$ 51.88
In Stock
| Yes | No | |||
| 5 | PG285 - UNI-VAC VACUUM PDR PULLING TOOL | hands-autoshot | 336.91 | CAT3980XZ |
C$ 336.91
In Stock
| Yes | No | |||
| 6 | PG285 - CROSS CHISEL HAMMER | martin-tools | 67.84 | CAT3980XZ |
C$ 67.84
In Stock
| Yes | No | |||
| 7 | PG285 - BODY PICK | martin-tools | 29.7 | CAT3980XZ |
C$ 29.70
In Stock
| Yes | No | |||
| 8 | PG285 - SHORT CURVED PICK | martin-tools | 29.2 | CAT3980XZ |
C$ 29.20
In Stock
| Yes | No | |||
| 9 | PG285 - HEAVY BODY CHISEL | martin-tools | 85.48 | CAT3980XZ |
C$ 85.48
In Stock
| Yes | No | |||
| 10 | PG285 - LONG CURVED PICK | martin-tools | 92.28 | CAT3980XZ |
C$ 92.28
In Stock
| Yes | No | |||
| 11 | PG285 - 3 PIECE ALUMINUM HAMMER SET WITH CASE | dentfix | 226.8 | CAT3980XZ |
C$ 226.80
In Stock
| Yes | No | |||
| 12 | PG284 - MAXI DENT REMOVAL SYSTEM 220 VOLT | dentfix | 2986.92 | CAT3980XZ |
C$ 2,986.92
In Stock
| Yes | No | |||
| 13 | PG285 - 5 METER TRAM GAUGE | dentfix | 615.41 | CAT3980XZ |
C$ 615.41
In Stock
| Yes | No | |||
| 14 | PG285 - 3 METER TRAM GAUGE | dentfix | 469.87 | CAT3980XZ |
C$ 469.87
In Stock
| Yes | No | |||
| 15 | PG284 - 10 TON PORTABLE HYDRAULIC KIT | porto-power | 755.95 | CAT3980XZ |
C$ 755.95
In Stock
| Yes | No | |||
| 16 | PG284 - 4 TON PORTABLE HYDRAULIC KIT | porto-power | 546 | CAT3980XZ |
C$ 546.00
In Stock
| Yes | No | |||
| 17 | PG284 - 10T BODY REPAIR KIT | atd | 728.16 | CAT3980XZ |
C$ 728.16
In Stock
| Yes | No | |||
| 18 | PG284 - 4-TON MINI HYDRAULIC RAM KIT | atd | 482.46 | CAT3980XZ |
C$ 482.46
In Stock
| Yes | No | |||
| 19 | PG285 - 10 LBS HEAVY DUTY DENT PULLER SET | atd | 204.34 | CAT3980XZ |
C$ 204.34
In Stock
| Yes | No | |||
| 20 | PG285 - 7PC H/D BODY&FENDER HAMMER SET W/FIBERGLASS HDLS | atd | 115.46 | CAT3980XZ |
C$ 115.46
In Stock
| Yes | No | |||
| 21 | PG285 - 3-PC BUMPER DENT REMOVER ROLLERS KIT | polyvance | 161.41 | CAT3980XZ |
C$ 161.41
In Stock
| Yes | No | |||
| 22 | PG284 - GPR-PRO GLUE PULLING REPAIR SYSTEM | hands-autoshot | 934.13 | CAT3980XZ |
C$ 934.13
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 23 | 4 TON COLLISION REPAIR KIT - CAST ADAPTERS W/GAUGE | norco | 417.6 | CAT3980XZ |
C$ 417.60
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 24 | PG285 - BUMPER PLIERS KIT | polyvance | 364.01 | CAT3980XZ |
C$ 364.01
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 25 | PG284 - 20 TON COLLISION / MAINTENANCE KIT W/GAUGE | norco | 2378.57 | CAT3980XZ |
C$ 2,378.57
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 26 | PG284 - 10 TON COLLISION REPAIR KIT - CAST ADAPTERS W/GAUGE | norco | 662.74 | CAT3980XZ |
C$ 662.74
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 27 | PG285 - MED. CURVED PICK | martin-tools | 87.49 | CAT3980XZ |
C$ 87.49
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 28 | PG284 - ULTRA DING MASSAGER DELUXE GLUE PULLING PAINT-LESS DENT REPAIR KIT | dentfix | 581.04 | CAT3980XZ |
Dentfix
PG284 - ULTRA DING MASSAGER DELUXE GLUE PULLING PAINT-LESS DENT REPAIR KITPart# DTF-DF-DM555C$ 581.04
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 29 | PG284 - 10 TON PORTO-POWER SET | atd | 758.06 | CAT3980XZ |
C$ 758.06
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |