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 >= '160rhngbb' and catalogpartcode <= '163-006' order by ref_product.catalogpartcode,ref_product.id ;

160RHNGBB - Tech Lighting - Rhonan Grande shade black/black

160RHNGWW - Tech Lighting - Rhonan Grande shade white/white

160RHNULABB - Tech Lighting - Shade Rhonan Black/Black

160RHNULAGW - Tech Lighting - Shade Rhonan Gold/White

160RHNULAWW - Tech Lighting - Shade Rhonan White/White

160RYKERA - Tech Lighting - Shade Ryker Pendant Lg B. Alum

160RYKERG - Tech Lighting - Shade Ryker Pendant Lg Gold

160RYKERSA - Tech Lighting - Shade Ryker Pendant Sm B.Alm

160RYKERW - Tech Lighting - Shade Ryker Pendant Lg White

160RYKERY - Tech Lighting - Shade Ryker Pendant Lg Grey

160SC4XBAR - Tech Lighting - SCREW-LESS 4 CNPY CROSSBAR

160SCFFJCB - Tech Lighting - SCW-LS CNPY FEMALE FJ CAP BLK

160SCFFJCC - Tech Lighting - SCW-LS CNPY FEMALE FJ CAP CHR

160SCFFJCS - Tech Lighting - SCW-LS CNPY FEMALE FJ CAP S.N

160SCFFJCW - Tech Lighting - SCW-LS CNPY FEMALE FJ CAP WHT

160SCFFJCZ - Tech Lighting - SCW-LS CNPY FEMALE FJ CAP A.B

160SKY08BK - Tech Lighting - Sky - 8 Inch Black - Replacement Component

160SKY08CP - Tech Lighting - Sky - 8 Inch Copper - Replacement Component

160SKY08SN - Tech Lighting - Sky - 8 Inch Satin Nickel - Replacement Component

160SKY12BK - Tech Lighting - Sky - 12 Inch Black - Replacement Component

160SKY12CP - Tech Lighting - Sky - 12 Inch Copper - Replacement Component

160SUMLSN - Tech Lighting - Summit - Large - Replacement Component

160SUMSSN - Tech Lighting - Summit - Small - Replacement Component

160TDKARAMLBK - Tech Lighting - Td Shade Karam Lrg Black

160TDKARAMLCT - Tech Lighting - Td Shade Karam Lrg Concrete

160TDKARAMSBK - Tech Lighting - Td Shade Karam Sm Black

160TDKARAMSCT - Tech Lighting - Td Shade Karam Sm Concrete

160TDRONSS - Tech Lighting - Meridian Small - Sm. Roundel Satin Nickel - Replacement Component

160TDSISHB - Tech Lighting - Siesta - Black Shade

160TDSISHW - Tech Lighting - Siesta - White Shade

160TUBEPAB - Tech Lighting - Piper - Antique Bronze - Replacement Component

160TUBEPBL - Tech Lighting - Piper - Black - Replacement Component

160TUBEPCH - Tech Lighting - Piper - Chrome - Replacement Component

160TUBEPSN - Tech Lighting - Piper - Satin Nickel - Replacement Component

160TUBEPWH - Tech Lighting - Piper - White - Replacement Component

160WDSBK - Tech Lighting - Windsor shade matte black

160WDSCT - Tech Lighting - Windsor shade matte concrete

160WDSSN - Tech Lighting - Windsor shade satin nickel

161-001 - Dimond Home - Retro Round Back Leather Lounger

161-002 - Dimond Home - Industrial Bar Stool

161-003 - Dimond Home - Industrial Arm Chair

161-004 - Dimond Home - Goatskin Tuft Side Chair

161-005 - Dimond Home - Goatskin Leather Lounger

161-006 - Dimond Home - Goatskin Leather Ottoman

161-007 - Dimond Home - Angular Modern Lounge Chair

161521 - GuildMaster - Guest Cottage

161704S - GuildMaster - Ladies By The Lake

162-001 - Dimond Home - Teak Furniture - Natural Teak Stacking Tables

162-002 - Dimond Home - Teak Furniture - Teak Nesting Tables

162-003 - Dimond Home - Teak Furniture - Teak Table With Angular Base

162-004 - Dimond Home - Teak Furniture - Hammered Decorative Teak Table in Gold

162-005 - Dimond Home - Teak Furniture - Hammered Decorative Teak Table In Silver

162-010 - Dimond Home - Teak Root Bowl With Aluminum Insert - Long

162-011 - Dimond Home - Teak Root Bowl With Aluminum Insert - Short

162-012 - Dimond Home - Teak Root Bowl With Copper Insert - Long

162-013 - Dimond Home - Teak Root Bowl With Copper Insert - Short

162-014 - Dimond Home - Round Teak Bowl With Aluminum Insert - Large

162-015 - Dimond Home - Round Teak Bowl With Aluminum Insert - Medium

162-016 - Dimond Home - Round Teak Bowl With Aluminum Insert - Small

162-017/S3 - Dimond Home - Teak Wood Mirror

162-020 - Dimond Home - Small Teak Bowl

162-021 - Dimond Home - Decorative Teak Whale Bone

162-022 - Dimond Home - Teak Furniture - Natural Teak Slab Bar

162-023 - Sterling - Swivel Barstool 162-023

162-024 - Dimond Home - Amoeba Aluminum Stool

162-025 - Dimond Home - Teak Furniture - Teak Strapped Coffee Table

162-026 - Dimond Home - Teak Furniture - Teak Pyramid Table

162-027 - Dimond Home - Teak Furniture - Teak Root Console

162-029 - Dimond Home - Teak Furniture - Bundled Teak Root Console

162002 - GuildMaster - Global Graphics II

162027 - GuildMaster - Midnight Fog

162029 - GuildMaster - Beachscape

162514 - GuildMaster - River Boat

162530 - GuildMaster - The Sea Horse

163-001 - Dimond Home - Mosaic Glass Mirror

163-002 - Dimond Home - Vibrant Multi Starburst Mirror

163-003 - Dimond Home - Earth Multi Starburst Wall Mirror

163-004 - Dimond Home - Round Twig Mirror

163-005 - Dimond Home - Flower Arc Shell Mirror

163-006 - Dimond Home - Cross Hatch Shell Mirror

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