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

393495 - Pomeroy - Snowlight Votive In White

3935/1 - Dimond Lighting - Mary-Kate and Ashley 27 Continuum White Table Lamp in Chrome

3935/1-LED - Dimond Lighting - Mary-Kate and Ashley 27 Continuum White LED Table Lamp in Chrome

393501 - Pomeroy - Trees - Tree Votive Large

393525 - Pomeroy - Iclyn Pillar Holder

394324 - Pomeroy - Fern Snowflake Votive Large

394331 - Pomeroy - Cherubs Set of 3 Votives

394348 - Pomeroy - Jubilee Votive Large

394423 - Pomeroy - Odine Set of 3 Votives

394447 - Pomeroy - Lambert Votive Small

394454 - Pomeroy - Lambert Votive Large

394461 - Pomeroy - Witton Votive

394478 - Pomeroy - Witton Pillar Holder

394485 - Pomeroy - Classique Set of 2 Votives

394508 - Pomeroy - Coral Luminaria

394546/S4 - Pomeroy - Melonoptic Set of 4 Tulip Votives

394553/S4 - Pomeroy - Rivet Set of 4 Votives

394560/S4 - Pomeroy - Modern Trees - Modern Tree Set of 4 Votives

394577/S4 - Pomeroy - Modern Trees - Modern Tree Set of 4 Pillar Holders

394584 - Pomeroy - Merry Christmas Hurricane

394591/S4 - Pomeroy - Reindeer Set of 4 Votive Holders

394607/S4 - Pomeroy - Reindeer Set of 4 Pillar Holders

394614/S4 - Pomeroy - Winter Scene Set of 4 Pillar Holders

3948/1 - Dimond Lighting - Mary-Kate and Ashley 23 Elemis Table Lamp in White and Chrome

3948/1-LED - Dimond Lighting - Mary-Kate and Ashley 23 Elemis LED Table Lamp in White and Chrome

3950/1 - Dimond Lighting - Mary-Kate and Ashley 23 Elemis Table Lamp in Natural Stone

3950/1-LED - Dimond Lighting - Mary-Kate and Ashley 23 Elemis LED Table Lamp in Natural Stone

398010 - Dimond Home - Needle Eye Pitch Pail - Small

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

3AVMR64GRYD - Monte Carlo - 64 Avvo Max - Grey

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

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