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` = 100) 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
    $19.49 /QT
    45501 QT EXT. FLAT WHITE Learn More
  2. EXTERIOR FLAT HOUSE PAINT
    $47.39 /GA
    45508 GA EXT.FL.PASTEL BASE Learn More
  3. EXTERIOR FLAT HOUSE PAINT
    $46.29 /GA
    45502 GA EXT.FLAT TINT BASE Learn More
  4. MEDALLION EXTERIOR LATEX SEMI GLOSS PAINT
    $273.75 /EA
    4300 5GAL EXT.S/GLOSS WHITE Learn More
  5. EXTERIOR FLAT HOUSE PAINT
    $47.39 /GA
    45501 GAL EXT. FLAT WHITE Learn More
  6. EXTERIOR FLAT HOUSE PAINT
    $18.15 /QT
    45505 QT EXT.FLAT CLEAR BSE Learn More
  7. EXTERIOR FLAT HOUSE PAINT
    $19.49 /QT
    45508 QT EXT.FL PASTEL BASE Learn More
  8. MEDALLION EXTERIOR PAINT AND PRIMER
    $55.45 /GA
    4315 GAL EXT. S/GLOSS BLACK Learn More
  9. EXTERIOR FLAT HOUSE PAINT
    $19.19 /QT
    45502 QT EXT.FLAT TINT BASE Learn More
View as Grid List

10 items

Page
per page
Set Descending Direction