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

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-459BUAMRD - LBL Lighting - Glass, Abbey Blue 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-461GR - LBL Lighting - Glass Bonn Green

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

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

G-462CR - LBL Lighting - GLASS CYPREE LG PENDANT CLEAR

G-462FR - LBL Lighting - Glass, Cypree Lg Pendant Frost

G-462GR - LBL Lighting - Glass, Cypree Lg Pendant Green

G-462PR - LBL Lighting - Glass, Cypree Lg Pend Amethyst

G-462SM - LBL Lighting - GLASS CYPREE LG PENDANT SMOKE

G-463AM - LBL Lighting - Glass, Cypree Sm Pendant Amber

G-463BR - LBL Lighting - Glass, Cypree Sm Pendant Brown

G-463FR - LBL Lighting - Glass, Cypree Sm Pendant Frost

G-463GR - LBL Lighting - Glass, Cypree Sm Pendant Green

G-463PR - LBL Lighting - Glass, Cypree Sm Pend Amethyst

G-463SM - LBL Lighting - GLASS CYPREE SM PENDANT SMOKE

G-467AM - LBL Lighting - Glass Seguro Amber

G-467AQ - LBL Lighting - Glass Seguro Aqua

G-467BR - LBL Lighting - Glass Seguro Brown

G-467CR - LBL Lighting - Glass Seguro Clear

G-468AM - LBL Lighting - Glass Mini-Ruffle Amber

G-468OP - LBL Lighting - Glass Mini-Ruffle Opal

G-469AM - LBL Lighting - Glass Mojave Amber

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