Park Home - Shop Furniture, Appliances, Mattresses in PA
Park Home Tagline
Phone Icon

Welcome to

Welcome to Park Home


Get updates on our latest styles & savings!

We will never sell your information. Opt-Out anytime. Offer valid for new email addresses only. See store for details.

No Thanks

Cooktops

Arrange By

Narrow By

Brand

Features

Width

Height

Depth

Collection

Price

296 Items
SELECT f.u_id, 
									f.id,
									IF(f.display_title = '', f.title, f.display_title) AS title, 
									IF(f.retail_sku = '', f.brand_sku, f.retail_sku) AS public_sku, 
									IF(f.on_display = '1', '1', '0') AS available,						
									f.page,
									f.display_price,
									f.msrp_price,
									f.sale_price,
									f.sale_price_start,
									f.sale_price_end,
									IF(ab.display_title = '', ab.title, ab.display_title) AS b_title, 
									ac.folder AS c_f,
									a_sc.folder AS sc_f,								
									'appliances/' AS catalog_folder,
									'appliance' AS rtable
								FROM appliance AS f
								JOIN knorrweb_NEWcatalog.appliance AS ma ON f.u_id = ma.u_id  AND ma.active='1' AND ma.expired='0'
								JOIN appliance_brands AS ab ON f.brand_u_id = ab.u_id
								JOIN appliance_categories AS ac ON f.category_u_id = ac.u_id AND ac.active = 1
								JOIN appliance_categories AS a_sc ON f.sub_category_u_id = a_sc.u_id AND a_sc.active = 1 AND a_sc.u_id LIKE 'WD3AOQD227Z8O73C0DUM2'	
								WHERE f.active='1' AND f.expired='0' 
								       
								ORDER BY f.display_price = 0.00, display_price ASC, b_title ASC, title ASC
								LIMIT 0, 48
Whirlpool
WCC31430AB
$225.00
Whirlpool
WCC31430AW
$249.00
GE
JP328WKWW
$270.00
GE
JP201CBSS
$279.00
Whirlpool
WCC31430AR
$279.00
Whirlpool
W3CG3014XB
$290.00
GE
JP328BKBB
$299.00
Whirlpool
W3CG3014XS
$331.00
GE
JP328SKSS
$349.00
Frigidaire
FFEC3605LB
$359.00
Frigidaire
FFEC3605LW
$359.00
GE
JP3030DJBB
$398.00
GE
JGP329DETBB
$398.00
GE
JGP329DETWW
$398.00
Whirlpool
W5CE3024XB
$399.00
Frigidaire
FFEC3605LS
$404.00
Whirlpool
W5CE1522FB
$404.00
Maytag
MEC7430BB
$443.00
Whirlpool
WCG51US0DS
$449.00
Frigidaire
FFEC3205LS
$494.00
Frigidaire
FFEC3624PB
$494.00
Frigidaire
FFGC3010QB
$499.00
Frigidaire
FFGC3010QW
$499.00
GE
JP3030SJSS
$499.00
GE
JGP329SETSS
$499.00
GE
JP256BMBB
$539.00
Whirlpool
WCG51US0DB
$539.00
Whirlpool
WCG51US0DW
$539.00
Whirlpool
W5CE3024XS
$539.00
Frigidaire
FFEC2605LS
$549.00
Frigidaire
FFGC3010QS
$549.00
Whirlpool
WCG51US6DS
$549.00
Maytag
MGC7430DS
$554.00
GE
JP3030TJWW
$584.00
Whirlpool
W5CE3625AB
$584.00
Frigidaire
FFGC3610QW
$599.00
Frigidaire
FFGC3610QB
$599.00
GE
JGP333DETBB
$629.00
KitchenAid
KECC056RBL
$629.00
Maytag
MEC7430BS
$629.00
Maytag
MEC9530BB
$629.00
Whirlpool
WCG51US6DB
$629.00
Whirlpool
WCG51US6DW
$629.00
GE
JP3036DLBB
$630.00
Frigidaire
FFGC3610QS
$649.00
Whirlpool
G7CE3034XP
$674.00
GE
JP3036TLWW
$675.00
GE
JP5030DJBB
$698.00
Catalog Loader
Loading More Items
Back To Top Button

Cooktops