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 >= '398011' and catalogpartcode <= '3sr-chr' order by ref_product.catalogpartcode,ref_product.id ;

398011 - Dimond Home - Needle Eye Pitch Pail - Large

398017 - Dimond Home - Terraced Wood Jar - Large

398019 - Dimond Home - Terraced Pillar - Marbled Terraced Wood Pillar Holder - Medium

398020 - Dimond Home - Terraced Pillar - Marbled Terraced Wood Pillar Holder - Large

398021 - Dimond Home - Terraced Pillar - Terraced Wood Pillar Holder - Small

398022 - Dimond Home - Terraced Pillar - Terraced Wood Pillar Holder - Medium

398023 - Dimond Home - Terraced Pillar - Terraced Wood Pillar Holder - Large

3AVMR64AGPD - Monte Carlo - 64 Avvo Max - Aged Pewter

3AVMR64KOAD - Monte Carlo - 64 Avvo Max - Koa

3AVMR64QSD - Monte Carlo - 64 Avvo Max - Quicksilver

3AVMR64RZWD - Monte Carlo - 64 Avvo Max - Matte White

3AVOR56AGPD - Monte Carlo - 56 Avvo - Aged Pewter

3AVOR56GRYD - Monte Carlo - Avvo - LED - 80 CRI - 2700k

3AVOR56KOAD - Monte Carlo - Avvo - LED - 80 CRI - 2700k

3AVOR56QSD - Monte Carlo - 56 Avvo - Quicksilver

3AVOR56RZWD - Monte Carlo - Avvo - LED - 80 CRI - 2700k

3BWR50OZD - Monte Carlo - Baldwin - 50" - Fan - LED - 80 CRI - 2700K

3BWR50RZWD - Monte Carlo - Baldwin - 50" - Fan - LED - 80 CRI - 2700K

3CDR56BS - Monte Carlo - Cannondale - Fan

3CDR56BZ - Monte Carlo - Cannondale - Fan

3CLMR56BSD - Monte Carlo - Clarity Max - 56" - Fan - LED - 80 CRI - 2700k

3CLMR56RBD - Monte Carlo - Clarity Max - 56" - Fan - LED - 80 CRI - 2700k

3CLMR56RZWD - Monte Carlo - Clarity Max - 56" - Fan - LED - 80 CRI - 2700k

3CLYR42OZD - Monte Carlo - Clarity II - 42" - Fan - LED - 80 CRI - 2700k

3CLYR52BSD - Monte Carlo - Clarity - 52" Fan - LED - 80 CRI - 2700k

3CLYR52OZD - Monte Carlo - Clarity - 52" Fan - LED - 80 CRI - 2700k

3CLYR52RZWD - Monte Carlo - Clarity - 52" Fan - LED - 80 CRI - 2700k

3DLR56AGP - Monte Carlo - 56 Delray Outdoor - Aged Pewter

3DLR56RB - Monte Carlo - 56 Delray Outdoor - Roman Bronze

3DLR56RZW - Monte Carlo - 56 Delray Outdoor - Matte White

3DSTR57AGPD - Monte Carlo - 57 Destin - Aged Pewter

3DSTR57BSD - Monte Carlo - 57 Destin - Brushed Steel

3DYR56AGB - Monte Carlo - Dylan - 56" - Fan

3DYR56AGP - Monte Carlo - Dylan - 56" - Fan

3KNR52BSD/ABS - Monte Carlo - Ken - 52" - Fan - LED - 80 CRI - 3000K

3KNR52CHD/ABS - Monte Carlo - Ken - 52" - Fan - LED - 80 CRI - 3000K

3L-CHR - ELK Lighting - Illuminare Accessories 3 Light Linear Bar In Chrome

3L-DR - ELK Lighting - Illuminare Accessories 3 Light Linear Bar In Dark Rust

3L-OB - ELK Lighting - Illuminaire Accessories 3 Light Linear Pan In Oiled Bronze 3L-OB

3L-SN - ELK Lighting - Illuminare Accessories 3 Light Linear Bar In Satin Nickel

