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 >= 'sf314shbl' and catalogpartcode <= 'shade-862gypl' order by ref_product.catalogpartcode,ref_product.id ;

SF314SHBL - Feiss - Freemont Light Semi Flush Mount - 1 - Light

SF316SN - Feiss - Tori Light Semi Flush - 3 - Light

SF317HTBZ - Feiss - Vintner Light Semi-Flush - 3 - Light - Opal

SF317SN - Feiss - Vintner Light Semi-Flush - 3 - Light

SF326PN - Feiss - Pave Light Indoor Semi-Flush Mount - 3 - Light

SF327PN - Feiss - Pave Light Indoor Semi-Flush Mount - 5 - Light

SF329BUS - Feiss - Lucia Light Semi-Flush Mount - 6 - Light

SF335SN/CH - Feiss - Prospect Park Light Semi-Flush - 2 - Light

SF337ORB - Feiss - Marteau Light Indoor Semi-Flush Mount - 3 - Light

SF338ORB - Feiss - Marteau Light Indoor Semi-Flush Mount - 5 - Light

SF339ORB - Feiss - 3 - Light Semi-Flush Mount

SF339SG - Feiss - 3 - Light Semi-Flush Mount

SF339SN - Feiss - 3 - Light Semi-Flush Mount

SF340ORB - Feiss - 5 - Light Semi-Flush Mount

SF340SG - Feiss - 5 - Light Semi-Flush Mount

SF340SN - Feiss - 5 - Light Semi-Flush Mount

SF341ORB - Feiss - 2 - Light Semi Flush Mount

SF341PN - Feiss - 2 - Light Semi Flush Mount

SF342ORB - Feiss - 3 - Light Semi Flush Mount

SF342PN - Feiss - 3 - Light Semi Flush Mount

SF346DA - Feiss - 3 - Light Semi Flush Mount

SF347TXB/CH - Feiss - 4 - Light Semi Flush Mount

SF349PN - Feiss - 4 - Light Semi Flush Mount

SF349SN - Feiss - 4 - Light Semi-Flush Mount

SHADE-556GY - LBL Lighting - Lucia Shadecharcoal Gray

SHADE-556IV - LBL Lighting - Lucia Shadecharcoal Ivory

SHADE-556ST - LBL Lighting - Lucia Shadecharcoal Stone

SHADE-559FLI - LBL Lighting - Shade Omni Outr Linen Fab Sml

SHADE-559FPE - LBL Lighting - Shade Omni Outr Pewter Fab Sml

SHADE-561FLI - LBL Lighting - Shade Omni Outr Linen Fab Med

SHADE-561FPE - LBL Lighting - Shade Omni Outr Pewter Fab Med

SHADE-590PE - LBL Lighting - Shade Fiona Pendant Pewter

SHADE-643PE - LBL Lighting - SHADE CHIC JAZZ PEWTR OPAL GLS

SHADE-666TN - LBL Lighting - SHADE DERBY WALL TAN

SHADE-680LI - LBL Lighting - SHADE FIONA GRNDE W/DIF LINEN

SHADE-680PB - LBL Lighting - SHADE FIONA GRNDE W/DIF PEBBLE

SHADE-680PE - LBL Lighting - SHADE FIONA GRNDE W/DIF PEWTER

SHADE-681LI - LBL Lighting - SHADE,FIONA Wall Linen

SHADE-681PB - LBL Lighting - SHADE,FIONA wall W/DIF PEBBLE

SHADE-681PE - LBL Lighting - SHADE,FIONA wall W/DIF PEWTER

SHADE-698BR - LBL Lighting - CHAIN MA CAMELOT BRS 5.25x12IN

SHADE-698BZ - LBL Lighting - CHAIN MA CAMELOT BRZ 5.25x12IN

SHADE-698SS - LBL Lighting - CHAIN MA CAMELOT SS 5.25x12IN

