Cooking - Hoods - Vent Hoods

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 = 'cooking' AND cgSlug = 'hoods' AND cSlug = 'vent-hoods' AND mp.Available = 1 AND ((CommonBrandID = 'WHIR')) 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 3
123 Last Page >>

Whirlpool30" Custom Hood Liner

Add To Compare

Whirlpool 30" Custom Hood Liner

Model Color Price
UVL5430JSS Stainless Steel $649.00
Whirlpool36" Custom Hood Liner

Add To Compare

Whirlpool 36" Custom Hood Liner

Model Color Price
UVL6036JSS Stainless Steel $1,049.00
Whirlpool48" Custom Hood Liner

Add To Compare

Whirlpool 48" Custom Hood Liner

Model Color Price
UVL6048JSS Stainless Steel $1,149.00
Whirlpool1170 CFM internal blower

Add To Compare

Whirlpool 1170 CFM internal blower

Model Color Price
UXB1200DYS Stainless Steel $699.00
Whirlpool30-INCH VENTED UNDERCABINET HOOD

Add To Compare

Whirlpool 30-INCH VENTED UNDERCABINET HOOD

Model Color Price
UXT3030ADB Black $109.00
Whirlpool30" Range Hood with the FIT System

Add To Compare

Whirlpool 30" Range Hood with the FIT System

Model Color Price
UXT4130ADS Stainless Steel $159.00
Whirlpool36" Range Hood with the FIT System

Add To Compare

Whirlpool 36" Range Hood with the FIT System

Model Color Price
UXT4136ADS Stainless Steel Contact us for best price
Whirlpool36" Range Hood with the FIT System

Add To Compare

Whirlpool 36" Range Hood with the FIT System

Model Color Price
UXT4236ADS Stainless Steel $199.00
Whirlpool30" Range Hood with the FIT System

Add To Compare

Whirlpool 30" Range Hood with the FIT System

Model Color Price
UXT5230BDS Stainless Steel $389.00
Whirlpool36" Range Hood with the FIT System

Add To Compare

Whirlpool 36" Range Hood with the FIT System

Model Color Price
UXT5236BDS Stainless Steel $409.00
Whirlpool30" Convertible Under-Cabinet Hood

Add To Compare

Whirlpool 30" Convertible Under-Cabinet Hood

Model Color Regular Price Savings After Savings
UXT5530AAS Stainless Steel $569.00 $70.00 $499.00
Whirlpool36" Convertible Under-Cabinet Hood

Add To Compare

Whirlpool 36" Convertible Under-Cabinet Hood

Model Color Regular Price Savings After Savings
UXT5536AAS Stainless Steel $619.00 $90.00 $529.00
Whirlpool24" Wall-Mount Canopy

Add To Compare

Whirlpool 24" Wall-Mount Canopy

Model Color Price
UXW7324BSS Stainless Steel $799.00
Whirlpool30" Range Hood with Full-Width Grease Filters

Add To Compare

Whirlpool 30" Range Hood with Full-Width Grease Filters

Model Color Price
WVU17UC0JB Heritage Black $159.00
WVU17UC0JW Heritage White $159.00
Whirlpool30" Range Hood with Full-Width Grease Filters

Add To Compare

Whirlpool 30" Range Hood with Full-Width Grease Filters

Model Color Price
WVU37UC0FS Stainless Steel $379.00

Page 1 of 3
123 Last Page >>

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