3LP-CHR - ELK Lighting - Illuminaire Accessories 3 Light Linear Pan In Polished Chrome 3LP-CHR

3LP-OB - ELK Lighting - Illuminaire Accessories 3 Light Linear Pan In Oil Rubbed Bronze 3LP-OB

3LP-SN - ELK Lighting - Illuminaire Accessories 3 Light Linear Pan In Satin Nickel 3LP-SN

3MAVR60AGP - Monte Carlo - 60 Maverick - Aged Pewter

3MAVR60BK - Monte Carlo - 60 Maverick - Black

3MAVR60BKBK - Monte Carlo - 60 Maverick - Black on Black

3MAVR60BS - Monte Carlo - 60 Maverick - Brushed Steel with Dark Walnut Blades

3MAVR60BSKOA - Monte Carlo - 60 Maverick - Brushed Steel with Koa Blades

3MAVR70AGP - Monte Carlo - 70 Maverick Max - Aged Pewter

3MAVR70BK - Monte Carlo - 70 Maverick Max - Black

3MAVR70BKBK - Monte Carlo - 70 Maverick Max - Black on Black

3MAVR70BS - Monte Carlo - 70 Maverick Max - Brushed Steel with Dark Walnut Blades

3MAVR70BSKOA - Monte Carlo - 70 Maverick Max - Brushed Steel with Koa Blades

3MAVR88AGP - Monte Carlo - 88 Maverick Super Max - Aged Pewter

3MAVR88BK - Monte Carlo - 88 Maverick Super Max - Black

3MAVR88BKBK - Monte Carlo - 88 Maverick Super Max - Black on Black

3MAVR88BS - Monte Carlo - 88 Maverick Super Max - Brushed Steel with Dark Walnut Blades

3MAVR88BSKOA - Monte Carlo - 88 Maverick Super Max - Brushed Steel with Koa Blades

3MAVR99AGP - Monte Carlo - 99 Maverick Grand - Aged Pewter

3MAVR99BK - Monte Carlo - 99 Maverick Grand - Matte Black

3MAVR99BKBK - Monte Carlo - 99 Maverick Grand - Black on Black

3MAVR99BS - Monte Carlo - 99 Maverick Grand - Brush Steel

3MAVR99BSKOA - Monte Carlo - 99 Maverick Grand - Koa

3MER56AGPD - Monte Carlo - 56 Melody Aged Pewter

3MER56BSD - Monte Carlo - 56 Melody Brushed Steel

3MNLR56AGPD - Monte Carlo - 56 Minimalist - Aged Pewter

3MNLR56BKD - Monte Carlo - Minimalist - 56" - Fan - LED - 80 CRI - 3000K

3MNLR56BSD - Monte Carlo - Minimalist - 56" - Fan - LED - 80 CRI - 3000K

3MNLR56BZD - Monte Carlo - Minimalist - 56" - Fan - LED - 80 CRI - 3000K

3MNLR56RZWD - Monte Carlo - Minimalist - 56" - Fan - LED - 80 CRI - 3000K

3MNLR72AGPD - Monte Carlo - 72in Minimalist Max Aged Pewter

3MNLR72BKD - Monte Carlo - Minimalist Max - 72" - Fan - LED - 80 CRI - 3000K

3MNLR72BSD - Monte Carlo - Minimalist Max - 72" - Fan - LED - 80 CRI - 3000K

3MNLR72BZD - Monte Carlo - Minimalist Max - 72" - Fan - LED - 80 CRI - 3000K

3MNLR72RZWD - Monte Carlo - Minimalist Max - 72" - Fan - LED - 80 CRI - 3000K

3MO52RBO-L - Monte Carlo - Mach One Fan - 52" - Fan

3MUR52RBD - Monte Carlo - Muirfield Fan - 52" - Fan

3SKYR56SND - Monte Carlo - Skylon - 56" - Fan - LED - 80 CRI - LED - 2700K

3SKYR56WHD - Monte Carlo - 56 Skylon - Shiny White / Matte White

3SR-CHR - ELK Lighting - Illuminaire Accessories 3 Light Small Round Canopy In Polished Chrome 3SR-CHR

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