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

140TDSPBRD - Tech Lighting - Spirit - Glass Ball Red - Replacement Component

140TDSPIFR - Tech Lighting - Spirit - Glass Inverted Frost Wht - Replacement Component

140TDSPILB - Tech Lighting - Spirit - Glass Inverted Blue-Violet - Replacement Component

140TDSPILG - Tech Lighting - Spirit - Glass Inverted Lime Green - Replacement Component

140TDSPIML - Tech Lighting - Spirit - Glass Inverted Multicolor - Replacement Component

140TDSPIOR - Tech Lighting - Spirit - Glass Inverted Orange - Replacement Component

140TDSPIRD - Tech Lighting - Spirit - Glass Inverted Ferrari Red - Replacement Component

140TDSQDIF - Tech Lighting - Chambers Ceiling Large - Lg. Sq. Diffuser - Replacement Component

140TDSUSAM - Tech Lighting - Suspense - Amber - Replacement Component

140TDSUSBL - Tech Lighting - Suspense - Sea Blue - Replacement Component

140TDSUSLA - Tech Lighting - Suspense - Lavender - Replacement Component

140TEKLACL - Tech Lighting - Glass Tekla Pend Clear

140TELESLW - Tech Lighting - Telesto Ceiling - Lrg. - Replacement Component

140TELESSW - Tech Lighting - Telesto Ceiling - Sm. - Replacement Component

140TIBORCB - Tech Lighting - Glass Assem,Tibor Clear Black

140TIBORCS - Tech Lighting - Glass Assem,Tibor Clear S.Nkl

140TRACECR - Tech Lighting - Trace Suspension - Crystal - Replacement Component

140TSGLASS - Tech Lighting - Lynx - Frost - Replacement Component

140TUSKFR - Tech Lighting - Tusk - Frost - Replacement Component

140VEILPBR - Tech Lighting - Veil - Brown - Replacement Component

140VENTSIW - Tech Lighting - Glass, Ventana Small Inner Glass

140VINOAM - Tech Lighting - Vino - Amber - Replacement Component

140VINOCB - Tech Lighting - Vino - Blue - Replacement Component

140VINORD - Tech Lighting - Vino - Red - Replacement Component

140VINOWH - Tech Lighting - Vino - Frost - Replacement Component

140VORLIWH - Tech Lighting - Vorlage Inner Glass

140VORLOSD - Tech Lighting - Vorlage Sterling Silver / Duomo

140VORLOYH - Tech Lighting - Vorlage Charcoal Gray / Honey Comb

140WAFFLL - Tech Lighting - Waffle - Latte - Replacement Component

140WAFFLW - Tech Lighting - Waffle - Frost - Replacement Component

140WCACOMF - Tech Lighting - Acorn Wall Glass - Frost

140WCACORW - Tech Lighting - Glass,Wc Acorn School White

140WCCONGA - Tech Lighting - Glass, Wc Congress Amber

140WCCONGP - Tech Lighting - Glass,Wc Congress Prismatic

140WCDEARA - Tech Lighting - Dearborn Amber

140WCGLOBP - Tech Lighting - Glass Clear

140WCGROVW - Tech Lighting - Grove Wall White Glass

140WCLASIW - Tech Lighting - Glass,Wc Lasalle Inner Wht

140WCLINDW - Tech Lighting - Glass,Wc Linden White

140WCMACOW - Tech Lighting - Glass,Wc Mini-Acorn Frost

140WCMCLYBC - Tech Lighting - Glass,Wc Mini-Clybourn Prs Clr

140WCMCLYBF - Tech Lighting - Glass,Wc Mini-Clybourn Frost

140WCMDELA - Tech Lighting - Glass,Wc Mini-Delaware Amber

140WCMHALSC - Tech Lighting - Glass,Wc Mini-Halsted Prsm Clr

140WCMHALSF - Tech Lighting - Glass,Wc Mini-Halsted Frost

140WCMISSA - Tech Lighting - Glass,Wc Mission Amber

140WCMISSF - Tech Lighting - Glass,Wc Mission Frost

140WCMMISA - Tech Lighting - Glass,Wc Mini-Mission Amber

140WCMONRL - Tech Lighting - Glass,Wc Monroe Latte

140WCMTAVW - Tech Lighting - Glass,Wc Mini-Tavern White

140WCPRINA - Tech Lighting - Printers Row Amber

140WCPRINP - Tech Lighting - Printers Row Clear

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

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