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
60
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 2
12 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

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

Model Color Price
18FFRACB01 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 Egg Tray

Model Color Price
215817806 Contact us for best price
Frigidaire Water Filter Wrench

Add To Compare

Frigidaire Water Filter Wrench

Model Color Price
218710300 Contact us for best price
Frigidaire White Dairy Door

Add To Compare

Frigidaire White Dairy Door

Model Color Price
240337701 Contact us for best price
Frigidaire 8'' Clear Dairy Door

Add To Compare

Frigidaire 8'' Clear Dairy Door

Model Color Price
240337712 Contact us for best price
Frigidaire White Ice Cream Shelf

Add To Compare

Frigidaire White Ice Cream Shelf

Model Color Price
240342901 Contact us for best price
Frigidaire Ice Bin

Add To Compare

Frigidaire Ice Bin

Model Color Price
240385201 Contact us for best price
Frigidaire Clear Light Cover

Add To Compare

Frigidaire Clear Light Cover

Model Color Price
240412701 Contact us for best price
FrigidaireSmart Choice White Touchup Paint Pen

Add To Compare

Frigidaire Smart Choice White Touchup Paint Pen

Model Color Price
241581802 White Contact us for best price
FrigidaireSmart Choice Black Touchup Paint Pen

Add To Compare

Frigidaire Smart Choice Black Touchup Paint Pen

Model Color Price
241581804 Black Contact us for best price
Frigidaire Metal Light Cover

Add To Compare

Frigidaire Metal Light Cover

Model Color Price
241686101 Contact us for best price
Frigidaire Small Blue Door Bin Liner

Add To Compare

Frigidaire Small Blue Door Bin Liner

Model Color Price
241779601 Blue Contact us for best price
Frigidaire Small Grey Door Bin Liner

Add To Compare

Frigidaire Small Grey Door Bin Liner

Model Color Price
241779603 Grey Contact us for best price
Frigidaire Large Blue Door Bin Liner

Add To Compare

Frigidaire Large Blue Door Bin Liner

Model Color Price
241780401 Blue Contact us for best price
Frigidaire Large Grey Door Bin Liner

Add To Compare

Frigidaire Large Grey Door Bin Liner

Model Color Price
241780403 Grey Contact us for best price
Frigidaire Freezer Shelf Clips

Add To Compare

Frigidaire Freezer Shelf Clips

Model Color Price
297121900 Contact us for best price
Frigidaire Plastic Key for Upright and Chest Freezers

Add To Compare

Frigidaire Plastic Key for Upright and Chest Freezers

Model Color Price
297147700 Contact us for best price
Frigidaire Freezer Shelf End Cap

Add To Compare

Frigidaire Freezer Shelf End Cap

Model Color Price
3201150 Contact us for best price
Frigidaire Top Mount Refrigerator Ice Maker Kit

Add To Compare

Frigidaire Top Mount Refrigerator Ice Maker Kit

Model Color Price
IM117000 White Contact us for best price
Frigidaire French Door Bottom Mount Ice Maker Kit, Standard-Depth

Add To Compare

Frigidaire French Door Bottom Mount Ice Maker Kit, Standard-Depth

Model Color Price
IMK0028A White Contact us for best price
FrigidaireSmart Choice Refrigerator and Freezer Thermometer

Add To Compare

Frigidaire Smart Choice Refrigerator and Freezer Thermometer

Model Color Price
L304432837 Contact us for best price
Frigidaire PureAir Ultra&reg; Air Filter

Add To Compare

Frigidaire PureAir Ultra® Air Filter

Model Color Price
PAULTRA Contact us for best price
Frigidaire PureAir Ultra II&trade; Air Filter

Add To Compare

Frigidaire PureAir Ultra II™ Air Filter

Model Color Price
PAULTRA2 Contact us for best price
Frigidaire PureAir Ultra II&trade; Air Filter (2 Pack)

Add To Compare

Frigidaire PureAir Ultra II™ Air Filter (2 Pack)

Model Color Price
PAULTRAII2PK White Contact us for best price
Frigidaire Professional 75" Dual Trim kit - Flat Design

Add To Compare

Frigidaire Professional 75" Dual Trim kit - Flat Design

Model Color Price
TRMKTEZ2FL75 Stainless Steel Contact us for best price
Frigidaire Professional 79" Dual Trim kit - Flat design

