Simmons' 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	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEBSTYLE	WEIGHTED_SEARCH
1	[empty string]	CYCLOPS	Cyclops	HUNTING	Hunting	[empty string]	1	49.99	0	49.99	13943-DEFAULT-l.jpg	49.99	13943-DEFAULT-m.jpg	CYCLOPS BRONTES 2000 LUMEN FLAHLIGHT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	705	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Cyclops Brontes 2k- 2000 Lumen Flashlight	<p><strong>DESCRIPTION:</strong></p><ul><li>Light Source: CREE XHP50.2 20W LED * 1</li><li>Power Source: Energizer AA - 9 included</li><li>Weight: 420grams (net)</li><li>Material: Aluminum Alloy 6063-T6</li><li>Anodized Finish</li><li>Switch:Tailcap100%-30%-10%-SOS-8HZ</li><li>IPX7</li><li>Twist Focus</li><li>Performs brightness of 2000 lumens (100%)</li><li>Light range up to 400 meters (100%)</li><li>Works consecutive 2 hours (100%)</li></ul>	[empty string]	N	49.99	49.99	[empty string]	13943-DEFAULT-s.jpg	[empty string]	1000	1000	CYC-FLB2000	131511	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cyclops/cyclops-brontes-2k-2000-lumen-flashlight-131511	CYC-FLB2000	0
2	[empty string]	CYCLOPS	Cyclops	HUNTING	Hunting	[empty string]	1	34.99	0	39.99	13942-DEFAULT-l.jpg	34.99	13942-DEFAULT-m.jpg	CYCLOPS STEROPES 700	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	705	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	Cyclops Steropes 700 Lumens	<p><strong>DESCRIPTION:</strong></p><ul><li>Light Source: CREE XPG3 6W LED * 1</li><li>Material: Aluminum Alloy 6063-T6</li><li>Finish: Anodized</li><li>Switch:Tailcap100%-off-40%-off-10%-off</li><li>-SOS-off-8HZ strobe-off,</li><li>light press 100%-40%-10%-SOS-8hz cycle</li><li>IPX4</li><li>Twist Focus</li><li>USB charge</li><li>Independent Power bank</li><li>Dual-power supply</li><li>Performs brightness of 700 lumens (18650)</li><li>Light range up to 220 meters (18650)</li><li>Works consecutive 3 hours (18650)</li><li>Performs brightness of 400 lumens (AAA*3)</li><li>Light range up to 180 meters</li><li>Works consecutive 3.5 hours</li></ul>	[empty string]	N	39.99	39.99	[empty string]	13942-DEFAULT-s.jpg	[empty string]	1000	1000	CYC-FLS700	131512	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cyclops/cyclops-steropes-700-lumens-131512	CYC-FLS700	0
3	[empty string]	CYCLOPS	Cyclops	HUNTING	Hunting	[empty string]	1	39.99	0	44.99	13944-DEFAULT-l.jpg	39.99	13944-DEFAULT-m.jpg	CYCLOPS HADES 1000	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	705	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Cyclops Hades 1000 Lumen Headlamp	<p><strong>DESCRIPTION:</strong></p><p>The Cyclops Hades Headlamp is a powerful headlamp with the ability to light a whole room at the press of a button. This light gives off an impressive 1000 lumens at a range of 100 meters. </p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Magnetic charging</li><li>IXP4 weather resistant</li><li>Removable clip</li><li>Color Black</li><li>Material Anodized Aluminum</li><li>Waterproof No</li><li>Weight 1.94 Ounce</li><li>Battery 18650</li><li>Battery Type 18650 Rechargeable Battery</li><li>Batteries Included Yes</li><li>Attachment Method Headband</li><li>Rechargeable Yes</li><li>Bulb Type LED</li><li>Light Output High 1000 Lumens</li><li>Bulb Color White</li><li>Switch Type Push Button</li><li>Strobe Yes</li><li>Beam Distance 328 Feet</li><li>Headband Type Adjustable</li></ul>	[empty string]	N	44.99	44.99	[empty string]	13944-DEFAULT-s.jpg	[empty string]	1000	1000	CYC-HLH1000	131516	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cyclops/cyclops-hades-1000-lumen-headlamp-131516	CYC-HLH1000	0
4	[empty string]	CYCLOPS	Cyclops	HUNTING	Hunting	[empty string]	1	34.99	0	39.99	13945-DEFAULT-l.jpg	34.99	13945-DEFAULT-m.jpg	CYCLOPS HADES HORIZON	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	705	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	9	25-to-50	0.00	[empty string]	Cyclops Hades Horizon 500 Lumens Headlamp	<p><strong>DESCRIPTION:</strong></p><p>The xyclops hades horizon removable and rechargeable headlamp runs up to 3 hours.Featuring 500 lumens, 100 meter range, magnetic charging cable, removable clip and rechargeable battery.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Output: 250/500 Lumens</li><li>Bulb Type: P9 LED</li><li>Weight: 1.94 oz</li><li>Battery: 16340 Li-ion</li><li>Proofs: Water Resistant</li><li>Color: Black Anodized</li><li>Rechargeable: Yes</li><li>Filter Color: Red/White.</li><li>WEIGHT: 1.0000 lbs</li><li>DIMENSIONS: 24.0000 0.0000 0.0000 in</li><li>PROOFS: Water Resistant</li><li>RECHARGEABLE: Yes</li><li>COLOR: Black Anodized</li><li>FILTER COLOR: Red/White</li><li>BULB TYPE: P9 LED</li><li>OUTPUT: 250/500 Lumens</li><li>BATTERY: 16340 Li-ion</li><li>WEIGHT: 1.94 oz</li><li>UPC: 888151032893</li><li>MPN: CYC-HLH500</li><li>BRAND: Cyclops</li></ul>	[empty string]	N	39.99	39.99	[empty string]	13945-DEFAULT-s.jpg	[empty string]	1000	1000	CYC-HLH500	131517	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cyclops/cyclops-hades-horizon-500-lumens-headlamp-131517	CYC-HLH500	0
5	[empty string]	CYCLOPS	Cyclops	HUNTING	Hunting	[empty string]	1	49.99	1	29.99	4979-DEFAULT-l.jpg	49.99	4979-DEFAULT-m.jpg	CYCLOPS CYC-LBDR126-RM	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	705	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	63	25-to-50	0.00	[empty string]	Cyclops 20" Bottom Mount LED Light Bar	<ul><li>Top of the line gsm product</li><li>Durable and long lasting Flashlight</li><li>Cyclops bar mount light CYC-LBDR126-BM </li></ul>	[empty string]	Y	29.99	29.99	8820LUM	4979-DEFAULT-s.jpg	[empty string]	1000	1000	CYC-LBDR126-RM	131519	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cyclops/cyclops-20-bottom-mount-led-light-bar-131519	CYC-LBDR126-RM	0
6	[empty string]	CYCLOPS	Cyclops	HUNTING	Hunting	[empty string]	1	19.99	1	9.99	4980-DEFAULT-l.jpg	19.99	4980-DEFAULT-m.jpg	CYCLOPS CYC-LBWHK HARNESS	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	705	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	70	5-to-10	0.00	[empty string]	Cyclops Universal Wiring Kit	<p> </p><ul><li><strong>Type:</strong> Wiring Harness</li><li><strong>Function:</strong> Remote Switch</li><li><strong>Battery:</strong> None</li><li><strong>Screen Type:</strong> None</li><li><strong>Backlight:</strong> No</li><li><strong>Color:</strong> Black</li><li><strong>Data Cards:</strong> N/A</li><li><strong>Manufacturer Part Number:</strong> CYCLBWH1</li></ul>	[empty string]	Y	9.99	9.99	[empty string]	4980-DEFAULT-s.jpg	[empty string]	1000	1000	CYC-LBWHK	131521	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cyclops/cyclops-universal-wiring-kit-131521	CYC-LBWHK	0
7	BLACK	CYCLOPS	Cyclops	HUNTING	Hunting	BLACK\|NULL\|NULL	1	39.99	0	39.99	1610-DEFAULT-l.jpg	39.99	1610-DEFAULT-m.jpg	CYCLOPS SEEKER PRO	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	705	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	13	25-to-50	0.00	[empty string]	Cyclops Seeker Pro Spotlight	<p>Cyclops Solutions continues to invent and light the way for avid outdoor professionals and seasonal hunters who demand reliability and long-lasting performance in their lighting gear. The Seeker Pro 1,500 Lumens 12-Volt Spotlight features a 105-Watt halogen bulb that throws those 1,500 Lumens for a long distance of 1,640 ft. It plugs right into a car, truck or ATV no batteries or recharging required. Nothing escapes the view of the Seeker Pro.</p><p><strong>SPECIFICATIONS</strong></p><ul><li>Durable ABS plastic housing</li><li>Adjustable-angle handle with soft, slip-proof TPR coating</li><li>On/off rocker switch</li><li>Retractable metal bracket/clasp</li><li>Plugs into 12-Volt accessory port</li><li>Includes heavy-gauge 10 ft. coiled cord and detachable red lens</li></ul>	[empty string]	N	39.99	39.99	1500LUM	1610-DEFAULT-s.jpg	[empty string]	1000	1000	CYC-S150012VR	131523	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cyclops/cyclops-seeker-pro-spotlight-131523	CYC-S150012VR	0
8	[empty string]	CYCLOPS	Cyclops	HUNTING	Hunting	[empty string]	1	79.99	0	79.99	4099-DEFAULT-l.jpg	79.99	4099-DEFAULT-m.jpg	CYCLOPS 1600LM SPOTLIGHT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	705	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	13	50-to-100	0.00	[empty string]	Cyclops 1600 LM Rechargeable Spotlight	<ul><li>Super Bright CREE XHP50.2 18 Watt LED</li><li>Tri-Mode illumination: High/ Low/ S.O.S.</li><li>Auto brightness reduction after 5 minutes</li><li>Included 120cm Micro USB cord</li><li>Includes dual function DC 12-24V car charger/adapter (output: DC 9V IA) with heavy-gauge 3m(10ft) coil cord</li></ul>	[empty string]	N	79.99	79.99	[empty string]	4099-DEFAULT-s.jpg	[empty string]	1000	1000	CYC-SP1600	131524	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cyclops/cyclops-1600-lm-rechargeable-spotlight-131524	CYC-SP1600	0
9	[empty string]	CYCLOPS	Cyclops	HUNTING	Hunting	[empty string]	1	149.99	0	149.99	4097-DEFAULT-l.jpg	149.99	4097-DEFAULT-m.jpg	CYCLOPS 6000LM SPOTLIGHT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	705	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	9	100-to-150	0.00	[empty string]	Cyclops 6000 LM Rechargeable Spotlight	<ul><li>Super Bright 3 CREE XHP70.2 70 Watt LED</li><li>Tri-Mode Illumination: High/Low/S.O.S</li><li>Bottom flood LED for close-range lighting or as a lantern</li><li>Auto brightness reduction after 20 minutes</li><li>Included 120cm Micro USB cord</li></ul>	[empty string]	N	149.99	149.99	[empty string]	4097-DEFAULT-s.jpg	[empty string]	1000	1000	CYC-SPL-6X	131525	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cyclops/cyclops-6000-lm-rechargeable-spotlight-131525	CYC-SPL-6X	0
10	[empty string]	CYCLOPS	Cyclops	HUNTING	Hunting	[empty string]	1	129.99	0	129.99	4098-DEFAULT-l.jpg	129.99	4098-DEFAULT-m.jpg	CYCLOPS 4500LM SPOTLIGHT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	705	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	9	100-to-150	0.00	[empty string]	Cyclops 4500 LM Rechargeable Spotlight	<ul><li>Super Bright 3 CREE XHP50.2 45 Watt LED</li><li>Tri-Mode illumination: High/ Low/ 5.0.S.</li><li>Auto brightness reduction after 5 minutes</li><li>Included 120cm Micro USB cord</li><li>Includes dual function DC 12-24V car charger/adapter (output: DC 9V IA) with heavy-gauge 3m(10ft) coil cord</li></ul>	[empty string]	N	129.99	129.99	[empty string]	4098-DEFAULT-s.jpg	[empty string]	1000	1000	CYC-SPL45X	131526	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cyclops/cyclops-4500-lm-rechargeable-spotlight-131526	CYC-SPL45X	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts4 ORDER BY sortposition asc

