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]	NIGHTSTICK	Nightstick	CAMPING	Camping>Lighting>Flashlights	[empty string]	1	18.99	0	18.99	100528-DEFAULT-l.jpg	18.99	100528-DEFAULT-m.jpg	MINI-TAC 100 L BLACK 2AAA	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]	ONLINE CLOSEOUT	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	MINI-TAC - 130 LUMENS	<p>This 2 AAA Mini-TAC light uses a deep parabolic reflector creating a tight, long-throw beam for distance illumination.</p> <p> </p> <ul> <li>LED technology</li> <li>Momentary or constant-on flashlight</li> <li>Sharp focused flashlight beam</li> <li>Aircraft-grade 6061-T6 aluminum housing</li> <li>Type II hard anodized finish</li> <li>Non-slip grip</li> <li>IP-X4 Water Resistant</li> <li>Impact & chemical resistant</li> <li>2 AAA batteries (included)</li> </ul> <p> </p> <ul> <li>High Lumens: 130</li> <li>High Beam Distance: 44 meters</li> <li>High Candela: 484</li> <li>Drop Rating: 2 meters</li> <li>Water Rating: IP-X4 Water-resistant</li> <li>High Runtime: 3.5 hours</li> <li>Switch Function: Single Tail Cap Switch - Momentary or Constant-on Flashlight</li> <li>Light Source: LED</li> <li>Case Material: 6061-T6 Aluminum</li> <li>Body Color: Black</li> <li>Quantity of Batteries: 2</li> <li>Power Source: AAA</li> <li>Package Contents: Light, 2 AAA batteries, Removable pocket clip</li> </ul>	[empty string]	N	18.99	18.99	[empty string]	100528-DEFAULT-s.jpg	[empty string]	1000	MT-100	337564	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	nightstick/mini-tac-130-lumens-337564	1
2	[empty string]	NIGHTSTICK	Nightstick	CAMPING	Camping>Lighting>Flashlights	[empty string]	1	49.99	0	49.99	100532-DEFAULT-l.jpg	49.99	100532-DEFAULT-m.jpg	XTREME 500L POLYMER TACTICAL	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]	ONLINE CLOSEOUT	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	POLYMER TACTICAL FLASHLIGHT - 500 LUMENS	<p>This compact polymer Xtreme Lumens tactical flashlight uses an LED rated at 500 lumens that works in conjunction with a high-efficiency deep parabolic reflector to create a usable beam rated at 150 meters. The tail-cap switch provides momentary or constant-on functionality. The housing is made from glass-filled nylon polymer. Power comes from a pair of included CR123 Lithium batteries. (Not compatible with rechargeable batteries.</p> <p> </p> <ul> <li>LED technology</li> <li>Momentary or constant-on flashlight</li> <li>Sharp focused flashlight beam</li> <li>High-efficiency deep parabolic reflector</li> <li>Effective beam distance of 190 meters (over 492 feet)</li> <li>Glass-filled nylon polymer housing</li> <li>Non-slip grip</li> <li>Large textured tail-switch</li> <li>1” Handle diameter fits most 3rd party scope/flashlight mounts</li> <li>1.25” Head diameter accepts 3rd party filters</li> <li>IP-X7 Waterproof</li> <li>Impact & chemical resistant</li> <li>Includes removable pocket clip</li> <li>2CR123 batteries (included)</li> </ul> <p> </p> <ul> <li>High Lumens: 500</li> <li>High Beam Distance: 150 meters</li> <li>High Candela: 5,597</li> <li>Drop Rating: 2 meters</li> <li>Water Rating: IP-X7 Waterproof</li> <li>High Runtime: 1.5 hours</li> <li>Switch Function: Single Tail Cap Switch - Momentary or Constant-on Flashlight</li> <li>Light Source: LED</li> <li>Case Material: Glass-filled Nylon Polymer</li> <li>Body Color: Black</li> <li>Quantity of Batteries: 2</li> <li>Power Source: CR123</li> <li>Package Contents: Light, 2 CR123 batteries and Removable pocket clip</li> </ul>	[empty string]	N	49.99	49.99	[empty string]	100532-DEFAULT-s.jpg	[empty string]	1000	TAC-310XL	337565	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	nightstick/polymer-tactical-flashlight-500-lumens-337565	1
3	[empty string]	NIGHTSTICK	Nightstick	HUNTING	Hunting>Lighting>Flashlights	[empty string]	1	104.95	0	104.95	84853-DEFAULT-l.jpg	104.95	84853-DEFAULT-m.jpg	XTREME 800L POLYMER TACTICAL RECHARGABLE	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]	ONLINE CLOSEOUT	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	POLYMER TACTICAL FLASHLIGHT - RECHARGEABLE - 800 LUMENS	<p>This compact rechargeable polymer Xtreme Lumens tactical flashlight uses an LED rated at 800 lumens that works in conjunction with a high-efficiency deep parabolic reflector to create a usable beam rated at 205 meters.  The tail-cap switch provides momentary or constant-on functionality.  The housing is made from a glass-filled nylon polymer.</p> <p> </p> <ul> <li>LED technology</li> <li>Momentary or constant-on flashlight</li> <li>Sharp focused flashlight beam</li> <li>High-efficiency deep parabolic reflector</li> <li>Effective beam distance of 205 meters (over 670 feet)</li> <li>Glass-filled nylon polymer housing</li> <li>Non-slip grip</li> <li>Large textured tail-switch</li> <li>1” Handle diameter fits most 3rd party scope/flashlight mounts</li> <li>1.25” Head diameter accepts 3rd party filters</li> <li>IP-X7 Waterproof</li> <li>Impact & chemical resistant</li> <li>Powered by rechargeable Lithium-ion battery (included)</li> <li>Can also be 2CR123 batteries (not included) using the CR123 Battery Carrier (included)</li> </ul> <p> </p> <ul> <li>High Lumens: 800</li> <li>High Beam Distance: 205 meters</li> <li>High Candela: 10,765</li> <li>Drop Rating: 2 meters</li> <li>Water Rating: IP-X7 Waterproof</li> <li>High Runtime: 2 hours</li> <li>Charge Time: 4 hours</li> <li>Switch Function: Single Tail Cap Switch - Momentary or Constant-on Flashlight</li> <li>Light Source: LED</li> <li>Serialized: Y</li> <li>Case Material: Glass-filled Nylon Polymer</li> <li>Body Color: Black</li> <li>Quantity of Batteries: 1</li> <li>Power Source: Li-ion Rechargeable</li> <li>Backup Power Source: 2 CR123 Lithium Primary Batteries (not included)</li> <li>Package Contents: Light, Rechargeable Lithium-ion Battery, AC & DC Power Supplies, Charger & CR123 Battery Carrier (batteries not included)</li> </ul>	[empty string]	N	104.95	104.95	[empty string]	84853-DEFAULT-s.jpg	[empty string]	1000	TAC-410XL	337566	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	nightstick/polymer-tactical-flashlight-rechargeable-800-lumens-337566	1
4	[empty string]	NIGHTSTICK	Nightstick	HUNTING	Hunting>Lighting>Flashlights	[empty string]	1	114.45	0	114.45	89678-DEFAULT-l.jpg	114.45	89678-DEFAULT-m.jpg	XTREME 900L POLYMER TACTICAL USB RECHARGABLE	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]	ONLINE CLOSEOUT	[empty string]	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	USB TACTICAL FLASHLIGHT - 1100 LUMENS	<p>The USB-558XL USB Rechargeable Tactical Flashlight uses an LED rated at 1100 lumens on high for 2 hours but can be extended up to 22 hours in low mode (125 lumens). At only 5.9 inches long and weighing only 5.7 oz, this metal tactical flashlight is multi-functional, cycling between high, medium, and low modes.</p> <p> </p> <ul> <li>LED technology</li> <li>Momentary or constant-on flashlight</li> <li>Sharp focused beam</li> <li>Aircraft-grade 6061-T6 aluminum housing with Type III hard anodized finish</li> <li>IP-X7 Waterproof</li> <li>Chemical, heat and impact resistant</li> <li>Meets the requirements for NFPA-1971-8.6 (2013)</li> <li>USB cord with rechargeable lithium-ion battery (included)</li> <li>Can also run on 2 CR123 batteries (not included)</li> <li>Serialized for personal identification</li> </ul> <p> </p> <ul> <li>Multi-Function: Yes</li> <li>High Lumens: 1100</li> <li>Medium Lumens: 450</li> <li>Low Lumens: 125</li> <li>High Beam Distance: 235 meters</li> <li>Medium Beam Distance: 148 meters</li> <li>Low Beam Distance: 79 meters</li> <li>High Candela: 13843</li> <li>Medium Candela: 5447</li> <li>Low Candela: 1550</li> <li>Drop Rating: 2 meters</li> <li>Water Rating: IP-X7 Waterproof</li> <li>High Runtime: 2 hours</li> <li>Medium Runtime: 4.5 hours</li> <li>Low Runtime: 22 hours</li> <li>Charge Time: 4 hours</li> <li>Switch Function: Single Tail Switch - Momentary or Constant-on Flashlight, High, Medium and Low-Brightness Flashlight</li> <li>Light Source: LED</li> <li>Serialized: Y</li> <li>Case Material: 6061-T6 Aluminum</li> <li>Body Color: Black</li> <li>Cord Length: 2'</li> <li>Cord Color: Black</li> <li>Quantity of Batteries: 1</li> <li>Power Source: Li-ion Rechargeable</li> <li>Package Contents: Light, Lithium-ion Rechargeable Battery, USB-C Cable, CR123 Battery Carrier</li> </ul>	[empty string]	N	114.45	114.45	[empty string]	89678-DEFAULT-s.jpg	[empty string]	1000	USB-558XL	337567	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	nightstick/usb-tactical-flashlight-1100-lumens-337567	1
5	[empty string]	NIGHTSTICK	Nightstick	CAMPING	Camping>Lighting>Headlamps	[empty string]	1	38.95	0	38.95	84852-DEFAULT-l.jpg	38.95	84852-DEFAULT-m.jpg	HEADLAMP MULTI FUNCTION 3AAA 210L	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]	ONLINE CLOSEOUT	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	MULTI-FUNCTION HEADLAMP - 210 LUMENS	<p>This 3 AAA multi-function headlamp features a multi-position tilt head design and includes an elastic head strap with a non-slip lining. The top-mounted dual switches provide a high/low-brightness spotlight for distance illumination and white/red/green floodlight operation for illuminating objects that are close by. Power comes from three AAA batteries (included).</p> <p> </p> <ul> <li>LED technology</li> <li>High/low spotlight</li> <li>White/Red/Green floodlight</li> <li>Focused spotlight beam for distance illumination</li> <li>Unfocused wide-beam floodlight for close-up illumination</li> <li>Colored floodlight for night vision preservation</li> <li>Engineered polymer housing</li> <li>Dual switches located on top of light</li> <li>Adjustable ratchet tilt head</li> <li>Non-slip elastic head strap</li> <li>Waterproof</li> <li>Impact & chemical resistant</li> <li>3 AAA batteries (included)</li> </ul> <p> </p> <ul> <li>Multi-Function: Yes</li> <li>High Lumens: 210</li> <li>Low Lumens: 110</li> <li>Floodlight Lumens: 135</li> <li>Flood Low Lumens: 110</li> <li>High Beam Distance: 93 meters</li> <li>Medium Beam Distance: 67 meters</li> <li>High Candela: 2,170</li> <li>Low Candela: 1,110</li> <li>Drop Rating: 2 meters</li> <li>Water Rating: IP-X7 Waterproof</li> <li>High Runtime: 4.5 hours</li> <li>Low Runtime: 8.5 hours</li> <li>High Flood Runtime: 4.5 hours</li> <li>Medium Flood Runtime: 25 hours</li> <li>Low Flood Runtime: 25 hours</li> <li>Floodlight Color: White/Red/Green</li> <li>Switch Function: Dual Switches. High/Low Spotlight, White/Red/Green Floodlight</li> <li>Light Source: LED</li> <li>Case Material: Engineered Polymer</li> <li>Body Color: Black</li> <li>Strap/Mount: Elastic Strap</li> <li>Quantity of Batteries: 3</li> <li>Power Source: AAA</li> <li>Package Contents: Light, Elastic non-slip head strap & 3 AAA Batteries</li> </ul>	[empty string]	N	38.95	38.95	[empty string]	84852-DEFAULT-s.jpg	[empty string]	1000	NSP-4610B	337570	HEADLAMPS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	nightstick/multi-function-headlamp-210-lumens-337570	1
6	[empty string]	NIGHTSTICK	Nightstick	CAMPING	Camping>Lighting>Flashlights	[empty string]	1	130.45	0	130.45	84759-DEFAULT-l.jpg	130.45	84759-DEFAULT-m.jpg	AREA LIGHT 1000L RECHARGABLE AC/DC POWER	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]	ONLINE CLOSEOUT	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	RECHARGEABLE LED SCENE LIGHT WITH MAGNETIC BASE - 1000 LUMENS	<p>The NSR-1514 rechargeable LED area light with magnetic base is perfect when portability is important. This area light cranks out an impressive 1,000 lumens of light on high and 500 lumens on low using a single sealed push button switch. The housing is constructed from lightweight 6061-T6 aluminum and the multi-fin heat sink design keeps the fixture cool to the touch.</p> <p> </p> <ul> <li>Rechargeable Li-ion battery</li> <li>Multi-angle tilt and swivel fixture design</li> <li>High/Low brightness modes</li> <li>LED technology</li> <li>Includes AC and DC power supplies</li> <li>Constructed from lightweight 6061-T6 aluminum</li> <li>Powerful magnetic base for hands-free operation</li> <li>Multi-fin heat sink keeps light cool to the touch</li> <li>Adjustable comfort-grip handle</li> <li>Single sealed push button switch</li> <li>Tempered glass lens</li> <li>Powder coated for long wear</li> <li>IP-67 Dustproof / Waterproof</li> <li>Impact and chemical resistant design</li> <li>Meets requirements of NFPA-1971-8.6 (2013)</li> </ul> <p> </p> <ul> <li>Multi-Function: Yes</li> <li>High Lumens: 1000</li> <li>Floodlight Lumens: 1000</li> <li>Flood Low Lumens: 500</li> <li>Drop Rating: 2 meters</li> <li>Water Rating: IP-67 Dustproof/Waterproof</li> <li>High Flood Runtime: 4 hours</li> <li>Medium Flood Runtime: 8 hours</li> <li>Charge Time: 3.5 hours</li> <li>Floodlight Color: White</li> <li>Switch Function: Single sealed push button</li> <li>Light Source: LED</li> <li>Case Material: 6061-T6 Aluminum</li> <li>Body Color: Black</li> <li>Quantity of Batteries: 1</li> <li>Power Source: Integrated Li-ion</li> <li>Backup Power Source: AC/DC</li> <li>Package Contents: Area Light, adjustable handle, AC and DC power supplies</li> </ul>	[empty string]	N	130.45	130.45	[empty string]	84759-DEFAULT-s.jpg	[empty string]	1000	NSR-1514	337571	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	nightstick/rechargeable-led-scene-light-with-magnetic-base-1000-lumens-337571	1
7	[empty string]	NIGHTSTICK	Nightstick	HUNTING	Hunting>Lighting>Flashlights	[empty string]	1	58.45	0	58.45	84742-DEFAULT-l.jpg	58.45	84742-DEFAULT-m.jpg	MINI TAC RECHARGEABLE FLASHLIGHT	N	16 DEVON	[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]	2	50-to-100	0.00	[empty string]	USB RECHARGEABLE EDC FLASHLIGHT - 320 LUMENS	<p>The USB rechargeable every-day-carry (EDC) metal flashlight uses an LED rated at 320 lumens for 1.5 hours. At only 4.5 inches long and weighing only 3 oz, this compact flashlight includes a removable deep concealment clip for ease of use in and out of a pocket.</p> <p> </p> <ul> <li>LED technology</li> <li>Momentary or constant-on flashlight</li> <li>Sharp focused beam</li> <li>Aircraft-grade 6061-T6 aluminum housing with Type III hard anodized finish</li> <li>IP-X7 Waterproof</li> <li>Chemical, heat and impact resistant</li> <li>Meets the requirements for NFPA-1971-8.6 (2013)</li> <li>USB cord with rechargeable lithium-ion battery (included)</li> <li>Serialized for personal identification</li> </ul> <p> </p> <ul> <li>High Lumens: 320</li> <li>High Beam Distance: 111 meters</li> <li>High Candela: 3,100</li> <li>Drop Rating: 2 m</li> <li>Water Rating: IP-X7 Waterproof</li> <li>High Runtime: 1.5 hours</li> <li>Charge Time: 4 hours</li> <li>Switch Function: Single Body Switch - Momentary or Constant-on Flashlight</li> <li>Light Source: LED</li> <li>Serialized: Y</li> <li>Case Material: 6061-T6 Aluminum</li> <li>Body Color: Black</li> <li>Cord Length: 2'</li> <li>Cord Color: Black</li> <li>Quantity of Batteries: 1</li> <li>Power Source: Li-ion Rechargeable</li> <li>Package Contents: Light, Rechargeable Li-ion Battery, USB Charging Cord</li> </ul>	[empty string]	N	58.45	58.45	[empty string]	84742-DEFAULT-s.jpg	[empty string]	1000	USB-320	338019	FLASHLIGHTS	EMPTY	EMPTY	0	0	0	LIGHTING	[empty string]	nightstick/usb-rechargeable-edc-flashlight-320-lumens-338019	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Categories

Filter