If you find a better price, we'll beat it...even after delivery.
Applies to most orders. Click for details...
The WAC Lighting Shop does not collect sales tax in 49 states.

SQL MAIN=
SELECT distinct(ref_product.id),ref_product.catalogpartcode,date(lastedited) as 'ledate',imageurl,entrytype,upc FROM ref_product WHERE ref_product.EntryType IN('basepart','bundle','kit') AND ref_product.active='1' AND ref_product.manufacturerid IN(select id from lslocal.site_manufacturers where active='1') and catalogpartcode >= '290firegigz-cf' and catalogpartcode <= '290giamrr6sks-led840' order by ref_product.catalogpartcode,ref_product.id ;

290FIREGIGZ-CF - Tech Lighting - Fire Grande - Fire Grande-Cf Inner Glass Brz

290FIRFAB - Tech Lighting - Firefrost - Amber - Replacement Component

290FIRFBL - Tech Lighting - Firefrost - Cobalt - Replacement Component

290FIRFCT - Tech Lighting - Firefrost - Chartreuse - Replacement Component

290FIRFGR - Tech Lighting - Firefrost - Green - Replacement Component

290FIRFRD - Tech Lighting - Firefrost - Red - Replacement Component

290FIRFWH - Tech Lighting - Firefrost - White - Replacement Component

290FIROABC - Tech Lighting - Fire - Outer Amber - Replacement Component

290FIROABS - Tech Lighting - Fire - Outer Amber - Replacement Component

290FIROABZ - Tech Lighting - Fire - Outer Amber - Replacement Component

290FIROBBC - Tech Lighting - Firebird - Outer Bluebird - Replacement Component

290FIROBBS - Tech Lighting - Firebird - Outer Bluebird - Replacement Component

290FIROBBZ - Tech Lighting - Firebird - Outer Bluebird - Replacement Component

290FIROBLC - Tech Lighting - Fire - Outer Cobalt - Replacement Component

290FIROBLS - Tech Lighting - Fire - Outer Cobalt - Replacement Component

290FIROBLZ - Tech Lighting - Fire - Outer Cobalt - Replacement Component

290FIROCDC - Tech Lighting - Firebird - Outer Cardinal - Replacement Component

290FIROCDS - Tech Lighting - Firebird - Outer Cardinal - Replacement Component

290FIROGRC - Tech Lighting - Fire - Outer Green - Replacement Component

290FIROGRS - Tech Lighting - Fire - Outer Green - Replacement Component

290FIROGRZ - Tech Lighting - Fire - Outer Green - Replacement Component

290FIROHNC - Tech Lighting - Fire - Outer Havana Brown - Replacement Component

290FIROHNS - Tech Lighting - Fire - Outer Havana Brown - Replacement Component

290FIROHNZ - Tech Lighting - Fire - Outer Havana Brown - Replacement Component

290FIROPEC - Tech Lighting - Outer Peacock

290FIROPES - Tech Lighting - Outer Peacock

290FIROPEZ - Tech Lighting - Outer Peacock

290FIRORDC - Tech Lighting - Firebird - Outer Peacock - Replacement Component

290FIRORDS - Tech Lighting - Firebird - Outer Peacock - Replacement Component

290FIRORDZ - Tech Lighting - Firebird - Outer Peacock - Replacement Component

290FIROSAC - Tech Lighting - Firebird - Outer Swan - Replacement Component

290FIROSAS - Tech Lighting - Firebird - Outer Swan - Replacement Component

290FIROSAZ - Tech Lighting - Firebird - Outer Swan - Replacement Component

290FIROSMC - Tech Lighting - Fire - Outer Smoke - Replacement Component

290FIROSMS - Tech Lighting - Fire - Outer Smoke - Replacement Component

290FIROSMZ - Tech Lighting - Fire - Outer Smoke - Replacement Component

290FIROSUC - Tech Lighting - Fire - Outer Steel Blue - Replacement Component

290FIROSUS - Tech Lighting - Fire - Outer Steel Blue - Replacement Component

290FIROSUZ - Tech Lighting - Fire - Outer Steel Blue - Replacement Component

290FIROVGC - Tech Lighting - Fire - Outer Olive Green - Replacement Component

290FIRYAM - Tech Lighting - Firefrit - Amber - Replacement Component

290FIRYML - Tech Lighting - Firefrit - Multicolor - Replacement Component

