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

594045 - Dimond Home - Aged Iron Wire Sphere - Small

594046 - Dimond Home - Aged Iron Wire Sphere - Large

5960/1 - ELK Lighting - Elizabethan 1 Light Wall Sconce In Dark Bronze 5960/1

5962/3 - ELK Lighting - Elizabethan 3 Light Flushmount In Dark Bronze And Crystal 5962/3

5963/6 - ELK Lighting - Elizabethan 6 Light Flushmount In Dark Bronze And Crystal 5963/6

5964/3 - ELK Lighting - Elizabethan 3 Light Semi Flush In Dark Bronze 5964/3

5965/4 - ELK Lighting - Elizabethan 4 Light Chandelier In Dark Bronze 5965/4

5967/6+4 - ELK Lighting - Elizabethan 10 Light Chandelier In Dark Bronze 5967/6+4

5970/2 - ELK Lighting - Elizabethan 2 Light Wall Sconce In Dark Bronze 5970/2

5972/1 - ELK Lighting - Elizabethan 1 Light Pendant In Dark Bronze 5972/1

5973/4+1 - ELK Lighting - Elizabethan 5 Light Chandelier In Dark Bronze 5973/4+1

5AHR60RBD-L - Monte Carlo - Arch - 60" - Fan

5BHM60BP - Monte Carlo - Bonneville Max - 60" - Fan

5BO52EBD - Monte Carlo - Bravo - 52" - Fan

5CLR66RBD-L - Monte Carlo - Chloe Fan - 66" - Fan

5COM52AGP - Monte Carlo - 52in COLONY MAX DAMP AGED PEWTER

5COM52BS - Monte Carlo - Colony Max - 52" - Fan

5COM52RB - Monte Carlo - Colony Max - 52" - Fan

5COM52RZW - Monte Carlo - Colony Max - 52" - Fan

5CQM44BS - Monte Carlo - Centro Max II - 44" - Fan

5CQM44PN - Monte Carlo - Centro Max II - 44" - Fan

5CQM44RB - Monte Carlo - Centro Max II - 44" - Fan

5CQM44RZW - Monte Carlo - Centro Max II - 44" - Fan

5CQM52BS - Monte Carlo - Centro Max - 52" - Fan

5CQM52BS-L - Monte Carlo - Centro Max Uplight - 52" - Fan

5CQM52RB - Monte Carlo - Centro Max - 52" - Fan

5CQM52RB-L - Monte Carlo - Centro Max Uplight - 52" - Fan

5CQM52RZW - Monte Carlo - Centro Max - 52" - Fan

5CQM52RZW-L - Monte Carlo - Centro Max Uplight - 52" - Fan

5CSM60AGP - Monte Carlo - 60 Colony Super Max - Aged Pewter

5CSM60BS - Monte Carlo - 60 Colony Super Max - Brushed Steel

5CSM60RB - Monte Carlo - 60 Colony Super Max - Roman Bronze

5CSM60RZW - Monte Carlo - 60 Colony Super Max - Rubberized White

5CU52RB - Monte Carlo - Cruise Outdoor - 52" - Fan

5CU52WH - Monte Carlo - Cruise Outdoor - 52" - Fan

5CY60BK - Monte Carlo - Cyclone Outdoor Fan - 60" - Fan

5CY60RB - Monte Carlo - Cyclone Outdoor Fan - 60" - Fan

5CY60WH - Monte Carlo - Cyclone Outdoor Fan - 60" - Fan

5DI44WHD - Monte Carlo - Discus II Fan - 44" - Fan

5DIO52AGPD - Monte Carlo - 52 Discus Ornate - Aged Pewter

5DIO52BKD - Monte Carlo - 52 Discus Ornate - Black

5DIO52RBD - Monte Carlo - 52 Discus Ornate - Roman Bronze

5DIW52PBSD - Monte Carlo - 52 foot Discus Outdoor Fan - Painted Brushed Steel

5DIW52RBD - Monte Carlo - 52 foot Discus Outdoor Fan - Roman Bronze

5DIW52WHD - Monte Carlo - 52 foot Discus Outdoor Fan - White

5DKR52HBD - Monte Carlo - Dakota - 52" - Fan

5DM44BS - Monte Carlo - Designer Max II - 44" - Fan

5DM44RZW - Monte Carlo - Designer Max II - 44" - Fan

5ED56RBD - Monte Carlo - Drawing Room - 56" - Fan

5ESR54ESD - Monte Carlo - Essex - 54" - Fan - LED - 80 CRI - 3000K

5ESR54PND - Monte Carlo - Essex - 54" - Fan - LED - 80 CRI - 3000K

5GFR52AFID - Monte Carlo - Grafton - 52" - Fan

5HLR54ES - Monte Carlo - Hillsborough - Fan

5HS52TBD-L - Monte Carlo - Homeowner Deluxe Fan - 52"- Fan

5LLR56BSD - Monte Carlo - Lily - 56" - Fan - LED - 80 CRI - 2700K

5LLR56RZWD - Monte Carlo - Lily - 56" - Fan - LED - 80 CRI - 2700K

5NKR52PND - Monte Carlo - Nikki - 52" - Fan - LED - 80 CRI - 3000K

5NKR52RZWD - Monte Carlo - Nikki - 52" - Fan - LED - 80 CRI - 3000K

5OR52RBD-L - Monte Carlo - Ornate Elite Fan - 52" - Fan

5OS52DWD - Monte Carlo - Old School - 55" Fan

5PEN56RB - Monte Carlo - Peninsula Indoor Outdoor - 56" - Fan

5PPR54RZW - Monte Carlo - Piper - 54" - Fan - LED - 80 CRI - 2700K

5RYEP - Monte Carlo - Royalton Fan Blades Separate - Fan

5RYRB - Monte Carlo - Royalton Fan Blades Separate - Fan

5SH54RBD-L - Monte Carlo - Shores - 54" - Fan

5SLR52BSD-B - Monte Carlo - Sleek Fan - 52" - Fan

5SLR52RBD-B - Monte Carlo - Sleek Fan - 52" - Fan

5SLR52WHD-B - Monte Carlo - Sleek Fan - 52" - Fan

5TLR54CHKW - Monte Carlo - 54in Tillbury - Chalk Washed - Fan Only

5TQ52RBD-L - Monte Carlo - Town Square - 52" - Fan

5VIR52RBD - Monte Carlo - Vintage Industrial - 52" - Fan

5WS52RBD-L - Monte Carlo - Weatherford Outdoor Fan - 52" -Fan

60-1540 - Sterling - Fire Island Coral Display Statue

6000017 - Sterling - Bellingham Side Table

600027 - GuildMaster - Credenza With Wine Storage

600029 - GuildMaster - Victorian Display Cabinet

60004-1 - ELK Lighting - Halophane 1 Light Pendant In Polished Chrome 60004-1

60005-1 - ELK Lighting - Halophane 1 Light Pendant In Polished Chrome 60005-1

6000538 - Sterling - Avalon Pedestal Table

6001375 - Sterling - Empress Bench

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