Banner1 Banner1
 
SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_12` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_name` IN ('Light Bulbs & Tubes','Lamps')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%LampsandLighting' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('LampsandLighting' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+LampsandLighting' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"LampsandLighting"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"LampsandLighting"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"LampsandLighting"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"LampsandLighting"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+LampsandLighting' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='LampsandLighting',`category_4` ='LampsandLighting') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'LampsandLighting,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('LampsandLighting', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Lamps And Lighting

Refine Search

  GO
 
Brand

OttLite(45)

Satco(21)

Bostitch(14)

BLACK+DECKER(13)

Lorell(12)

Data Accessories Company(5)

Victory Light(5)

Alba(4)

HON(2)

Kensington(1)

Ledu(1)

 
Packaged Quantity

1 Each(106)

30 / Carton(3)

4 / Pack(2)

2 / Carton(2)

6 / Carton(2)

2 / Pack(1)

1 Set(1)

10 / Carton(1)

3 / Box(1)

12 / Carton(1)

40 / Carton(1)

50 / Carton(1)

16 / Carton(1)

 
Assembly Required

No(73)

Yes(7)

 
Limited Warranty

2 Year(15)

1 Year(13)

3 Year(5)

5 Year(5)

10 Year(2)

Lifetime(1)

90 Day(1)

 
Weight (Approximate)

4 lb(3)

8.96 oz(2)

4.48 oz(2)

2.21 lb(2)

9.76 oz(2)

4.41 lb(2)

2.93 lb(1)

2 lb(1)

14.08 oz(1)

5.44 oz(1)

4 oz(1)

1.60 oz(1)

6.61 lb(1)

5.95 lb(1)

1.58 lb(1)

13.23 lb(1)

6.17 lb(1)

2.20 lb(1)

2.88 oz(1)

1.90 lb(1)

1.81 lb(1)

4.76 lb(1)

4.67 lb(1)

5 lb(1)

8.11 oz(1)

3.31 lb(1)

6.90 lb(1)

 
Diameter

1"(4)

2.1"(2)

10.2"(1)

2.4"(1)

0.6"(1)

 
Package Type

Retail(1)

 
Input Voltage

120 V AC(22)

230 V AC(6)

5 V(3)

12 V DC(3)

24 V DC(2)

5 V DC(1)

277 V AC(1)

 
USB

Yes(1)

 
Mount Type

Desk Mountable(74)

Table Top(11)

Floor-mountable(7)

Undercabinet Mountable(3)

Wall Mountable(1)

Recessed Mount(1)

Shelf Mountable(1)

Stand(1)

 
Base

E26(11)

G13(4)

GX23(2)

Fa8(1)

G5(1)

 
Bulb/Tube Type

LED(84)

CFL(3)

Fluorescent(2)

 
Maximum Bulb Power

13 W(4)

10 W(2)

7.50 W(2)

23 W(2)

32 W(2)

6.50 W(1)

12.50 W(1)

15 W(1)

25 W(1)

 
Maximum Bulb Life

25000 Hour(7)

12000 Hour(4)

15000 Hour(2)

24000 Hour(2)

30000 Hour(1)

 
Quantity Per Container

3/Box(1)

 
Color Rendering Index

82(5)

85(5)

93(3)

90(3)

95(2)

94(1)

75(1)

 
Maximum Bulb/Tube Power

10 W(8)

8 W(3)

6.50 W(3)

5 W(2)

6 W(2)

5.50 W(2)

9 W(2)

13 W(2)

5.20 W(1)

3 W(1)

7 W(1)

22 W(1)

14 W(1)

8.50 W(1)

4.60 W(1)

27 W(1)

 
Number of Bulbs/Tubes Supported

1(4)

2(1)

 
Light Output

400 lm(7)

350 lm(4)

700 lm(3)

420 lm(2)

330 lm(2)

600 lm(1)

510 lm(1)

440 lm(1)

240 lm(1)

270 lm(1)

300 lm(1)

485 lm(1)

428 lm(1)

410 lm(1)

220 lm(1)

1350 lm(1)

780 lm(1)

250 lm(1)

800 lm(1)

 
Maximum Tube Power

32 W(2)

40 W(1)

54 W(1)

28 W(1)

 
Maximum Tube Life

20000 Hour(2)

24000 Hour(2)

50000 Hour(1)

 
Number of Bulbs/Tubes Included

1(4)

2(1)

 
Manufacturer Part Number

LEDAERO N(1)

CSP9300W(1)

L1205NK9SHPR(1)

G97BGC-FFP(1)

F26WG9-SHPR(1)

F261G9-SHPR(1)

F1DY8G59SHPR(1)

F1D83BR9SHPR(1)

F1D83BN9SHPR(1)

F1485TU9SHPR(1)

F1485009-SHPR(1)

CSR7500CSHPR(1)

CSR3008C-SHPR(1)

CSR07G5WSHPR(1)

CSN85G5CSHPR(1)

S83WGW(1)

CSN8500CSHPR(1)

CSN34KCW(1)

CSN34KCCSHPR(1)

CSN30G5W(1)

CSDQA02W-SHPR(1)

CSAQA4K9SHPR(1)

CSA77WGCSHPR(1)

CSA26KUQSHPR(1)

CS59G59SHPR(1)

CS59399SHPR(1)

CS59089SHPR(1)

CS59029SHPR(1)

CS59009SHPR(1)

L1604NK9SHPR(1)

SC1AP00S(1)

CS3QN4WW(1)

S8144(1)

VS687372BN(1)

SVCA2148104B(1)

9VSL40203SC(1)

9B101AB(1)

S8458(1)

S8449(1)

S8448(1)

S8440(1)

S8424(1)

S8420(1)

S8310CT(1)

S8310(1)

S6274CT(1)

SCD0500S(1)

S6274(1)

S29918(1)

S29615CT(1)

S29615(1)

S29446(1)

S29431(1)

S29406(1)

S28578CT(1)

S28578(1)

S28563(1)

S28560(1)

SCNQC00S(1)

SCEY700S(1)

CS43828W(1)

CS336G5CSHPR(1)

LEDLUCEBC(1)

LEDUC93WK(1)

VLF100D(1)

VLED1826BBOS(1)

VLED1821WBOS(1)

VLED1813BOS(1)

VLED1812FGBD(1)

VLED1800BK(1)

VLED1510(1)

LEDUCPUCK5WK(1)

LEDUCPUCK5RG(1)

LEDUCPUCK3RG(1)

LEDUC96CCTAC(1)

LEDUC94CCTAC(1)

LEDUC9-2REC(1)

VLF100-WHT(1)

LEDUC9-2BAT(1)

LEDUC91CCTAC(1)

LEDUC241CCTA(1)

LEDUC181CCTA(1)

LED2107WHT(1)

LED2105PNK(1)

LED2104WBD(1)

LED2103(1)

KTVLED1502W(1)

2200QISMBK(1)

2200CLSMBK(1)

LEDMY(1)

LEDLUCEN(1)

VLF100F(1)

02343(1)

CS33600CSHPR(1)

99956(1)

CS03KQISHPR(1)

CS030QI-SHPR(1)

CS01SV9SHPR(1)

CS01RB9SHPR(1)

CS01KC9SHPR(1)

CS01KA9-SHPR(1)

CS01BS9SHPR(1)

CS01B19SHPR(1)

99967(1)

99966(1)

99963(1)

99957(1)

99954(1)

02353(1)

99774(1)

82020(1)

13205(1)

13202(1)

13201(1)

13200(1)

L9135(1)

K87653WW(1)

HONH870960(1)

H870942(1)

21646(1)

21634(1)

2356(1)

VS80907B(1)

 
Country of Origin

China(119)

Switzerland(3)

United States(1)

 
Height

22"(6)

24"(4)

15.5"(4)

23"(3)

20"(2)

18"(2)

12.5"(1)

4.5"(1)

12"(1)

10"(1)

11.8"(1)

60"(1)

14.8"(1)

21.3"(1)

71"(1)

26.5"(1)

17"(1)

29"(1)

54.8"(1)

58"(1)

21"(1)

65"(1)

33"(1)

1"(1)

1.3"(1)

15"(1)

16"(1)

72"(1)

48"(1)

 
Width

6"(4)

4"(4)

7.5"(3)

5.1"(3)

3"(2)

10"(2)

8.8"(1)

2.5"(1)

5"(1)

2.6"(1)

7"(1)

18"(1)

4.3"(1)

6.8"(1)

2"(1)

9"(1)

12"(1)

7.8"(1)

6.5"(1)

 
Depth

6"(4)

4"(3)

7.5"(3)

7"(3)

3"(1)

9"(1)

6.8"(1)

10"(1)

5.1"(1)

18"(1)

6.6"(1)

3.6"(1)

9.8"(1)

8.8"(1)

8.2"(1)

 
Length

47.8"(3)

4.9"(2)

4.3"(1)

96"(1)

45.8"(1)

7.1"(1)

22.6"(1)

48"(1)

 
Style

Contemporary(15)

Modern(5)

Classic(3)

Transitional(3)

Traditional(3)

Vintage(2)

 
Power Source

Electric(6)

AC Adapter(6)

USB(5)

DC Adapter(5)

AC Supply(2)

Battery(1)

 
Power Consumption

10 W(7)

8 W(3)

6.50 W(3)

5 W(2)

9 W(2)

13 W(2)

5.50 W(2)

6 W(2)

3 W(1)

5.20 W(1)

7 W(1)

2.50 W(1)

22 W(1)

14 W(1)

8.50 W(1)

4.60 W(1)

27 W(1)

 
Cord Length

6 ft(5)

9 ft(2)

 
Color Temperature

2700°K(7)

4100°K(6)

3000°K(5)

5000°K(1)

4000°K(1)

3500°K(1)

 
Light Color

Natural Daylight(23)

Warm White(22)

Natural(11)

Cool White(9)

Bright White(8)

Cool(4)

White(4)

Warm(3)

True White(1)

Yellow(1)

Natural Light(1)

Neutral White(1)

 
Bulb Shape

Parabolic Reflector(3)

Spiral(2)

Tubular(1)

U-shaped(1)

 
Lamp Type

LED(1)

 
Switch Type

Dimmer(19)

Touch(9)

On/Off(5)

Rotary(1)

 
 
 

© 2026-2027 Office Hub, All Rights Reserved