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` = 67) WHERE (`e`.`entity_id` IN('3213', '3554', '3555', '3559')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') PAINT BRUSH FOAM - PAINT BRUSHES - PAINT BRUSHES ROLLERS SPRAYS - PAINT, SUNDRIES, GLASS, LADDERS
  1. See Detail

PAINT BRUSH FOAM


View as Grid List

15 items

Page
per page
Set Descending Direction
  1. POLY FOAM BRUSH
    $0.69 /EA
    1" POLY BRUSH Learn More
  2. POLY FOAM BRUSH
    $1.29 /EA
    MP 2" POLY BRUSHES 3/BAG Learn More
  3. FOAM PAINT BRUSH WOOD HANDLE
    $0.49 /EA
    8500 3" FOAM BRUSH WD/HNDL Learn More
  4. POLY FOAM BRUSH
    $0.89 /EA
    4" POLY BRUSH Learn More
  5. FOAM PAINT BRUSH WOOD HANDLE
    $0.39 /EA
    8500 1" FOAM BRUSH WD HNDL Learn More
  6. FOAM BRUSH SET
    $1.69 /EA
    7040 4PC FOAM BRUSH SET Learn More
  7. POLY FOAM BRUSH
    $0.89 /EA
    3" POLY BRUSH Learn More
  8. POLY FOAM BRUSH
    $0.99 /EA
    MP3 3" POLY BRUSHES 2/BAG Learn More
  9. FOAM PAINT BRUSH WOOD HANDLE
    $0.69 /EA
    8500 4" FOAM BRUSH WD/HNDL Learn More
View as Grid List

15 items

Page
per page
Set Descending Direction