Add To Compare

Frigidaire Professional 79" Dual Trim kit - Flat design

Model Color Price
TRMKTEZ2FL79 Stainless Steel Contact us for best price
Frigidaire Professional 79" Dual Trim kit - Louvered Design

Add To Compare

Frigidaire Professional 79" Dual Trim kit - Louvered Design

Model Color Price
TRMKTEZ2LV79 Stainless Steel Contact us for best price
Frigidaire PureSource Ultra&reg; Water and Ice Refrigerator Filter

Add To Compare

Frigidaire PureSource Ultra® Water and Ice Refrigerator Filter

Model Color Price
ULTRAWF Contact us for best price
Frigidaire PureSource Ultra&reg; Replacement Ice and Water Filter, 2 pack

Add To Compare

Frigidaire PureSource Ultra® Replacement Ice and Water Filter, 2 pack

Model Color Price
ULTRAWF2PAK Contact us for best price
Frigidaire PureSource Ultra&reg; Replacement Ice and Water Filter, 3 pack

Add To Compare

Frigidaire PureSource Ultra® Replacement Ice and Water Filter, 3 pack

Model Color Price
ULTRAWF3PAK Contact us for best price
Frigidaire Gallery PureSource 2&reg; Water and Ice Refrigerator Filter

Add To Compare

Frigidaire Gallery PureSource 2® Water and Ice Refrigerator Filter

Model Color Price
WF2CB Contact us for best price
Frigidaire PureSource 2&reg; Replacement Ice and Water Filter, 2 Pack

Add To Compare

Frigidaire PureSource 2® Replacement Ice and Water Filter, 2 Pack

Model Color Price
WF2CB2PAK Contact us for best price
Frigidaire PureSource 2&reg; Replacement Ice and Water Filter, 3 Pack

Add To Compare

Frigidaire PureSource 2® Replacement Ice and Water Filter, 3 Pack

Model Color Price
WF2CB3PAK Contact us for best price
Frigidaire PureSource&reg; 3 Water and Ice Refrigerator Filter

Add To Compare

Frigidaire PureSource® 3 Water and Ice Refrigerator Filter

Model Color Price
WF3CB Contact us for best price
Frigidaire PureSource&reg; 3 Replacement Ice and Water Filter, 2 pack

Add To Compare

Frigidaire PureSource® 3 Replacement Ice and Water Filter, 2 pack

Model Color Price
WF3CB2PAK Contact us for best price
Frigidaire PureSource&reg; 3 Replacement Ice and Water Filter, 3 Pack

Add To Compare

Frigidaire PureSource® 3 Replacement Ice and Water Filter, 3 Pack

Model Color Price
WF3CB3PAK Contact us for best price

Page 1 of 2
12 Last Page >>

Added to Cart
Model#
Enter Zip Code*For delivery options
Start Checkout Continue Shopping
Final discounts, tax, and shipping costs at checkout.
CONNECT WITH US
SAVE WITH US

sign up for exclusive email savings!

CLICK TO SIGN UP

REACH US
FIND US

info@dewaardandbode.com

Tel: (360) 733-5900

BELLINGHAM SHOWROOM
3944 Meridian St.
Bellingham, WA 98225
BELLINGHAM OUTLET
service | parts | delivery
4175 Hannegan Rd.
Bellingham, WA 98225
BURLINGTON SHOWROOM & OUTLET
1611 S. Burlington Blvd.
Burlington, WA 98233
MORE
Parts & Services
Delivery Options
Contact Us
Careers
Builders
Terms of Use
Donations
Brands
Privacy Policy
About Us
Warranty Protection
Returns & Restock

Welcome to our website! As we have the ability to list over one million items on our website (our selection changes all of the time), it is not feasible for a company our size to record and playback the descriptions on every item on our website. However, if you are an American with a disability we are here to help you. Please call our disability services phone line at 360-733-5900 during regular business hours and one of our kind and friendly personal shoppers will help you navigate through our website, help conduct advanced searches, help you choose the item you are looking for with the specifications you are seeking, read you the specifications of any item and consult with you about the products themselves. There is no charge for the help of this personal shopper for any American with a disability. Finally, your personal shopper will explain our Privacy Policy and Terms of Service, and help you place an order if you so desire.

Copyright © 2009 - 2024 DeWaard & Bode All Rights Reserved.

≡