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 >= '17160/1-led' and catalogpartcode <= '173-012' order by ref_product.catalogpartcode,ref_product.id ;

172-001 - Sterling - Pierced Metal Frame Work And Wood Mirror

172-002 - Sterling - Pierced Metal Frame Work Frame Mirror

172-003 - Sterling - Pierced Metalwork Hanging Pendant

172-004 - Sterling - Small Pierced Metalwork Hanging Pendant

172-005 - Sterling - Pierced Metalwork Hanging Pendant

172-006 - Sterling - Large Pierced Metalwork Hanging Pendant

172-007 - Sterling - Decorative Accessory - Black Structural Orb

172-008 - Sterling - Pierced Metal Work Stool 172-008

172-009 - Sterling - Pierced Metal Work Stool 172-009

172-010/S2 - Sterling - Set of 2 Mirrored Ring Tray

172-012/S2 - Sterling - Set of 2 Mirrored Greek Key Tray

172-013 - Sterling - Pierced Metal Frame Disks Mirror

172-014 - Sterling - Embossed Metal Frame Frame Mirror

172-015/S2 - Sterling - Set of 2 Pierced Metal Tray

172-016/S2 - Sterling - Set of 2 Pierced Metal Picture Frames

173-001 - Dimond Home - Chain Link Mirror

173-002 - Dimond Home - Square Alternating Oblong Mirror

173-003 - Dimond Home - Segmented Mirror

173-004 - Dimond Home - Stacked Mirror Console

173-005 - Dimond Home - Alternating Oblong Mirror

173-006 - Dimond Home - Mirrored Wall Decoration

173-007 - Dimond Home - Hollywood Two Drawer Chest

173-008 - Dimond Home - Rectangular Wall Mirror With D-Pattern Frame

173-009 - Dimond Home - Mirrored Console With D-Shape Detailing

173-010 - Dimond Home - Set of Two Mirrored Trays

173-011 - Dimond Home - Free Standing Mirrored Floor Lamp

173-012 - Dimond Home - Mirrored Vase

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