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('1977', '2257', '2258', '2261')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') FLOOR WAX SEALER POLISH - FLOOR & WALL CLEANERS/AND/WAX - CLEANERS,SEALERS,WAXES,POLISHES - HOUSEWARE & HOUSEHOLD SUPPLIES
  1. See Detail

FLOOR WAX SEALER POLISH


View as Grid List

10 items

Page
per page
Set Descending Direction
  1. FLOOR RESTORER
    $25.99 /EA
    RJ32PROFG FLOOR RESTORER 32 Learn More
  2. FUTURE
    $9.69 /EA
    11182 JOHNSON FUTURE 27OZ FLOOR FIN Learn More
  3. Hardwood Floor Polish
    $18.99 /EA
    WP500359001 FLR POLISH 36OZ Learn More
  4. GOLD LABEL SEALER WAX
    $26.99 /EA
    887171967 SEALER WAX 1 GAL GLOSS Learn More
  5. FLOOR RESTORER
    $18.99 /EA
    RJ32F FLOOR RESTORER 32OZ Learn More
  6. STONE, TILE, & LAMINATE POLISH
    $18.99 /EA
    WP511059001 STL POLISH 36OZ Learn More
  7. Hardwood Floor Polish
    $18.99 /EA
    WP510059001 HDWD FLR POLISH Learn More
  8. GOLD LABEL SEALER
    $7.89 /EA
    887135027 GOLD LABEL SEALER 32OZ Learn More
  9. FLOOR RESTORER
    $25.99 /EA
    RJ32PROFS FLR RESTORE SATIN Learn More
View as Grid List

10 items

Page
per page
Set Descending Direction