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 >= 'g-887sb' and catalogpartcode <= 'h860w-c/cc' order by ref_product.catalogpartcode,ref_product.id ;

G-887SB - LBL Lighting - Glass Mini Miyu steel blue

G-888OP - LBL Lighting - Mini Miyu inner glass white

G-888OP - Tech Lighting - Inner White Glass

G-889FR - LBL Lighting - GLASS BRIOLETTE frost

G-889SM - LBL Lighting - GLASS BRIOLETTE smoke

G-935BU - LBL Lighting - Glass Monty Susp Blue

G-935MO - LBL Lighting - Glass Monty Susp Mocha

G-935OP - LBL Lighting - Glass Monty Susp Opal

G-935RD - LBL Lighting - Glass Monty Susp Red

G-936MO - LBL Lighting - Glass Monty Wall Mocha

G-936OP - LBL Lighting - Glass Monty Wall Opal

G-936RD - LBL Lighting - Glass Monty Wall Red

G-942CR - LBL Lighting - Karif glass clear

G-942OP - LBL Lighting - Karif glass opan

G-942SM - LBL Lighting - Karif glass smoke

G-953-SM - LBL Lighting - Smoke glass

G-953-WH - LBL Lighting - Clear glass

G-994-WH - LBL Lighting - White case/clear

G-AP10AM - LBL Lighting - Glass Bora Wall Amber

G-AP10OP - LBL Lighting - Glass Bora Wall Opal

G-AP11AM - LBL Lighting - Glass Iris Wall Amber

G-AP12AM - LBL Lighting - Glass Zeffiro Wall Amber

G-AP12OP - LBL Lighting - Glass Zeffiro Wall Opal

G-AP13OP - LBL Lighting - Glass Aliseo Wall Opal

G-AP14OP - LBL Lighting - Glass Mistral Wall Opal

G-AP19OC - LBL Lighting - Glass Taitu Wall Opal

G-AP24AM - LBL Lighting - Glass Wave Wall Amber

G-AP24OP - LBL Lighting - Glass Wave Wall Opal

G-LF6110-LG - LBL Lighting - Large Outer Frosted Glass

G-LF6110CONE - LBL Lighting - Inner Cone Frosted Glass

G-SL1851 - LBL Lighting - Glass, Baybridge Frost

G-TWINTUBE - LBL Lighting - Glass Twin Tube Frost

G13038 - LBL Lighting - Glass Nikko Frost

G13075 - LBL Lighting - Glass Maro Frost

G13075 - Tech Lighting - Glass Maro Frost

G13099 - LBL Lighting - Glass Eko 25 Frost

G13131 - LBL Lighting - Glass Tartaruga Oval 200 Frost

G13131 - Tech Lighting - Glass Tartaruga Oval 200 Frost

G13147 - LBL Lighting - Glass Eko 20 Frost

G13185 - LBL Lighting - Glass Tartaruga Oval 60 Frost

G13185 - Tech Lighting - Glass Tartaruga Oval 60 Frost

G13187 - LBL Lighting - Glass Tartaruga Rnd 100 Frost

G13187 - Tech Lighting - Glass Tartaruga Rnd 100 Frost

G13189 - LBL Lighting - Glass Tartaruga Round 200 Frst

G13189 - Tech Lighting - Glass Tartaruga Round 200 Frst

G13193 - LBL Lighting - Glass Tartaruga Oval 150 Frost

G13193 - Tech Lighting - Glass Tartaruga Oval 150 Frost

G13210 - LBL Lighting - Glass Superdelta Tondo Frost

G13253 - LBL Lighting - Glass Chip Oval 30 Frost

G13255 - LBL Lighting - Glass Chip Round 25 Frost

G13257 - LBL Lighting - Glass Chip Round 30 Frost

G13284 - LBL Lighting - Glass Polo 3 Frost

G966 - Monte Carlo - Glass - Antique - White - Scavo

GB1GR - LBL Lighting - Glass Confuzion Green

GB1RD - LBL Lighting - Glass Confuzion Red

GLS-TUBE-CVR - LBL Lighting

GLS-TUBE-CVR-2 - LBL Lighting - bulb shield w/metal base (Athena Wall, etc.)

GU24/18 - LBL Lighting - GU24 - Compact Fluorescent Bulb - 18 Watt 2700K

GU24/32 - LBL Lighting - GU24 - Compact Fluorescent Bulb - 32 Watt 2700K

GU24/42 - LBL Lighting - GU24 - Compact Fluorescent Bulb - 42 Watt 2700K

H105 - LBL Lighting - Bulb,E26 120V 60W S21 Sq Cag Cl

H107 - LBL Lighting - Bulb Mb A21 19W 120V Led

H200 - LBL Lighting - MB BT15 60W 120V Soft White Halogen Bulb

H205 - LBL Lighting - Bulb, E26 Par20 39W 30 120V

H250 - LBL Lighting - Bulb Mb Par20 7W 120V LED

H251 - LBL Lighting - Bulb Mb Par30L 13W 120V LED

H335CL - LBL Lighting - Halogen Bi-Pin Lamps - 12V 35W Halogen Clear - GY6.35

H335CL/24V - LBL Lighting - Halogen Bi-Pin Lamps - 24V 35W Halogen Clear - GY6.35

H420/24V - LBL Lighting - Xenon Bi-Pin Lamps - G4 24Volt 20Watt Clear

H420XCL - LBL Lighting - Xenon Bi-pin

H435XCL - LBL Lighting - Xenon Bi-pin

H435XFR - LBL Lighting - Xenon Bi-Pin Lamps - GY6.35 12Volt 35Watt Frosted

H450 - LBL Lighting - Xenon Bi-pin

H450XFR - LBL Lighting - Xenon Bi-Pin Lamps - GY6.35 12Volt 50Watt Frosted

H4WH-L - Monte Carlo - Light Fitter - 4 - Light

H685 - LBL Lighting - E11 / Mini-Candelabra Halogen Bulbs - E11 130V 100W Halogen Clear

H695 - LBL Lighting - E11 / Mini-Candelabra Halogen Bulbs - E11 130V 250W Halogen Clear

H704 - LBL Lighting - Double Ended Halogen Bulbs - R7S 130V 100W 78MM Halogen Clear

H706 - LBL Lighting - Double Ended Halogen Bulbs - R7S 130V 100W 118MM Halogen Clear

H860W-C/CC - LBL Lighting - MR16 Constant CRI

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