Filter By

Sort By

Items Per Page

Cyclops Brontes 2k- 2000 Lumen Flashlight

details

Cyclops Brontes 2k- 2000 Lumen Flashlight

Item # CYC-FLB2000 $49.99

Cyclops Steropes 700 Lumens

details

Cyclops Steropes 700 Lumens

Item # CYC-FLS700 $39.99

Cyclops Hades 1000 Lumen Headlamp

details

Cyclops Hades 1000 Lumen Headlamp

Item # CYC-HLH1000 $44.99

Cyclops Hades Horizon 500 Lumens Headlamp

details

Cyclops Hades Horizon 500 Lumens Headlamp

Item # CYC-HLH500 $39.99

Cyclops 20

details

Cyclops 20 " Bottom Mount Led Light Bar

Item # CYC-LBDR126-RM $49.99 $29.99

Cyclops Universal Wiring Kit

details

Cyclops Universal Wiring Kit

Item # CYC-LBWHK $19.99 $9.99

Cyclops Seeker Pro Spotlight

details

Cyclops Seeker Pro Spotlight

Item # CYC-S150012VR $39.99

Cyclops 1600 LM Rechargeable Spotlight

details

Cyclops 1600 Lm Rechargeable Spotlight

Item # CYC-SP1600 $79.99

Cyclops 6000 LM Rechargeable Spotlight

details

Cyclops 6000 Lm Rechargeable Spotlight

Item # CYC-SPL-6X $149.99

Cyclops 4500 LM Rechargeable Spotlight

details

Cyclops 4500 Lm Rechargeable Spotlight

Item # CYC-SPL45X $129.99