290FJMESAG - Tech Lighting - Freejack - Mini Amb Gd - Replacement Component

290FJMESAS - Tech Lighting - Freejack - Mini Amb Sn - Replacement Component

290FJMESBC - Tech Lighting - Freejack - Mini Blu Ch - Replacement Component

290FJMESBG - Tech Lighting - Freejack - Mini Blu Gd - Replacement Component

290FJMESBS - Tech Lighting - Freejack - Mini Blu Sn - Replacement Component

290FJMESBZ - Tech Lighting - Freejack - Mini Blu Bz - Replacement Component

290FJMESMC - Tech Lighting - Freejack - Mini Mlt Ch - Replacement Component

290FJMESMG - Tech Lighting - Freejack - Mini Mlt Gd - Replacement Component

290FJMESMS - Tech Lighting - Freejack - Mini Mlt Sn - Replacement Component

290FJMESMZ - Tech Lighting - Freejack - Mini Mlt Bz - Replacement Component

290FJMESRC - Tech Lighting - Freejack - Mini Red Ch - Replacement Component

290FJMESRG - Tech Lighting - Freejack - Mini Red Gd - Replacement Component

290FJMESRS - Tech Lighting - Freejack - Mini Red Sn - Replacement Component

290FJMESRZ - Tech Lighting - Freejack - Mini Red Bz - Replacement Component

290FJMESWC - Tech Lighting - Freejack - Mini Wht Ch - Replacement Component

290FJMESWG - Tech Lighting - Freejack - Mini Wht Gd - Replacement Component

290FJMESWS - Tech Lighting - Freejack - Mini Wht Sn - Replacement Component

290FJMESWZ - Tech Lighting - Freejack - Mini Wht Bz - Replacement Component

290FJMESXX - Tech Lighting - GLASS, INCLUDES MACHINED TOP

290G-579OPSC - LBL Lighting - REPLACEMENT INNER GLASS SC

290GIAMRR3SCC-LED824 - Tech Lighting - GIA MRR RPL KIT 824K 300 CL CH

290GIAMRR3SCC-LED830 - Tech Lighting - GIA MRR RPL KIT 830K 300 CL CH

290GIAMRR3SCC-LED930 - Tech Lighting - GIA MRR RPL KIT 930K 300 CL CH

290GIAMRR3SCS-LED840 - Tech Lighting - GIA MRR RPL KIT 840K 300 CL SN

290GIAMRR3SCS-LED930 - Tech Lighting - Gia Mirror Replacement Kit 930K 300 Cl Sn

290GIAMRR3SKC-LED824 - Tech Lighting - GIA MRR RPL KIT 824K 300 SM CH

290GIAMRR6SCC-LED830 - Tech Lighting - Gia Mirror Replacement Kit 830K 600 Cl Ch

290GIAMRR6SCC-LED835 - Tech Lighting - Gia Mirror Replacement Kit 835K 600 Cl Ch

290GIAMRR6SCC-LED840 - Tech Lighting - GIA MRR RPL KIT 840K 600 CL CH

290GIAMRR6SCC-LED930 - Tech Lighting - Gia Mirror Replacement Kit 930K 600 Cl Ch

290GIAMRR6SCS-LED830 - Tech Lighting - Gia Mirror Replacement Kit 830K 600 Cl Sn

290GIAMRR6SCS-LED835 - Tech Lighting - GIA MRR RPL KIT 835K 600 CL SN

290GIAMRR6SCS-LED840 - Tech Lighting - GIA MRR RPL KIT 840K 600 CL SN

290GIAMRR6SCS-LED930 - Tech Lighting - GIA MRR RPL KIT 930K 600 CL SN

290GIAMRR6SKC-LED930 - Tech Lighting - GIA MRR RPL KIT 930K 600 SM CH

290GIAMRR6SKS-LED830 - Tech Lighting - Gia Mirror Replacement Kit 830K 600 Sm Sn

290GIAMRR6SKS-LED835 - Tech Lighting - GIA MRR RPL KIT 835K 600 SM SN

290GIAMRR6SKS-LED840 - Tech Lighting - Gia Mirror Replacement Kit 840K 600 Sm Sn

home|wac lighting part code list
policies and faq|my account|contact us
Copyright © 2010 - 2020 WAC Lighting Shop. All rights reserved.