Refrigeration - Bottom Freezer Refrigerators

SELECT p.id,p.pkID, p.mhSlug,p.cgSlug,p.cSlug, p.CommonBrandName, p.RootModelNumber, p.SKU,p.SeriesName, p.StandardColor, p.KeyFeature1, p.KeyFeature2, p.KeyFeature3, p.KeyFeature4, p.KeyFeature5,p.client_flag ,if(p.CustomDescription IS NOT NULL AND p.CustomDescription <> '', p.CustomDescription, p.ModelDescription) AS ModelDescription,if(p.thumb LIKE 'http%',p.thumb, concat('/uploads/products/',p.thumb)) AS thumb ,if(p.large LIKE 'http%',p.large, concat('/uploads/products/',p.large)) AS large , mp.PowerBuy, mp.quick_ship, bd.preferred ,IF( (mp.Sale = 0), mp.MSRP, IF( (mp.MSRP = 0), mp.Sale, IF((mp.Sale > mp.MSRP), mp.MSRP, mp.Sale))) AS SortPrice, bd.CommonBrandID,mh.super_category, mp.ge_inv FROM tbl_store_brands AS sb INNER JOIN Brand_Data AS bd ON bd.pkID = sb.brandID+0 INNER JOIN tbl_products AS p ON sb.categoryID = p.pkCategory AND sb.brandID = p.pkBrand INNER JOIN ModelPrice AS mp ON (p.SKU = mp.SKU AND p.pkSKU = mp.pkSKU) INNER JOIN menu_heading AS mh ON mh.slug = p.mhSlug WHERE p.mhSlug = 'refrigeration' AND cgSlug = 'bottom-freezer' AND mp.Available = 1 GROUP BY p.RootModelNumber ORDER BY IF(quick_ship =1,quick_ship,999999) ASC, FIELD(p.cSlug, 'grill-accessories') ASC, p.cSlug, display_sequence ASC, IF(PowerBuy = 1,PowerBuy, 99999) ASC, preferred ASC, CommonBrandName, SKU
11
Compare Products:
  • Product List View
  • Product Grid View

Page 7 of 7
<< First Page 4567

MieleKF 2902 SF - MasterCool&trade; fridge-freezer with high-quality features and maximum storage space for exacting demands.

Add To Compare

Miele KF 2902 SF - MasterCool™ fridge-freezer with high-quality features and maximum storage space for exacting demands.

MasterCool - Active AirClean filter, MasterCool - NoFrost, MasterCool - DynaCool, MasterCool - Miele@home *, MasterCool - MasterSensor

Model Color Price
KF2902SFSTAINLESSSTEELCLEANSTEEL Stainless Steel/cleansteel $9,299.00
MieleKF 2902 Vi - MasterCool&trade; fridge-freezer with high-quality features and maximum storage space for exacting demands.

Add To Compare

Miele KF 2902 Vi - MasterCool™ fridge-freezer with high-quality features and maximum storage space for exacting demands.

MasterCool - Active AirClean filter, MasterCool - NoFrost, MasterCool - DynaCool, MasterCool - Miele@home *, MasterCool - MasterSensor

Model Color Price
KF2902VI $8,799.00
MieleKF 2912 SF - MasterCool&trade; fridge-freezer For high-end design and technology on a large scale.

Add To Compare

Miele KF 2912 SF - MasterCool™ fridge-freezer For high-end design and technology on a large scale.

Push2open for convenient door-opening assistance, Food stays fresh for up to 3 x longer thanks to SmartFresh, Light floods the interior thanks to LED elements - BrilliantLight, Communication with the machine could not be easier - WiFi Conn@ct, Convenient control thanks to color touch display MasterSensor

Model Color Price
KF2912SF $9,299.00
MieleKF 2912 Vi - MasterCool&trade; fridge-freezer with high-quality features and maximum storage space for exacting demands.

Add To Compare

Miele KF 2912 Vi - MasterCool™ fridge-freezer with high-quality features and maximum storage space for exacting demands.

MasterCool - Active AirClean filter, MasterCool - NoFrost, MasterCool - DynaCool, MasterCool - Miele@home *, MasterCool - MasterSensor

Model Color Price
KF2912VI $8,799.00
MieleKF 2981 SF - MasterCool FrenchDoor with high-quality features and maximum storage space for exacting demands.

Add To Compare

Miele KF 2981 SF - MasterCool FrenchDoor with high-quality features and maximum storage space for exacting demands.

MasterCool - Active AirClean filter, MasterCool - NoFrost, MasterCool - DynaCool, MasterCool - Miele@home *, MasterCool - MasterSensor

Model Color Price
KF2981SFSTAINLESSSTEELCLEANSTEEL Stainless Steel/cleansteel Contact us for best price
MieleKFN 13923 DE edt/cs - Freestanding fridge-freezer with convenient interior cabinet and IceMaker for fresh ice cubes any time.

Add To Compare

Miele KFN 13923 DE edt/cs - Freestanding fridge-freezer with convenient interior cabinet and IceMaker for fresh ice cubes any time.

IceMaker, ComfortClean, NoFrost, Fresh ice cubes from the IceMaker with plumbed water connection, * Miele@mobile app

Model Color Price
KFN13923DEEDTCSSTAINLESSSTEELCLEANSTEEL Stainless Steel/cleansteel $2,899.00
MieleKFN 15943 DE edt/cs - Freestanding fridge-freezer 30" (75 cm) wide for a lot of storage space.

Add To Compare

Miele KFN 15943 DE edt/cs - Freestanding fridge-freezer 30" (75 cm) wide for a lot of storage space.

IceMaker, ComfortClean, Soft Open/Soft Close, NoFrost, Ice cubes thanks to the plumbed IceMaker

Model Color Price
KFN15943DEEDTCSSTAINLESSSTEELCLEANSTEEL Stainless Steel/cleansteel $3,599.00
MieleKFN 9855 iDE - PerfectCool fridge-freezer maximum convenience thanks to generous large capacity and ice maker.

Add To Compare

MieleKFN 9855 iDE - PerfectCool fridge-freezer maximum convenience thanks to generous large capacity and ice maker.

Add To Compare

Samsung Appliances12.0 cu. ft. BESPOKE Bottom Freezer refrigerator with customizable colors and flexible design in Grey Glass

Add To Compare

Samsung Appliances 12.0 cu. ft. BESPOKE Bottom Freezer refrigerator with customizable colors and flexible design in Grey Glass

Customize Your Color, Flexible Design, Modern Look, Even Cooling, Top to Bottom, ENERGY STAR ® Certified

Model Color Price
RB12A300631 Grey Glass $1,799.00
RB12A300641 Navy Glass $1,799.00
Samsung Appliances12 cu. ft. Counter Depth Euro Chef Refrigerator

Add To Compare

Samsung Appliances 12 cu. ft. Counter Depth Euro Chef Refrigerator

Counter Depth, Fridge In Freezer, Twin Cooling Plus, Chef Mode, Chef Pan

Model Color Price
RB12J8896S4 Stainless Steel Contact us for best price

Page 7 of 7
<< First Page 4567

Added to Cart
Model#
Enter Zip Code*For delivery options
Final discounts, tax, and shipping costs at checkout.