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

G-172RD - LBL Lighting - Glass Aurora Red

G-173AM - LBL Lighting - Glass Piattini Amber

G-173CR - LBL Lighting - Glass Piattini Clear

G-174 - LBL Lighting - Glass Annie Amber

G-175MO - LBL Lighting - Glass Big Mango Mocha

G-175OP - LBL Lighting - Glass Big Mango Opal

G-175PR - LBL Lighting - Glass Big Mango Purple

G-175RD - LBL Lighting - Glass Big Mango Red

G-176ON - LBL Lighting - Glass Onyx Cylinder

G-176ON - Tech Lighting - Onyx Cylinder

G-176ONL - Tech Lighting - Cabo Grande - Honey Onyx - Replacement Component

G-177ON - LBL Lighting - Glass Onyx Dome

G-178ON - LBL Lighting - Glass Onyx Teardrop

G-179AM - LBL Lighting - Glass Wilt Amber

G-179FR - LBL Lighting - Glass Wilt Frost

G-180AM - LBL Lighting - Glass Belle Amber

G-180MC - LBL Lighting - Glass Belle Multi-Color

G-180OP - LBL Lighting - Glass Belle Opal

G-180RD - LBL Lighting - Glass Belle Red

G-182AM - LBL Lighting - Glass Brandy Amber Frit

G-182BU - LBL Lighting - Glass Brandy Blue Frit

G-182OP - LBL Lighting - Glass Brandy Opal

G-185MO - LBL Lighting - Glass Big Cuttle Mocha

G-186AM - LBL Lighting - Glass Pyramid Amber

G-186BU - LBL Lighting - Glass Pyramid Blue

G-186FR - LBL Lighting - Glass Pyramid Frost

G-186PR - LBL Lighting - Glass Pyramid Purple

G-187MO - LBL Lighting - Glass M2 Mocha

G-187OP - LBL Lighting - Glass M2 Opal

G-190MON - LBL Lighting - Glass Spin Mocha

G-190OPN - LBL Lighting - Glass Spin Opal

G-190RDN - LBL Lighting - Glass Spin Red

G-191MON - LBL Lighting - Glass Spin Grande Mocha

G-191OPN - LBL Lighting - Glass Spin Grande Opal

G-191RDN - LBL Lighting - Glass Spin Grande Red

G-191TO - LBL Lighting - Glass Spin Grande Tortoise

G-194AM - LBL Lighting - Flute Glass Amber

G-197AM - LBL Lighting - Glass Drizzle Amber

G-197BU - LBL Lighting - Glass Drizzle Blue

G-197CR - LBL Lighting - Glass Drizzle Clear

G-197RB - LBL Lighting - Glass Drizzle Burgundy

G-197RD - LBL Lighting - Glass Drizzle Red

G-200AM - LBL Lighting - Glass Ursula Amber

G-200BU - LBL Lighting - Glass Ursula Blue

G-200PR - LBL Lighting - Glass Ursula Purple

G-200RD - LBL Lighting - Glass Ursula Red

G-202MC - LBL Lighting - Glass Confetti Multicolor

G-214 - LBL Lighting - Glass Nube 214 Frost

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-235BU - LBL Lighting - Glass Vortex Blue

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-240OP - LBL Lighting - Glass Top-Si Outer Opal (CFL - only)

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-242AM - LBL Lighting - Tear Cased Amber 1517 3.

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

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