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 >= 'g-323rd' and catalogpartcode <= 'g-405rd' order by ref_product.catalogpartcode,ref_product.id ;

G-323RD - LBL Lighting - Glass, Flare Red

G-325BL - LBL Lighting - Glass Mini-Dome I Black

G-325BU - LBL Lighting - Glass Mini-Dome I Blue

G-325CR - LBL Lighting - Glass Mini-Dome I Clear

G-325RD - LBL Lighting - Glass Mini-Dome I Rose

G-326AM - LBL Lighting - Glass Leo Amber

G-330BU - LBL Lighting - Glass Bellboy Blue

G-330PR - LBL Lighting - Glass Bellboy Purple

G-330RD - LBL Lighting - Glass Bellboy Red

G-331-INBORO - LBL Lighting - Cone Ii Inner Glass

G-331BG - LBL Lighting - Glass Cone I/Ii Outer Blue-Grn

G-331MC - LBL Lighting - Glass Cone/I/Ii Outer Multiclr

G-331PB - LBL Lighting - Glass Cone/I/Ii Outer Purp-Blu

G-332BS - LBL Lighting - Glass Daisy Blue Silver

G-332PG - LBL Lighting - Glass Daisy Pink Gold

G-336AB - LBL Lighting - Glass Vision Prismatic

G-336BU - LBL Lighting - Glass Vision Blue

G-336GR - LBL Lighting - Glass Vision Green

G-336PR - LBL Lighting - Glass Vision Lavender

G-336RD - LBL Lighting - Glass Vision Bordeaux

G-338RD - LBL Lighting - Glass Mini-Monty Red

G-343OPL - LBL Lighting - Glass Twist Opal

G-344OP - LBL Lighting - Glass Big Twist Opal

G-348BU - LBL Lighting - Glass Bulle Blue

G-348CR - LBL Lighting - Glass Bulle Clear

G-349AM - LBL Lighting - Glass Paperweight Amber

G-349OP - LBL Lighting - Glass Paperweight Opal

G-350AM - LBL Lighting - Glass Mini-Stogie Ii Amber

G-350BU - LBL Lighting - Glass Mini-Stogie Ii Blue

G-350OP - LBL Lighting - Glass Mini-Stogie Ii Opal

G-350RD - LBL Lighting - Glass Mini-Stogie Ii Red

G-351BU - LBL Lighting - Glass Cone Iii Blue

G-351OP - LBL Lighting - Glass Cone Iii Opal

G-352AM - LBL Lighting - Glass Calla Amber

G-352BU - LBL Lighting - Glass Calla Blue

G-352OP - LBL Lighting - Glass Calla Opal

G-352PK - LBL Lighting - Glass Calla Pink

G-353BU - LBL Lighting - Glass Madeleine Swvl Blue

G-353PR - LBL Lighting - Glass Madeleine Swvl Purple

G-353RD - LBL Lighting - Glass Madeleine Swvl Red

G-353TO - LBL Lighting - Glass Madeleine Swvl Tortoise

G-358BRE - LBL Lighting - Glass Mini-Reflex Black

G-359AM - LBL Lighting - Glass Mini-Wilt Amber

G-359FR - LBL Lighting - Glass Mini-Wilt Frost

G-360AM - LBL Lighting - Glass S-I Gran Tetra Amber

G-360BU - LBL Lighting - Glass S-I Gran Tetra Blue

G-360OP - LBL Lighting - Glass S-I Gran Tetra Opal

G-364AM - LBL Lighting - Glass Veneto Wall Amber

G-364MO - LBL Lighting - Glass Veneto Wall Mocha

G-364OP - LBL Lighting - Glass Veneto Wall Opal

G-364RD - LBL Lighting - Glass Veneto Wall Red

G-367AM - LBL Lighting - Glass Veneto Grande Wall Amber

G-367MO - LBL Lighting - Glass Veneto Grande Wall Mocha

G-367OP - LBL Lighting - Glass Veneto Grande Wall Opal

G-367RD - LBL Lighting - Glass Veneto Grande Wall Red

G-371BU - LBL Lighting - Glass Neptune Blue

G-371RD - LBL Lighting - Glass Neptune I Wall Red

G-377AM - LBL Lighting - Glass Flow Amber

G-3783AM - LBL Lighting - Glass Tulip Amber

G-3783BU - LBL Lighting - Glass Tulip Blue

G-3783OP - LBL Lighting - Glass Tulip Opal

G-378AM - LBL Lighting - Glass Lily Amber

G-378BL - LBL Lighting - Glass Lily Black

G-378OR - LBL Lighting - Glass Lily Orange

G-378RD - LBL Lighting - Glass Lily Red

G-379OP - LBL Lighting - Glass Mini-Veneto Opal

G-379RD - LBL Lighting - Glass Mini-Veneto Red

G-395AM - LBL Lighting - Glass Encalmo I White/Amber

G-395BU - LBL Lighting - Glass Encalmo I White/Blue

G-396AM - LBL Lighting - Glass Encalmo Ii White/Amber

G-396BU - LBL Lighting - Glass Encalmo Ii White/Blue

G-396CL - LBL Lighting - Glass Encalmo Ii White/Clear

G-398AM - LBL Lighting - Glass Wilt Bowl Amber

G-402BR - LBL Lighting - Glass, Allie Brown

G-402CR - LBL Lighting - Glass, Allie Clear

G-402GR - LBL Lighting - Glass, Allie Green

G-404BR - LBL Lighting - Glass Buttercup Brown

G-404CR - LBL Lighting - Glass Buttercup Clear

G-404GR - LBL Lighting - Glass Buttercup Green

G-405RD - LBL Lighting - Glass Storm Brown

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