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

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

G-245CL - LBL Lighting - Glass Dome-Si Clear 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-269RD - LBL Lighting - Glass Stogie I Red

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-277CR - LBL Lighting - Glass Icicle Clear (277 Volt)

G-277OP - LBL Lighting - Glass Icicle Opal (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

G-298OPN - LBL Lighting - Glass Mango Nuage Opal

G-298RDN - LBL Lighting - Glass Mango Nuage Red

G-300FR - LBL Lighting - Glass Merlino Frost

G-301OP - LBL Lighting - Glass Renee Ii Suspension

G-303SAM - LBL Lighting - Glass Wired Ii Susp Amber

G-303SBU - LBL Lighting - Glass Wired Ii Susp Blue

G-303SCR - LBL Lighting - Glass Wired Ii Susp Clear

G-303W-AM - LBL Lighting - Glass Wired Wall Amber

G-303W-BU - LBL Lighting - Glass Wired Wall Blue

G-303W-CR - LBL Lighting - Glass Wired Wall Clear

G-305TO - LBL Lighting - Glass Lava I Tortoise

G-306IW - LBL Lighting - Glass Clay I Ivory White

G-306TG - LBL Lighting - Glass Clay I Terra Gray

G-306WB - LBL Lighting - Glass Clay I Wenge Brown

G-307IW - LBL Lighting - Glass Clay Ii Ivory White

G-307TG - LBL Lighting - Glass Clay Ii Terra Gray

G-307WB - LBL Lighting - Glass Clay Ii Wenge Brown

G-308BW - LBL Lighting - Glass Zebra Black

G-309TO - LBL Lighting - Glass Lava Ii Tortoise

G-310OP - LBL Lighting - Glass Casino Opal

G-317MO - LBL Lighting - Glass Veneto Mocha

G-317OP - LBL Lighting - Glass Veneto Opal

G-318AM - LBL Lighting - Glass Veneto Grande Amber

G-318OP - LBL Lighting - Glass Veneto Grande Opal

G-319BU - LBL Lighting - Glass Jelly Wall Blue

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