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]	LEUPOLD + STEVENS IN	Leupold + Stevens In	SHOOTING	Shooting	[empty string]	1	64.99	0	64.99	4440-DEFAULT-l.jpg	64.99	4440-DEFAULT-m.jpg	LEUPOLD MOUNT 10293	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	179	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Leupold 10293 Mount System Mark4 IMS 20 MOA Rail Insert	<p>The Leupold Mark 4 IMS Rail 20 MOA Integral Rail Insert 110293 is a part of a system designed for compatibility and ease of use. This Mark 4 AR 20 MOA insert will give you proper placement of the riflescope on your AR rifle. Leupold Mark 4 IMS 20-MOA Integral Rail Insert models come with the Leupold Full Lifetime Guarantee and are field tested for durability and strength for your mounts. The Mark 4 IMS from Leupold gives you the correct scope height and eye relief, with Leupold mount construction quality. The Leupold I M S raises the scope and pushes it forward, so you can have a much broader scope compatibility than traditional ring inserts.</p>	[empty string]	N	64.99	64.99	[empty string]	4440-DEFAULT-s.jpg	[empty string]	1000	1000	10293	200959	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	leupold-stevens-in/leupold-10293-mount-system-mark4-ims-20-moa-rail-insert-200959	10293	0
2	[empty string]	LEUPOLD + STEVENS IN	Leupold + Stevens In	SHOOTING	Shooting	[empty string]	1	34.99	0	34.99	4443-DEFAULT-l.jpg	34.99	4443-DEFAULT-m.jpg	LEUPOLD 114975 DD 2 PC BASE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	179	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Leupold 2 Piece Base Dual Dovetail Savage With Round Receiver Matte	<p>Machined steel construction. Provides a classic low-profile mount for scopes on a variety of popular actions. Bases accept all Leupold rotary dovetail rings. Dovetail connections at both front and rear.</p><p><strong>Attributes</strong></p><ul><li><strong>Made In The USA:</strong> Made In The USA</li><li><strong>Finish:</strong> Matte</li><li><strong>Type:</strong> Two Piece</li><li><strong>For:</strong> Savage 10/110 With Round Receiver</li><li><strong>Manufacturer Part Number:</strong> 114975 </li></ul>	[empty string]	N	34.99	34.99	[empty string]	4443-DEFAULT-s.jpg	[empty string]	1000	1000	114975	200968	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	leupold-stevens-in/leupold-2-piece-base-dual-dovetail-savage-with-round-receiver-matte-200968	114975	0
3	[empty string]	LEUPOLD + STEVENS IN	Leupold + Stevens In	SHOOTING	Shooting	[empty string]	1	349.99	0	349.99	24385-DEFAULT-l.jpg	349.99	24385-DEFAULT-m.jpg	LEUPOLD 115836 MOUNT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	179	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	300-to-350	0.00	[empty string]	Leupold Base For Mark 6 Integral Mounting System Style Matte Finish	<p>Designed specifically for tactical use. Features a monolithic, cantilever design. Integral base/ring (formed from one piece of bar stock) affixed securely to the picatinny rail of most AR and other tactical rifles. Ring spacing is pre-set and return-to-zero more accurate. Matte black finish.</p><ul><li>Retail Price : 469.99</li><li>Tube Diameter : 34mm</li><li>Description : Integral Mounting System Mark 6 34mm Matte Black</li><li>Made In The USA : Made In The USA</li><li>Tactica : Tactical</li><li>Catalog Vendor Name : LEUPOLD</li><li>Desc. : Mounting system</li><li>Finish : Matte Black</li><li>For : Mark 6</li></ul>	[empty string]	N	349.99	349.99	[empty string]	24385-DEFAULT-s.jpg	[empty string]	1000	1000	115836	200974	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	leupold-stevens-in/leupold-base-for-mark-6-integral-mounting-system-style-matte-finish-200974	115836	0
4	[empty string]	LEUPOLD + STEVENS IN	Leupold + Stevens In	SHOOTING	Shooting	[empty string]	1	99.99	0	99.99	17118-DEFAULT-l.jpg	99.99	17118-DEFAULT-m.jpg	LEUPOLD 117607 LENS COVER	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	179	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Alumina Flip Back Lens Cover 42mm	<p>Compatible with Leupold post-2004 riflescopes with 42mm objective lenses. Not compatible with M8 and FX-3 42mm riflescopes.</p><p>Designed for Leupold scopes built after 2004, Alumina Flip-Back lens covers feature powerful neodymium magnets to hold them securely closed, and the triple O-ring seals provide maximum protection from the elements. Constructed out of durable 6061-T6 aircraft grade aluminum, they are precisely machined to allow for quick and easy operation, and a low-profile position, when open, make these Flip-Back lens covers stand above the rest. The round objective and ocular models can be rotated so they can open in any direction.</p><p><strong>FEATURES</strong></p><p>Material Aluminum<br />Weight (oz) .74</p><p>Size 42mm</p><p> </p>	[empty string]	N	99.99	99.99	[empty string]	17118-DEFAULT-s.jpg	[empty string]	1000	1000	117607	200975	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	leupold-stevens-in/alumina-flip-back-lens-cover-42mm-200975	117607	0
5	[empty string]	LEUPOLD + STEVENS IN	Leupold + Stevens In	SHOOTING	Shooting	[empty string]	1	99.99	0	99.99	4474-DEFAULT-l.jpg	99.99	4474-DEFAULT-m.jpg	LEUPOLD 117611 LENS COVER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	179	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	Leupold Alumina Flip-Back Lens Cover Eyepiece 36mm	<p>Compatible with Leupold post-2004 riflescopes with 36mm objective lenses, as well as the VX -3 Handgun 2.5-8x32mm.</p><p>Our Alumina Flip-Back lens covers feature powerful neodymium magnets to hold them securely closed, and triple O-ring seals to provide maximum protection from the elements. Constructed out of durable 6061-T6 aircraft grade aluminum, they are precisely machined to allow for quick and easy operation, and a low-profile position, when open, make these Flip-Back lens covers stand above the rest. The round objective and ocular models can rotate so that they can open in any direction.</p><p><strong>FEATURES</strong></p><p>Material Aluminum<br />Weight (oz) .53</p><p>Matte finish</p><p>Size 36mm</p><p> </p>	[empty string]	N	99.99	99.99	[empty string]	4474-DEFAULT-s.jpg	[empty string]	1000	1000	117611	200977	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	leupold-stevens-in/leupold-alumina-flip-back-lens-cover-eyepiece-36mm-200977	117611	0
6	[empty string]	LEUPOLD + STEVENS IN	Leupold + Stevens In	SHOOTING	Shooting	[empty string]	1	74.99	0	74.99	4454-DEFAULT-l.jpg	74.99	4454-DEFAULT-m.jpg	LEUPOLD 118284 RINGS	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	179	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Leupold 34mm Rings Dual Dovetail Super High Matte	<p>Classic dual dovetail rings. Machined steel construction. Twist and lock action ensures a strong connection. Available in four different height selections. In gloss or matte blue and silver finishes.</p><p><strong>Attributes</strong></p><ul><li><strong>Tube Diameter:</strong> 34mm</li><li><strong>Made In The USA:</strong> Made In The USA</li><li><strong>Finish:</strong> Matte</li><li><strong>Height:</strong> Super High</li><li><strong>Manufacturer Part Number:</strong> 118284 </li></ul>	[empty string]	N	74.99	74.99	[empty string]	4454-DEFAULT-s.jpg	[empty string]	1000	1000	118284	200979	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	leupold-stevens-in/leupold-34mm-rings-dual-dovetail-super-high-matte-200979	118284	0
7	[empty string]	LEUPOLD + STEVENS IN	Leupold + Stevens In	SHOOTING	Shooting	[empty string]	1	69.99	0	69.99	24349-DEFAULT-l.jpg	69.99	24349-DEFAULT-m.jpg	LEUPOLD 118286 RINGS	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	179	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Leupold Quick Release 34mm Mounting System	<ul><li>Color Black</li><li>Finish Matte</li><li>Attachment/Mount Type Dovetail</li><li>Fabric/Material Machined steel, Steel</li><li>Ring Height Super High</li><li>Tube Diameter 34 mm</li><li>Ring Quantity Pair</li></ul>	[empty string]	N	69.99	69.99	[empty string]	24349-DEFAULT-s.jpg	[empty string]	1000	1000	118286	200980	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	leupold-stevens-in/leupold-quick-release-34mm-mounting-system-200980	118286	0
8	[empty string]	LEUPOLD + STEVENS IN	Leupold + Stevens In	SHOOTING	Shooting	[empty string]	1	79.99	0	79.99	10615-DEFAULT-l.jpg	79.99	10615-DEFAULT-m.jpg	LEUPOLD 120056 DELTAPOINT MNT	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	179	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Leupold Delta Point Pro Mount Matte Black AR-15/M16 Cross-Slot	<p><strong>DESCRIPTION:</strong></p><p>Most people think of the DeltaPoint Pro as a pistol sight, but it is just as capable on an AR platform as it is on a handgun. The DeltaPoint Pro Cross Slot Mount is designed to fit on any Picatinny, Weaver, cantilever rail or base that doesn't require a riser.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Leupold</li><li>Category Bases</li><li>Model DeltaPoint Pro</li><li>Series Mount</li><li>Color Matte Black</li><li>Material Aluminum</li><li>Firearm Type AR Platform</li><li>Firearm Fit AR-15 / M16</li><li>Style Cross-Slot</li><li>Rings Included No</li><li>Mount Type Picatinny Rail / Weaver Style</li><li>Weight 1.30 oz</li></ul>	[empty string]	N	79.99	79.99	[empty string]	10615-DEFAULT-s.jpg	[empty string]	1000	1000	120056	200984	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	leupold-stevens-in/leupold-delta-point-pro-mount-matte-black-ar-15-m16-cross-slot-200984	120056	0
9	[empty string]	LEUPOLD + STEVENS IN	Leupold + Stevens In	SHOOTING	Shooting	[empty string]	1	199.99	0	199.99	10616-DEFAULT-l.jpg	199.99	10616-DEFAULT-m.jpg	LEUPOLD 120180 RINGS	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	179	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	LEUPOLD MARK 4 SCOPE RING SET PICATINNY RAIL HIGH 35MM MATTE BLACK ALUMINUM - 120180	<p><strong>DESCRIPTION:</strong></p><p>The Mark 4 cross-slot mount is designed to fit a Picatinny rail. Mark 4 rings offer superior integrity and tighter tolerances that are based on the proven cross-slot design.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Leupold</li><li>Category Scope Rings</li><li>Model Mark 4</li><li>Series Scope Ring Set</li><li>Color Matte Black</li><li>Material Aluminum</li><li>Tube Diameter 35mm</li><li>Height 1.06"</li><li>Mount Type Picatinny Rail</li><li>Ring Height High</li><li>Weight 8 oz</li></ul>	[empty string]	N	199.99	199.99	[empty string]	10616-DEFAULT-s.jpg	[empty string]	1000	1000	120180	200988	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	leupold-stevens-in/leupold-mark-4-scope-ring-set-picatinny-rail-high-35mm-matte-black-aluminum-120180-200988	120180	0
10	[empty string]	LEUPOLD + STEVENS IN	Leupold + Stevens In	SHOOTING	Shooting	[empty string]	1	199.99	0	199.99	24350-DEFAULT-l.jpg	199.99	24350-DEFAULT-m.jpg	LEUPOLD 120181 RINGS	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	179	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Mark 4 Aluminum Ring 34mm High Matte	<ul><li>SKU: 120181</li><li>Color: Matte</li><li>Height: High</li><li>Diameter (mm): 34</li><li>Material: Aluminum</li></ul>	[empty string]	N	199.99	199.99	[empty string]	24350-DEFAULT-s.jpg	[empty string]	1000	1000	120181	200989	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	leupold-stevens-in/mark-4-aluminum-ring-34mm-high-matte-200989	120181	0

