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 >= '525377' and catalogpartcode <= '551468' order by ref_product.catalogpartcode,ref_product.id ;

525377 - Pomeroy - Rockport Extra Large Starfish

525391 - Pomeroy - Textured Starfish

525506 - Pomeroy - Monticello Pillar Holder - Small

525513 - Pomeroy - Monticello Pillar Holder - Medium

525520 - Pomeroy - Monticello Pillar Holder - Large

525575 - Pomeroy - Monticello Mantle Hurricane - Small

525582 - Pomeroy - Monticello Mantle Hurricane Large

525643 - Pomeroy - Marin Centerpiece

526107 - Pomeroy - Timberline Pillar Holder 12.6-Inch

526114 - Pomeroy - Timberline Pillar Holder 15.5-Inch

526121 - Pomeroy - Timberline Pillar Holder 19-Inch

5261WS/10 - Cornerstone - Wall Sconces - 1 Light Sconce In Oil Rubbed Bronze And White Opal Glass 5261WS/10

5261WS/27 - Cornerstone - Wall Sconces - 1 Light Sconce In Stainless Steel And White Opal Glass 5261WS/27

5261WS/30 - Cornerstone - Wall Sconces - 1 Light Sconce In Chrome And White Opal Glass 5261WS/30

5271WS/10 - Cornerstone - Wall Sconces - 1 Light Sconce In Oil Rubbed Bronze And Honey Alabaster Glass 5271WS/10

5271WS/27 - Cornerstone - Wall Sconces - 1 Light Sconce In Stainless Steel And White Alabaster Glass 5271WS/27

5281WS/10 - Cornerstone - Wall Sconces - 1 Light Sconce In Oil Rubbed Bronze 5281WS/10

5281WS/27 - Cornerstone - Wall Sconces - 1 Light Sconce In Satin Nickel 5281WS/27

5281WS/30 - Cornerstone - Wall Sconces - 1 Light Sconce In Chrome 5281WS/30

5291WS/30 - Cornerstone - Wall Sconces - 1 Light Sconce In Chrome And White Opal Glass 5291WS/30

53-1160M - Sterling - Natural Birch Bark Mirror

53-8105M - Sterling - Portsmouth Mirror

53-8502 - Sterling - Round Mirrors On Rope - Set of 2

53-8503 - Sterling - Oval Mirrors On Rope - Set of 2

541117 - Pomeroy - Fiore Vase 15.75-Inch

541124 - Pomeroy - Fiore Vase 19.25-Inch

541131 - Pomeroy - Valorien Centerpiece

545009 - Pomeroy - Templo Vessel

545023 - Pomeroy - Templo Bowl

545047 - Pomeroy - Templo Vase

545160 - Pomeroy - Tanner Centerpiece

545191 - Pomeroy - Mission 5 Votive Lighting Bar

545207 - Pomeroy - Santiago Centerpiece

545214 - Pomeroy - Bandera Centerpiece

545221 - Pomeroy - Cordero Centerpiece

549007/S4 - Pomeroy - Taos Set of 4 Planters

549014/S2 - Pomeroy - Arlo 10-Inch Vases - Set of 2

549021 - Pomeroy - Arlo 12-Inch Vase

549045/S4 - Pomeroy - Milo Set of 4 Planters

549052/S2 - Pomeroy - Holden Set of 2 Planters

549069 - Pomeroy - Holden Vase

549120/S4 - Pomeroy - Astria Set of 4 Planters

55-0005M - Sterling - Victoria Starburst Beveled Mirror

55-0027M - Sterling - Ruffled Oval Mirror

55-0062M - Sterling - Centauri Starburst Beveled Mirror

55-211 - Sterling - Willow Brook Beveled Mirror

55-213 - Sterling - Abberley Beveled Mirror

55-214 - Sterling - Woodside Beveled Mirror

55-216 - Sterling - Brackenhead Mirror

55-217 - Sterling - Harolds Grange Beveled Mirror

5501BB/10 - Cornerstone - Shelburne 1 Light Bathbar In Oil Rubbed Bronze 5501BB/10

5501BB/20 - Cornerstone - Shelburne 1 Light Bathbar In Brushed Nickel 5501BB/20

5501BB/30 - Cornerstone - Shelburne 1 Light Bathbar In Chrome 5501BB/30

5502BB/10 - Cornerstone - Shelburne 2 Light Bathbar In Oil Rubbed Bronze 5502BB/10

5502BB/20 - Cornerstone - Shelburne 2 Light Bathbar In Brushed Nickel 5502BB/20

5502BB/30 - Cornerstone - Shelburne 2 Light Bathbar In Chrome 5502BB/30

5503BB/10 - Cornerstone - Shelburne 3 Light Bathbar In Oil Rubbed Bronze 5503BB/10

5503BB/20 - Cornerstone - Shelburne 3 Light Bathbar In Brushed Nickel 5503BB/20

5503BB/30 - Cornerstone - Shelburne 3 Light Bathbar In Chrome 5503BB/30

5504BB/10 - Cornerstone - Shelburne 4 Light Bathbar In Oil Rubbed Bronze 5504BB/10

5504BB/20 - Cornerstone - Shelburne 4 Light Bathbar In Brushed Nickel 5504BB/20

5504BB/30 - Cornerstone - Shelburne 4 Light Bathbar In Chrome 5504BB/30

551222 - Pomeroy - Leif Vase Small

551246 - Pomeroy - Leif Round Vase

551253 - Pomeroy - Virginia Planter Round

551260 - Pomeroy - Virginia Vase Small

551277 - Pomeroy - Virginia Vase - Large

551307 - Pomeroy - Malaya Planter

551314 - Pomeroy - Malaya Vase 15.5-Inch

551321 - Pomeroy - Malaya Vase 25.75-Inch

551338 - Pomeroy - Malaya Vase 34.875-Inch

551345 - Pomeroy - Malaya Umbrella Stand

551352 - Pomeroy - Malaya S2 Bowls

551369 - Pomeroy - Malaya Garden Stool

551406 - Pomeroy - Leif Umbrella Stand

551413 - Pomeroy - Leif Rectangle Planter

551437 - Pomeroy - Cherub Garden Statue

551444 - Pomeroy - Cottontail Catchpot

551451 - Pomeroy - Lark Catchpot

551468 - Pomeroy - Porter Set of 2 Pots

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