Cooking - Ovens - Electric: Double

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 = 'ovens' AND cSlug = 'electric-double-ovens' AND mp.Available = 1 AND ((CommonBrandID = 'LG')) 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
3
Compare Products:
  • Product List View
  • Product Grid View

Page 1 of 1
1

LG AppliancesLG STUDIO 1.7/4.7 cu. ft. Smart wi-fi Enabled Combination Double Wall Oven

Add To Compare

LG Appliances LG STUDIO 1.7/4.7 cu. ft. Smart wi-fi Enabled Combination Double Wall Oven

Model Color Regular Price Savings After Savings
LSWC307ST Stainless Steel $4069.00 $1,070.00 $2,999.00
LG AppliancesLG STUDIO 4.7 cu. ft. Smart wi-fi Enabled Double Built-In Wall Oven

Add To Compare

LG Appliances LG STUDIO 4.7 cu. ft. Smart wi-fi Enabled Double Built-In Wall Oven

Model Color Regular Price Savings After Savings
LSWD307ST $3904.00 $1,005.00 $2,899.00
LG AppliancesLG Black Stainless Steel Series 9.4 cu. ft Total Capacity Double Wall Oven

Add To Compare

LG Appliances LG Black Stainless Steel Series 9.4 cu. ft Total Capacity Double Wall Oven

Model Color Regular Price Savings After Savings
LWD3063BD Black Stainless Steel $3299.00 $600.00 $2,699.00

Page 1 of 1
1

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