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 >= '140wcpulbp' and catalogpartcode <= '146articggw' order by ref_product.catalogpartcode,ref_product.id ;

140WCPULBP - Tech Lighting - Bottom Glass Frost

140WCUNLBP - Tech Lighting - Union Large Bottom Glass Frost

140WCUNLBPA - Tech Lighting - Union Large Bottom Glass Amber

140WCUNLMP - Tech Lighting - Union Large Middle Glass Frost

140WCUNLMPA - Tech Lighting - Union Large Middle Glass Amber

140WCUNLTPA - Tech Lighting - Union Large Top Glass Amber

140WCUNSBP - Tech Lighting - Union Small Bottom Glass Frost

140WCUNSBPA - Tech Lighting - Union Small Bottom Glass Amber

140WCUNSTP - Tech Lighting - Union Small Top Glass Frost

140WCUNSTPA - Tech Lighting - Union Small Top Glass Amber

140WCVANBA - Tech Lighting - Van Buren Amber

140WCVANBP - Tech Lighting - Van Buren Clear

140WCVANMP - Tech Lighting - Glass Clear

140WG40AQ - Tech Lighting - Hanging Wok - Lt. Blue - Replacement Component

140WG40CL - Tech Lighting - Hanging Wok - Clear - Replacement Component

140WG40CO - Tech Lighting - Hanging Wok - Cobalt - Replacement Component

140WG40GR - Tech Lighting - Hanging Wok - Green - Replacement Component

140WG40RD - Tech Lighting - Hanging Wok - Red - Replacement Component

140WSCORBCL - Tech Lighting - Glass,Ws Corbel Cast Clear

140WSCORBIW - Tech Lighting - Glass Assem,Ws Corbel Inner Wh

140WSCORBSM - Tech Lighting - Glass,Ws Corbel Cast Smoke

140WSCORWH - Tech Lighting - Corva - White Glass Satin Nickel Band - Replacement Component

140WSESSNS - Tech Lighting - Essex - Shell, White - Replacement Component

140WSESSWS - Tech Lighting - Fire Onyx - Honey Onyx - Replacement Component

140WSHUDW - Tech Lighting - Ice - Frost - Replacement Component

140WSMURAGF - Tech Lighting - Shade Ws Mura Glass Frost

140WSMURAGK - Tech Lighting - Shade Ws Mura Glass Smoke

140WSMURAVB - Tech Lighting - Shade Ws Mura Veritas Black

140WSSAIWH - Tech Lighting - Inner white glass

140WSSEDONYR - Tech Lighting - Glass Gray Aged Brass

140WSSEDONYS - Tech Lighting - Glass Gray Satin Nickel

140WSSHLD - Tech Lighting - Bulb Shield - Low-Voltage Orb Sconce

140WSSQFR - Tech Lighting - Ice - Frost - Replacement Component

140ZENLBL - Tech Lighting - Glass, Zenith Large Steel Blue

140ZENLBN - Tech Lighting - GLASS, ZENITH LARGE BROWN

140ZENLGY - Tech Lighting - GLASS, ZENITH LARGE GRAY

140ZENLSM - Tech Lighting - Zenith - Glass,Zenith Large Smoke - Replacement Component

140ZENLWH - Tech Lighting - Zenith - Glass, Zenith Large White - Replacement Component

140ZENSBL - Tech Lighting - Glass, Zenith Small Steel Blue

140ZENSBN - Tech Lighting - GLASS, ZENITH SMALL BROWN

140ZENSGY - Tech Lighting - GLASS, ZENITH SMALL GRAY

140ZENSSM - Tech Lighting - Zenith - Glass,Zenith Small Smoke - Replacement Component

140ZENSWH - Tech Lighting - Zenith - Glass,Zenith Small White - Replacement Component

141-001 - Sterling - Ailsa-Ringed 3 Light Cluster Lantern

141ROCFAT - Tech Lighting - Roc - Fathoms Blue - Replacement Component

141ROCMOS - Tech Lighting - Roc - Moss Green - Replacement Component

141ROCPLU - Tech Lighting - Roc - Plum Red - Replacement Component

141ROCRIV - Tech Lighting - Roc - River Bed Natural - Replacement Component

14210/1 - Dimond Lighting - Palacial 1 Light Table Lamp In Oil Rubbed Bronze And Clear Crystal

14211/3 - Dimond Lighting - Palacial 3 Light Floor Lamp In Oil Rubbed Bronze And Clear Crystal

143-001 - Sterling - Inshes-1Light Mini Pendant Lamp 143-001

143-002 - Sterling - Inshes-1Light Mini Pendant Lamp 143-002

144-006 - Sterling - Torvean (Small)-1 Light Clear Hooked Ring Pendant

144-007 - Sterling - Torvean (Large)-3 Light Clear Hooked Ring Pendant

144-009 - Sterling - Telford-12 Silver Spun Acrylic Pendant

144-011 - Sterling - Balvorie-Contemporary Wave Pendant In White

144-013 - Sterling - Theatre-3 Light Purple Mini Chandelier

144-014 - Sterling - Theatre-3 Light Cerise Pink Mini Chandelier

144-015 - Sterling - Theatre-3 Light Clear Mini Chandelier

144-020 - Sterling - Huntly-Pearlescent Disks Mini Pendant

144-021 - Sterling - Kinloss-Smoked Drop Mini Pendant

144-025 - Sterling - Montebello-1Light Mini Pendant Lamp

144011 - Pomeroy - Nirvana Highball Cooler

144042 - Pomeroy - Nirvana Wine

144158 - Pomeroy - Nirvana Pitcher

144202 - Pomeroy - Nirvana Margarita

144240 - Pomeroy - Nirvana Beverage

144585 - Pomeroy - Nirvana Whiskey

145-001 - Sterling - Star-1Light Glass Pendant Lamp 145-001

145-002 - Sterling - Star-1Light Glass Pendant Lamp 145-002

1451PS/10 - Cornerstone - Kingston 1 Light Mini Pendant In Oil Rubbed Bronze 1451PS/10

1451WS/10 - Cornerstone - Kingston 1 Light Sconce In Oil Rubbed Bronze 1451WS/10

1452BB/10 - Cornerstone - Kingston 2 Light Bath Bar In Oil Rubbed Bronze 1452BB/10

1452SF/10 - Cornerstone - Kingston 2 Light Semi-Flush In Oil Rubbed Bronze 1452SF/10

1453BB/10 - Cornerstone - Kingston 3 Light Bath Bar In Oil Rubbed Bronze 1453BB/10

1453CH/10 - Cornerstone - Kingston 3 Light Chandelier In Oil Rubbed Bronze 1453CH/10

1454BB/10 - Cornerstone - Kingston 4 Light Bath Bar In Oil Rubbed Bronze 1454BB/10

1455CH/10 - Cornerstone - Kingston 5 Light Chandelier In Oil Rubbed Bronze 1455CH/10

145643 - Pomeroy - Inferno Bowl

146ARTICGGW - Tech Lighting - Shade Artic Grande Gold/White

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