Outdoor Cooking - Grills - Grill Accessories

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 = 'outdoor-cooking' AND cgSlug = 'grills' AND cSlug = 'grill-accessories' AND mp.Available = 1 AND ((CommonBrandID = 'WEBER')) 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 3 of 14
<< First Page 1234 [Next 10 of 14 pages] Last Page >>

WeberWEBER ORIGINAL - Large Stainless Steel Fish Basket

Add To Compare

Weber WEBER ORIGINAL - Large Stainless Steel Fish Basket

Model Color Regular Price Savings After Savings
6471 $44.00 $5.01 $38.99
WeberWEBER STYLE - Small Stainless Steel Vegetable Basket

Add To Compare

Weber WEBER STYLE - Small Stainless Steel Vegetable Basket

Model Color Regular Price Savings After Savings
6481 $23.00 $3.01 $19.99
WeberWEBER ORIGINAL - Poultry Roaster

Add To Compare

Weber WEBER ORIGINAL - Poultry Roaster

Model Color Regular Price Savings After Savings
6482 $23.00 $3.01 $19.99
WeberWEBER ORIGINAL - Burger Press

Add To Compare

Weber WEBER ORIGINAL - Burger Press

Model Color Regular Price Savings After Savings
6483 $15.00 $3.01 $11.99
WeberWEBER ORIGINAL - Potato Nails

Add To Compare

Weber WEBER ORIGINAL - Potato Nails

Model Color Regular Price Savings After Savings
6488 $16.00 $3.01 $12.99
WeberWEBER ORIGINAL&trade; Corn Picks

Add To Compare

Weber WEBER ORIGINAL™ Corn Picks

Model Color Regular Price Savings After Savings
6489 $16.00 $3.01 $12.99
Weber21 inch Three-Sided Grill Brush

Add To Compare

Weber 21 inch Three-Sided Grill Brush

Model Color Regular Price Savings After Savings
6493 $17.00 $3.01 $13.99
WeberCast-Iron Grill Brush

Add To Compare

Weber Cast-Iron Grill Brush

Model Color Regular Price Savings After Savings
6495 $14.00 $3.01 $10.99
WeberDrip Pan

Add To Compare

Weber Drip Pan

Model Color Regular Price Savings After Savings
6498 $15.00 $2.51 $12.49
WeberQ&trade; Adapter Hose

Add To Compare

Weber Q™ Adapter Hose

Model Color Regular Price Savings After Savings
6501 $40.00 $5.01 $34.99
WeberWEBER ORIGINAL - Q&trade; Griddle

Add To Compare

Weber WEBER ORIGINAL - Q™ Griddle

Model Color Regular Price Savings After Savings
6506 $74.00 $10.01 $63.99
WeberQ&trade; Cart

Add To Compare

Weber Q™ Cart

Model Color Regular Price Savings After Savings
6525 $140.00 $10.01 $129.99
WeberQ&reg; Handle Light

Add To Compare

Weber Q® Handle Light

Model Color Price
6530 Contact us for best price
WeberUniversal Grill Light

Add To Compare

Weber Universal Grill Light

Model Color Price
6531 Contact us for best price
WeberBarbecue Mitt

Add To Compare

Weber Barbecue Mitt

Model Color Regular Price Savings After Savings
6532 $13.00 $2.51 $10.49

Page 3 of 14
<< First Page 1234 [Next 10 of 14 pages] Last Page >>

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