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] NIGHTSTICK Nightstick HUNTING Hunting [empty string] 1 39.99 0 39.99 34896-DEFAULT-l.jpg 39.99 34896-DEFAULT-m.jpg NIGHTSTICK N AMAZON [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5625 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 25-to-50 0.00 [empty string] Nightstick NSP4610B Multi-Function Green/Red/White LED Bulb - 93 Meters Beam Distance <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. Includes user-programmable Battery Safe Mode. Power comes from three AAA batteries (included).</p><p><strong>Features</strong></p><ul><li>LED technology</li><li>High/low spotlight</li><li>White/Red/Green floodlight</li><li>User-programmable Battery Safe Mode</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 &amp; chemical resistant</li><li>3 AAA batteries (included)</li></ul><p><strong>Specifications</strong></p><ul><li>UPC: 017398802376</li><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 (m): 93</li><li>Medium Beam Distance (m): 67</li><li>High Candela: 2,170</li><li>Low Candela: 1,110</li><li>Drop Rating: 2 m</li><li>Water Rating: IP-X7 Waterproof</li><li>High Runtime (h): 4.5</li><li>Low Runtime (h): 8.5</li><li>High Flood Runtime (h): 4.5</li><li>Medium Flood Runtime (h): 25</li><li>Low Flood Runtime (h): 25</li><li>Floodlight Color: White/Red/Green</li><li>Switch Function: Dual Switches. High/Low Spotlight, White/Red/Green Floodlight. Battery Safe Mode.</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 &amp; 3 AAA Batteries</li><li>US Patent(s) : 9713217</li><li>Warranty: Limited Lifetime Warranty</li></ul> [empty string] N 39.99 39.99 [empty string] 34896-DEFAULT-s.jpg [empty string] 1000 1000 NSP4610B 147726 EMPTY EMPTY EMPTY 0 0 0 EMPTY nightstick/nightstick-nsp4610b-multi-function-green-red-white-led-bulb-93-meters-beam-distance-147726 NSP4610B 0
3 [empty string] NIGHTSTICK Nightstick HUNTING Hunting [empty string] 1 27.99 0 59.99 34904-DEFAULT-l.jpg 27.99 34904-DEFAULT-m.jpg NIGHTSTICK MINI TAC N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5625 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 11 50-to-100 0.00 [empty string] Nightstick USB-320 Tactical Aluminum White Cree LED 320 Lumens - 111 Meters Range <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. Includes both momentary or constant-on functionality. This light features an IP-X7 rated waterproof, chemical, heat, and impact-resistant housing. The sleeved collar discretely opens for direct USB charging. While charging the light turns red and turns green when fully charged. Meets requirements of NFPA-1971-8.6 (2013). Includes a 2 foot USB-C charging cable and Li-ion rechargeable battery.</p><p><strong>Features</strong></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-C cord with rechargeable lithium-ion battery (included)</li><li>Serialized for personal identification</li><li>Limited Lifetime Warranty</li></ul><p><strong>Specifications</strong></p><ul><li>UPC: 017398806015</li><li>High Lumens: 320</li><li>High Beam Distance (m): 157</li><li>High Candela: 6,168</li><li>Drop Rating: 2 m</li><li>Water Rating: IP-X7 Waterproof</li><li>High Runtime (h): 1.5</li><li>Charge Time (h): 4</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 ft</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-C Charging Cord</li><li>Warranty: Limited Lifetime Warranty</li></ul><p> </p> [empty string] N 59.99 59.99 [empty string] 34904-DEFAULT-s.jpg [empty string] 1000 1000 USB320 147730 EMPTY EMPTY EMPTY 0 0 0 EMPTY nightstick/nightstick-usb-320-tactical-aluminum-white-cree-led-320-lumens-111-meters-range-147730 USB320 0
4 [empty string] NIGHTSTICK Nightstick HUNTING Hunting [empty string] 1 48.99 0 99.99 34906-DEFAULT-l.jpg 48.99 34906-DEFAULT-m.jpg NIGHTSTICK EXTREME TACTICAL N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5625 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 8 50-to-100 0.00 [empty string] Nightstick USB-558XL Tactical Aluminum White Cree LED 100/350/900 Lumens - 215 Meters Range <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>The USB-558XL is rated IP-X7 waterproof and features a discretely sleeved collar that opens for direct USB charging. The built-in charging indicator turns from red to green when fully charged. Included is a 2 foot USB-C charging cable, lithium-ion rechargeable battery, and CR123 battery carrier (batteries not included) for added convenience.</p><p><strong>Features</strong></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><strong>Specifications</strong></p><ul><li>UPC: 017398806022</li><li>Multi-Function: Yes</li><li>High Lumens: 1100</li><li>Medium Lumens: 450</li><li>Low Lumens: 125</li><li>High Beam Distance (m): 235</li><li>Medium Beam Distance (m): 148</li><li>Low Beam Distance (m): 79</li><li>High Candela: 13843</li><li>Medium Candela: 5447</li><li>Low Candela: 1550</li><li>Drop Rating: 2 m</li><li>Water Rating: IP-X7 Waterproof</li><li>High Runtime (h): 2</li><li>Medium Runtime (h): 4.5</li><li>Low Runtime (h): 22</li><li>Charge Time (h): 4</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 ft</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><li>US Patent(s) : 9713217</li><li>Warranty: Limited Lifetime Warranty</li></ul> [empty string] N 99.99 99.99 [empty string] 34906-DEFAULT-s.jpg [empty string] 1000 1000 USB558XL 147731 EMPTY EMPTY EMPTY 0 0 0 EMPTY nightstick/nightstick-usb-558xl-tactical-aluminum-white-cree-led-100-350-900-lumens-215-meters-range-147731 USB558XL 0
5 [empty string] SPYPOINT Spypoint HUNTING Hunting [empty string] 1 14.99 0 19.99 17029-DEFAULT-l.jpg 14.99 17029-DEFAULT-m.jpg SPYPOINT MICROSD 32GB CARD N AMAZON [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4346 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 16 15-to-20 0.00 [empty string] Spypoint Micro SD 32 GB Memory Card <p><strong>Specifications:</strong></p><ul><li>Spypoint 05892 Micro Sd Memory Card 32Gb</li><li>32Gb Memory Card.</li><li>Function: Stores Pictures/Video</li><li>Color: Black</li></ul> [empty string] N 19.99 19.99 [empty string] 17029-DEFAULT-s.jpg [empty string] 1000 1000 05892 190524 EMPTY EMPTY EMPTY 0 0 0 EMPTY spypoint/spypoint-micro-sd-32-gb-memory-card-190524 05892 0
6 [empty string] SPYPOINT Spypoint HUNTING Hunting [empty string] 1 79.99 1 49.99 2072-DEFAULT-l.jpg 79.99 2072-DEFAULT-m.jpg SPYPOINT LONG RANGE ANTENNA N AMAZON [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4346 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 239 25-to-50 0.00 [empty string] Spypoint Long Range Cellular Antenna <p>Take advantage of an enhanced signal by combining the CA-01 cellular antenna to your cellular camera. Suitable for the Link-Evo, Link-S and Link-Dark camera models. Also compatible with most of cellular cameras on the market, adaptor provided in the box.</p><p>Ideal for low cellular coverage areas, the CA-01 has a 15' long wire.</p><p>Easy to install with the metal bracket included in the box.</p><p>External omnidirectional antenna (passive) </p><ul><li>- Enhances cellular signal (effective in low coverage area) </li><li>- 15 ft cable length, RP-SMA male connector </li><li>- Bracket for easy installation </li><li>- Do not require any external power </li><li>- Compatible with most cellular trail cameras</li></ul> [empty string] Y 49.99 49.99 [empty string] 2072-DEFAULT-s.jpg [empty string] 1000 1000 CA01-2 190529 EMPTY EMPTY EMPTY 0 0 0 EMPTY spypoint/spypoint-long-range-cellular-antenna-190529 CA01-2 0
7 [empty string] SPYPOINT Spypoint HUNTING Hunting [empty string] 1 149.99 1 89.99 33516-DEFAULT-l.jpg 149.99 33516-DEFAULT-m.jpg SPYPOINT FORCE-PRO CAMERA N AMAZON [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4346 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 13 50-to-100 0.00 [empty string] Spypoint Force Pro 30MP HD Trail Camera In Camo <p>The FORCE-PRO from SPYPOINT is a workhorse trail camera with all the features you need, like the fast 0.2-second trigger speed. Features a detection range out to 110'; still images are delivered in 30MP resolution; video can be captured in 4K mode; 54 LEDs; color by day infrared by night and Buck Tracker Detection Technology. Requires an SD/SDHC card up to 128 GB. Includes 16GB SD card, strap and quick start guide.</p><p><strong>General</strong></p><ul><li>Super-fast 0.2-second trigger speed ensures you won't miss a thing</li><li>54 IR LED flash with a range of about 90 feet</li><li>No-glow flash won't disturb animals when it goes off in the pitch dark</li><li>Up to 110-foot detection range</li><li>One motion sensor covers three detection zones</li><li>Delay mode allows you to select the time period before the camera can detect again and take another photo or video</li><li>Accepts SD memory cards from 2 to 128GB, 16GB card included</li><li>1.5&quot; LCD screen with simple navigation buttons and a menu-driven interface allows you to set up and configure the camera in the field</li><li>Runs on eight user-supplied alkaline AA batteries or an optional 12 VDC external battery</li><li>Language support for English, German, French</li></ul><p><strong>Photos</strong></p><ul><li>Selectable resolution of 4, 16, or 30MP</li><li>Color by day, black &amp; white (IR) at night</li><li>Date, time, moon phase, and temperature ( C/ F) stamp</li><li>Set motion-detector sensitivity -- Low, Normal, High, Auto</li><li>Multi-shot mode takes up to 6 photos per detection, configurable in settings</li></ul><p><strong>Video</strong></p><ul><li>Up to 4K 10 fps recording -- choose lower quality to use less memory: VGA, HD, FHD, QHD</li><li>Frame rates: 4k video @ 10 fps, 2560x1440 @ 25 fps, 1080p video @ 30 fps, 720p @ 60 fps</li><li>Selectable 10-, 20-, 30-, 60-second recording times</li><li>Audio recording on all video settings</li></ul><p><strong>Mounting</strong></p><ul><li>3.8 x 5.0 x 2.7&quot; dimensions</li><li>Strap included to mount onto trees and poles</li><li>1/4&quot;-20 socket allows you to mount the camera on support systems in an area without trees, like in a field</li></ul> [empty string] Y 89.99 89.99 [empty string] 33516-DEFAULT-s.jpg [empty string] 1000 1000 FORCE-PRO 190539 EMPTY EMPTY EMPTY 0 0 0 EMPTY spypoint/spypoint-force-pro-30mp-hd-trail-camera-in-camo-190539 FORCE-PRO 0
8 [empty string] SPYPOINT Spypoint HUNTING Hunting [empty string] 1 179.99 1 149.99 4289-DEFAULT-l.jpg 179.99 4289-DEFAULT-m.jpg SPYPOINT LINK MICRO SOLAR LTEV N AMAZON [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4346 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 100-to-150 0.00 [empty string] Spypoint LINKMICROS Link-Micro-S-LTE Verizon Nationwide Camo 10 MP Resolution MicroSD Card Slot/Up to 32GB Memory <p>The LINK-MICRO-S-LTE brings the popular integrated solar panel technology that has been so popular in other SPYPOINT cameras, to the LINK-MICRO family of cellular game cameras. The LINK-MICRO-S-LTE has a small passive solar panel built right into the camera, that directly charges the LIT-10 lithium battery pack, which takes the place of the battery tray from other LINK-MICRO cameras. This marriage of solar charging capabilities and rechargeable lithium battery packs means battery life is going to a whole new level. Not only that, but because the images are transmitted out on the available cellular network, you can avoid making trips and disturbing game to check cards. With the number of trips required to service cards or batteries drastically reduced, you save time, money, and are far less likely to disturb and stress game with frequent trips on your hunting property. When you factor in all the advanced mobile scouting tools from SPYPOINT in the SPYPOINT App, you can see why SPYPOINT is the definitive mobile scouting solution.</p> [empty string] Y 149.99 149.99 [empty string] 4289-DEFAULT-s.jpg [empty string] 1000 1000 LINK-MICRO-SLTE-3 190554 EMPTY EMPTY EMPTY 0 0 0 EMPTY spypoint/spypoint-linkmicros-link-micro-s-lte-verizon-nationwide-camo-10-mp-resolution-microsd-card-slot-up-to-32gb-memory-190554 LINK-MICRO-SLTE-3 0
9 [empty string] SPYPOINT Spypoint HUNTING Hunting [empty string] 1 64.99 1 39.99 6995-DEFAULT-l.jpg 64.99 6995-DEFAULT-m.jpg SPYPOINT LITHIUM BATTERY PACK N AMAZON [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4346 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 94 25-to-50 0.00 [empty string] Spypoint LIT-10 Rechargeable Battery 3.7v Lithium <p> </p><ul><li>Manufacturer: Spypoint</li><li>Model: LIT-10</li><li>UPC: 887157020118</li><li>SKU: LIT10</li><li>Width: 3.6000</li><li>Length: 5.8000</li><li>Height: 2.1000</li><li>Weight: 0.5450</li><li>Chemical Composition: Lithium</li><li>Dimension: 2.20 X 3.70 X 5.85</li><li>Nominal Voltage: 3.7V</li><li>Rated Capacity Mah: 10,000</li><li>Rechargeable: Yes</li><li>Series: Rechargeable Battery</li><li>Weight: 0.50 lbs</li></ul> [empty string] Y 39.99 39.99 [empty string] 6995-DEFAULT-s.jpg [empty string] 1000 1000 LIT-10-2 190568 EMPTY EMPTY EMPTY 0 0 0 EMPTY spypoint/spypoint-lit-10-rechargeable-battery-3-7v-lithium-190568 LIT-10-2 0
10 SB_300 SPYPOINT Spypoint HUNTING Hunting SB_300|NULL|NULL 1 59.99 0 59.99 3566-DEFAULT-l.jpg 59.99 3566-DEFAULT-m.jpg SPYPOINT SECURITY BOX N AMAZON [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4346 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 50-to-100 0.00 [empty string] Spypoint Steel Security Boxes <p><strong>SB-200</strong></p><p>Fitting all 42 LED SPYPOINT cameras including the SOLAR, the SB-200 is an armored shell for your game camera. It keeps your SPYPOINT camera secured and protected from both damage and theft.</p><p>- Hole on front to a install a padlock<br />- Holes on both side to insert a cable-lock<br />- Holes on back to anchor it to a tree or wall</p><p>Compatible with cameras:<br />- FORCE-DARK<br />- SOLAR-DARK<br />- LINK-EVO<br />- LINK-S<br />- LINK-DARK</p><p><strong>*Steel boxes may affect wireless connectivity, especially in low-reception areas.</strong></p><p><strong>SB-300</strong></p><p>Fitting all 4 power LED SPYPOINT cameras including the LINK-MICRO, the SB-300 is an armored shell for your game camera. It keeps your SPYPOINT camera secured and protected from both damage and theft.</p><p>- Hole on front to a install a padlock<br />- Holes on both side to insert a cable-lock<br />- Holes on back to anchor it to a tree or wall</p><p>Compatible with cameras:<br />- LINK-MICRO</p><p><strong>*Steel boxes may affect wireless connectivity, especially in low-reception areas.</strong></p> [empty string] N 59.99 59.99 [empty string] 3566-DEFAULT-s.jpg [empty string] 1000 1000 SB-300 190572 EMPTY EMPTY EMPTY 0 0 0 EMPTY spypoint/spypoint-steel-security-boxes-190572 SB-300 0
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts4 ORDER BY sortposition asc