Cooking - Microwaves - Over The Range

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 = 'microwaves' AND cSlug = 'over-the-range-microwaves' 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
15
Compare Products:
  • Product List View
  • Product Grid View

Page 3 of 7
<< First Page 1234 Last Page >>

LG Appliances1.7 cu. ft. Over-the-Range Microwave Oven with EasyClean&reg;

Add To Compare

LG Appliances 1.7 cu. ft. Over-the-Range Microwave Oven with EasyClean®

Model Color Regular Price Savings After Savings
LMV1764ST Stainless Steel $274.00 $42.00 $232.00
LG Appliances1.8 cu. ft. Over-the-Range Microwave Oven with EasyClean&reg;

Add To Compare

LG Appliances 1.8 cu. ft. Over-the-Range Microwave Oven with EasyClean®

Model Color Regular Price Savings After Savings
LMV1831SS Print Proof Stainless Steel $373.00 $96.00 $277.00
LG Appliances1.8 cu.ft. Over-the-Range Microwave Oven

Add To Compare

LG Appliances 1.8 cu.ft. Over-the-Range Microwave Oven

Model Color Regular Price Savings After Savings
LMV1831ST Stainless Steel $351.00 $97.00 $254.00
LG Appliances2.0 cu. ft. Over-the-Range Microwave Oven with EasyClean&reg;

Add To Compare

LG Appliances 2.0 cu. ft. Over-the-Range Microwave Oven with EasyClean®

Model Color Price
LMV2031SW Smooth White Contact us for best price
LMV2031ST Stainless Steel $439.00 $140.00 $299.00
LMV2031BD Black Stainless Steel $494.00 $135.00 $359.00
LG Appliances1.7 cu. ft. Over-the-Range Convection Microwave Oven

Add To Compare

LG Appliances 1.7 cu. ft. Over-the-Range Convection Microwave Oven

Model Color Regular Price Savings After Savings
LMVH1711ST Stainless Steel $659.00 $120.00 $539.00
LG Appliances2.0 cu. ft. Over-the-Range Microwave Oven with EasyClean&reg;

Add To Compare

LG Appliances 2.0 cu. ft. Over-the-Range Microwave Oven with EasyClean®

Model Color Regular Price Savings After Savings
LMVM2033ST Stainless Steel $494.00 $45.00 $449.00
LG AppliancesLG STUDIO 1.7 cu. ft. Over-the-Range Convection Microwave Oven

Add To Compare

LG Appliances LG STUDIO 1.7 cu. ft. Over-the-Range Convection Microwave Oven

Model Color Regular Price Savings After Savings
LSMC3086SS Stainless Steel $879.00 $160.00 $719.00
LG AppliancesSTUDIOLG STUDIO 1.7 cu. ft. Over-the-Range Convection Microwave Oven

Add To Compare

LG Appliances STUDIO LG STUDIO 1.7 cu. ft. Over-the-Range Convection Microwave Oven

Model Color Price
LSMC3086ST Stainless Steel Contact us for best price
LG AppliancesSTUDIOLG STUDIO 1.7 cu. ft. Over-the- Range Convection Microwave Oven

Add To Compare

LG Appliances STUDIO LG STUDIO 1.7 cu. ft. Over-the- Range Convection Microwave Oven

Model Color Price
LSMC3089BD Black Stainless Steel Contact us for best price
Amana1.6 Cu. Ft. Over-the-Range Microwave with Add 0:30 Seconds - Black

Add To Compare

Amana 1.6 Cu. Ft. Over-the-Range Microwave with Add 0:30 Seconds - Black

Model Color Regular Price Savings After Savings
AMV2307PFB Black $239.00 $60.00 $179.00
Blomberg30" Over the Range Microwave

Add To Compare

Blomberg 30" Over the Range Microwave

Model Color Price
BOTR30100SS Stainless Steel Contact us for best price
Blomberg30in OTR - handless design

Add To Compare

Blomberg 30in OTR - handless design

Model Color Price
BOTR30102SS Stainless Steel Contact us for best price
Blomberg30" OTR Convection Microwave

Add To Compare

Blomberg 30" OTR Convection Microwave

Model Color Price
BOTR30200CSS Stainless Steel Contact us for best price
Bosch300 Series OTR

Add To Compare

Bosch 300 Series OTR

Model Color Regular Price Savings After Savings
HMV3053U Stainless Steel $499.00 $50.00 $449.00
Bosch500 Series OTR

Add To Compare

Bosch 500 Series OTR

Model Color Regular Price Savings After Savings
HMV5053U Stainless Steel $649.00 $100.00 $549.00

Page 3 of 7
<< First Page 1234 Last Page >>

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