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]	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" 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 & 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" dimensions</li><li>Strap included to mount onto trees and poles</li><li>1/4"-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]	LATITUDE	Latitude	HUNTING	Hunting	[empty string]	1	31.99	0	31.99	18202-DEFAULT-l.jpg	31.99	18202-DEFAULT-m.jpg	LATITUDE OUTDOORS BACK BAND	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6102	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Latitude Outdoors Back Band	<p>Upgrade your tree saddle hunting setup with the Back Band by Latitude Outdoors. This accessory is highly suited for use with a single panel saddle like the Classic 2, but is equally compatible with two panel saddles like the Method 2. The Back Band offers enhanced comfort, allowing you to stay in the tree for longer periods, and helps cut down on back fatigue especially when used with a single panel saddle. It quickly attaches to your carabiner clip, and conforms to your body's natural shape no matter what position it's in. The Back Band weighs in at a mere 3 ounces, and is smaller than a cell phone for easy storage and transportation.</p><p><strong>Features of the Back Band:</strong></p><ul><li>Works with both single and two panel tree saddles</li><li>Conforms to your body's natural shape</li><li>Provides extra support and comfort for longer periods in the tree</li><li>Helps reduce back fatigue</li><li>Lightweight, compact design</li><li>Available in regular and XL sizes</li></ul>	[empty string]	N	31.99	31.99	[empty string]	18202-DEFAULT-s.jpg	[empty string]	1000	1000	AX-BB-REG	200625	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	latitude/latitude-outdoors-back-band-200625	AX-BB-REG	0
10	[empty string]	LATITUDE	Latitude	HUNTING	Hunting	[empty string]	1	329.99	0	329.99	18204-DEFAULT-l.jpg	329.99	18204-DEFAULT-m.jpg	LATITUDE OUTDOORS X WING PLATFORM	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6102	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	300-to-350	0.00	[empty string]	Latitude Outdoors Rebel Speed Series Platform	<p>The Rebel Platform is only 2.7 pounds, it delivers the best surface area to weight ratio available. It's pentagon shape supports maneuverability with meticulously designed perimeter edges to counteract gravitational pull into the tree. The rearward facing edges are longer making moves around the tree easier and safer, and their location relative to the pivot point on the post ensures the platform will not uncam when load is applied while taking a backside shot.</p><ul><li>Dimensions: 11.95 in X 13.29 in</li><li>6061 Aluminum</li><li>Weight: (approx) 44 oz</li><li>Downward facing bevel for proper camming action and better stability on the tree</li></ul>	[empty string]	N	329.99	329.99	[empty string]	18204-DEFAULT-s.jpg	[empty string]	1000	1000	RSS-SP	200633	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	latitude/latitude-outdoors-rebel-speed-series-platform-200633	RSS-SP	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts4 ORDER BY sortposition asc