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-695gd' and catalogpartcode <= 'g-887gy' order by ref_product.catalogpartcode,ref_product.id ;

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-782BR - LBL Lighting - GLASS DIA PENDANT BROWN

G-782CR - LBL Lighting - GLASS DIA PENDANT CLEAR

G-782GY - LBL Lighting - GLASS DIA PENDANT CHARCOAL

G-783BR - LBL Lighting - GLASS MINI-DIA PENDANT BROWN

G-783CR - LBL Lighting - GLASS MINI-DIA PENDANT CLEAR

G-783GY - LBL Lighting - GLASS MINI-DIA PENDANT CHARCOL

G-788SM - LBL Lighting - GLASS MOON DANCE 13 OUTD SMOKE

G-789SM - LBL Lighting - GLASS MOON DANCE 18 OUTD SMOKE

G-793BU - LBL Lighting - GLASS KENDALL PEND PEACOCK BLU

G-794OP - LBL Lighting - GLASS TINDRA PEND OPAL

G-795AM - LBL Lighting - OUTER GLASS PAIGE PENDANT AMBER

G-795SM - LBL Lighting - OUTER GLASS PAIGE PENDANT SMOKE

G-796BU - LBL Lighting - GLASS MINI-AKARI P STEEL BLUE

G-796SM - LBL Lighting - GLASS MINI-AKARI P SMOKE

G-797BU - LBL Lighting - GLASS AKARI PENDANT STEEL BLUE

G-797SM - LBL Lighting - GLASS AKARI PENDANT SMOKE

G-798EG - LBL Lighting - GLASS LILAH PENDANT EGGPLANT

G-798GY - LBL Lighting - GLASS LILAH PENDANT GRAY

G-823OP - LBL Lighting - GLASS RANIA BATH OPAL

G-824OP - LBL Lighting - GLASS ALBAN BATH OPAL

G-827SM - LBL Lighting - GLASS MOON DANCE OD FLSH SMOKE

G-834BU - LBL Lighting - GLASS ADARA PEND STEEL BLUE

G-834FR - LBL Lighting - GLASS ADARA PEND FROST

G-834SM - LBL Lighting - GLASS ADARA PEND SMOKE

G-849SM - LBL Lighting - GLASS SPHERE PENDANT SMOKE

G-859BL - LBL Lighting - GLASS MINI-ZURI PENDANT BLACK

G-859SI - LBL Lighting - GLASS MINI-ZURI PENDANT SILVER

G-869CR - LBL Lighting - GLASS ANELLA FLUSH CLEAR

G-869OP - LBL Lighting - GLASS ANELLA FLUSH OPAL

G-869SM - LBL Lighting - GLASS ANELLA FLUSH SMOKE

G-873CR - LBL Lighting - GLASS PRECIP FLUSH CLEAR

G-887GY - LBL Lighting - Glass Mini Miyu Gray

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