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('1977', '2421', '2424', '2425')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') TRIM RINGS AND KNOBS ELECTRIC RANGE - REPLACEMENT PARTS (ALL) - RANGES AND REPLACEMENT PARTS - HOUSEWARE & HOUSEHOLD SUPPLIES
  1. See Detail

TRIM RINGS AND KNOBS ELECTRIC RANGE


View as Grid List

10 items

Page
per page
Set Descending Direction
  1. ELECTRIC RANGE KNOBS
    $12.99 /EA
    RKG GAS RANGE KNOBS Learn More
  2. TRIM RINGS FOR ELECTRIC RANGES
    $5.39 /EA
    00353 8" UNIV CH TRIM RING Learn More
  3. TRIM RINGS FOR ELECTRIC RANGES
    $4.99 /EA
    00313 8" GE/HP CH TRIM RING Learn More
  4. TOP BURNER KNOB KIT
    $5.39 /EA
    00973 GAS OVEN BLK KNOB Learn More
  5. ELECTRIC RANGE KNOBS
    $12.99 /EA
    RKE ELECTRIC RANGE KNOBS Learn More
  6. ELECTRIC RANGE TOP BURNER KNOB KIT
    $18.99 /EA
    00883 ELEC BURNER BLK KNOBS Learn More
  7. TRIM RINGS FOR ELECTRIC RANGES
    $4.79 /EA
    00343 6" UNIV CH TRIM RING Learn More
  8. BURNER COVER
    $11.99 /EA
    5000 BURNER COVER VINE Learn More
  9. TRIM RINGS FOR ELECTRIC RANGES
    $4.49 /EA
    00303 6" GE/HP CH TRIM RING Learn More
View as Grid List

10 items

Page
per page
Set Descending Direction