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_36` 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_id` IN ('836')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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 '%Flashlights' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Flashlights' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Flashlights' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Flashlights"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Flashlights"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Flashlights"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Flashlights"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Flashlights' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Flashlights',`category_4` ='Flashlights') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Flashlights,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Flashlights', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Flashlights

Refine Search

  GO
 
Brand

Streamlight(19)

Pelican(19)

Energizer(18)

Maglite(17)

Rayovac(13)

DORCY(4)

Bright Star(2)

Life+Gear(2)

Eveready(2)

 
Color

Chrome(2)

Yellow(1)

Red(1)

Blue(1)

 
Height

6.2"(1)

 
Color(s)

Black(43)

Yellow(15)

Yellow/Black(5)

Red(4)

Silver(3)

Blue(3)

Assorted(3)

Orange(2)

Gray(2)

Orange/Black(2)

Titanium(1)

Red/Black(1)

Blue, Red or Yellow—Color is Chosen Randomly(1)

Lime(1)

Chrome(1)

Silver/Gray(1)

Silver/Black(1)

Black/Silver/Orange(1)

Black/Orange(1)

Machined Aluminum/Metallic Sage(1)

 
Manufacturer Part Number

10500(1)

SP2201H(1)

1900CYELLOW(1)

1900CORANGE(1)

1900CBLACK(1)

1830CYELLOW(1)

1820CYELLOW(1)

1800CYELLOW(1)

1800CBLACK(1)

ST3D016(1)

SP2209H(1)

S6D016(1)

2000CYELLOW(1)

S5D016(1)

S4D016(1)

S3D036(1)

S3D016(1)

S3C016(1)

S2D016(1)

S2C016(1)

M3A016(1)

M2A11H(1)

2000CBLACK(1)

2010CYELLOW(1)

M2A01H(1)

BER2AABA(1)

SP8DTP4(1)

SP2AA-BA(1)

SE4W3CA(1)

SE3DLNA(1)

RN3AAABA(1)

IN2MSE(1)

I2D-BC(1)

DIYHL3AAABTA(1)

DIY3AAABE(1)

BEKLN6VBTA(1)

2140CYELLOW(1)

301K(1)

2620C(1)

2400CYELLOW(1)

2400CORANGE(1)

2400CLIME(1)

2340CYELLOW(1)

2300CYELLOW(1)

2300CBLACK(1)

2250C(1)

M2A01L(1)

M2A01C(1)

14460(1)

ENML2DS(1)

HCAL41E(1)

EVM5511S(1)

EVFL45S(1)

EPMZH61E(1)

EPMZH21E(1)

EPMHH32E(1)

EPMHH21E(1)

ENRUB22E(1)

ENRUB21E(1)

ENML2AAS(1)

HDB32E(1)

ENFFL81E(1)

ENFAT41E(1)

ENCAP22E(1)

LG1160222SA3(1)

416487(1)

414216(1)

413788(1)

412594(1)

411218(1)

HDA32E(1)

L152S(1)

M2A016(1)

68201(1)

88033(1)

85001(1)

75713(1)

75014(1)

71500(1)

68602(1)

68254(1)

68244(1)

68202(1)

66318(1)

MLT1WAAE(1)

66118(1)

65022(1)

65018(1)

61400(1)

61302(1)

61200(1)

33254(1)

33202(1)

RCL1NM2WR(1)

PLED23AEH(1)

WHK2DBULKA(1)

 
Country of Origin

US(49)

CN(42)

China(4)

ID(1)

 
Width

3.9"(1)

 
Material

Metal(2)

Polyethylene(1)

 
Length

2.8"(1)

 
Durability

Water Resistant(2)

Shatter Proof(1)

 
Power Source(s)

2 AA (Included)(19)

4 AA (Included)(10)

2 AAA (Included)(8)

3 AAA (Included)(5)

3 C (Sold Separately)(5)

2 D (Sold Separately)(4)

2 C (Sold Separately)(4)

