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

Soundbars

Arrange By

Narrow By

Brand

Features

67 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.brand_sku,
									f.brand_u_id,
									f.page,
									f.display_price,
									f.msrp_price,
									f.sale_price,
									f.sale_price_start,
									f.sale_price_end,
									f.screen_size,
									IF(fb.display_title = '', fb.title, fb.display_title) AS b_title, 
									fb.title AS origTitle,
									fc.folder AS c_f,
									fsc.folder AS sc_f,
									'electronics/' AS catalog_folder,
									'electronics' AS rtable
								FROM electronics AS f
								JOIN knorrweb_NEWcatalog.electronics AS mf ON f.u_id = mf.u_id AND mf.expired = 0 AND mf.group_item = 0
								JOIN electronics_brands AS fb ON f.brand_u_id = fb.u_id
								JOIN electronics_categories AS fc ON f.category_u_id = fc.u_id AND fc.active = 1
								JOIN electronics_categories AS fsc ON f.sub_category_u_id = fsc.u_id AND fsc.active = 1 AND fsc.u_id LIKE '5P5AUE51IV97JY84JOR9U'		
								WHERE f.active='1' AND f.expired='0'      
								GROUP BY u_id
								ORDER BY available DESC, available DESC, b_title ASC, title ASC
								LIMIT 0, 15
Bose
solo5tv

See in Store

Bose
soundtouch300

See in Store

Bose
SoundTouch300SB

See in Store

Definitive Technology
SSA-42

See in Store

Denon
heosbar

See in Store

LG
LAB540W

See in Store

Yamaha
ATS-1050

See in Store

Yamaha
YAS-203

See in Store

Yamaha
YAS-706

See in Store

Yamaha
YSP-1600

See in Store

Definitive Technology
xtr-60
Definitive Technology
mythosxtrssa3
Definitive Technology
XTR-SSA5
Definitive Technology
wstudio
Catalog Loader
Loading More Items
Back To Top Button

Soundbars