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

A/V Receivers

Arrange By

Narrow By

Brand

Features

49 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 '2K9742ZXBA8W5EV4BXIAI'		
								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
Anthem
MRX 720

See in Store

Marantz
SR5012

See in Store

Marantz
SR7011

See in Store

Marantz
SR6012

See in Store

Yamaha
RX-A1070

See in Store

Yamaha
RX-A2070

See in Store

Yamaha
RX-A3070

See in Store

Yamaha
RX-A770

See in Store

Anthem
MRX 1120
Anthem
MRX 520
Denon
HEOSAVR
Marantz
NR1508
Marantz
NR1506
Marantz
NR1608
Marantz
NR1607
Marantz
SR5011
Marantz
SR6011
Paradigm
mrx1120
Paradigm
mrx520
Paradigm
mrx720
Sony
STRDH130
Sony
STRDH550
Sony
STRDH550
Sony
STRZA3000ES
Sony
STRDN1080
Sony
STRDN1060
Sony
STRZA1000ES
Sony
STRDN1060
Sony
STRDN1070
Sony
STRDN1050
Sony
STRDN1070
Sony
STRDN860
Sony
STRDH770
Sony
STRZA2000ES
Sony
STRDN840
Sony
STRDH770
Sony
STRDH750
Sony
STRDH750
Sony
STRZA810ES
Sony
STRZA810ES
Sony
STRZA2100ES
Sony
STRZA2100ES
Sony
STRZA1100ES
Sony
STRZA1100ES
Sony
STRZA3100ES
Sony
STRZA5000ES
Yamaha
RX-A670
Catalog Loader
Loading More Items
Back To Top Button

A/V Receivers