3 D (Sold Separately)(4)

3 AAAA (Included)(3)

2 AAA(2)

2 D (Included)(2)

1 D (Included)(2)

(3) AAA (Included)(2)

3.6V (Included)(1)

3 C(1)

6 D (Sold Separately)(1)

6V (Included)(1)

5 D (Sold Separately)(1)

4 D(1)

6 V (Included)(1)

2-3V (Included)(1)

3V (Included)(1)

3.6V NiCad (Included)(1)

2 AA (Included) or L91 (Sold Separately)(1)

1 AAA (Included)(1)

2 D(1)

3 AA (Included)(1)

3 C (Included)(1)

1 NiMH Rechargeable (Included)(1)

1 AA (Included)(1)

4 or 8 AA (4 Included)(1)

3 AG13 (Included)(1)

1 D (Sold Separately)(1)

1 Rechargeable Lithium-Ion (Included)(1)

8 D (Sold Separately)(1)

 
Voltage

1.5 V(12)

3 V(8)

4.5 V(6)

6 V(4)

3.7 V(1)

3.6 V(1)

 
Power Source

Battery(4)

 
Battery Type

Alkaline(82)

Lithium(2)

Lithium Ion(1)

LR44(1)

Nickel Metal Hydride(1)

Alkaline; Lithium(1)

NiCad(1)

Rechargeable NiCad(1)

Carbon Zinc(1)

Zinc Chloride(1)

 
Input Voltage

6 V DC(1)

 
Battery Size

AA(2)

D(2)

 
Run Time

20 h(2)

4 1/2 h(1)

50 h(1)

8 1/2 h(1)

18 h(1)

2.5 h(1)

High - 10hrs, Low - 50hrs(1)

Up to 50 hrs(1)

20 Hours(1)

 
Bulb/Tube Type

LED(4)

 
Lamp Life

400 Hour(1)

 
Battery Life

21 Hour(1)

19 Hour(1)

60 Hour(1)

 
Light Output

100 lm(1)

25 lm(1)

150 lm(1)

80 lm(1)

85 lm(1)

270 lm(1)

 
Number of Batteries

2(1)

6(1)

4(1)

 
Product Type

Flashlight(3)

Lantern(1)

 
Packaged Quantity

1 Each(2)

1 Pack(1)

4 / Pack(1)

 
Product Line

Vision HD(2)

 
Package Contents

  • Vision HD Performance Metal Flashlight with Digital Focus
  • 2 x AA Batteries
(1)

  • Vision HD Extra Performance Metal Flashlight with Digital Focus
  • 6 x AA batteries
(1)

  • Readyflex Floating Lantern
  • 2 x Battery
(1)

 
Batteries Included

Yes(28)

No(8)

 
Bulb Type

LED(46)

Xenon(21)

Krypton(13)

Incandescent(6)

PR-2(2)

Super High-Flux LED(1)

LMX(1)

Xenon/LED(1)

Fluorescent(1)

 
Flashlights Type

Standard(45)

LED(13)

Penlight(11)

Headlamp(8)

Mini Maglite(4)

Industrial(3)

Tactical(2)

Mini(2)

Lantern(2)

Stylus(1)

Swivel Head(1)

 
Projection Distance

Area Or Directional(2)

12 m(1)

518 ft(1)

180 m (High); 120 m (Energy Saver)(1)

146 m(1)

30 m (High); 17 m (Energy Saver)(1)

171 m(1)

33 m(1)

226 m(1)

44 m(1)

125 m(1)

141 ft(1)

472 ft(1)

158 m(1)

45 m(1)

148 ft(1)

100 m(1)

430 ft(1)

690 ft(1)

123 m(1)

52 m(1)

17 m(1)

24 m(1)

50m(1)

High - 35m, Low - 20m(1)

84 m(1)

30 m(1)

1 m(1)

87 m(1)

 
 
 

© 2020-2021 Horizon Business Products, All Rights Reserved