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=4789 and pa.subcategory_id=4871 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| CENTRE FLOW TOWEL DISPENSER | kimberly-clark | 66.67 | CAT4871XZ |
C$ 66.67
Limited Stock
| Yes | No | ||||
| 1 | DISPENSER | kimberly-clark | 75 | CAT4871XZ |
C$ 75.00
Limited Stock
| Yes | No | |||
| 2 | TOWEL DISPENSER SMOKE | kimberly-clark | 162.5 | CAT4871XZ |
C$ 162.50
Limited Stock
| Yes | No | |||
| 3 | JUMBO TWN BATH TISS.DISPEN | kimberly-clark | 75 | CAT4871XZ |
C$ 75.00
| No | No | |||
| 4 | DISPENSER | kimberly-clark | 108.34 | CAT4871XZ |
C$ 108.34
| No | No | |||
| 5 | TOWEL DISPENSER | kimberly-clark | 130 | CAT4871XZ |
C$ 130.00
| No | No | |||
| 6 | AIR FRESHENER DISPENSER | kimberly-clark | 6.67 | CAT4871XZ |
C$ 6.67
| No | No | |||
| 7 | TWIN ROLL SRT DISPENSER | kimberly-clark | 50 | CAT4871XZ |
C$ 50.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 8 | QUARTERFLD WIPER DISPENSER | kimberly-clark | 25 | CAT4871XZ |
C$ 25.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 9 | GRABBER WALL-MOUNT DISP | kimberly-clark | 390 | CAT4871XZ |
C$ 390.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 10 | PERSONAL SEAT COVER DISP | kimberly-clark | 33.34 | CAT4871XZ |
C$ 33.34
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 11 | JRT CORELESS JR. BATHROOM | kimberly-clark | 43.33 | CAT4871XZ |
C$ 43.33
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 12 | JRT CORELESS JR. BATHROOM | kimberly-clark | 32.4 | CAT4871XZ |
C$ 32.40
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 13 | DBL ROLL TOWEL DISPENSER | kimberly-clark | 33.34 | CAT4871XZ |
C$ 33.34
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 14 | ROLL TOWEL DISPENSER | kimberly-clark | 108.34 | CAT4871XZ |
C$ 108.34
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 15 | MULTI FOLD TOWEL DISPENSER | kimberly-clark | 75 | CAT4871XZ |
C$ 75.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 16 | SANITOUCH HARD ROLL TOWEL | kimberly-clark | 130 | CAT4871XZ |
C$ 130.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 17 | SANITOUCH ROLL TOWEL DISP | kimberly-clark | 130 | CAT4871XZ |
C$ 130.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 18 | SCOTT UNI.FOLD.TOW.DISP.BK | kimberly-clark | 48.5 | CAT4871XZ |
C$ 48.50
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 19 | SCOTT BATHTISSUE DISP. BK | kimberly-clark | 44.02 | CAT4871XZ |
C$ 44.02
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 20 | KCP UNV FOLDED TOWEL DISP | kimberly-clark | 116.66 | CAT4871XZ |
C$ 116.66
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 21 | HARD ROLL TOWEL DISPENSER | kimberly-clark | 86.66 | CAT4871XZ |
C$ 86.66
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 22 | ESSENTIAL TOWEL DISPENSER | kimberly-clark | 141.67 | CAT4871XZ |
C$ 141.67
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 23 | WYPALL REACH TOWEL DISPENS | kimberly-clark | 25 | CAT4871XZ |
C$ 25.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 24 | ELECTR SKIN CARE DISPENSER | kimberly-clark | 50 | CAT4871XZ |
C$ 50.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |