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 >= '5di52bkd-l' and catalogpartcode <= '6003205' order by ref_product.catalogpartcode,ref_product.id ;

5DI52BKD-L - Monte Carlo - Discus Fan - Fan

5DI52BSD-L - Monte Carlo - Discus Fan - Fan

5DI52ESRBD - Monte Carlo - Discus Fan - Energy- Star - Fan

5DI52PND - Monte Carlo - Discus Fan - Fan

5DI52RBD-L - Monte Carlo - Discus Fan - Fan

5DI52WHD-L - Monte Carlo - Discus Fan - 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

5DM52BS - Monte Carlo - Designer Max - 52" - Fan

5DM52RB - Monte Carlo - Designer Max - 52" - Fan

5DM52RZW - Monte Carlo - Designer Max - 52" - Fan

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

5EM60BS - Monte Carlo - Embassy Max - 60" - Fan

5EM60PN - Monte Carlo - Embassy Max - 60" - Fan

5EM60RB - Monte Carlo - Embassy Max - 60" - Fan

5EM60RZW - Monte Carlo - Embassy Max - 60" - 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

5HM52BPN - Monte Carlo - Homeowner Max - 52" - Fan

5HM52RBND - Monte Carlo - Homeowner Max Plus - 52" - Fan

5HM52RZWD - Monte Carlo - Homeowner Max Plus - 52" - Fan

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

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

5HS52WHD-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

5MXRB - Monte Carlo - Maxima - Fan

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

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

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

5SBR56TBD-L - Monte Carlo - Strasburg - 56" - Fan

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

5SIRB - Monte Carlo - St Ives - 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

5TV52AGPD - Monte Carlo - 52 Traverse Semi-Flush Fan - Aged Pewter

5TV52BSD - Monte Carlo - Traverse Semi-Flush Fan - 52" - Fan

5TV52RBD - Monte Carlo - Traverse Semi-Flush Fan - 52" - Fan

5TV52WHD - Monte Carlo - Traverse Semi-Flush Fan - 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

60014-1 - ELK Lighting - Halophane 1 Light Pendant In Aged Bronze 60014-1

60015-1 - ELK Lighting - Halophane 1 Light Pendant In Aged Bronze 60015-1

6001566 - Sterling - Aderley Cocktail Table

60016-2 - ELK Lighting - Trego 2 Light Sconce In Dark Rust 60016-2

60018-1 - ELK Lighting - Trego 1 Light Mini Pendant In Tiffany Bronze 60018-1

60018-1-LED - ELK Lighting - Trego 1 Light LED Pendant In Dark Rust With Multi-Colored Stone 60018-1-LED

60018-3 - ELK Lighting - Trego 3 Light Pendant In Dark Rust 60018-3

60018-3L - ELK Lighting - Trego 3 Light Pendant In Dark Rust 60018-3L

60018-6 - ELK Lighting - Trego 6 Light Pendant In Dark Rust 60018-6

6002387 - Sterling - Maderia Accent Table

6003030 - Sterling - Macklowe Hall Table

6003043 - Sterling - Cheval Bookcase

6003205 - Sterling - Melbourne Nesting Tables

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