CACHED

false

EXECUTIONTIME

SQL

SELECT top 10 style_id , max(webstyle) as webstyle , max(url) as url , max(realName) as realName , max(style) as style , max(overallqoh) as overallqoh , max(sale) as sale , max(new) as new , max(SmallPicture) as SmallPicture , max(MediumPicture) as MediumPicture , max(LargePicture) as LargePicture , max(sortposition) as sortposition , max(dept) as dept , max(typ) as typ , max(subtyp1) as subtyp1 , max(subtyp2) as subtyp2 , max(subtyp3) as subtyp3 , max(brand) as brand , max(branddisplay) as branddisplay , max(priceRange) as priceRange , min(salePriceRangeBottom) as salePriceRangeBottom , max(salePriceRangeTop) as salePriceRangeTop , max(ListPrice) as ListPrice , max(ranking) as ranking , max(romanticcopylong) as romanticcopylong , max(romanticcopyshort) as romanticcopyshort , max(depttree) as depttree , max(attr1list) as attr1list , max(famlist) as famlist , max(sizelist) as sizelist , max(name) as name , max(prodreviewsaverage) as prodreviewsaverage , max(INTERNALLISTPRICE) as INTERNALLISTPRICE , max(INTERNALMARKDOWN) as INTERNALMARKDOWN , max(INTERNALPRICE) as INTERNALPRICE , max(TERMSALELISTPRICE) as TERMSALELISTPRICE , max(TERMSALEPRICE) as TERMSALEPRICE , max(TERMSALE) as TERMSALE , max(of1) as of1 , max(of2) as of2 , max(of3) as of3 , max(of4) as of4 , max(of5) as of5 , max(of6) as of6 , max(of7) as of7 , max(of8) as of8 , max(of9) as of9 , max(of10) as of10 , max(of11) as of11 , max(of12) as of12 , max(of13) as of13 , max(of14) as of14 , max(of15) as of15 , max(of16) as of16 , max(of17) as of17 , max(of18) as of18 , max(of19) as of19 , max(of20) as of20 , min(sortposition) as sortposition , max(quantitysoldsum) as sold , CASE WHEN isNull(max(picture_id),0) = 0 THEN 0 ELSE 1 END as hasImage , CASE WHEN isNull(max(weighted_search),0) = 1 THEN 900000000 ELSE 0 END as weighted_search FROM web_all_products WHERE 1=1 --AND pictureid is not null and ltrim(rtrim(dept)) = ? and ltrim(rtrim(typ)) = 'EMPTY' AND ( 1=2 OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? ) GROUP BY STYLE_ID

