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=4786 and pa.subcategory_id=4866 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| M3 Panel | 20x20 | G/W | dafco | 241.28 | CAT4866XZ |
C$ 241.28
In Stock
| Yes | No | ||||
| 1 | M3 Panel | 20x25 | G/W | dafco | 269.44 | CAT4866XZ |
C$ 269.44
In Stock
| Yes | No | |||
| 2 | Fiberglass Arrestor Pad | 20x20x2-1/2 | Glass Green Dry | dafco | 148 | CAT4866XZ |
C$ 148.00
Limited Stock
| Yes | No | |||
| 3 | Fiberglass Arrestor Pad | 20x25x2-1/2 | Glass Green Dry | dafco | 166.67 | CAT4866XZ |
C$ 166.67
Limited Stock
| Yes | No | |||
| 4 | M3 Panel | 20x48 | dafco | 159.58 | CAT4866XZ |
C$ 159.58
Limited Stock
| Yes | No | |||
| 5 | Paper Paint Arrestor Media | 20x25 | #3031 Plain SC | dafco | 329.95 | CAT4866XZ |
C$ 329.95
| No | No | |||
| 6 | Andreae Accordion | 36x30 | AF813 | dafco | 338.75 | CAT4866XZ |
C$ 338.75
| No | No | |||
| 7 | 3 Ply Panel | 24x24 | W/W | dafco | 325.76 | CAT4866XZ |
C$ 325.76
| No | No | |||
| 8 | DIFF-R1 Panel | 20x48 | dafco | 463.15 | CAT4866XZ |
C$ 463.15
| No | No | |||
| 9 | DIFF-R1 Panel | 20x20 | dafco | 709.57 | CAT4866XZ |
C$ 709.57
| No | No | |||
| 10 | Paint Pocket Pad | 20x20x1 | White | dafco | 352.99 | CAT4866XZ |
C$ 352.99
| No | No | |||
| 11 | Paint Pocket Pad | 20x25x1 | White | dafco | 440.99 | CAT4866XZ |
C$ 440.99
| No | No | |||
| 12 | Paint Pocket Roll | 30x50x1 | White | dafco | 314.16 | CAT4866XZ |
C$ 314.16
| No | No | |||
| 13 | Andreae Accordion | 20x25 | No Frame | dafco | 0 | CAT4866XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 14 | Poly Dry Roll | 24x120x1 | dafco | 0 | CAT4866XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 15 | Paper Paint Arrestor | 45''x7' | #3252 HE poly | dafco | 0 | CAT4866XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 16 | Fiberglass Arrestor | 24x100x2-1/2 | Glass Green Dry Nom | dafco | 0 | CAT4866XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 17 | Fiberglass Arrestor | 28x100x2-1/2 | Glass Green Dry Nom | dafco | 0 | CAT4866XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 18 | Paint Pocket | 20x25x1 | Green | dafco | 348.46 | CAT4866XZ |
C$ 348.46
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 19 | DIFF-DD Media | Pad 60x96 - SYN 65% - 10P EX | dafco | 0 | CAT4866XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 20 | Synthetic Pocket | 23-5/8x32x18 | Paper PA SC | dafco | 0 | CAT4866XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 21 | M3 Panel | 10x20 | G/W | dafco | 134.4 | CAT4866XZ |
C$ 134.40
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 22 | Fiberglass Arrestor Pad | 24x24x2-1/2 | Glass Green Dry | dafco | 192 | CAT4866XZ |
C$ 192.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 23 | Fiberglass Arrestor Roll | 20x100x2-1/2 | Glass Green Dry | dafco | 0 | CAT4866XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 24 | Fiberglass Arrestor Roll | 30x100x2-1/2 | Glass Green Dry | dafco | 0 | CAT4866XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 25 | Fiberglass Arrestor Roll | 36x100x2-1/2 | Glass Green Dry | dafco | 0 | CAT4866XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 26 | Fiberglass Arrestor Roll | 48x100x2-1/2 | Glass Green Dry | dafco | 0 | CAT4866XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 27 | Fiberglass Arrestor Roll | 20x300x2-1/2 | Glass Green Dry | dafco | 322.1 | CAT4866XZ |
C$ 322.10
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 28 | Fiberglass Arrestor Roll | 30x300x2-1/2 | Glass Green Dry | dafco | 568.1 | CAT4866XZ |
C$ 568.10
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 29 | DIFF-R1 Panel | 10x20 | dafco | 350.08 | CAT4866XZ |
C$ 350.08
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 30 | Paper Paint Arrestor | 20x20 | #3232 HE Poly | dafco | 0 | CAT4866XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 31 | Baffle Box | 20x25x3 | Paint Mate | dafco | 362.88 | CAT4866XZ |
C$ 362.88
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 32 | Paint Pocket Roll | 36x50x1 | White | dafco | 512.96 | CAT4866XZ |
C$ 512.96
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 33 | Paint Pocket Roll | 48x50x1 | White | dafco | 754.03 | CAT4866XZ |
C$ 754.03
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 34 | Paint Pocket | 60x50x1 | White | dafco | 996.8 | CAT4866XZ |
C$ 996.80
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |