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', '3389', '3400', '3411')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') VOC COMPLIANT INTERIOR WOOD STAIN FINISH MINWAX - WOOD STAINS - VARNISHES, SHELLACS, PRESERVATIV - PAINT, SUNDRIES, GLASS, LADDERS
  1. See Detail

VOC COMPLIANT INTERIOR WOOD STAIN FINISH MINWAX


View as Grid List

13 items

Page
per page
Set Descending Direction
  1. V.O.C COMPLIANT WOOD FINISH
    $45.99 /GA
    71070 GAL VOC WD FIN.NATURAL Learn More
  2. V.O.C COMPLIANT WOOD FINISH
    $45.99 /GA
    71076 GAL VOC WD FIN.S/WALNUT Learn More
  3. V.O.C COMPLIANT WOOD FINISH
    $45.99 /GA
    71087 GAL VOC WD FIN.E/CHESTNUT Learn More
  4. V.O.C COMPLIANT WOOD FINISH
    $45.99 /GA
    71074 GAL VOC WD FIN.I/PINE Learn More
  5. V.O.C COMPLIANT WOOD FINISH
    $45.99 /GA
    71088 GAL VOC WD FIN.GUNSTOCK Learn More
  6. V.O.C COMPLIANT WOOD FINISH
    $45.99 /GA
    71071 GAL VOC WD FIN.G/OAK Learn More
  7. V.O.C COMPLIANT WOOD FINISH
    $45.99 /GA
    71077 GAL VOC WD FIN.R/MAHOGANY Learn More
  8. V.O.C COMPLIANT WOOD FINISH
    $45.99 /GA
    71079 GAL VOC WD FIN.CHERRY Learn More
  9. V.O.C COMPLIANT WOOD FINISH
    $45.99 /GA
    71075 GAL VOC WD FIN.C/MAPLE Learn More
View as Grid List

13 items

Page
per page
Set Descending Direction