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

Single Wall Ovens

Arrange By

Narrow By

Brand

Features

Width

Height

Depth

Collection

Price

150 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 'DZ3KYBZAS48SSG5NPXDZF'	
								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
Thermador
MBES
$699.00
Frigidaire
FFEW2725PB
$764.00
Frigidaire
FFEW2725PW
$764.00
Frigidaire
FFEW2725PS
$854.00
Whirlpool
WOS11EM4EB
$854.00
Whirlpool
WOS11EM4EW
$854.00
GE
JRS06BJBB
$899.00
GE
JT1000DFBB
$899.00
Thermador
MCES
$899.00
GE
JK3000SFSS
$948.00
GE
JT3000SFSS
$948.00
Whirlpool
WOS51EC7AS
$949.00
Whirlpool
WOS51EC0AS
$949.00
GE
JRS06SKSS
$989.00
Whirlpool
WOS51EC7AB
$989.00
Whirlpool
WOS51EC7AW
$989.00
Whirlpool
WOS51EC0AB
$989.00
GE
JK3000DFBB
$1,079.00
GE
JK3000DFWW
$1,079.00
GE
JT1000SFSS
$1,079.00
GE
JT3000DFBB
$1,079.00
GE
JT3000DFWW
$1,079.00
Whirlpool
WOS51ES4EB
$1,169.00
Whirlpool
WOS51ES4EW
$1,169.00
Frigidaire Gallery
FGEW2765PB
$1,214.00
GE
JRP20WJWW
$1,259.00
GE
JRP20BJBB
$1,259.00
Whirlpool
WOS92EC0AS
$1,274.00
GE
JK5000SFSS
$1,298.00
GE
JT5000SFSS
$1,298.00
Whirlpool
WOS51ES4ES
$1,349.00
Whirlpool
WOS92EC0AB
$1,394.00
Whirlpool
WOS92EC7AB
$1,394.00
GE
JRP20SKSS
$1,439.00
GE
JRP28BJBB
$1,484.00
Whirlpool
WOS92EC0AE
$1,484.00
Whirlpool
WOS92EC0AH
$1,484.00
GE
JK3500SFSS
$1,498.00
GE
JT3500SFSS
$1,498.00
Bosch
HBL5351UC
$1,529.00
GE
JK5000DFBB
$1,529.00
GE
JT5000DFBB
$1,529.00
GE
JRP28SKSS
$1,664.00
GE
JK3500DFWW
$1,709.00
GE
JK3500DFBB
$1,709.00
GE
JT3500DFBB
$1,709.00
GE
PK7000SFSS
$1,798.00
GE
PT7050EHES
$1,798.00
Catalog Loader
Loading More Items
Back To Top Button

Single Wall Ovens