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

47 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
Yamaha
CD-C600
Yamaha
CD-S300
Yamaha
CRX-N560
Yamaha
HTR-3068
Yamaha
NP-S2000
Yamaha
R-N301
Yamaha
R-N500
Yamaha
R-N602
Yamaha
R-S201
Yamaha
R-S202
Yamaha
R-S300
Yamaha
R-S500
Yamaha
R-S700
Yamaha
RX-A1040
Yamaha
RX-A1050
Yamaha
RX-A2030
Yamaha
RX-A2040
Yamaha
RX-A2050
Yamaha
RX-A3040
Yamaha
RX-A3050
Yamaha
RX-A550
Yamaha
RX-A740
Yamaha
RX-A750
Yamaha
RX-A840
Yamaha
RX-A850
Yamaha
RX-S600
Yamaha
RX-S601
Yamaha
RX-V377
Yamaha
RX-V379
Yamaha
RX-V381
Yamaha
RX-V477
Yamaha
RX-V479
Yamaha
RX-V481
Yamaha
RX-V577
Yamaha
RX-V579
Yamaha
RX-V581
Yamaha
RX-V677
Yamaha
RX-V679
Yamaha
RX-V681
Yamaha
RX-V777BT
Yamaha
RX-V779
Yamaha
RX-V781
Yamaha
T-S500
Yamaha
TSR-5790BL
Yamaha
TSR-7790BL
Yamaha
YHT-4910U
Showing All Items For This Category
Catalog Loader
Loading More Items
Back To Top Button

A/V Receivers