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]	COJO	Cojo	SHOOTING	Shooting	[empty string]	1	29.99	0	29.99	32051-DEFAULT-l.jpg	29.99	32051-DEFAULT-m.jpg	COJO MFG COJO2301	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4356	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	40	25-to-50	0.00	[empty string]	COJO Magnetic Gun Mount - Mount Anywhere!	<p>?<strong>FACILE INSTALLATION -</strong> we have constructed our gun magnet with two grommeted mounting holes to securely screw it in. With an easy installation, you can conveniently shift it from other vehicles. Moreover, 2 screws are enough to support the weight of your pistol and at the same time keep the sleekness of your vehicle interior.<br />?<strong>PATENTED DESIGN -</strong> US Patent# 9,528,794B2 With the competition of gun magnets in the market we have patented a unique design that's crafted for vehicular use. Our V-shape design will not only carry a gun but hold an extra mag so as to not leave you in a vulnerable position if you run out of ammo. We have patented this since we believe that our design has a potential not only for vehicles but for tactical advantages too!<br />?<strong>ENHANCED STRENGTH</strong> - made from the highest grade rare earth magnets, our product is made from strong permanent magnets categorized as rare-earth elements. This means that it produces the strongest magnetic field than other types of magnets and will definitely safely and securely hold your revolver or any pistol that you wish to keep in your car regardless of shakes and vibrations.<br />?<strong>STORAGE SOLUTIONS -</strong> It's a tactical storage solution compressed in a V-Shaped compact magnetic field! A Pistol magnet that can plant your pistol and pistol magazines in a place that you can easily access while maintaining a low profile! This is not your regular vehicle holster. It's a car gun magnet that can be discreetly placed in your car or truck.<br />?<strong>VERSATILE-</strong> Notwithstanding the fact that we specifically designed this for vehicular use, this magnet gun holder model can still be widely used in different places and for different firearms. With its V-shaped design, you can have a wide variety of options to place your gun in any angles in comparison with our counterparts.</p><p>WE ARE NOT THE CHEAPEST FOR A REASON!! The CoJo Gun Magnet is the only gun magnet on the market made that works for hunting situations and vehicle applications. With its patented V-shaped design, the magnet can hold shotguns,rifles, and pistols at an upright position without the worry of a possible accidental gun discharge. Not only can it help prevent a gun from falling over while hunting, it can also contain a gun anywhere to provide the user with fast, convenient, safe access in that time of need. CoJo Gun Magnet simply provides the user with more options for gun placement. It can be mounted in deer stands, duck blinds, home, offices, vehicles, UTV's and boats. A unique feature about the CoJo Gun Magnet is that it has a loop on each side of the magnet, which provides it with the ability to be mounted with a strap and wrapped around a tree while hunting in flooded timber, or can even be used as a tool belt around the waist. The belt loops can also be used to strap the magnet in ladderstands, climbing stands. The use of this product are simply on the bounds of imagination. DONT BE FOOLED BY COPYCATS OF THIS PRODUCT WE ARE A PATENTED PRODUCT.</p>	[empty string]	N	29.99	29.99	[empty string]	32051-DEFAULT-s.jpg	[empty string]	1000	1000	COJO2301	129868	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	cojo/cojo-magnetic-gun-mount-mount-anywhere-129868	COJO2301	0
2	[empty string]	GSM	Gsm	SHOOTING	Shooting	[empty string]	1	29.99	0	29.99	17030-DEFAULT-l.jpg	29.99	17030-DEFAULT-m.jpg	SIGHT RITE XSIBL17 BULLET	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	713	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Sight-Rite Laser Bore Sighting System \| Red Laser For 17 HMR - XSIBL17	<p>Get your rifle sighted in faster by first bore sighting with a GSM Outdoors Sight-Rite Laser Bore Sight. These caliber-specific bore sights slip into the chamber like a cartridge and shine a bright beam of laser light through the bore of the rifle. The brass case is precision machined for maximum accuracy and perfect results every time. Batteries are included.</p><p><strong>Specifications and Features:</strong></p><ul><li>GSM Outdoors BL17</li><li>.17 HMR</li><li>High output red laser</li><li>Machined brass case</li><li>Batteries included</li></ul><p> </p>	[empty string]	N	29.99	29.99	[empty string]	17030-DEFAULT-s.jpg	[empty string]	1000	1000	XSIBL17	137264	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	gsm/sight-rite-laser-bore-sighting-system-red-laser-for-17-hmr-xsibl17-137264	XSIBL17	0
3	[empty string]	GSM	Gsm	SHOOTING	Shooting	[empty string]	1	29.99	1	19.99	16742-DEFAULT-l.jpg	29.99	16742-DEFAULT-m.jpg	SIGHT RITE XSIBL222 BULLET	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	713	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	15-to-20	0.00	[empty string]	Sight-Rite Laser Bore Sighting System \| Red Laser For 222,223 Remington - XSIBL222	<p>Get meticulous accuracy with the most exacting tolerance specifications in the sighting industry. Sight-Rite is SME's precision machined caliber specific sighter that delivers unparalleled results.</p><p>It is precision machined from brass casing for optimum accuracy and has a high output laser. Included are three (3) button cell batteries.</p><table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Type</td><td>Bore Sighter</td></tr><tr><td>Caliber</td><td>223 Rem</td></tr><tr><td>Style</td><td>Laser</td></tr><tr><td>Material</td><td>Brass</td></tr><tr><td>Battery</td><td>Alkaline</td></tr><tr><td>Manufacturer Part Number</td><td>XSIBL222</td></tr></table>	[empty string]	Y	19.99	19.99	[empty string]	16742-DEFAULT-s.jpg	[empty string]	1000	1000	XSIBL222	137266	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	gsm/sight-rite-laser-bore-sighting-system-red-laser-for-222-223-remington-xsibl222-137266	XSIBL222	0
4	[empty string]	GSM	Gsm	SHOOTING	Shooting	[empty string]	1	29.99	1	9.99	16743-DEFAULT-l.jpg	29.99	16743-DEFAULT-m.jpg	SIGHT RITE XSIBL250	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	713	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	5-to-10	0.00	[empty string]	Sight-Rite Laser Bore Sighting System \| Red Laser For 22-250 Remington - XSIBL250	<p><br />Get meticulous accuracy with the most exacting tolerance specifications in the sighting industry. Sight-Rite is SME's precision machined caliber specific sighter that delivers unparalleled results. It is precision machined from brass casing for optimum accuracy and has a high output laser. Included are three (3) button cell batteries.</p><p><strong>FEATURES</strong></p><p>Series Laser Bore Sighting System<br />Caliber 22-250 rem<br />Material Brass<br />Quantity 1<br />Battery Size Alkaline</p><p> </p>	[empty string]	Y	9.99	9.99	[empty string]	16743-DEFAULT-s.jpg	[empty string]	1000	1000	XSIBL250	137267	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	gsm/sight-rite-laser-bore-sighting-system-red-laser-for-22-250-remington-xsibl250-137267	XSIBL250	0
5	[empty string]	LBE UNLIMITED	Lbe Unlimited	SHOOTING	Shooting	[empty string]	1	24.99	0	24.99	11413-DEFAULT-l.jpg	24.99	11413-DEFAULT-m.jpg	LBE UNLIMITED LBTOOL-AKSKS	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5873	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	20-to-25	0.00	[empty string]	LBE Unlimited TOOL-AKSKS Wind and Elevation Tool for Ak/SKS	<table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Model</td><td>Sight Adjustment Tool</td></tr><tr><td>Manufacturer Part Number</td><td>TOOL-AKSKS </td></tr></table>	[empty string]	N	24.99	24.99	[empty string]	11413-DEFAULT-s.jpg	[empty string]	1000	1000	LBTOOL-AKSKS	200699	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	lbe-unlimited/lbe-unlimited-tool-aksks-wind-and-elevation-tool-for-ak-sks-200699	LBTOOL-AKSKS	0
6	[empty string]	SAFARILAND	Safariland	SHOOTING	Shooting	[empty string]	1	49.99	1	29.99	557-DEFAULT-l.jpg	49.99	557-DEFAULT-m.jpg	BIANCHI 26084 HOLSTER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4092	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Bianchi Model 100 Professional Inside Waistband Holster Right Hand Size 22	<p>This leather inside the waistband design features a high back that provides a shield between the body and the sharp edges of the pistol for comfort and to protect clothing. It is designed to allow for a proper firing grip. A belt clip securely anchors the holster to the belt.</p><p>Right Hand</p><p>Size 22</p><p>Ruger LC9</p><p> </p>	[empty string]	Y	29.99	29.99	[empty string]	557-DEFAULT-s.jpg	[empty string]	1000	1000	26084	207705	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	safariland/bianchi-model-100-professional-inside-waistband-holster-right-hand-size-22-207705	26084	0
7	[empty string]	SAFARILAND	Safariland	SHOOTING	Shooting	[empty string]	1	49.99	0	49.99	16627-DEFAULT-l.jpg	49.99	16627-DEFAULT-m.jpg	SAFARILAND 578-83-412 HOLSTER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4092	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Safariland GLS Pro-Fit Black Synthetic Belt Fits Glock 17/22 - Left Hand	<p>The Model 578 GLS Pro-Fit brings the unique GLS (Grip Lock System) and SafariSeven together in a customizable holster. The GLS is an innovative technology that automatically secures the weapon when holstered and releases it upon application of the middle finger with a standard shooting grip for a more intuitive and safer release. The holster body is constructed of SafariSeven, a lightweight, state-of-the-art nylon blend which is completely non-abrasive to a gun's finish, tolerant of extreme high and low temperatures, and easy to maintain. This holster includes an injection-molded paddle and an injection-molded belt loop that is adjustable for maximum comfort and allows the holster to be worn cross draw.</p><table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Type</td><td>Concealment Holster</td></tr><tr><td>Color</td><td>Black</td></tr><tr><td>Material</td><td>Synthetic</td></tr><tr><td>Size</td><td>Medium</td></tr><tr><td>Hand</td><td>Left</td></tr><tr><td>Finish</td><td>Smooth</td></tr><tr><td>Firearm Fit</td><td>Glock 17/22</td></tr><tr><td>Mount Type</td><td>Belt Clip</td></tr><tr><td>Gun Type</td><td>Pistol</td></tr><tr><td>Compartments</td><td>1</td></tr><tr><td>Manufacturer Part Number</td><td>57883412 </td></tr></table>	[empty string]	N	49.99	49.99	[empty string]	16627-DEFAULT-s.jpg	[empty string]	1000	1000	578-83-412	207739	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	safariland/safariland-gls-pro-fit-black-synthetic-belt-fits-glock-17-22-left-hand-207739	578-83-412	0
8	[empty string]	BUSHNELL	Bushnell	SHOOTING	Shooting	[empty string]	1	799.99	0	799.99	19803-DEFAULT-l.jpg	799.99	19803-DEFAULT-m.jpg	BUSHNELL BINOCULAR FUSION	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	48	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Bushnell Binocular Fusion \| FX1042AD	<p><br /><strong>Bushnell - Fusion X - 10x42 - Rangefinding Binoculars - FX1042AD:</strong></p><p>Bushnell's Fusion X boasts superb ranging accuracy and advanced optics for the best of both worlds in one unit. Bushnell's HDOS - High-Definition Optical System - provides optimum viewing clarity, and you never have to worry about the rangefinder falling short because this unit delivers detailed readings for distances up to a full mile. Built to take the hard knocks field use deals out, this full-size 10X42 design supports a rock-steady hold and great magnification but without being too bulky and heavy. The Fusion X won't so much blink when the weather gets rough and your view won't be compromised thanks to its IPX7 waterproofing and Exo-Barrier lens coatings. Whether it's meat for the table or a chance at the buck or bull of a lifetime, the Fusion X will be there when you need it most.</p><p><strong>ActivSync Technology</strong></p><p>First of its kind ActivSync display technology fluidly morphs from black readouts against bright backgrounds to red readouts against dark ones, with infinitely variable tones. No more lost readings on game in deep cover. No more washed-out numbers on those super-bright cloudless days. No more guessing about whether you're seeing a 600 or an 800 or ranging a buck or a tree. This is what best-in-class rangefinding was destined to be.</p><p>Covered by Bushnell's Ironclad warranty.<br />Electro-Optics & Electronic Components = 5 years</p><p><strong>Features & Designs:</strong></p><ul><li>Magnification: 10x</li><li>Colour: Black</li><li>Objective Diameter: 42mm</li><li>Weight: 2.18 lbs.</li><li>Length: 7.0 inch</li><li>Water/Fog Proof: Yes, IPX7 / Nitrogen gas purged</li><li>FOV at 100 yards: 305 yards</li><li>Battery Included: Yes</li><li>Battery Type: CR2</li><li>Ranging (Deer/Flag): 700 yards</li><li>Ranging (Tree): 900 yards</li><li>Ranging (Reflective): 1760 yards</li><li>ActivSync Technology</li><li>IPX7 Waterproof construction</li><li>Full one-mile ranging capabilities</li><li>EXO Barrier lens protection to defend against snow, sleet, pouring rain, fog & grit</li><li>High Definition Optical System</li></ul>	[empty string]	N	799.99	799.99	10X42	19803-DEFAULT-s.jpg	[empty string]	1000	1000	FX1042AD	227545	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bushnell/bushnell-binocular-fusion-fx1042ad-227545	FX1042AD	0
9	BLACK	BUSHNELL	Bushnell	SHOOTING	Shooting	BLACK\|NULL\|NULL	1	149.99	1	99.99	7268-DEFAULT-l.jpg	149.99	7268-DEFAULT-m.jpg	BUSHNELL TROPHY XLT 3-9x40	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	48	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	10	50-to-100	0.00	[empty string]	Bushnell Trophy XLT	<p>Excellent low-light performance and resolution with Rainguard HD coating that repels water on the lens.</p><ul><li>EXCELLENT LOW LIGHT PERFORMANCE AND IMAGE QUALITY Trophy XLT has improved optical performance that boosts contrast and clarity with fully multi-coated lenses.</li><li>KEEP YOUR IMAGE CLEAR IN RAIN AND WATER WITH RAINGUARD HD Rainguard HD coating repels water on the lens so your image is always clear and allows you to make the shot.</li><li>DOA QUICK BALLISTIC RETICLE FOR FAST, ACCURATE SHOTS WITH ANY CALIBER The DOA Quick Ballistic Reticle provides 5 drop points with 5 mph wind hold lines. The reticle can be used for any caliber that matches your typical hunting cartridges out to 500 yards. With the free Bushnell Ballistics App you can quickly determine your exact distances on the reticle making it easy to have confidence in every shot.</li><li>LIGHTWEIGHT, WATERPROOF SEALED, ONE PIECE AIRCRAFT GRADE ALUMINUM BODY Trophy XLT is built to withstand the elements and will stay in the hunt as long as you can.</li></ul>	[empty string]	Y	99.99	99.99	3/9X40	7268-DEFAULT-s.jpg	[empty string]	1000	1000	RT3940BS11	227561	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bushnell/bushnell-trophy-xlt-227561	RT3940BS11	0
10	BLACK	BUSHNELL	Bushnell	SHOOTING	Shooting	BLACK\|NULL\|NULL	1	179.99	0	179.99	7267-DEFAULT-l.jpg	179.99	7267-DEFAULT-m.jpg	BUSHNELL TROPHY XLT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	48	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	150-to-200	0.00	[empty string]	Bushnell Trophy XLT	<p>Excellent low-light performance and resolution with Rainguard HD coating that repels water on the lens.</p><ul><li>EXCELLENT LOW LIGHT PERFORMANCE AND IMAGE QUALITY Trophy XLT has improved optical performance that boosts contrast and clarity with fully multi-coated lenses.</li><li>KEEP YOUR IMAGE CLEAR IN RAIN AND WATER WITH RAINGUARD HD Rainguard HD coating repels water on the lens so your image is always clear and allows you to make the shot.</li><li>DOA QUICK BALLISTIC RETICLE FOR FAST, ACCURATE SHOTS WITH ANY CALIBER The DOA Quick Ballistic Reticle provides 5 drop points with 5 mph wind hold lines. The reticle can be used for any caliber that matches your typical hunting cartridges out to 500 yards. With the free Bushnell Ballistics App you can quickly determine your exact distances on the reticle making it easy to have confidence in every shot.</li><li>LIGHTWEIGHT, WATERPROOF SEALED, ONE PIECE AIRCRAFT GRADE ALUMINUM BODY Trophy XLT is built to withstand the elements and will stay in the hunt as long as you can.</li></ul>	[empty string]	N	179.99	179.99	4/12X40	7267-DEFAULT-s.jpg	[empty string]	1000	1000	RT4124BS11	227562	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bushnell/bushnell-trophy-xlt-227562	RT4124BS11	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts104 ORDER BY sortposition asc