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-364am' and catalogpartcode <= 'g-462br' order by ref_product.catalogpartcode,ref_product.id ;

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

G-395AM - LBL Lighting - Glass Encalmo I White/Amber

G-395BU - LBL Lighting - Glass Encalmo I White/Blue

G-396AM - LBL Lighting - Glass Encalmo Ii White/Amber

G-396BU - LBL Lighting - Glass Encalmo Ii White/Blue

G-396CL - LBL Lighting - Glass Encalmo Ii White/Clear

G-398AM - LBL Lighting - Glass Wilt Bowl Amber

G-402BR - LBL Lighting - Glass, Allie Brown

G-402CR - LBL Lighting - Glass, Allie Clear

G-402GR - LBL Lighting - Glass, Allie Green

G-404BR - LBL Lighting - Glass Buttercup Brown

G-404CR - LBL Lighting - Glass Buttercup Clear

G-404GR - LBL Lighting - Glass Buttercup Green

G-405RD - LBL Lighting - Glass Storm Brown

G-406BR - LBL Lighting - Glass Dollop Brown

G-406CR - LBL Lighting - Glass Dollop Clear

G-406GR - LBL Lighting - Glass Dollop Olive Green

G-409AM - LBL Lighting - Glass Monna Amber

G-409BL - LBL Lighting - Glass Monna Blue

G-409OP - LBL Lighting - Glass Monna Opal

G-409RD - LBL Lighting - Glass Monna Red

G-413BR - LBL Lighting - Glass Buttercup Brown

G-413CR - LBL Lighting - Glass Buttercup Clear

G-413GR - LBL Lighting - Glass Buttercup Green

G-427AM - LBL Lighting - GLASS, ANELLO BOWL GRNDE AMBER

G-427OP - LBL Lighting - GLASS, ANELLO BOWL GRNDE OPAL

G-433ALAB - LBL Lighting - Glass Hemisphere Alabaster

G-433OPN - LBL Lighting - Glass Hemisphere Opal

G-435AM - LBL Lighting - Glass Flora Wall Amber

G-435BR - LBL Lighting - Glass Flora Wall Brown

G-435OP - LBL Lighting - Glass Flora Wall Opal

G-436ALAB - LBL Lighting - Glass Hemisphere Gran Alabastr

G-436OPN - LBL Lighting - Glass Hemisphere Gran Opal

G-445AM - LBL Lighting - Glass, Jasmine Dark Amber

G-445BL - LBL Lighting - Glass, Jasmine Black

G-445OP - LBL Lighting - Glass, Jasmine Opal

G-445RD - LBL Lighting - Glass, Jasmine Red

G-446AM - LBL Lighting - Glass, Finestra Amber

G-446BL - LBL Lighting - Glass Finestra Black

G-447CR - LBL Lighting - Glass Bling

G-448BU - LBL Lighting - Glass, Morsel Blue Green

G-448OP - LBL Lighting - Glass, Morsel Opal

G-448RD - LBL Lighting - Glass, Morsel Red Amber

G-448TO - LBL Lighting - Glass, Morsel Tortoise

G-449AM - LBL Lighting - GLASS, ANELLO BOWL AMBER

G-449OP - LBL Lighting - GLASS, ANELLO BOWL OPAL

G-451ON - LBL Lighting - Glass Onyx Cone

G-452AM - LBL Lighting - Shade, Flurry Oatmeal

G-452GR - LBL Lighting - Shade, Flurry Green

G-452OP - LBL Lighting - Shade, Flurry Opal

G-457RU - LBL Lighting - Glass, Accent Flower, Rust

G-459AMPR - LBL Lighting - Glass, Abbey Amber Purple

G-459AMRD - LBL Lighting - Glass, Abbey Amber Red

G-4601BU - LBL Lighting - Glass Teardrop Wall Blue

G-4605AM - LBL Lighting - Glass Hannah Wall Amber

G-4605BU - LBL Lighting - Glass Hannah Wall Blue

G-461AM - LBL Lighting - Glass Bonn Amber

G-461BR - LBL Lighting - Glass Bonn Brown

G-461CR - LBL Lighting - Glass Bonn Clear

G-462AM - LBL Lighting - Glass, Cypree Lg Pendant Amber

G-462BR - LBL Lighting - Glass, Cypree Lg Pendant Brown

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