SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 95) WHERE (`e`.`entity_id` IN('3213', '3214', '3272')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') ROOF PAINTS & COATINGS/FOUNDATIONS - PAINTS - PAINT, SUNDRIES, GLASS, LADDERS
  1. See Detail

ROOF PAINTS & COATINGS/FOUNDATIONS


View as Grid List

70 items

Page
per page
Set Descending Direction
  1. STA-KOOL 440 WHITE FLASH ACRYLIC ROOF CEMENT
    $36.99 /EA
    SK4401 GAL WHT ROOF CEMENT Learn More
  2. LEAK SEAL COAT
    $16.99 /QT
    275116 QT LEAKESAL COAT CLEAR Learn More
  3. LEAK SEAL COAT
    $9.99 /EA
    275117 HPT LEAKSEAL COAT BLK Learn More
  4. LEAK SEAL COAT
    $9.99 /EA
    279614 HPT LEAKSEAL COAT CLEAR Learn More
  5. LEAKSEAL TAPE
    $8.29 /EA
    275795 10'LEAKSEAL TAPE BLK Learn More
  6. LEAKSEAL TAPE
    $8.29 /EA
    275796 10'LEAKSEAL TAPE OPAQUE Learn More
  7. Black Jack® Super Flash® Neoprene Cement
    $9.39 /EA
    1010 10OZ BJ NEOP. R/CEMENT Learn More
  8. Roof-tex Ultra Premium Elastomeric Roof Coating
    $118.99 /EA
    8800 5GAL ELAST. ROOF COAT Learn More
  9. FIBERED ROOF COATING
    $49.99 /EA
    0105-GA 5GAL W/F ROOF COAT Learn More
View as Grid List

70 items

Page
per page
Set Descending Direction