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=4408 and pa.subcategory_id=4436 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 | |
---|---|---|---|---|---|---|---|---|---|---|
SURE SEAL SEAM & JOINT SEALER - Black | dominion-sure-seal | 12.97 | CAT4436XZ |
C$ 12.97
In Stock
| Yes | No | ||||
1 | SURE SEAL SEAM & JOINT SEALER - Clear | dominion-sure-seal | 14.74 | CAT4436XZ |
C$ 14.74
In Stock
| Yes | No | |||
2 | SURE SEAL SEAM & JOINT SEALER - Grey | dominion-sure-seal | 14.27 | CAT4436XZ |
C$ 14.27
In Stock
| Yes | No | |||
3 | SURE SEAL SEAM & JOINT SEALER - Beige | dominion-sure-seal | 12.23 | CAT4436XZ |
C$ 12.23
In Stock
| Yes | No | |||
4 | Brush On Seam Sealer | dominion-sure-seal | 28.79 | CAT4436XZ |
C$ 28.79
In Stock
| Yes | No | |||
5 | SUREMIX DTM HEAVY BODY EPOXY SEAM SEALER | dominion-sure-seal | 44.92 | CAT4436XZ |
C$ 44.92
In Stock
| Yes | No | |||
6 | Brushable Seam Sealer Quart | evercoat | 61 | CAT4436XZ |
C$ 61.00
In Stock
| Yes | No | |||
7 | SURE SEAL SEAM & JOINT SEALER - White | dominion-sure-seal | 12.97 | CAT4436XZ |
C$ 12.97
| No | No | |||
8 | SUREMIX DTM CONTROL FLOW EPOXY SEAM SEALER | dominion-sure-seal | 37.34 | CAT4436XZ |
C$ 37.34
| No | No | |||
9 | SUREMIX DTM SELF-LEVELING EPOXY SEAM SEALER | dominion-sure-seal | 0 | CAT4436XZ |
C$ 0.00
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |