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-577br' and catalogpartcode <= 'g-751cr-sc' order by ref_product.catalogpartcode,ref_product.id ;

G-577BR - LBL Lighting - Glass Mini-Aiko Pendant Brown

G-577IV - LBL Lighting - Glass Mini-Aiko Pendant Ivory

G-577OP - LBL Lighting - Glass Mini-Aiko Pendant Opal

G-578GY - LBL Lighting - Glass Miyu Pendant Gray

G-582BA - LBL Lighting - Glass Sora Pnd D-Brown L-Amber

G-583CR - LBL Lighting - Glass Chill Pendant Clear

G-584BR - LBL Lighting - Glass Addison Pendant Brown

G-584CR - LBL Lighting - GLASS ADDISON PENDANT CLEAR

G-584OP - LBL Lighting - Glass Addison Pendant Opal

G-585BB - LBL Lighting - Glass Rio Pend Beige D-Brown

G-585GP - LBL Lighting - Glass Rio Pend Gray Purple

G-586BR - LBL Lighting - Glass Horizon Pend D-Brown

G-586OP - LBL Lighting - Glass Horizon Pend Opal

G-586SB - LBL Lighting - Glass Horizon Pend Steel Blue

G-587BR - LBL Lighting - Glass Ariana Pendant Brown

G-587CR - LBL Lighting - Glass Ariana Pendant Clear

G-593BL - LBL Lighting - Glass Emi Pend Choclate Brown

G-594AM - LBL Lighting - Glass Mason Pendant Amber

G-594BR - LBL Lighting - Glass Mason Pendant Brown

G-594CR - LBL Lighting - Glass Mason Pendant Clear

G-5957-AM - LBL Lighting - Glass Kona Wall Amber

G-5957AP - LBL Lighting - Glass Kona Wall Apricot

G-5957BU - LBL Lighting - Glass Kona Wall Blue

G-5957OP - LBL Lighting - Glass Kona Wall Opal

G-595CRL - LBL Lighting - Glass Lowe Clear

G-595OPM - LBL Lighting - Glass Middle Opal

G-595OPU - LBL Lighting - Glass Upper Opal

G-598AM - LBL Lighting - GLASS INDULGENT AMBER

G-598OP - LBL Lighting - GLASS INDULGENT OPAL

G-598RD - LBL Lighting - GLASS INDULGENT RED

G-599AM - LBL Lighting - GLASS MINI-INDULGENT AMBER

G-599OP - LBL Lighting - GLASS MINI-INDULGENT OPAL

G-599RD - LBL Lighting - GLASS MINI-INDULGENT RED

G-603CR - LBL Lighting - GLASS SPRINGVIEW CLEAR

G-603SM - LBL Lighting - GLASS SPRINGVIEW SMOKE

G-604CR - LBL Lighting - GLASS MINI-SPRINGVIEW CLEAR

G-604SM - LBL Lighting - GLASS MINI-SPRINGVIEW SMOKE

G-608GO - LBL Lighting - GLASS DAHLING GRANDE GRAY-OPAL

G-623AM-BZ - LBL Lighting - GLASS M ROCK CANDY CYL WALL AM

G-623AM-SC - LBL Lighting - GLASS M ROCK CANDY CYL WALL AM

G-623CR-BZ - LBL Lighting - GLASS M ROCK CANDY CYL WALL CR

G-623OP-BZ - LBL Lighting - GLASS M ROCK CANDY CYL WALL OP

G-623OP-SC - LBL Lighting - GLASS M ROCK CANDY CYL WALL OP

G-623PR-BZ - LBL Lighting - GLASS M ROCK CANDY CYL WALL CR

G-623PR-SC - LBL Lighting - GLASS M ROCK CANDY CYL WALL CR

G-623SB-BZ - LBL Lighting - GLASS M ROCK CANDY CYL WALL SB

G-623SB-SC - LBL Lighting - GLASS M ROCK CANDY CYL WALL SB

G-623SM-BZ - LBL Lighting - GLASS M ROCK CANDY CYL WALL SM

G-625AM - LBL Lighting - GLASS ISIS PENDANT AMBER

G-625AQ - LBL Lighting - GLASS ISIS PENDANT AQUA

G-625CR - LBL Lighting - GLASS ISIS PENDANT CLEAR

G-625SM - LBL Lighting - GLASS ISIS PENDANT SMOKE

G-626FR - LBL Lighting - GLASS ISIS PENDANT INNER FROST

G-667CRFR - LBL Lighting - GLASS DUKE SUSP CR GLS-FIZZ

G-667CRMS - LBL Lighting - GLASS DUKE SUSP CR GLS-MICA

G-678CC-RH - LBL Lighting - CRYS MADEMS 13X22 STONES CLEAR

G-678CG-RH - LBL Lighting - CRYS MADEMS 13X22 STONES GOLD

G-688GR - LBL Lighting

G-688OR - LBL Lighting

G-693BU - LBL Lighting - GLASS ZOLLO PENDANT BLUE

G-693GY - LBL Lighting - GLASS ZOLLO PENDANT GRAY

G-695CC - LBL Lighting - CRYS MADEMS 13X33 STONES CLEAR

G-695CG - LBL Lighting - CRYS MADEMS 13X33 STONES GOLD

G-695CR - LBL Lighting - CRYS MADEMS 13X33 STONES CLEAR

G-695GD - LBL Lighting - CRYS MADEMS 13X33 STONES GOLD

G-697CR - LBL Lighting - CRYS MADEMS 13X44 STONES CLEAR

G-697GD - LBL Lighting - CRYS MADEMS 13X44 STONES GOLD

G-744OP-A - LBL Lighting - GLASS LOLA BATH OPAL-A

G-744OP-B - LBL Lighting - GLASS LOLA BATH OPAL-B

G-744OP-C - LBL Lighting - GLASS LOLA BATH OPAL-C

G-744OP-D - LBL Lighting - GLASS LOLA BATH OPAL-D

G-744OP-E - LBL Lighting - GLASS LOLA BATH OPAL-E

G-747AM - LBL Lighting - GLASS CONSELLATION GRNDE AM FRIT

G-747OP - LBL Lighting - GLASS CONSELLATION GRNDE OP FRIT

G-747OS - LBL Lighting - GLASS CONSELLATION GRNDE OPAL

G-748OP - LBL Lighting - GLASS SOMEDAY PENDANT OPAL

G-749OP - LBL Lighting - GLASS MINI-SOMEDAY PEND OPAL

G-750OP - LBL Lighting - GLASS SOMEDAY GRANDE PEND OPAL

G-751CR-BZ - LBL Lighting - GLASS ROCK CAN BATH CLEAR BZ

G-751CR-SC - LBL Lighting - GLASS ROCK CAN BATH CLEAR SN

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