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

G-319MO - LBL Lighting - Glass Jelly Wall Mocha

G-319RD - LBL Lighting - Glass Jelly Wall Red

G-320BU - LBL Lighting - Glass Big Jelly Blue

G-320MO - LBL Lighting - Glass Big Jelly Mocha

G-320RD - LBL Lighting - Glass Big Jelly Red

G-322RE - LBL Lighting - Glass Mini-Reflex

G-323AM - LBL Lighting - Glass, Flare Amber

G-323BU - LBL Lighting - Glass, Flare Blue

G-323CR - LBL Lighting - Glass, Flare Clear

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

G-325AM - LBL Lighting - Glass Mini-Dome I Amber

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-325FR - LBL Lighting - Glass Mini-Dome I Frost

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-338MO - LBL Lighting - Glass Mini-Monty Mocha

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-378OP - LBL Lighting - Glass Lily Opal

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

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