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', '3215', '3246')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') VALSPAR 45000 SERIES MEDALLION EXTERIOR PAINT - EXTERIOR PAINTS (NOT ROOF & FLOORS) - PAINTS - PAINT, SUNDRIES, GLASS, LADDERS
  1. See Detail

VALSPAR 45000 SERIES MEDALLION EXTERIOR PAINT


View as Grid List

10 items

Page
per page
Set Descending Direction
  1. EXTERIOR FLAT HOUSE PAINT
    $21.99 /QT
    45501 QT EXT. FLAT WHITE Learn More
  2. EXTERIOR FLAT HOUSE PAINT
    $47.99 /GA
    45508 GA EXT.FL.PASTEL BASE Learn More
  3. EXTERIOR FLAT HOUSE PAINT
    $46.99 /GA
    45502 GA EXT.FLAT TINT BASE Learn More
  4. MEDALLION EXTERIOR LATEX SEMI GLOSS PAINT
    $218.99 /EA
    4300 5GAL EXT.S/GLOSS WHITE Learn More
  5. EXTERIOR FLAT HOUSE PAINT
    $47.99 /GA
    45501 GAL EXT. FLAT WHITE Learn More
  6. EXTERIOR FLAT HOUSE PAINT
    $20.49 /QT
    45505 QT EXT.FLAT CLEAR BSE Learn More
  7. EXTERIOR FLAT HOUSE PAINT
    $21.99 /QT
    45508 QT EXT.FL PASTEL BASE Learn More
  8. MEDALLION EXTERIOR PAINT AND PRIMER
    $44.49 /GA
    4315 GAL EXT. S/GLOSS BLACK Learn More
  9. EXTERIOR FLAT HOUSE PAINT
    $21.99 /QT
    45502 QT EXT.FLAT TINT BASE Learn More
View as Grid List

10 items

Page
per page
Set Descending Direction