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

VALSPAR 4000 SERIES MEDALLION EXTERIOR HOUSE TRIM PAINT


View as Grid List

19 items

Page
per page
Set Descending Direction
  1. EXTERIOR SEMI-GLOSS HOUSE AND TRIM
    $46.49 /GA
    4300 GAL EXT. S/GLOSS WHITE Learn More
  2. EXTERIOR SATIN WHITE HOUSE AND TRIM
    $291.99 /EA
    4100 5GAL EXT. SATIN WHITE Learn More
  3. EXTERIOR SEMI-GLOSS HOUSE AND TRIM
    $21.49 /QT
    4308 QT EXT. SG PASTEL BASE Learn More
  4. EXTERIOR SATIN WHITE HOUSE AND TRIM
    $19.99 /QT
    4105 QT EXT.SATIN CLEAR BSE Learn More
  5. EXTERIOR SATIN WHITE HOUSE AND TRIM
    $245.99 /EA
    4105 5GAL MED CLEAR S/BASE Learn More
  6. EXTERIOR SEMI-GLOSS HOUSE AND TRIM
    $19.99 /QT
    4305 QT EXT. SG CLEAR BASE Learn More
  7. EXTERIOR SATIN WHITE HOUSE AND TRIM
    $19.99 /QT
    4102 QT EXT.SATIN TINT BSE. Learn More
  8. EXTERIOR SATIN WHITE HOUSE AND TRIM
    $57.99 /GA
    4108 GAL EXT.SAT.PASTEL BSE Learn More
  9. EXTERIOR SATIN WHITE HOUSE AND TRIM
    $270.99 /EA
    4108 5GAL EXT S/PASTEL BASE Learn More
View as Grid List

19 items

Page
per page
Set Descending Direction