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 = 'BEST')) 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 10
1234 Last Page >>

BestOptional Decorative soffit flue extensions for the WP28 Range Hood

Add To Compare

Best Optional Decorative soffit flue extensions for the WP28 Range Hood

Model Color Regular Price Savings After Savings
AEWP28362SB $296.00 $30.00 $266.00
BestOptional Decorative soffit flue extensions for the WP28 Range Hood

Add To Compare

Best Optional Decorative soffit flue extensions for the WP28 Range Hood

Model Color Regular Price Savings After Savings
AEWP28422SB $319.00 $32.00 $287.00
BestOptional Decorative soffit flue extensions for the WP28 Range Hood

Add To Compare

Best Optional Decorative soffit flue extensions for the WP28 Range Hood

Model Color Regular Price Savings After Savings
AEWP28482SB $342.00 $34.00 $308.00
BestOptional Decorative soffit flue extensions for the WP28 Range Hood

Add To Compare

Best Optional Decorative soffit flue extensions for the WP28 Range Hood

Model Color Regular Price Savings After Savings
AEWP28602SB $426.00 $43.00 $383.00
Best18" Flue Cover for 9' Ceiling - Standard Depth

Add To Compare

Best 18" Flue Cover for 9' Ceiling - Standard Depth

Model Color Regular Price Savings After Savings
AEWPD318SB $235.00 $23.00 $212.00
Best18" Flue Cover for 9' Ceiling - Extended Depth

Add To Compare

Best 18" Flue Cover for 9' Ceiling - Extended Depth

Model Color Regular Price Savings After Savings
AEWPD318SBE $246.00 $25.00 $221.00
Best30" Flue Cover for 10' Ceiling - Standard Depth

Add To Compare

Best 30" Flue Cover for 10' Ceiling - Standard Depth

Model Color Regular Price Savings After Savings
AEWPD330SB $320.00 $32.00 $288.00
Best30" Flue Cover for 10' Ceiling - Extended Depth

Add To Compare

Best 30" Flue Cover for 10' Ceiling - Extended Depth

Model Color Regular Price Savings After Savings
AEWPD330SBE $321.00 $32.00 $289.00
Best6" Flue Cover for 8' Ceiling - Standard Depth

Add To Compare

Best 6" Flue Cover for 8' Ceiling - Standard Depth

Model Color Regular Price Savings After Savings
AEWPD36SB $211.00 $21.00 $190.00
Best6" Flue Cover for 8' Ceiling - Extended Depth

Add To Compare

Best 6" Flue Cover for 8' Ceiling - Extended Depth

Model Color Regular Price Savings After Savings
AEWPD36SBE $225.00 $22.00 $203.00
BestOptional flue extensions for WPP9 Chimney Range Hoods 10'-11' ceiling application (Ducted and non-ducted installation)

Add To Compare

Best Optional flue extensions for WPP9 Chimney Range Hoods 10'-11' ceiling application (Ducted and non-ducted installation)

Model Color Regular Price Savings After Savings
AEWPP9SBN $490.00 $49.00 $441.00
BestStainless Steel Flue Extension for 10' Ceilings on WTT32I48SB Range Hood Only

Add To Compare

Best Stainless Steel Flue Extension for 10' Ceilings on WTT32I48SB Range Hood Only

Model Color Regular Price Savings After Savings
AEWTT328SB $351.00 $35.00 $316.00
BestStainless Steel Flue Extension for 10' Ceilings on 30"-42" WTT32I Range Hoods Only

Add To Compare

Best Stainless Steel Flue Extension for 10' Ceilings on 30"-42" WTT32I Range Hoods Only

Model Color Regular Price Savings After Savings
AEWTT32SB $351.00 $35.00 $316.00
BestCirrus 43-1/4 inch Brushed Stainless Steel Ceiling Mounted Range Hood with External Blower

Add To Compare

Best Cirrus 43-1/4 inch Brushed Stainless Steel Ceiling Mounted Range Hood with External Blower

Model Color Regular Price Savings After Savings
CC34E6SB $2105.00 $210.00 $1,895.00
BestCirrus 43-1/4 inch Brushed Stainless Steel Ceiling Mounted Range Hood with 800 MAX CFM iQ6 Internal Blower

Add To Compare

Best Cirrus 43-1/4 inch Brushed Stainless Steel Ceiling Mounted Range Hood with 800 MAX CFM iQ6 Internal Blower

Model Color Regular Price Savings After Savings
CC34IQSB $2579.00 $258.00 $2,321.00

Page 1 of 10
1234 Last Page >>

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