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 >= 'sf241bs' and catalogpartcode <= 'shade-837gy' order by ref_product.catalogpartcode,ref_product.id ;

SF241BS - Feiss - Barrington Light Indoor Semi-Flush Mount - 2 - Light

SF241ORB - Feiss - Barrington Light Indoor Semi-Flush Mount - 2 - Light

SF251BS - Feiss - Casual Luxury Light Indoor Semi-Flush Mount - 2 - Light

SF251DBZ - Feiss - Casual Luxury Light Indoor Semi-Flush Mount - 2 - Light

SF254BS - Feiss - 4 - Light Semi-Flush Mount

SF254CH - Feiss - 4 - Light Semi-Flush Mount

SF254ORB - Feiss - 4 - Light Semi-Flush Mount

SF258BS - Feiss - 3 - Light Semi-Flush Mount

SF258CH - Feiss - 3 - Light Semi-Flush Mount

SF258ORB - Feiss - 3 - Light Semi-Flush Mount

SF259BS - Feiss - Sunset Drive Light Indoor Semi-Flush Mount - 2 - Light - White

SF259CB - Feiss - Sunset Drive Light Indoor Semi-Flush Mount - 2 - Light

SF259CH - Feiss - 2 - Light Semi-Flush Mount

SF259ORB - Feiss - 2 - Light Semi-Flush Mount

SF275BK - Feiss - Peyton Light Indoor Semi-Flush Mount - 2 - Light

SF289BUS - Feiss - Lucia Light Indoor Semi-Flush Mount - 3 - Light

SF292AF/BS - Feiss - Ethan Light Indoor Semi-Flush Mount - 4 - Light

SF308PN - Feiss - Malibu Light Indoor Semi-Flush Mount - 3 - Light

SF310PRBZ - Feiss - Yorktown Heights Light Semi-Flush Mount - 3 - Light

SF312PN - Feiss - Malia Light Semi Flush Mount - 3 - Light

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

SF348ORB/BBS - 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-772-GY - LBL Lighting - Metal Shade Grey

SHADE-772-WH - LBL Lighting - Metal Shade White

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.

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