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 >= '300blv358' and catalogpartcode <= '31013/3' order by ref_product.catalogpartcode,ref_product.id ;

300BLV358 - Tech Lighting - Bulb,Bi-Pin G4 24V 20W Xenon

300BLV359 - Tech Lighting - Bulb,Gy6.35 12V 35W Xenon Clr

300BLV360 - Tech Lighting - Bulb,Gy6.35 24V 35W Xenon Clr

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

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)

300BLV454 - Tech Lighting - SORRA Vivid LED MR16 - MR16 - 12V - LED - 9 Watt - 36 - 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

301507 - GuildMaster - Lake Side Candle Stand

303W/S2 - Lamp Works - Luna Glass Table Lamp In White

303W/S2-LED - Lamp Works - Luna Glass LED Table Lamp In White

304644 - Pomeroy - Bonnet Bowl

305C - Lamp Works - River Rock With Night Light In Cream

306112 - Pomeroy - Inca Bowl

306136 - Pomeroy - Inca Votive

306310 - Pomeroy - Maya Medium Vase In Light Grey

306396 - Pomeroy - Maya Large Vase In Light Grey

306B - Lamp Works - River Rock With Night Light In Brown

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

307C/S2 - Lamp Works - Blown Glass Oval Table Lamp In Cream - Set of 2

307C/S2-LED - Lamp Works - Blown Glass Oval LED Table Lamp In Cream - Set of 2

307G/S2 - Lamp Works - Blown Glass Oval Table Lamp In Grey - Set of 2

307G/S2-LED - Lamp Works - Blown Glass Oval LED Table Lamp In Grey - Set of 2

308 - Lamp Works - White Marble Base Arc Desk Lamp

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

31-88843-PC - Lux Source - Prima Cable Rigid Stem Support Standoffs - 4 Inch length

310 - Lamp Works - White Marble Base Arc Floor Lamp

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

31006/5 - ELK Lighting - New York 5 Light Chandelier In Renaissance Silver Leaf

31007/3 - ELK Lighting - New York 3 Light Semi Flush In Renaissance Silver Leaf

31010/1 - ELK Lighting - New York 1 Light Wall Sconce In Renaissance Silver Leaf

310126 - Pomeroy - Inca Square Bowl

31013/3 - ELK Lighting - New York 3 Light Chandelier In Renaissance Silver Leaf

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