SHADE-700LI - LBL Lighting - SHADE FIONA FLUSH MOUNT LINEN

SHADE-700PB - LBL Lighting - SHADE FIONA FLUSH MOUNT PEBBLE

SHADE-700PE - LBL Lighting - SHADE FIONA FLUSH MOUNT PEWTER

SHADE-784-GC - LBL Lighting - SHADE MILO SUSP GRAY/CHARTREUS

SHADE-784-WA - LBL Lighting - SHADE MILO SUSP WHITE/CHAMPAGN

SHADE-784-WO - LBL Lighting - SHADE MILO SUSP WHITE/ORANGE

SHADE-815DU - LBL Lighting - SHADE LINNET PEND SHAPE A DU

SHADE-816DU - LBL Lighting - SHADE LINNET PEND SHAPE B DU

SHADE-817DU - LBL Lighting - SHADE LINNET PEND SHAPE C DU

SHADE-835GY - LBL Lighting - SHADE ASSY MALKA BOWL PEND GY Includes diffuser.

SHADE-835WH - LBL Lighting - SHADE ASSY MALKA BOWL PEND WH Includes diffuser.

SHADE-836GY - LBL Lighting - SHADE ASSY MALKA GRANDE GRAY Includes diffuser.

SHADE-836WH - LBL Lighting - SHADE ASSY MALKA GRANDE WHITE Includes diffuser.

SHADE-837GY - LBL Lighting - SHADE ASSY MALKA PENDANT GRAY Includes diffuser.

SHADE-837WH - LBL Lighting - SHADE ASSY MALKA PENDANT WHITE Includes diffuser.

SHADE-844ALWH - LBL Lighting - SHADE AMPHORA PEND AL/WH

SHADE-844WHAL - LBL Lighting - SHADE AMPHORA PEND WH/AL

SHADE-860GYBU - LBL Lighting - SHADE MINI-SIGNAL GRAY-BLUE

SHADE-860GYCP - LBL Lighting - SHADE MINI-SIGNAL GRAY-COPPER

SHADE-860GYGD - LBL Lighting - SHADE MINI-SIGNAL GRAY-GOLD

SHADE-860GYPL - LBL Lighting - SHADE MINI-SIGNAL GRAY-PLATINM

SHADE-860WHBU - LBL Lighting - SHADE MINI-SIGNAL WHT-BLUE

SHADE-860WHCP - LBL Lighting - SHADE MINI-SIGNAL WHT-COPPER

SHADE-860WHGD - LBL Lighting - SHADE MINI-SIGNAL WHT-GOLD

SHADE-860WHPL - LBL Lighting - SHADE MINI-SIGNAL WHT-PLATINM

SHADE-861GYBU - LBL Lighting - SHADE SIGNAL GRAY-BLUE

SHADE-861GYCP - LBL Lighting - SHADE SIGNAL GRAY-COPPER

SHADE-861GYGD - LBL Lighting - SHADE SIGNAL GRAY-GOLD

SHADE-861GYPL - LBL Lighting - SHADE SIGNAL GRAY-PLATINM

SHADE-861WHBU - LBL Lighting - SHADE SIGNAL WHITE-BLUE

SHADE-861WHCP - LBL Lighting - SHADE SIGNAL WHITE-COPPER

SHADE-861WHGD - LBL Lighting - SHADE SIGNAL WHITE-GOLD

SHADE-861WHPL - LBL Lighting - SHADE SIGNAL WHITE-PLATINM

SHADE-862GYBU - LBL Lighting - SHADE SIGNAL GR GRAY-BLUE

SHADE-862GYCP - LBL Lighting - SHADE SIGNAL GR GRAY-COPPER

SHADE-862GYGD - LBL Lighting - SHADE SIGNAL GR GRAY-GOLD

SHADE-862GYPL - LBL Lighting - SHADE SIGNAL GR GRAY-PLATINM

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