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] COLEMAN Coleman HUNTING Hunting [empty string] 1 7.99 0 7.99 24306-DEFAULT-l.jpg 7.99 24306-DEFAULT-m.jpg COLEMAN 332418 PROPANE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 752 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 567 5-to-10 0.00 [empty string] Coleman Propane Camping Cylinder 16-oz. <p>The lightweight, universal one pound Propane Cylinder is compatible with most portable stoves, lanterns, heaters and camping appliances. Constructed of durable steel with reliable valves that are safe and easy to use.</p><ul><li>CGA600 valve fits most portable appliances, grills and lanterns requiring propane</li><li>Lightweight design for portability</li><li>Durable steel construction</li></ul> [empty string] N 7.99 7.99 [empty string] 24306-DEFAULT-s.jpg [empty string] 1000 1000 332418 129925 EMPTY EMPTY EMPTY 0 0 0 EMPTY coleman/coleman-propane-camping-cylinder-16-oz-129925 332418 0
2 [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
3 [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
4 [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
5 [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
6 [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
7 [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
8 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
9 [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
10 [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
CACHED false
EXECUTIONTIME 1
SQL SELECT * FROM GetALLProducts4 ORDER BY sortposition asc