Jay's Sporting Goods

query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	FAMLIST	HASIMAGE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SOLD	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	UPC	URL	VENDOR_INTEGRATE_ID
1	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Headlamps	[empty string]	1	6.99	0	6.99	41852-DEFAULT-l.jpg	6.99	41852-DEFAULT-m.jpg	ORION HAT CLIP LIGHT CLEAR LED	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	4	5-to-10	0.00	[empty string]	Orion - 17.5 Lumens - White Leds	<p>The Orion has a contoured shape which fits a cap brims securely and does not obstruct line of vision.</p>	[empty string]	N	6.99	6.99	[empty string]	41852-DEFAULT-s.jpg	[empty string]	1000	CYC-HC1-W	28463	HEADLAMPS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/orion-hat-clip-light-clear-led-28463	1
2	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Headlamps	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	TILT HAT CLIP LIGHT CAMO	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	16	10-to-15	0.00	[empty string]	Orion Tilt - 30 Lumens - White / Green Leds	<p>FEATURES:<br /> -5 super bright LED`s with interchangeable light modules in white and green bulbs<br /> -Contoured shape fits cap brims securely, does not obstruct line of vision<br /> -Light module tilts 45 degree for desired light position</p>	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	CYC-HCDT-WGNXT	129096	HEADLAMPS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/tilt-hat-clip-light-camo-129096	1
3	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Headlamps	[empty string]	0	6.99	0	6.99	[empty string]	6.99	[empty string]	MICRO MINI LED HAT CLIP	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	6	5-to-10	0.00	[empty string]	Micro - 10 Lumens - White Leds	<p>FEATURES:<br /> -5 super bright LED’s with built-in 15 angle tilt<br /> -Weighs less than an ounce, top mount design does not obstruct vision</p>	[empty string]	N	6.99	6.99	[empty string]	[empty string]	[empty string]	1000	CYC-MHC-W	146816	HEADLAMPS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/micro-mini-led-hat-clip-146816	1
4	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	1	79.99	0	79.99	41879-DEFAULT-l.jpg	79.99	41879-DEFAULT-m.jpg	SIRUS 500 LUMEN RECHARGABLE SPOTLIGHT	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	12	50-to-100	0.00	[empty string]	Sirius 500 - Rechargeable - 500 Lumens	<p>FEATURES:<br /> -Improved 20% brighter illumination<br /> -Ergonomically designed rubberized grip with trigger pulse switch<br /> -Dual recharge, AC/DC adapter or 12V DC car adapter (both included)<br /> -Detachable red lens included<br /> -Always ON lock switch</p>	[empty string]	N	79.99	79.99	[empty string]	41879-DEFAULT-s.jpg	[empty string]	1000	CYC-X500H	177276	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/sirus-500-lumen-rechargable-spotlight-177276	1
5	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Headlamps	[empty string]	0	6.99	0	6.99	[empty string]	6.99	[empty string]	MICRO MINI LED HAT CLIP GREEN BULB	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	8	5-to-10	0.00	[empty string]	Micro - 10 Lumens - Green Leds	<p>FEATURES:<br /> -5 super bright LED`s with built-in 15 angle tilt<br /> -Weighs less than an ounce, top mount design does not obstruct vision</p>	[empty string]	N	6.99	6.99	[empty string]	[empty string]	[empty string]	1000	CYC-MHC-G	177277	HEADLAMPS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/micro-mini-led-hat-clip-green-bulb-177277	1
6	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	0	11.99	0	11.99	[empty string]	11.99	[empty string]	LED FLASHLIGHT WITH STROBE	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	3	10-to-15	0.00	[empty string]	Hi Output Led Flashlight - 80 Lumens - White Led	<p>FEATURES:<br /> -Aviation grade anodized aluminum<br /> -Rear tactical switch<br /> -Color ring for emergency blinker</p>	[empty string]	N	11.99	11.99	[empty string]	[empty string]	[empty string]	1000	CYC-1WF	177278	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/led-flashlight-with-strobe-177278	1
7	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	APOLLO XP 200L LANTERN/FLASHLIGHT	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	13	10-to-15	0.00	[empty string]	Apollo Xp - 200 Lumens - White Led	<p>FEATURES:<br /> -Cree XRE-Q5 LED bulb<br /> -Magnifier Beam Distance (600 feet)<br /> -Dual Mode – Flashlight/Lantern<br /> -Aviation grade anodized aluminum<br /> -Integrated hang hook<br /> -Rear tactical switch</p>	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	CYC-LF200	177279	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/apollo-xp-200l-lantern-flashlight-177279	1
8	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Headlamps	[empty string]	0	6.99	0	6.99	[empty string]	6.99	[empty string]	ORION HAT CLIP LIGHT GREEN LED	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	11	5-to-10	0.00	[empty string]	Orion - 17.5 Lumens - Green Leds	<p>The Orion has a contoured shape which fits a cap brims securely and does not obstruct line of vision.</p>	[empty string]	N	6.99	6.99	[empty string]	[empty string]	[empty string]	1000	CYC-HC1-G	177297	HEADLAMPS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/orion-hat-clip-light-green-led-177297	1
9	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Headlamps	[empty string]	0	26.99	0	26.99	[empty string]	26.99	[empty string]	RANGER XP HEADLAMP 4 MODE 126 LUMEN	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	HOTSHOW	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	13	25-to-50	0.00	[empty string]	Ranger Xp - 126 Lumens	<p>FEATURES:<br /> -4 side red LED’s or side red LED strobe<br /> -3 layer adjustable nylon cross-strap elastic headband<br /> -ABS rubberized housing for durability, plus weather-resistant<br /> -Powered by (3) three Energizer ‘AAA’ alkaline batteries (included)</p>	[empty string]	N	26.99	26.99	[empty string]	[empty string]	[empty string]	1000	CYC-RNG1XP-CMO	247708	HEADLAMPS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/ranger-xp-headlamp-4-mode-126-lumen-247708	1
10	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	1	119.99	0	119.99	76762-DEFAULT-l.jpg	119.99	76762-DEFAULT-m.jpg	REVO 1100 LUM SPOTLIGHT	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	8	100-to-150	0.00	[empty string]	Revo 1100 - 1100 Lumens	<p>FEATURES:<br /> -Two Hi-Power Luxeon LEDs<br /> -Vented housing to reduce heat build-up<br /> -Ergonomically designed rubberized grip with trigger pulse switch<br /> -Dual recharge, AC/DC adapter or 12V DC car adapter (both included)<br /> -Detachable red lens included<br /> -Always ON lock switch</p>	[empty string]	N	119.99	119.99	[empty string]	76762-DEFAULT-s.jpg	[empty string]	1000	CYC-X1100H	254362	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/revo-1100-lum-spotlight-254362	1
11	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	1	29.99	0	29.99	76769-DEFAULT-l.jpg	29.99	76769-DEFAULT-m.jpg	LED FLASLIGHT 800LUMEN LIME GREEN	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	Led Specialty Flashlight - 700 Lumens	<p>FEATURES:<br /> -Machined aluminum and ABS plastic housing<br /> -IPX7 Weather Resistant rating<br /> -Durable Nylon Lanyard – included<br /> -Powered by four ‘AA’ batteries – included</p>	[empty string]	N	29.99	29.99	[empty string]	76769-DEFAULT-s.jpg	[empty string]	1000	CYC-FL700GB-LG	265201	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/led-flaslight-800lumen-lime-green-265201	1
12	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Headlamps	[empty string]	0	12.99	0	12.99	[empty string]	12.99	[empty string]	MICRO HAT CLIP 2 PACK WHITE	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	20	10-to-15	0.00	[empty string]	Micro - 10 Lumens - 2 Pack	<p>FEATURES:<br /> -5 super bright LED’s with built-in 15 angle tilt<br /> -Weighs less than an ounce, top mount design does not obstruct vision</p>	[empty string]	N	12.99	12.99	[empty string]	[empty string]	[empty string]	1000	CYC-MHC2PK-W	265204	HEADLAMPS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/micro-hat-clip-2-pack-white-265204	1
13	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Headlamps	[empty string]	0	32.99	0	32.99	[empty string]	32.99	[empty string]	2 PACK HEADLAMPS 210 LUMENS	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	23	25-to-50	0.00	[empty string]	Headlamp - 210 Lumens - 2 Pack	<p>FEATURES:<br /> -High Power 3W White LED<br /> -Hi / Low / Strobe (3W)<br /> -Adjustable headband<br /> -Each powered by 3 AAA batteries (Included)</p>	[empty string]	N	32.99	32.99	[empty string]	[empty string]	[empty string]	1000	CYC-HL210-2PK	281860	HEADLAMPS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/2-pack-headlamps-210-lumens-281860	1
14	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Headlamps	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	HEADLAMP FORCE XP 350	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	12	20-to-25	0.00	[empty string]	Force Xp Headlamp - 350 Lm	<p>FEATURES:<br /> -Small, Light, & compact<br /> -Blinking<br /> -IPX6 Water resistant<br /> -3 AAA Energizer batteries included</p>	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	CYC-HLFXP	300476	HEADLAMPS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/headlamp-force-xp-350-300476	1
15	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	TACTICAL FLASLIGHT 1500 LUMEN	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	15	25-to-50	0.00	[empty string]	Tactical Flashlight - 1500 Lumens	<p>SME's Tri Mode Illumination Flashlight features a spot to flood magnifier beam that reaches a distance up to 360 meters. It utilizes a CREE XHP50 20 watt led bulb, rear tactical power switch, and three modes 100%/20%/SOS. The flashlight is made of aviation grade anodized aluminum that is weather resistant. This 1500 Lumen model has a black finish and includes six AAA batteries.</p>	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	CYC-TF1500	300477	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/tactical-flaslight-1500-lumen-300477	1
16	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	SEEKER SPOTLIGHT 15000 LU W/RED LENS	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	9	25-to-50	0.00	[empty string]	Seeker Pro - 1500 Lumens	<p>FEATURES:<br /> -Tough ABS and tempered glass materials<br /> -Iron reflector + aluminum cooling fin<br /> -Tested by DC 13.8V as ANSI standard<br /> -Detachable red lens included<br /> -Handle with adjustable angle for hand-held portable use<br /> -Handle with soft TPR coat to be slip-proof<br /> -Convenient and hidden metal hasp<br /> -Rocker switch on/off on the back</p>	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	CYC-S150012VR	300483	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/seeker-spotlight-15000-lu-w-red-lens-300483	1
17	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	SPOTLIGHT 350LU HANDHELD AA MAX 5	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	14	25-to-50	0.00	[empty string]	Handheld Waterproof Spot - 350 Lumens	<p>FEATURES:<br /> -Cree XPG? R5 super bright 3W LED<br /> -Top adjustable bracket for hand or stand<br /> -Rubberized bezel<br /> -Durable ABS Poly Carbonate Housing<br /> -A rescue whistle on the lanyard<br /> -The main body of tough ABS PC rubber TPR materials<br /> -Magnetic switch with locking function<br /> -Lightweight Design<br /> --Powered by 3 AA battery</p>	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	CYC-350WPAA-RT	315438	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/spotlight-350lu-handheld-aa-max-5-315438	1
18	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	TACTICAL FLASLIGHT 150LUMEN	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	6	10-to-15	0.00	[empty string]	Tactical Flaslight 150lumen	[empty string]	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	CYC-TF150	315441	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/tactical-flaslight-150lumen-315441	1
19	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	0	22.99	0	22.99	[empty string]	22.99	[empty string]	TACTICAL FLASLIGHT 350 LUMEN	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	10	20-to-25	0.00	[empty string]	Tactical Flaslight 350 Lumen	[empty string]	[empty string]	N	22.99	22.99	[empty string]	[empty string]	[empty string]	1000	CYC-TF350	315442	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/tactical-flaslight-350-lumen-315442	1
20	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	RECHARGABLE SPOTLIGHT 10W	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	1 Watt Spotlight - Rechargeable - 850 Lumens	<p>FEATURES:<br /> -Dual recharge, either AC/DC charger or 12V DC car plug adapter<br /> -Tactical Power Button<br /> -Powered by 4V rechargeable sealed lead acid battery</p>	[empty string]	N	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	CYC-10W	315450	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/rechargable-spotlight-10w-315450	1
21	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	0	36.99	0	36.99	[empty string]	36.99	[empty string]	TACTICAL FLASLIGHT 800 LUMEN	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Tactical Flaslight 800 Lumen	[empty string]	[empty string]	N	36.99	36.99	[empty string]	[empty string]	[empty string]	1000	CYC-TF800	315459	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/tactical-flaslight-800-lumen-315459	1
22	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	1	24.99	0	24.99	92380-DEFAULT-l.jpg	24.99	92380-DEFAULT-m.jpg	FLEX FLASHLIGHT 400LUMEN	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	20-to-25	0.00	[empty string]	Flex Flashlight 400lumen	[empty string]	[empty string]	N	24.99	24.99	[empty string]	92380-DEFAULT-s.jpg	[empty string]	1000	CYC-FLX400	340553	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/flex-flashlight-400lumen-340553	1
23	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	0	119.99	0	119.99	[empty string]	119.99	[empty string]	RECHARGABLE SPORTLIGHT 600LUMEN	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	9	100-to-150	0.00	[empty string]	Rechargable Sportlight 600lumen	[empty string]	[empty string]	N	119.99	119.99	[empty string]	[empty string]	[empty string]	1000	CYC-SPL-6X	340554	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/rechargable-sportlight-600lumen-340554	1
24	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Headlamps	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	HEADLAMP LED 400LM RECHARGABLE	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	10	20-to-25	0.00	[empty string]	Headlamp Led 400lm Rechargable	[empty string]	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	CYC-HL4X	348156	HEADLAMPS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/headlamp-led-400lm-rechargable-348156	1
25	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	FLASHLIGHT 14LED ALUM W/WHITE LED 2PK	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	13	15-to-20	0.00	[empty string]	Flashlight 14led Alum W/white Led 2pk	[empty string]	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	CYC-FL14-2PK	348157	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/flashlight-14led-alum-w-white-led-2pk-348157	1
26	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	1	79.99	0	79.99	88800-DEFAULT-l.jpg	79.99	88800-DEFAULT-m.jpg	SPOTLIGHT RECHARGABLE 1600LUMEN	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	Spotlight Rechargable 1600lumen	[empty string]	[empty string]	N	79.99	79.99	[empty string]	88800-DEFAULT-s.jpg	[empty string]	1000	CYC-SP1600	348158	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/spotlight-rechargable-1600lumen-348158	1
27	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Flashlights	[empty string]	1	79.99	0	79.99	87835-DEFAULT-l.jpg	79.99	87835-DEFAULT-m.jpg	SPOTLIGHT RECHARGABLE 700LUMEN	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Spotlight Rechargable 700lumen	[empty string]	[empty string]	N	79.99	79.99	[empty string]	87835-DEFAULT-s.jpg	[empty string]	1000	CYC-700WP	355924	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/spotlight-rechargable-700lumen-355924	1
28	[empty string]	CYCLOPS	Cyclops	CAMPING	Camping>Lighting>Headlamps	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	HEADLAMP 3PK 300LUMEN	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	12	20-to-25	0.00	[empty string]	Headlamp 3pk 300lumen	[empty string]	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	CYC-HL-3PK	355926	HEADLAMPS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	cyclops/headlamp-3pk-300lumen-355926	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

2 1

Filter By

Filter

2 1

Filter By

Price

Categories

Brand

Orion - 17.5 Lumens - White Leds

Orion Tilt - 30 Lumens - White/Green Leds

Micro - 10 Lumens - White Leds

Sirius 500 - Rechargeable - 500 Lumens

Micro - 10 Lumens - Green Leds

Hi Output Led Flashlight - 80 Lumens - White Led

Apollo Xp - 200 Lumens - White Led

Orion - 17.5 Lumens - Green Leds

Ranger Xp - 126 Lumens

Revo 1100 - 1100 Lumens

Led Specialty Flashlight - 700 Lumens

Micro - 10 Lumens - 2 Pack

Headlamp - 210 Lumens - 2 Pack

Force Xp Headlamp - 350 Lm

Tactical Flashlight - 1500 Lumens

Seeker Pro - 1500 Lumens

Handheld Waterproof Spot - 350 Lumens

Tactical Flaslight 150lumen

Tactical Flaslight 350 Lumen

1 Watt Spotlight - Rechargeable - 850 Lumens

Tactical Flaslight 800 Lumen

Flex Flashlight 400lumen

Rechargable Sportlight 600lumen

Headlamp Led 400lm Rechargable