SQLPARAMETERS

array
1	Shooting
2	%mauser%
3	%dogtra%
4	%leupold%stevens%in%
5	%bushnell%

Filter By

Sort By

Item # 120181 $199.99

0 Reviews

Sign in

Shooting

Shooting

Availability

Brand

PRICE

Leupold 10293 Mount System Mark4 Ims 20 Moa Rail Insert

Leupold 2 Piece Base Dual Dovetail Savage With Round Receiver Matte

Leupold Base For Mark 6 Integral Mounting System Style Matte Finish

Alumina Flip Back Lens Cover 42mm

Leupold Alumina Flip- Back Lens Cover Eyepiece 36mm

Leupold 34mm Rings Dual Dovetail Super High Matte

Leupold Quick Release 34mm Mounting System

Leupold Delta Point Pro Mount Matte Black Ar- 15/M16 Cross- Slot

Leupold Mark 4 Scope Ring Set Picatinny Rail High 35mm Matte Black Aluminum - 120180

Mark 4 Aluminum Ring 34mm High Matte

Store Information

Shop

Our Company

Guest Help

Are you over 18?

Please make a selection:

Sign up

Shooting

Shooting

Availability

Brand

PRICE

Leupold 10293 Mount System Mark4 Ims 20 Moa Rail Insert

Leupold 2 Piece Base Dual Dovetail Savage With Round Receiver Matte

Leupold Base For Mark 6 Integral Mounting System Style Matte Finish

Alumina Flip Back Lens Cover 42mm

Leupold Alumina Flip- Back Lens Cover Eyepiece 36mm

Leupold 34mm Rings Dual Dovetail Super High Matte

Leupold Quick Release 34mm Mounting System

Leupold Delta Point Pro Mount Matte Black Ar- 15/M16 Cross- Slot

Leupold Mark 4 Scope Ring Set Picatinny Rail High 35mm Matte Black Aluminum - 120180

Mark 4 Aluminum Ring 34mm High Matte