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=4205 and pa.subcategory_id=4233 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG283 - EXHAUST PIPE STRETCHER | lisle-corporation | 176.11 | CAT4233XZ |
C$ 176.11
In Stock
| Yes | No | ||||
| 1 | PG283 - PIPE STRETCHER KIT | lisle-corporation | 365.7 | CAT4233XZ |
C$ 365.70
In Stock
| Yes | No | |||
| 2 | PG283 - 5" ADAPTER FOR THE #17350 LISLE TAILPIPE STRETCHER | lisle-corporation | 73.55 | CAT4233XZ |
C$ 73.55
In Stock
| Yes | No | |||
| 3 | PG282 - 4" Y-ASSEMBLY W/F400 ADAPTER (DUALS) | crushproof | 407.38 | CAT4233XZ |
C$ 407.38
In Stock
| Yes | No | |||
| 4 | PG282 - 3" Y-ASSEMBLY W/F300 ADAPTER (DUALS) | crushproof | 248.02 | CAT4233XZ |
C$ 248.02
In Stock
| Yes | No | |||
| 5 | PG282 - 2 1/2" Y-ASSEMBLY W/F250 ADAPTER (DUALS) | crushproof | 205.01 | CAT4233XZ |
C$ 205.01
In Stock
| Yes | No | |||
| 6 | PG282 - Y-CONNECTORS - RUBBER - FOR 3" HOSE | crushproof | 46.42 | CAT4233XZ |
C$ 46.42
In Stock
| Yes | No | |||
| 7 | PG282 - BELL - 3" HOSE | crushproof | 48.72 | CAT4233XZ |
C$ 48.72
In Stock
| Yes | No | |||
| 8 | PG282 - BELL - 2-1/2" HOSE | crushproof | 48.72 | CAT4233XZ |
C$ 48.72
In Stock
| Yes | No | |||
| 9 | PG282 - HOSE 3 1/2" FLARELOCK | crushproof | 236.4 | CAT4233XZ |
C$ 236.40
In Stock
| Yes | No | |||
| 10 | PG282 - HOSE 3" FLARELOCK | crushproof | 166.51 | CAT4233XZ |
C$ 166.51
In Stock
| Yes | No | |||
| 11 | PG282 - HOSE 2 1/2" FLARELOCK | crushproof | 137.81 | CAT4233XZ |
C$ 137.81
In Stock
| Yes | No | |||
| 12 | PG282 - TWIN/OVAL PIPES - CRU-F575 | crushproof | 69.26 | CAT4233XZ |
C$ 69.26
In Stock
| Yes | No | |||
| 13 | PG282 - TWIN/OVAL PIPES DYNO | crushproof | 87.98 | CAT4233XZ |
C$ 87.98
In Stock
| Yes | No | |||
| 14 | PG282 - TWIN/OVAL PIPES - CRU-F475 | crushproof | 53.81 | CAT4233XZ |
C$ 53.81
In Stock
| Yes | No | |||
| 15 | PG282 - TAILPIPES 3" DYNO | crushproof | 77.33 | CAT4233XZ |
C$ 77.33
In Stock
| Yes | No | |||
| 16 | PG282 - 6" DIESEL STACK FOR 4"-5" HOSE | crushproof | 108.14 | CAT4233XZ |
C$ 108.14
In Stock
| Yes | No | |||
| 17 | PG282 - DOOR PORT - RUBBER FOR 2 1/2" HOSE | crushproof | 43.34 | CAT4233XZ |
C$ 43.34
In Stock
| Yes | No | |||
| 18 | PG282 - Y-CONNECTORS - ALUM. - FOR 4" HOSE | crushproof | 113.33 | CAT4233XZ |
C$ 113.33
In Stock
| Yes | No | |||
| 19 | PG282 - DOOR PORT - ALUM. FOR 4" HOSE | crushproof | 69.74 | CAT4233XZ |
C$ 69.74
In Stock
| Yes | No | |||
| 20 | PG282 - DOOR PORT - ALUM. FOR 3" HOSE | crushproof | 51.98 | CAT4233XZ |
C$ 51.98
In Stock
| Yes | No | |||
| 21 | PG282 - HOSE 6" X 11' | crushproof | 465.55 | CAT4233XZ |
C$ 465.55
In Stock
| Yes | No | |||
| 22 | PG282 - HOSE 5" X 11' | crushproof | 368.59 | CAT4233XZ |
C$ 368.59
In Stock
| Yes | No | |||
| 23 | PG282 - HOSE 4" X 11' DYNO | crushproof | 336.24 | CAT4233XZ |
C$ 336.24
In Stock
| Yes | No | |||
| 24 | PG283 - EXHAUST HAND EXPANDER FOR CARS | blue-boy | 2288.04 | CAT4233XZ |
C$ 2,288.04
In Stock
| Yes | No | |||
| 25 | PG283 - 3 PIECE TAILPIPE EXPANDER SET FOR 1-1/8 TO 3-1/2 I.D. PIPE | atd | 58.34 | CAT4233XZ |
C$ 58.34
In Stock
| Yes | No | |||
| 26 | PG283 - EXHAUST PIPE STRETCHER KIT, 1-5/18" TO 4-1/4" | astro-pneumatics | 155.87 | CAT4233XZ |
C$ 155.87
In Stock
| Yes | No | |||
| 27 | INTERNAL TAILPIPE CLAMPING ADAPTER KIT: RUBBER NOZZLE FOR FOR 3" EXHAUST HOSES & UP TO 8" TAILPIPE END, 3" METAL CLAMP, RUBBER COVER FOR 3" METAL CLAMP | filcar | 593.04 | CAT4233XZ |
Filcar
INTERNAL TAILPIPE CLAMPING ADAPTER KIT: RUBBER NOZZLE FOR FOR 3" EXHAUST HOSES & UP TO 8" TAILPIPE END, 3" METAL CLAMP, RUBBER COVER FOR 3" METAL CLAMPPart# FIC-BG-75C$ 593.04
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 28 | INTERNAL TAILPIPE CLAMPING ADAPTER KIT: RUBBER NOZZLE FOR FOR 4" EXHAUST HOSES & UP TO 8" TAILPIPE END, 4" METAL CLAMP, RUBBER COVER FOR 4" METAL CLAMP | filcar | 593.04 | CAT4233XZ |
Filcar
INTERNAL TAILPIPE CLAMPING ADAPTER KIT: RUBBER NOZZLE FOR FOR 4" EXHAUST HOSES & UP TO 8" TAILPIPE END, 4" METAL CLAMP, RUBBER COVER FOR 4" METAL CLAMPPart# FIC-BG-100C$ 593.04
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 29 | EXHAUST SPRING HOSE REEL WITH ADJUSTABLE HOSE STOPPER AND SPECIAL 4" X 24.6 FT. RUBBER CRUSHPROOF HOSE, TEMP. RESISTANCE UP TO 200C | filcar | 1828.92 | CAT4233XZ |
Filcar
EXHAUST SPRING HOSE REEL WITH ADJUSTABLE HOSE STOPPER AND SPECIAL 4" X 24.6 FT. RUBBER CRUSHPROOF HOSE, TEMP. RESISTANCE UP TO 200CPart# FIC-ARC-100C$ 1,828.92
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 30 | EXHAUST SPRING HOSE REEL WITH ADJUSTABLE HOSE STOPPER AND SPECIAL 4" X 32.8 FT. RUBBER CRUSHPROOF HOSE, TEMP. RESISTANCE UP TO 200C | filcar | 2264.87 | CAT4233XZ |
Filcar
EXHAUST SPRING HOSE REEL WITH ADJUSTABLE HOSE STOPPER AND SPECIAL 4" X 32.8 FT. RUBBER CRUSHPROOF HOSE, TEMP. RESISTANCE UP TO 200CPart# FIC-ARC-100C$ 2,264.87
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 31 | TELESCOPING OVERHEAD SYSTEM | crushproof | 631.07 | CAT4233XZ |
C$ 631.07
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 32 | PG282 - Y-CONNECTORS - RUBBER - FOR 2.5" HOSE | crushproof | 44.21 | CAT4233XZ |
C$ 44.21
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 33 | PG282 - HOSE 4" FLARELOCK | crushproof | 260.4 | CAT4233XZ |
C$ 260.40
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 34 | PG282 - TWIN/OVAL PIPES - CRU-F675 | crushproof | 136.94 | CAT4233XZ |
C$ 136.94
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 35 | PG282 - 6" DIESEL STACK FOR 6" HOSE | crushproof | 127.15 | CAT4233XZ |
C$ 127.15
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 36 | PG283 - EXHAUST HAND EXPANDER FOR TRUCKS | blue-boy | 3247.28 | CAT4233XZ |
C$ 3,247.28
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |