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

Home Theater Systems

Arrange By

Narrow By

Brand

Features

61 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 'V38W9XMY887MWRSE2Y1L2'		
								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
Datasat
LS10
Datasat
RS20i
Definitive Technology
MGstand
Definitive Technology
ProCinema 1000 System
Definitive Technology
ProCinema 400 System
Definitive Technology
ProCinema 600 System
Definitive Technology
ProCinema 800 System
Definitive Technology
SoloCinema Studio
Definitive Technology
SoloCinema XTR
Definitive Technology
wstudiom
Sony
BDVN5200W
Sony
BDVE3100
Sony
BDVN5200W
Sony
BDVE2100
Sony
DAVTZ140
Triad
CINEMALCR2
Triad
CINEMAREFSURR2
Triad
INCEILINGBRONZEATMOS
Triad
INCEILINGGOLDMINI
Triad
INCEILINGMINI8
Triad
INCEILINGSILVERMON6
Triad
INROOMBRONZEATMOS
Triad
INROOMBRONZECENTER
Triad
INROOMBRONZEHEIGHTATMOS
Triad
INROOMBRONZELCR
Triad
INROOMBRONZELR-H
Triad
INROOMGOLDCENT
Triad
INROOMGOLDLCR
Triad
INROOMGOLDMINI
Triad
INROOMGOLDMON
Triad
INROOMPLATCENT
Triad
INROOMPLATLCR
Triad
INROOMSILVERCENTER
Triad
INROOMSILVERHEIGHTATMOS
Triad
INROOMSILVERLCR
Triad
INROOMSILVERLR-H
Triad
INROOMSILMINIMON
Triad
INROOMSILVERMON
Triad
INWALLBRONZE4
Triad
INWALLBRONZE4SURRO
Triad
INWALLGOLDSURR
Triad
INWALLGOLDLCR6
Triad
INWALLGOLDMINI
Triad
INWALLGOLDMON
Triad
INWALLSILVER4
Triad
INWALLSILMINIMON
Catalog Loader
Loading More Items
Back To Top Button

Home Theater Systems