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

Specialty

Arrange By

Narrow By

Brand

Features

Width

Height

Depth

Price

60 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 'WLYEN8A39IF2ZLG63OMBX'	
								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
WUW35X15DS
$720.00
Whirlpool
WUW35X24DS
$900.00
Whirlpool
WUR50X24EM
$989.00
Whirlpool
WUW55X15DS
$990.00
Whirlpool
WUB50X24EM
$1,080.00
Whirlpool
WUW55X24DS
$1,170.00
KitchenAid
KURR104EPA
$1,530.00
KitchenAid
KURR104EPA
$1,530.00
KitchenAid
KURR104ESB
$1,619.00
KitchenAid
KURR104ESB
$1,619.00
KitchenAid
KURL104ESB
$1,620.00
KitchenAid
KURL104ESB
$1,620.00
KitchenAid
KUBL204EPA
$1,665.00
KitchenAid
KUBR204EPA
$1,665.00
KitchenAid
KUBR204EPA
$1,665.00
KitchenAid
KUBL204EPA
$1,665.00
KitchenAid
KURL104EPA
$1,699.00
KitchenAid
KURL104EPA
$1,699.00
KitchenAid
KUBL204ESB
$1,755.00
KitchenAid
KUBL204ESB
$1,755.00
KitchenAid
KUBR204ESB
$1,755.00
KitchenAid
KUBR204ESB
$1,755.00
KitchenAid
KUWR204EPA
$1,755.00
KitchenAid
KUWR204EPA
$1,755.00
KitchenAid
KUWL204EPA
$1,755.00
KitchenAid
KUWL204EPA
$1,755.00
KitchenAid
KURR204ESB
$1,755.00
KitchenAid
KURR204ESB
$1,755.00
KitchenAid
KURL204ESB
$1,755.00
KitchenAid
KURL204ESB
$1,755.00
KitchenAid
KURL304ESS
$1,890.00
KitchenAid
KURR304ESS
$1,890.00
KitchenAid
KURR304ESS
$1,890.00
KitchenAid
KURL304ESS
$1,890.00
KitchenAid
KUWR204ESB
$1,890.00
KitchenAid
KUWR204ESB
$1,890.00
KitchenAid
KUWL204ESB
$1,890.00
KitchenAid
KUWL204ESB
$1,890.00
KitchenAid
KUBR304ESS
$1,980.00
KitchenAid
KUBR304ESS
$1,980.00
KitchenAid
KUWR304ESS
$1,980.00
KitchenAid
KUWR304ESS
$1,980.00
KitchenAid
KURL304EBS
$1,980.00
KitchenAid
KURR304EBS
$1,980.00
KitchenAid
KUWL304ESS
$1,980.00
KitchenAid
KUWL304ESS
$1,980.00
KitchenAid
KUBL304EBS
$2,070.00
KitchenAid
KUBR304EBS
$2,070.00
Catalog Loader
Loading More Items
Back To Top Button

Specialty