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 >= '300blv411' and catalogpartcode <= '310584' order by ref_product.catalogpartcode,ref_product.id ;

300BLV411 - Tech Lighting - MR16 - 12V - 50 Watt - 24 Beam (Ushio 10,000 hour)

300BLV412 - Tech Lighting - MR16 - 12V - 50 Watt - 12 Beam (Ushio Solid Aluminum Back)

300BLV413 - Tech Lighting - MR16 - 12V - 50 Watt - 24 Beam (Ushio Solid Aluminum Back)

300BLV414 - Tech Lighting - MR16 - 12V - 50 Watt - 39 Beam (Ushio Solid Aluminum Back)

300BLV451 - Tech Lighting - SORRA Vivid LED MR16 - MR16 - 12V - LED - 9 Watt - 24 - 2700k (95 CRI SORAA Vivid)

300BLV453 - Tech Lighting - SORRA Vivid LED MR16 - MR16 - 12V - LED - 9 Watt - 24 - 3000k (95 CRI SORAA Vivid)

300BLV461 - Tech Lighting - Bulb Gy6.35 12V 50W Xenon Clr

300BLV462 - Tech Lighting - Bulb Gy6.35 12V 50W Xenon Frs

300BLV463 - Tech Lighting - Bulb Gy6.35 24V 50W Xenon Clr

300BLV468 - Tech Lighting - BULB MR16 LED 12V 8W 36 30-18K

301507 - GuildMaster - Lake Side Candle Stand

304644 - Pomeroy - Bonnet Bowl

306112 - Pomeroy - Inca Bowl

306136 - Pomeroy - Inca Votive

306310 - Pomeroy - Maya Medium Vase In Light Grey

306396 - Pomeroy - Maya Large Vase In Light Grey

307003 - Pomeroy - Maya Medium Vase In Purple

307010 - Pomeroy - Maya Large Vase In Purple

307034 - Pomeroy - Inca Square Votive In Purple

307041 - Pomeroy - Liso Bowl

307331 - Pomeroy - Poseidon Vase

307409 - Pomeroy - Sunflower Bowl

307416 - Pomeroy - Sunflower Platter

307507 - GuildMaster - Carved Candle Stands - Carved Candle Stand

307607 - Pomeroy - Maya Large Vase In Red

307645 - Pomeroy - Rhea Vase In Red

308116 - Pomeroy - Lisboa Candlestick 16-Inch

308123 - Pomeroy - Lisboa Candlestick 21.5-Inch

308185 - Pomeroy - Sunflower Vase

308192 - Pomeroy - Rhea Vase In Nautical Blue

308253 - Pomeroy - Solis 2.9 Gallon Beverage Server

308376 - Pomeroy - Edison Vase 17.9-Inch

308383 - Pomeroy - Edison Vase 11.5-Inch

308420 - Pomeroy - Relin Bowl

308437 - Pomeroy - Vortizan 19-Inch Plate In Honey

308444 - Pomeroy - Vortizan 19.5-Inch Bowl In Honey

308451 - Pomeroy - Inca Chip & Dip

308529 - Pomeroy - Pandora Tray Small

308536 - Pomeroy - Pandora Tray

308543 - Pomeroy - Pandora Deep Bowl

308567 - Pomeroy - Rhea Vase - Large

308581 - Pomeroy - Pandora Triple Server

308598 - Pomeroy - Pandora 4 Server

308604 - Pomeroy - Vortizan 19-Inch Plate In Basic Turquoise

308611 - Pomeroy - Vortizan 19.5-Inch Bowl In Basic Turquoise

308666 - Pomeroy - Adura Vase In Juniper

3100-001 - Sterling - Jinkoh Chest - Tall

3100-002/S2 - Sterling - Jinkoh Trunks

3100-003 - Sterling - Jinkoh Cabinet

3100-004 - Sterling - Jinkoh Chest - Short

3100-005 - Sterling - Jinkoh Server

3100-006 - Sterling - Classical Arch Top Mirror

3100-007 - Dimond Home - Copper Frame Mirror

3100-008 - Dimond Home - Copper Frame Clock

3100-009 - Dimond Home - Gold Stripe Copper Cabinet

3100-011 - Dimond Home - Copper Frame Mirror With Nail Head

3100-012 - Dimond Home - Copper Frame Mirror With Gold

3100-013 - Sterling - Pulse Sculpture In Dark Bronze

3100-014 - Sterling - Pulse Accent Table In Dark Bronze

3100-015/S2 - Sterling - Moya Aged Iron Set of 2 Metal and Concrete Accent Tables

310126 - Pomeroy - Inca Square Bowl

310133 - Pomeroy - Rhea Vase - Small

310157 - Pomeroy - Maya Extra Large Vase In Recycled Glass

310164 - Pomeroy - Maya Extra Large Vase In Dark Brown

310171 - Pomeroy - Pandora Round Tray

310195 - Pomeroy - Maya Medium Vase In Orange

310218 - Pomeroy - Lucas Bottle

310256 - Pomeroy - Galen Bottle

310317 - Pomeroy - Helena Bottle

310324 - Pomeroy - Inca Square Votive In Aroma Shiny Blue

310331 - Pomeroy - Inca Square Votive In Red

31036/1 - Dimond Lighting - Skyline Table Lamp in Polished Stainless Steel

31036/1-LED - Dimond Lighting - Skyline 1 Light Portable LED Lamp In Polished Stainless Steel

310416 - Pomeroy - Celesta Vase 10.125-Inch

310423 - Pomeroy - Celesta Vase 14.375-Inch

310430 - Pomeroy - Caldas Bottle 12.5-Inch

310447 - Pomeroy - Caldas Bottle 14.75-Inch

310454 - Pomeroy - Caldas Bottle 20-Inch

310560 - Pomeroy - Celesta Vase 14.5-Inch

310584 - Pomeroy - Melina Vase 17.625-Inch

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