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 >= 'hs583ambz1bmpt' and catalogpartcode <= 'hs593ibbz1bfsj' order by ref_product.catalogpartcode,ref_product.id ;

HS583AMBZ1BMPT - LBL Lighting - Chill Pendant - Amber

HS583AMBZ1BMR2 - LBL Lighting - Chill Pendant - Amber

HS583AMBZ1BMRL - LBL Lighting - Chill Pendant - Amber

HS583AMSC1BFSJ - LBL Lighting - Chill Pendant - Amber

HS583AMSC1BMPT - LBL Lighting - Chill Pendant - Amber

HS583AMSC1BMR2 - LBL Lighting - Chill Pendant - Amber

HS583AMSC1BMRL - LBL Lighting - Chill Pendant - Amber

HS583BUBZ1BFSJ - LBL Lighting - Chill Pendant - Blue

HS583BUBZ1BMPT - LBL Lighting - Chill Pendant - Blue

HS583BUBZ1BMR2 - LBL Lighting - Chill Pendant - Blue

HS583BUBZ1BMRL - LBL Lighting - Chill Pendant - Blue

HS583BUSC1BFSJ - LBL Lighting - Chill Pendant - Blue

HS583BUSC1BMPT - LBL Lighting - Chill Pendant - Blue

HS583BUSC1BMR2 - LBL Lighting - Chill Pendant - Blue

HS583BUSC1BMRL - LBL Lighting - Chill Pendant - Blue

HS583CRBZ1BFSJ - LBL Lighting - Chill Pendant - Clear

HS583CRBZ1BMPT - LBL Lighting - Chill Pendant - Clear

HS583CRBZ1BMR2 - LBL Lighting - Chill Pendant - Clear

HS583CRBZ1BMRL - LBL Lighting - Chill Pendant - Clear

HS583CRSC1BFSJ - LBL Lighting - Chill Pendant - Clear

HS583CRSC1BMPT - LBL Lighting - Chill Pendant - Clear

HS583CRSC1BMR2 - LBL Lighting - Chill Pendant - Clear

HS583CRSC1BMRL - LBL Lighting - Chill Pendant - Clear

HS585BBBZ1BMPT - LBL Lighting - Rio Pendant - Amber/Dark Brown

HS585BBBZ1BMR2 - LBL Lighting - Rio Pendant - Amber/Dark Brown

HS585BBBZLEDS830MR2 - LBL Lighting - Rio Pendant - Amber/Dark Brown - LED

HS585BBSC1BMR2 - LBL Lighting - Rio Pendant - Amber/Dark Brown

HS585BBSC1BMRL - LBL Lighting - Rio Pendant - Amber/Dark Brown

HS585BBSCLEDS830MR2 - LBL Lighting - Rio Pendant - Amber/Dark Brown - LED

HS585BBSCLEDS830MRL - LBL Lighting - Rio Pendant - Amber/Dark Brown - LED

HS585BGBZ1BFSJ - LBL Lighting - Rio Pendant - Brown/Gray

HS585BGBZ1BMPT - LBL Lighting - Rio Pendant - Brown/Gray

HS585BGBZ1BMR2 - LBL Lighting - Rio Pendant - Brown/Gray

HS585BGBZ1BMRL - LBL Lighting - Rio Pendant - Brown/Gray

HS585BGBZLEDS830MR2 - LBL Lighting - Rio Pendant - Brown/Gray - LED

HS585BGSC1BFSJ - LBL Lighting - Rio Pendant - Brown/Gray

HS585BGSC1BMPT - LBL Lighting - Rio Pendant - Brown/Gray

HS585BGSC1BMR2 - LBL Lighting - Rio Pendant - Brown/Gray

HS585BGSC1BMRL - LBL Lighting - Rio Pendant - Brown/Gray

HS585BGSCLEDS830MR2 - LBL Lighting - Rio Pendant - Brown/Gray - LED

HS585BGSCLEDS830MRL - LBL Lighting - Rio Pendant - Brown/Gray - LED

HS585GPBZ1BMR2 - LBL Lighting - Rio Pendant - Gray/Purple

HS585GPBZLEDS830MR2 - LBL Lighting - Rio Pendant - Gray/Purple - LED

