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 >= '169-014' and catalogpartcode <= '173028' order by ref_product.catalogpartcode,ref_product.id ;

169-014 - Dimond Lighting - Antique Bottle Table Lamp In Antique Mercury Glass

169-015 - Dimond Lighting - Weathered Glass Bottle Lamp With White Faux Silk Shade

169006S - GuildMaster - Set of 4 Carved Wall Plaques

169050S - GuildMaster - Tuscan Sunflower

169554 - GuildMaster - Reflections

170-001/S3 - Sterling - Set of 3 Antique Book Trunks

170-002/S3 - Sterling - Linen Covered Travelers Trunks

170-003/S3 - Sterling - Set of 3 Travelers Storage Trunks

170-004 - Sterling - Trunk - Tall Travelers Chest

170-005/S2 - Sterling - Trunk - Set of 2 Travelers Cabinets

170-006 - Sterling - Travelers Mirror

17027/1 - Dimond Lighting - Elysburg 1 Light Floor Lamp In Aged Bronze

17027/1-LED - Dimond Lighting - Elysburg 1 Light LED Floor Lamp In Aged Bronze

17047/1 - Dimond Lighting - Elysburg 1 Light Floor Lamp In Satin Nickel

17047/1-LED - Dimond Lighting - Elysburg 1 Light LED Floor Lamp In Satin Nickel

170MASGGCB - Tech Lighting - Masque Grande Glass Cap Black

170MASGGCW - Tech Lighting - Masque Grande Glass Cap White

170PULWHS - Tech Lighting - PULLEY WHEEL

170PULYKS - Tech Lighting - PULLEY YOKE

170SHSR3C - Tech Lighting - SPIDER RING

170TDCCLB - Tech Lighting - Decorative Nut For Glass Diffuser - Canopy Cap Black - Replacement Component

170TDCCLS - Tech Lighting - Decorative Nut For Glass Diffuser - Canopy Cap Satin - Replacement Component

170TDCCLW - Tech Lighting - Decorative Nut For Glass Diffuser - Canopy Cap White - Replacement Component

170TDCCLZ - Tech Lighting - Decorative Nut For Glass Diffuser - Canopy Cap Bronze - Replacement Component

170TDSIEFB - Tech Lighting - Siesta - Black Cap

170TDSIEFW - Tech Lighting - Siesta - White Cap

170TDSITFS - Tech Lighting - Sierrra Satin Nickel Cap

170VERYOP20 - Tech Lighting - Veyron/Iso-Led Optic 20

170VERYOP30 - Tech Lighting - Veyron/Iso-Led Optic 30

170WSGWAS - Tech Lighting - Decorative Nut For Glass Diffuser - Teflon Washer - Replacement Component

171-002 - Sterling - Victoria Station Clock

171-004 - Sterling - Renaissance Style Printed Map Clock

171-005 - Sterling - Aged White Wall Clock

171-006 - Sterling - Double Sided Iron Scroll Wall Clock

171-008 - Sterling - Stylized Rooster Wall Clock

171-009 - Sterling - Antique Wall Clock

171-010 - Sterling - Stylized Roman Numeral Clock

171-011 - Sterling - Americana Clock

171-012 - Sterling - Open Center Iron Wall Clock

171-013 - Sterling - Vintage Style Clock in Square Mesh

171-014 - Sterling - Open Ring Wall Clock

171-015 - Sterling - Double Sided Curled Iron Wall Clock

171-016 - Sterling - Antique Fan Clock

171-017 - Sterling - Oval Iron Wall Clock

171-018 - Sterling - Gold Petal Wall Clock

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

173-013 - Dimond Home - Layered Circles Mirror

173-014 - Dimond Home - Layered Crescent Mirrored Console

173-015 - Dimond Home - Gaelic Pattern Mirror For Trump Home

173-016 - Dimond Home - Wrapped Glass Mirror Vase

173-017 - Dimond Home - Triangular Mirrored Vase - Large

173-018 - Dimond Home - Triangular Mirrored Vase - Small

173027 - Dimond Home - Fallow Faux Pony Tray 173027

173028 - Dimond Home - Holstein Faux Pony Tray 173028

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