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-623am-sc' and catalogpartcode <= 'g-781cr' order by ref_product.catalogpartcode,ref_product.id ;

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-623CR-SC - 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-623SM-SC - LBL Lighting - GLASS M ROCK CANDY CYL WALL SM

G-624OP - LBL Lighting - GLASS M ROCK CAND IN CY WAL OP

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-668OP - LBL Lighting - GLASS OLIVER BATH/WALL OPAL

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

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

G-688AM - LBL Lighting - GLASS,RELIC NO.1 PENDANT GREEN

G-688CR - LBL Lighting - GLASS,RELIC NO.1 PENDANT ORNGE

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

G-751OP-BZ - LBL Lighting - GLASS ROCK CAN BATH OPAL BZ

G-751OP-SC - LBL Lighting - GLASS ROCK CAN BATH OPAL SN

G-751SM-BZ - LBL Lighting - GLASS ROCK CAN BATH SMOKE BZ

G-751SM-SC - LBL Lighting - GLASS ROCK CAN BATH SMOKE SN

G-752OP - LBL Lighting - GLASS ROCK CAN BATH INNER OPAL

G-756CRFR - LBL Lighting - GLASS DUKE GR SUS CR GLS-FIZZ

G-756CRMS - LBL Lighting - GLASS DUKE GR SUS CR GLSS-MICA

G-7579AM - LBL Lighting - Glass Ollie Amber

G-7579BU - LBL Lighting - Glass Ollie Blue

G-7579OP - LBL Lighting - Glass Ollie Opal

G-7579RD - LBL Lighting - Glass Ollie Red

G-757OP - LBL Lighting - GLASS TESSA SUSPENSION OPAL

G-758CR - LBL Lighting - GLASS LUXA PEND CLEAR

G-759BR - LBL Lighting - GLASS ARIK PENDANT LT BROWN

G-759CR - LBL Lighting - GLASS ARIK PENDANT CLEAR

G-759GY - LBL Lighting - GLASS ARIK PENDANT GRAY

G-759OP - LBL Lighting - GLASS ARIK PENDANT OPAL

G-761OP - LBL Lighting - GLASS RHYTHM PENDANT OPAL

G-762OP - LBL Lighting - GLASS MINI-RHYTHM PENDANT OPAL

G-763OP - LBL Lighting - GLASS RHYTHM SUSPENSION OPAL

G-764BL - LBL Lighting - GLASS ZURI PENDANT BLACK

G-764CP - LBL Lighting - GLASS ZURI PENDANT COPPER

G-764SI - LBL Lighting - GLASS ZURI PENDANT SILVER

G-772OP - LBL Lighting - Glass

G-775CC - LBL Lighting - GLASS CORINNA PND CLEAR/CLEAR

G-775CZ - LBL Lighting - GLASS CORINNA PND CLEAR/BRONZE

G-775YZ - LBL Lighting - GLASS CORINNA PND GRAY/BRONZE

G-776OS - LBL Lighting - GLASS VERA SUSP OPAL/SILVER

G-777OS - LBL Lighting - GLASS VERA PEND OPAL/SILVER

G-778OS - LBL Lighting - GLASS MINI-VERA PEND OP/SI

G-779OS - LBL Lighting - GLASS VERA FLUSH OPAL/SILVER

G-780GD - LBL Lighting - GLASS MONACO PENDANT GOLD

G-781CR - LBL Lighting - GLASS LEXUM PENDANT CRYSTAL

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