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', '2433', '2434')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') REFRIGERATORS - REFRIGERATORS AND FREEZERS - HOUSEWARE & HOUSEHOLD SUPPLIES
  1. See Detail

REFRIGERATORS


View as Grid List

20 items

Page
per page
Set Descending Direction
  1. 26 CU FT. SIDE BY SIDE REFRIGERATOR
    $1,449.99 /PL
    FFHS2622MB FRIG.26CF SXS BLK.E-STAR Learn More
  2. REFRIGERATOR 23CF SIDE BY SIDE
    $1,527.99 /PL
    FFSS2314QS REFRIG 23CF STNL Learn More
  3. 18 CU. FT. TOP FREEZER REFRIGERATOR
    $790.99 /PL
    FFTR1821QB/18D2QB 18.2CF.FRIG BLCK Learn More
  4. 3.2 CU. FT. REFRIGERATOR
    $257.99 /EA
    DCR032C1BSLDD/DCR033A REFRG 3.2CF Learn More
  5. 22.6 CU FT SIDE BY SIDE REFRIGERATOR
    $1,277.99 /PL
    FFSS2314QE REFRIG 23CF BLK Learn More
  6. TOP FREEZER REFRIDGERATOR
    $790.99 /PL
    FFTR20G2QW/FFTR2021QW 21CF FRIG WHT Learn More
  7. 18CF REFRIGERATOR
    $896.99 /PL
    FFTR1821QW/18G2QW 18CF WH REFRI Learn More
  8. 26 CU FT. SIDE BY SIDE REFRIGERATOR
    $1,452.99 /PL
    FFSS2614QP REFRIG 26CF WHT Learn More
  9. 22.6 CU FT SIDE BY SIDE REFRIGERATOR
    $3,125.99 /PL
    FFSS2314QP REFRIG 23CF WHT Learn More
View as Grid List

20 items

Page
per page
Set Descending Direction