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] 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
3 [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
4 [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
5 [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
6 [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
7 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
8 SB_200 SPYPOINT Spypoint HUNTING Hunting SB_200|NULL|NULL 1 64.99 0 64.99 2564-DEFAULT-l.jpg 64.99 2564-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] 36 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 64.99 64.99 [empty string] 2564-DEFAULT-s.jpg [empty string] 1000 1000 SB200 190573 EMPTY EMPTY EMPTY 0 0 0 EMPTY spypoint/spypoint-steel-security-boxes-190573 SB200 0
9 [empty string] DEADEND Deadend HUNTING Hunting [empty string] 1 69.99 0 69.99 19625-DEFAULT-l.jpg 69.99 19625-DEFAULT-m.jpg DEADEND GAME CALLS RB001 N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 6142 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 3 50-to-100 0.00 [empty string] Deadend Game Calls Roadblock Cedar Glass Call <p>MADE FROM PREMIUM CEDAR, EACH CALL IS HAND TESTED AND MATCHED WITH A STRIKER TO ENSURE TOP LEVEL TURKEY TALK STRAIGHT FROM THE PACKAGE. THIS CALL WILL GIVE THE HIGH AND CLEAR FRONT END THAT ROLLS OVER INTO MEDIUM RASP, DRIVING A LONGBEARD CRAZY. THIS IS A GREAT CALL TO REACH A GOBBLER ON A WINDY DAY. THE ROADBLOCK CEDAR GLASS CALL IS A VERY USER FRIENDLY CALL TO HELP BRING A LONGBEARD DOWN A DEAD END ROAD!</p> [empty string] N 69.99 69.99 [empty string] 19625-DEFAULT-s.jpg [empty string] 1000 1000 RB001 241947 EMPTY EMPTY EMPTY 0 0 0 EMPTY deadend/deadend-game-calls-roadblock-cedar-glass-call-241947 RB001 0
10 [empty string] DEADEND Deadend HUNTING Hunting [empty string] 1 69.99 0 69.99 19626-DEFAULT-l.jpg 69.99 19626-DEFAULT-m.jpg DEADEND GAME CALLS RB002 N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 6142 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 50-to-100 0.00 [empty string] Deadend Game Calls Roadblock Slate Call <p>MADE FROM PREMIUM CHERRY WOOD, THIS SLATE OVER GLASS IS HAND TESTED AND INDIVIDUALLY MATCHED WITH A STRIKER. THE ROADBLOCK SLATE CALL WILL PROVIDE A LARGE VOLUME FOR RUNNING AND GUNNING THAT REACHES OUT TO MAKE A GOBBLER SHOCK GOBBLE. IT WILL ALSO GET DOWN AND DIRTY WITH THE SOFT STUFF SUCH AS SOFT YELPS, CLUCKS AND PURRS TO FINISH OFF THE WEARIEST OF LONGBEARDS. THE ROADBLOCK SLATE CALL TO HELP YOU BRING A LONGBEARD DOWN A DEAD END ROAD!</p> [empty string] N 69.99 69.99 [empty string] 19626-DEFAULT-s.jpg [empty string] 1000 1000 RB002 241948 EMPTY EMPTY EMPTY 0 0 0 EMPTY deadend/deadend-game-calls-roadblock-slate-call-241948 RB002 0
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts4 ORDER BY sortposition asc