Refrigeration - Freezers

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

Page 4 of 8
<< First Page 2345 Last Page >>

Frigidaire 13'' Clear Dairy Door

Add To Compare

Frigidaire 13'' Clear Dairy Door

Model Color Price
240326203 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 Water Filter Bypass for PureSource Ultra&reg; ULTRAWF and PureSource&reg; 3 WF3CB

Add To Compare

Frigidaire Water Filter Bypass for PureSource Ultra® ULTRAWF and PureSource® 3 WF3CB

Model Color Price
242294402 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
FrigidaireSmart Choice Universal Top Mount Refrigerator Ice Maker Kit

Add To Compare

Frigidaire Smart Choice Universal Top Mount Refrigerator Ice Maker Kit

Model Color Price
IM116000 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 Professional 79" Single Trim kit - Flat Design

Add To Compare

Frigidaire Professional 79" Single Trim kit - Flat Design

Model Color Price
TRMKTEZ1FL79 Stainless Steel 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
Frigidaire PureSource Plus&reg; Water and Ice Refrigerator Filter

Add To Compare

Frigidaire PureSource Plus® Water and Ice Refrigerator Filter

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

Add To Compare

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

Model Color Price
WFCB2PAK Contact us for best price
GE&reg;AFPWF AUTO FILL PITCHER WATER FILTER

Add To Compare

GE ®AFPWF AUTO FILL PITCHER WATER FILTER

Model Color Regular Price Savings After Savings
AFPWF White $45.98 $6.00 $39.98
GE&reg;GSWF REFRIGERATOR WATER FILTER

Add To Compare

GE ®GSWF REFRIGERATOR WATER FILTER

Model Color Regular Price Savings After Savings
GSWF Other $48.16 $6.28 $41.88
GE&reg;GSWF3PK REFRIGERATOR WATER FILTER 3-PACK

Add To Compare

GE ®GSWF3PK REFRIGERATOR WATER FILTER 3-PACK

Model Color Price
GSWF3PK Contact us for best price
GEWATER FILTRATION REPLACEMENT "O" RING

Add To Compare

GE WATER FILTRATION REPLACEMENT "O" RING

Model Color Price
HHRING Contact us for best price
GE1" WRENCH FOR WHOLE HOUSE FILTRATION SYSTEMS

Add To Compare

GE 1" WRENCH FOR WHOLE HOUSE FILTRATION SYSTEMS

Model Color Price
HHWRNCH Contact us for best price
GE&reg;Automatic Ice Maker Installation Kit, IM6D

Add To Compare

GE ®Automatic Ice Maker Installation Kit, IM6D

Model Color Price
IM6D Contact us for best price

Page 4 of 8
<< First Page 2345 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.

≡