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

72 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, 48
Paradigm
Soundscape
Paradigm
Soundtrack 2 System
Samsung
HW-H750/ZA
Samsung
HW-J250/ZA
Samsung
HW-J355/ZA
Samsung
HW-J370/ZA
Samsung
HW-J450/ZA
Samsung
HW-J470/ZA
Samsung
HW-J550/ZA
Samsung
HW-J551/ZA
Samsung
HW-J650/ZA
Samsung
WIS12ABGNX/XAA
Samsung
SSG-3570CR/ZA
Samsung
HW-J4000/ZA
Samsung
HW-J6000/ZA
Samsung
HW-J6500/ZA
Samsung
HW-J6500R/ZA
Samsung
HW-J7500/ZA
Samsung
HW-J7500R/ZA
Samsung
HW-J7501/ZA
Samsung
HW-J7501R/ZA
Samsung
HW-J8500/ZA
Samsung
HW-J8500R/ZA
Samsung
HW-K360/ZA
Samsung
HW-K370/ZA
Samsung
HW-K450/ZA
Samsung
HW-K470/ZA
Samsung
HW-K550/ZA
Samsung
HW-K650/ZA
Samsung
WAM250/ZA
Samsung
TW-J5500/ZA
Samsung
WMN3000BX/ZA
Sony
HT-CT780
Yamaha
AT-800
Catalog Loader
Loading More Items
Back To Top Button

Soundbars