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-214bu' and catalogpartcode <= 'g-298mon' order by ref_product.catalogpartcode,ref_product.id ;

G-214BU - LBL Lighting - Glass Nube 214 Blue

G-214RU - LBL Lighting - Glass Nube 214 Ruggine

G-217AN - LBL Lighting - Glass Nube 217 Antique

G-217BU - LBL Lighting - Glass Nube 217 Blue

G-219AP - LBL Lighting - Glass Mango Apricot

G-219BU - LBL Lighting - Glass Mango Blue

G-219OP - LBL Lighting - Glass Mango Opal

G-223AM - LBL Lighting - Glass Metro Wall Amber

G-223BU - LBL Lighting - Glass Metro Wall Blue

G-223OP - LBL Lighting - Glass Metro Wall Opal

G-229OP - LBL Lighting - Glass Juniper Suspension Opal

G-230OP - LBL Lighting - Glass Juniper Wall Opal

G-232AM - LBL Lighting - Tear Cased Amber

G-232BU - LBL Lighting - Tear Cased Blue

G-232RD - LBL Lighting - Tear Cased Red

G-234 - LBL Lighting - Glass Top-Si Inner Frost

G-235AM - LBL Lighting - Glass Vortex Amber

G-236CO - LBL Lighting - Glass Alaya Clear/Opal

G-240AM - LBL Lighting - Glass Top-Si Outer Amber

G-240BU - LBL Lighting - Glass Top-Si Outer Blue

G-240CR - LBL Lighting - Glass Top-Si Outer Clear

G-241AM - LBL Lighting - Glass Tear-Si Outer Amber

G-241BU - LBL Lighting - Glass Tear-Si Outer Blue

G-241CR - LBL Lighting - Glass Tear-Si Outer Clear

G-241RD - LBL Lighting - Glass Tear-Si Outer Red

G-242OP - LBL Lighting - Glass Tear-Sii Inner Opal

G-242RD - LBL Lighting - Tear Cased Red 1517 3.5

G-244BU - LBL Lighting - Glass Dome-Sii Blue

G-245AM - LBL Lighting - Glass Dome-Si Amber Outer

G-245BU - LBL Lighting - Glass Dome-Si Blue Outer

G-245RD - LBL Lighting - Glass Dome-Si Red Outer

G-246CL - LBL Lighting - Glass Dome-Si Clearl Outer

G-247AM - LBL Lighting - Glass Dome-Sii Amber

G-247BU - LBL Lighting - Glass Dome-Sii Blue

G-247OP - LBL Lighting - Glass Dome-Sii Opal

G-249AM - LBL Lighting - Glass Maraca-Si Amber

G-249BU - LBL Lighting - Glass Maraca-Si Blue

G-249MO - LBL Lighting - Glass Maraca-Si Mocha

G-249OP - LBL Lighting - Glass Maraca-Si Opal

G-249RD - LBL Lighting - Glass Maraca-Si Red

G-252BL - LBL Lighting - Glass Tear-Sii Black

G-261CR - LBL Lighting - Glass Rocks Clear

G-262FR - LBL Lighting - Glass Gracie Frost

G-264AM - LBL Lighting - Glass Crystal Ball Amber

G-264BU - LBL Lighting - Glass Crystal Ball Blue

G-264PK - LBL Lighting - Glass Crystal Ball Pink

G-264RD - LBL Lighting - Glass Crystal Ball Red

G-266BU - LBL Lighting - Glass Sophia Blue

G-266CR - LBL Lighting - Glass Sophia Clear

G-267AM - LBL Lighting - Glass Caroline Amber

G-267BU - LBL Lighting - Glass Caroline Blue

G-267OP - LBL Lighting - Glass Caroline Opal

G-267PK - LBL Lighting - Glass Caroline Pink

G-268PR - LBL Lighting - Glass Madeleine Purple

G-268TO - LBL Lighting - Glass Madeleine Tortoise

G-269AM - LBL Lighting - Glass Stogie I Amber

G-269BU - LBL Lighting - Glass Stogie I Blue

G-270AM - LBL Lighting - Glass Stogie Ii Amber

G-270BU - LBL Lighting - Glass Stogie Ii Blue

G-270OP - LBL Lighting - Glass Stogie Ii Opal

G-270RD - LBL Lighting - Glass Stogie Ii Red

G-272FR - LBL Lighting - Glass Poppy Frost

G-275AM - LBL Lighting - Glass Mini-Dome Ii Amber

G-275BU - LBL Lighting - Glass Mini-Dome Ii Blue

G-277AM - LBL Lighting - Glass Icicle Amber (277 Volt)

G-277BU - LBL Lighting - Glass Icicle Blue (277 Volt)

G-279FR - LBL Lighting - Glass Tubular Frost

G-280CR - LBL Lighting - Glass Ufo Clear

G-281RE - LBL Lighting - Glass Reflex

G-283OP - LBL Lighting - Glass Renee I Opal

G-284AM - LBL Lighting - Glass Spencer Amber

G-284BU - LBL Lighting - Glass Spencer Blue

G-284CR - LBL Lighting - Glass Spencer Clear

G-285AM - LBL Lighting - Glass Cube Amber

G-285BU - LBL Lighting - Glass Cube Blue

G-285FR - LBL Lighting - Glass Cube Frost

G-286AM - LBL Lighting - Glass Wired I Pend Amber

G-286BU - LBL Lighting - Glass Wired I Pend Blue

G-286CR - LBL Lighting - Glass Wired I Pend Clear

G-298MON - LBL Lighting - Glass Mango Nuage Mocha

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