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 >= 'bv2242-10-15' and catalogpartcode <= 'bv6t5-10-16m' order by ref_product.catalogpartcode,ref_product.id ;

BV2242-10-15 - Alico - Adam 2 Light Vanity In Chrome And White Opal Glass

BV2243-10-15 - Alico - Adam 3 Light Vanity In Chrome And White Opal Glass

BV2244-10-15 - Alico - Adam 4 Light Vanity In Chrome And White Opal Glass

BV2311-0-15 - Alico - Chastain 1 Light Vanity In Chrome And Clear Glass

BV2312-0-15 - Alico - Chastain 2 Light Vanity In Chrome And Clear Glass

BV2313-0-15 - Alico - Chastain 3 Light Vanity In Chrome And Clear Glass

BV2411-10-15 - Alico - Alton Road 1 Light Vanity In Chrome And Opal Glass

BV2412-10-15 - Alico - Alton Road 2 Light Vanity In Chrome And Opal Glass

BV2413-10-15 - Alico - Alton Road 3 Light Vanity In Chrome And Opal Glass

BV2414-10-15 - Alico - Alton Road 4 Light Vanity In Chrome And Opal Glass

BV281-10-15 - Alico - Moderno 1 Light Sconce In Chrome And White Opal Glass

BV281-10-16M - Alico - Moderno 1 Light Sconce In Matte Satin Nickel And White Opal Glass

BV3001-0-15 - Alico - Tiara 1 Light Vanity In Chrome And Slotted Clear Glass

BV3002-0-15 - Alico - Tiara 2 Light Vanity In Chrome And Slotted Clear Glass

BV3003-0-15 - Alico - Tiara 3 Light Vanity In Chrome And Slotted Clear Glass

BV3004-0-15 - Alico - Tiara 4 Light Vanity In Chrome And Slotted Clear Glass

BV301-90-15 - Alico - Circo 1 Light Vanity In Chrome And Polished Clear Glass

BV302-90-15 - Alico - Circo 2 Light Vanity In Chrome And Polished Clear Glass

BV303-90-15 - Alico - Circo 3 Light Vanity In Chrome And Polished Clear Glass

BV304-90-15 - Alico - Circo 4 Light Vanity In Chrome And Polished Clear Glass

BV311-90-15 - Alico - Quatra 1 Light Vanity In Chrome And Clear Glass

BV312-90-15 - Alico - Quatra 2 Light Vanity In Chrome And Clear Glass

BV313-90-15 - Alico - Quatra 3 Light Vanity In Chrome And Clear Glass

BV314-90-15 - Alico - Quatra 4 Light Vanity In Chrome And Clear Glass

BV331-10-15 - Alico - Pannelli Arc 2 Light Sconce In Chrome And White Opal Glass

BV331-10-16M - Alico - Pannelli Arc 2 Light Sconce In Satin Nickel And White Opal Glass

BV3321-10-15 - Alico - Gemelo 1 Light Vanity In Chrome And White Opal Glass

BV3322-10-15 - Alico - Gemelo 2 Light Vanity In Chrome And White Opal Glass

BV3323-10-15 - Alico - Gemelo 3 Light Vanity In Chrome And White Opal Glass

BV3324-10-15 - Alico - Gemelo 4 Light Vanity In Chrome And White Opal Glass

BV351-5-15 - Alico - Devon 1 Light Vanity In Chrome With Opal Glass Lens

BV352-5-15 - Alico - Devon 2 Light Vanity In Chrome With Opal Glass Lens

BV353-5-15 - Alico - Devon 3 Light Vanity In Chrome With Opal Glass Lens

BV354-5-15 - Alico - Devon 4 Light Vanity In Chrome With Opal Glass Lens

BV361-0-15 - Alico - Somerset 2 Light Vanity In Crystal Glass And Chrome

BV362-0-15 - Alico - Somerset 3 Light Vanity In Crystal Glass And Chrome

BV363-0-15 - Alico - Somerset 4 Light Vanity In Crystal Glass And Chrome

BV4001-0-15 - Alico - Sprocket 1 Light Vanity In Chrome And Clear Sprocket Cut Glass

BV4002-0-15 - Alico - Sprocket 2 Light Vanity In Chrome And Clear Sprocket Cut Glass

BV4003-0-15 - Alico - Sprocket 3 Light Vanity In Chrome And Clear Sprocket Cut Glass

