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 >= '3mavr70bs' and catalogpartcode <= '4002/5rs' order by ref_product.catalogpartcode,ref_product.id ;

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

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

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

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

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

3NDR54BSD - Monte Carlo - 54 Nord - Brushed Steel

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

3SR-OB - ELK Lighting - Illuminaire Accessories 3 Light Small Round Canopy In Oil Rubbed Bronze 3SR-OB

3SR-SN - ELK Lighting - Illuminaire Accessories 3 Light Small Round Canopy In Satin Nickel 3SR-SN

3SU54BK - Monte Carlo - Studio Fan - Fan

3SU54BP - Monte Carlo - Studio Fan - Fan

3SU54PN - Monte Carlo - Studio Fan - Fan

3SU54RB - Monte Carlo - Studio Fan - Fan

3SU54WH - Monte Carlo - Studio Fan - Fan

3T-CHR - ELK Lighting - Illuminare Accessories 3 Light Triangular Pan In Chrome

3T-DR - ELK Lighting - Illuminare Accessories 3 Light Triangular Pan In Dark Rust

3T-OB - ELK Lighting - Illuminaire Accessories 3 Light Triangular Pan In Oiled Bronze 3T-OB

3T-SN - ELK Lighting - Illuminare Accessories 3 Light Triangular Pan In Satin Nickel

3TF24PN - Monte Carlo - Micro Fan - 24" - Fan

3TF24WH - Monte Carlo - Micro Fan - 24" - Fan

3VNMR56BSD - Monte Carlo - Vision Max - Fan - LED - 80 CRI - 2700k

3VNMR56RBD - Monte Carlo - Vision Max - Fan - LED - 80 CRI - 2700k

3VNMR56RZWD - Monte Carlo - Vision Max - Fan - LED - 80 CRI - 2700k

3VNR42BSD - Monte Carlo - Vision II - Fan - LED - 80 CRI - 2700k

3VNR42OZD - Monte Carlo - Vision II - Fan - LED - 80 CRI - 2700k

3VNR42RZWD - Monte Carlo - Vision II - Fan - LED - 80 CRI - 2700k

3VNR52BSD - Monte Carlo - Vision - Fan - LED - 80 CRI - 2700k

3VNR52BSNDIST - Monte Carlo - Vision

3VNR52OZD - Monte Carlo - Vision - Fan - LED - 80 CRI - 2700k

3VNR52RZWD - Monte Carlo - Vision - Fan - LED - 80 CRI - 2700k

4-303300 - Sterling - Pair Chef Pig Bookends

4-83032 - Sterling - Pair Of Black Greyhound Bookends

4-83037 - Sterling - Pair Of Baby Rabbit Bookends

4-8527172 - Sterling - Set Of 2 Sprawling Elephants

40-1704M - Sterling - Floral Scroll Mirror

40-2376M - Sterling - Inlay Octagon Beveled Mirror

40-2470M - Sterling - Capetian Mirror

40-2630M - Sterling - Frederick Medallion Mirror

40-3214M - Sterling - Beverly Foyer Beveled Mirror

400 - Lamp Works - Cigar Table Lamp In Satin Nickel And White

400-LED - Lamp Works - Cigar LED Table Lamp In Satin Nickel And White

4000/2AMB - ELK Lighting - Opulence 2 Light Wall Sconce In Antique White And Amber Crystal

4000/2AQ - ELK Lighting - Opulence 2 Light Wall Sconce In Antique White And Aqua Crystal

4000/2CL - ELK Lighting - Opulence 2 Light Wall Sconce In Antique White And Clear Crystal

4000/2LM - ELK Lighting - Opulence 2 Light Wall Sconce In Antique White And Lime Crystal

4000/2RS - ELK Lighting - Opulence 2 Light Wall Sconce In Antique White And Rose Crystal

400087 - Pomeroy - Firenza Votive Centerpiece

4001/3LM - ELK Lighting - Opulence 3 Light Chandelier In Antique White And Lime Crystal

4001/3RS - ELK Lighting - Opulence 3 Light Chandelier In Antique White And Rose Crystal

4002/5AMB - ELK Lighting - Opulence 5 Light Chandelier In Antique White And Amber Crystal

4002/5AQ - ELK Lighting - Opulence 5 Light Chandelier In Antique White And Aqua Crystal

4002/5CL - ELK Lighting - Opulence 5 Light Chandelier In Antique White And Clear Crystal

4002/5LM - ELK Lighting - Opulence 5 Light Chandelier In Antique White And Lime Crystal

4002/5RS - ELK Lighting - Opulence 5 Light Chandelier In Antique White And Rose Crystal

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