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-406br' and catalogpartcode <= 'g-490lt' order by ref_product.catalogpartcode,ref_product.id ;

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

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

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

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

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

G-469FR - LBL Lighting - Glass Mojave Frost

G-469GR - LBL Lighting - Glass Mojave Green

G-469PR - LBL Lighting - Glass Mojave Amethyst

G-471AR - LBL Lighting - Glass Nave Crush Amber-Red

G-471BG - LBL Lighting - Glass Nave Crush Blue-Green

G-472AM - LBL Lighting - Glass, Cylia Pendant Amber

G-472OP - LBL Lighting - Glass, Cylia Pendant Opal

G-483AM - LBL Lighting - Glass, Mojave Wall Amber

G-483FR - LBL Lighting - Glass, Mojave Wall Frost

G-484LT - LBL Lighting - Glass Pavia Wall Latte

G-484OP - LBL Lighting - Glass Pavia Wall Opal

G-486OO - LBL Lighting - Glass Mia Bath Opal Opal

G-488AM - LBL Lighting - Glass Mojave Amber

G-488FR - LBL Lighting - Glass Mojave White

G-489AM - LBL Lighting - Glass Pavia Suspension Amber

G-489BR - LBL Lighting - Glass Pavia Suspension Brown

G-489LT - LBL Lighting - Glass Pavia Suspension Latte

G-490AM - LBL Lighting - Glass, Ruffle Suspension Amber

G-490LT - LBL Lighting - Glass, Ruffle Suspension Latte

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