BV4004-0-15 - Alico - Sprocket 4 Light Vanity In Chrome And Clear Sprocket Cut Glass

BV5001-10-15 - Alico - Crystal 1 Light Vanity In Chrome And White Opal Glass With Crystal Arm Detail

BV5002-10-15 - Alico - Crystal 2 Light Vanity In Chrome And White Opal Glass With Crystal Arm Detail

BV5003-10-15 - Alico - Crystal 3 Light Vanity In Chrome And White Opal Glass With Crystal Arm Detail

BV5004-10-15 - Alico - Crystal 4 Light Vanity In Chrome And White Opal Glass With Crystal Arm Detail

BV511-10-15 - Alico - Ombra 1 Light Vanity In Chrome And White Opal Glass

BV511-10-16P - Alico - Ombra 1 Light Vanity In Satin Nickel And White Opal Glass

BV512-10-15 - Alico - Ombra 2 Light Vanity In Chrome And White Opal Glass

BV512-10-16P - Alico - Ombra 2 Light Vanity In Satin Nickel And White Opal Glass

BV513-10-15 - Alico - Ombra 3 Light Vanity In Chrome And White Opal Glass

BV513-10-16P - Alico - Ombra 3 Light Vanity In Satin Nickel And White Opal Glass

BV514-10-15 - Alico - Ombra 4 Light Vanity In Chrome And White Opal Glass

BV514-10-16P - Alico - Ombra 4 Light Vanity In Satin Nickel And White Opal Glass

BV5501-10-15 - Alico - Embro 1 Light Vanity In Chrome And Oval White Opal Glass

BV5502-10-15 - Alico - Embro 2 Light Vanity In Chrome And Oval White Opal Glass

BV5503-10-15 - Alico - Embro 3 Light Vanity In Chrome And Oval White Opal Glass

BV5504-10-15 - Alico - Embro 4 Light Vanity In Chrome And Oval White Opal Glass

BV6021-10-15 - Alico - Toby 1 Light Vanity In Chrome And White Opal Glass

BV6021-10-16M - Alico - Toby 1 Light Vanity In Satin Nickel And White Opal Glass

BV6022-10-15 - Alico - Toby 2 Light Vanity In Chrome And White Opal Glass

BV6022-10-16M - Alico - Toby 2 Light Vanity In Satin Nickel And White Opal Glass

BV6023-10-15 - Alico - Toby 3 Light Vanity In Chrome And White Opal Glass

BV6023-10-16M - Alico - Toby 3 Light Vanity In Satin Nickel And White Opal Glass

BV6024-10-15 - Alico - Toby 4 Light Vanity In Chrome And White Opal Glass

BV6024-10-16M - Alico - Toby 4 Light Vanity In Satin Nickel And White Opal Glass

BV6031-10-15 - Alico - Barro 1 Light Vanity In Chrome And White Opal Glass

BV6032-10-15 - Alico - Barro 2 Light Vanity In Chrome And White Opal Glass

BV6033-10-15 - Alico - Barro 3 Light Vanity In Chrome And White Opal Glass

BV6034-10-15 - Alico - Barro 4 Light Vanity In Chrome And White Opal Glass

BV671-90-15 - Alico - Tubolaire 1 Light Sconce In Chrome With Clear Outer Glass And Frosted Interior Glass

BV6T1-10-15 - Alico - Pandora 1 Light Vanity In Chrome And White Opal Glass

BV6T1-10-16M - Alico - Pandora 1 Light Vanity In Satin Nickel And White Opal Glass

BV6T2-10-15 - Alico - Pandora 2 Light Vanity In Chrome And White Opal Glass

BV6T2-10-16M - Alico - Pandora 2 Light Vanity In Satin Nickel And White Opal Glass

BV6T3-10-15 - Alico - Pandora 3 Light Vanity In Chrome And White Opal Glass

BV6T3-10-16M - Alico - Pandora 3 Light Vanity In Satin Nickel And White Opal Glass

BV6T4-10-15 - Alico - Pandora 4 Light Vanity In Chrome And White Opal Glass

BV6T4-10-16M - Alico - Pandora 4 Light Vanity In Satin Nickel And White Opal Glass

BV6T5-10-15 - Alico - Pandora 5 Light Vanity In Chrome And White Opal Glass

BV6T5-10-16M - Alico - Pandora 5 Light Vanity In Polished Matte Nickel And White Opal Glass

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