Refrigeration - Freezers - Icemaker Kits

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 = 'freezers' AND cSlug = 'icemaker-kits-refrigerator' AND mp.Available = 1 AND ((CommonBrandID = 'FRIG')) 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
15
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 5
1234 Last Page >>

Frigidaire Ice Cube Tray

Add To Compare

Frigidaire Ice Cube Tray

Model Color Price
01121808 Contact us for best price
Frigidaire Dehumidifier Drain Hose

Add To Compare

Frigidaire Dehumidifier Drain Hose

Provides Continuous Drainage, Dehumidifier Drain Hose, Cut-to-Length Design: Easily cut hose to desired length., Fits Most Dehumidifiers: The 12 ft. length and hose coupling provides a great fit for dehumidifiers., Easy Installation

Model Color Price
18FFDHMH01 Contact us for best price
Frigidaire 80 lb. Air Conditioner Support Bracket

Add To Compare

Frigidaire 80 lb. Air Conditioner Support Bracket

Window A/C Support Bracket, Adjusts to Wall Thickness, Built to Support up to 10,000 BTU, Easy Installation, Durable Design & Construction

Model Color Price
18FFRACB01 Contact us for best price
Frigidaire 160 lb. Air Conditioner Support Bracket

Add To Compare

Frigidaire 160 lb. Air Conditioner Support Bracket

Adjusts to Wall Thickness, Built to Support up to 24,000 BTU, Easy Installation, Durable Design & Construction, Universal Support Bracket: Easily adjust support bracket to fit most window designs.

Model Color Price
18FFRACB02 Contact us for best price
Frigidaire Electrostatic Filter for Air Conditioner

Add To Compare

Frigidaire Electrostatic Filter for Air Conditioner

Cut-to-Fit Design, A/C Electrostatic Filter, Fits Most Window Air Conditioners, Easy Installation: Place electrostatic filter behind air conditioner grill and resume normal use., Easy to Use: For optimal performance, discard and replace filter once per season. Not washable.

Model Color Price
18FFRACF01 Contact us for best price
Frigidaire Air Conditioner Side Panel Kit

Add To Compare

Frigidaire Air Conditioner Side Panel Kit

Reduce Drafts in Your Room, Adjustable Side Panels 2 Pack, Fits Most Window Air Conditioners, Cut-to-Fit Design: Easily cut panel to desired height, using old panel as a guide., Easy Installation

Model Color Price
18FFRACP01 Contact us for best price
Frigidaire Ice Cube Tray

Add To Compare

Frigidaire Ice Cube Tray

Model Color Price
215667501 Contact us for best price
Frigidaire Egg Tray

Add To Compare

Frigidaire Water Filter Wrench

Add To Compare

Frigidaire 13'' Clear Dairy Door

Add To Compare

Frigidaire White Dairy Door

Add To Compare

Frigidaire 8'' Clear Dairy Door

Add To Compare

Frigidaire White Ice Cream Shelf

Add To Compare

Frigidaire White Ice Cream Shelf

SpaceWise® Organization System: Our SpaceWise® Organization system makes it easy to keep food organized and easy to find when you need it., Humidity-Controlled Crisper Drawers: Keep your fruits and vegetables fresh in our humidity-controlled crisper drawers., Smudge-Proof Stainless Steel: Resists fingerprints and smudges so it's easy to clean., Bright Lighting: Our bright lighting makes it easy to see what's inside. Watch Video, Reversible Door: Door can be installed to open left or right based on your needs.

Model Color Price
240342901 Contact us for best price

Page 1 of 5
1234 Last Page >>

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