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

Warming Drawers

Arrange By

Narrow By

Brand

Features

Width

Height

Depth

Price

18 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 '0I4A9ZSD9ML3Q3FMPCNY2'	
								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
Bosch
HWD5751UC
$944.00
Bosch
HWD5051UC
$989.00
KitchenAid
KOWT104ESS
$1,079.00
KitchenAid
KOWT107ESS
$1,214.00
KitchenAid
KOWT100ESS
$1,214.00
KitchenAid
KEWS175BPA
$1,249.00
KitchenAid
KEWS105BPA
$1,249.00
Thermador
WD30JS
$1,399.00
Thermador
WD30JP
$1,499.00
Thermador
WDC30J
$1,549.00
Thermador
WDC30JS
$1,879.00
Thermador
WDC30JP
$1,929.00
Bosch
HSD5051UC
Thermador
WDC36J
Thermador
WDC36JP
Thermador
WD27JS
Showing All Items For This Category
Catalog Loader
Loading More Items
Back To Top Button

Warming Drawers