HS585GPSC1BMR2 - LBL Lighting - Rio Pendant - Gray/Purple

HS585GPSCLEDS830MR2 - LBL Lighting - Rio Pendant - Gray/Purple - LED

HS586BRBZ1BMR2 - LBL Lighting - Horizon Pendant - Dark Brown

HS586BRBZLEDS830MR2 - LBL Lighting - Horizon Pendant - Dark Brown - LED 8W 80 CRI 3000k

HS586BRSC1BMR2 - LBL Lighting - Horizon Pendant - Dark Brown

HS586BRSCLEDS830MR2 - LBL Lighting - Horizon Pendant - Dark Brown - LED 8W 80 CRI 3000k

HS586BUBZ1BMR2 - LBL Lighting - Horizon Pendant - Steel Blue

HS586BUBZLEDS830MR2 - LBL Lighting - Horizon Pendant - Steel Blue - LED 8W 80 CRI 3000k

HS586BUSC1BFSJ - LBL Lighting - Horizon Pendant - Steel Blue

HS586BUSC1BMR2 - LBL Lighting - Horizon Pendant - Steel Blue

HS586BUSC1BMRL - LBL Lighting - Horizon Pendant - Steel Blue

HS586BUSCLEDS830FSJ - LBL Lighting - Horizon Pendant - Steel Blue - LED 8W 80 CRI 3000k

HS586BUSCLEDS830MR2 - LBL Lighting - Horizon Pendant - Steel Blue - LED 8W 80 CRI 3000k

HS586BUSCLEDS830MRL - LBL Lighting - Horizon Pendant - Steel Blue - LED 8W 80 CRI 3000k

HS586OPBZ1BMR2 - LBL Lighting - Horizon Pendant - Opal

HS586OPBZLEDS830MR2 - LBL Lighting - Horizon Pendant - Opal - LED 8W 80 CRI 3000k

HS586OPSC1BFSJ - LBL Lighting - Horizon Pendant - Opal

HS586OPSC1BMR2 - LBL Lighting - Horizon Pendant - Opal

HS586OPSC1BMRL - LBL Lighting - Horizon Pendant - Opal

HS586OPSCLEDS830FSJ - LBL Lighting - Horizon Pendant - Opal - LED 8W 80 CRI 3000k

HS586OPSCLEDS830MR2 - LBL Lighting - Horizon Pendant - Opal - LED 8W 80 CRI 3000k

HS586OPSCLEDS830MRL - LBL Lighting - Horizon Pendant - Opal - LED 8W 80 CRI 3000k

HS586PRBZ1BMR2 - LBL Lighting - Horizon Pendant - Amethyst

HS586PRBZLEDS830MR2 - LBL Lighting - Horizon Pendant - Amethyst - LED 8W 80 CRI 3000k

HS586PRSC1BMR2 - LBL Lighting - Horizon Pendant - Amethyst

HS586PRSCLEDS830MR2 - LBL Lighting - Horizon Pendant - Amethyst - LED 8W 80 CRI 3000k

HS590LIBZ1BMR2 - LBL Lighting - Fiona Pendant - Linen

HS590LISC1BMR2 - LBL Lighting - Fiona Pendant - Linen

HS590PBBZ1BMR2 - LBL Lighting - Fiona Pendant - Pebble

HS590PBSC1BMR2 - LBL Lighting - Fiona Pendant - Pebble

HS590PEBZ1BMR2 - LBL Lighting - Fiona Pendant - Pewter

HS590PESC1BMR2 - LBL Lighting - Fiona Pendant - Pewter

HS593CBBZ1BMR2 - LBL Lighting - Emi Pendant - Light Chocolate/Brown

HS593CBBZLEDS830MR2 - LBL Lighting - Emi Pendant - Light Chocolate/Brown - LED

HS593CBSC1BMR2 - LBL Lighting - Emi Pendant - Light Chocolate/Brown

HS593CBSCLEDS830MR2 - LBL Lighting - Emi Pendant - Light Chocolate/Brown - LED

HS593IBBZ1BFSJ - LBL Lighting - Emi Pendant - Ivory/Brown

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