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-240am' and catalogpartcode <= 'g-307wb' order by ref_product.catalogpartcode,ref_product.id ;

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-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

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