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	GREEN	MENDOTA	Mendota	HUNTING	Hunting	GREEN\|NULL\|NULL	1	19.99	0	19.99	525-DEFAULT-l.jpg	19.99	525-DEFAULT-m.jpg	MENDOTA 016 SNAP LEAD	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2401	.MENDOTA016SNAPLEAD	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Mendota Snap Lead (1/2"x4')	<p>Premium, strong (1/2" x 4 feet) solid braid UV coated polypropylene rope, leather sleeves, and a heavy gauge brass snap. Available in Camouflage and Green</p>	[empty string]	N	19.99	19.99	[empty string]	525-DEFAULT-s.jpg	[empty string]	1000	1000	016	75806	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	mendota/mendota-snap-lead-1-2-x4-75806	016	0
2	GREEN	MENDOTA	Mendota	HUNTING	Hunting	GREEN\|NULL\|NULL	1	16.99	0	16.99	522-DEFAULT-l.jpg	16.99	522-DEFAULT-m.jpg	MENDOTA 019 TRAFFIC LEAD	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2401	.MENDOTA019TRAFFICLEAD	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Mendota Traffic Leash - Large 1/2 Inch	<p>Traffic Lead -A short 1.5 foot handled snap lead for situations where you need your dog close at all times.</p><ul><li>Soft on the hands with its "Broken in Feel" easy to use and pliable enough to fit in your coat pocket</li><li>Brass, satin nickel or black metallic hardware and oil tanned leather splices</li><li>Made of waterproof, vibrant, long-lasting multi-filament polypropylene rope.</li><li>Matches Mendota's Double Braid Collars</li><li>Machine washable, air dry only.</li><li>Handmade in the U.S.A.</li><li>100% satisfaction guarantee</li><li>Shipping Weight 4 oz.</li><li>Package size: 4"x5"x1.5" </li></ul><p>We also have 4' and 6' foot available:</p><ul><li>Small Snap Leash: 3/8"" x 4' and 3/8"" x 6' (for dogs under 50 pounds)</li><li>Large Snap Leash: 1/2"" x 4' and 1/2"" x 6'</li><li>Traffic Lead: 1/2"" x 16""</li></ul>	[empty string]	N	16.99	16.99	[empty string]	522-DEFAULT-s.jpg	[empty string]	1000	1000	019	75807	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	mendota/mendota-traffic-leash-large-1-2-inch-75807	019	0
3	[empty string]	DOGTRA	Dogtra	HUNTING	Hunting	[empty string]	1	179.99	0	249.99	40416-DEFAULT-l.jpg	179.99	40416-DEFAULT-m.jpg	DOGTRA TRAINING	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2128	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	200-to-250	0.00	[empty string]	Dogtra 1900s Remote Training System	<p><span style="font-size:18px;">Dogtra has committed over 20 years to crafting dog training e-collars, perfecting the precise fit-and-finish, intuitive design, and accountable performance. The Dogtra 1900S e-collar exemplifies this dedication, providing an ultimate dog training tool that is durable, dependable, and designed for the most demanding conditions. This high-output e-collar is the unit of choice for serious amateurs and award-winning professional trainers in pet obedience, hunting, competition trials, and K-9 training.</span></p> <p><span style="font-size:18px;"><strong>Key Features:</strong></span></p> <ul> <li><span style="font-size:18px;">3/4-Mile Range: The 1900S e-collar offers an extended range, making it ideal for various training environments.</span></li> <li><span style="font-size:18px;">Fully Waterproof: The durable design ensures the collar remains functional even in wet conditions.</span></li> <li><span style="font-size:18px;">Unique Modern Receiver Design: The collar strap wraps around the receiver and your dog’s neck for enhanced comfort and a seamless appearance.</span></li> <li><span style="font-size:18px;">Low-High Stimulation Levels: With 0-127 levels, the wide range of stimulation fits any dog’s personality, <strong><em>from mild to the most stubborn.</em></strong></span></li> <li><span style="font-size:18px;">Patented Rheostat Dial: Allows for gradual and precise stimulation control, displayed on the illuminated LCD screen on the handheld transmitter.</span></li> </ul> <p><span style="font-size:18px;"><strong>Ideal For:</strong></span></p> <ul> <li><span style="font-size:18px;">Pet obedience training</span></li> <li><span style="font-size:18px;">Hunting</span></li> <li><span style="font-size:18px;">Competition trials</span></li> <li><span style="font-size:18px;">K-9 training</span></li> </ul> <p><span style="font-size:18px;"><strong>Product Benefits:</strong></span></p> <ul> <li><span style="font-size:18px;">Durable and Dependable: Crafted to withstand the most demanding conditions.</span></li> <li><span style="font-size:18px;">Enhanced Comfort: Designed with your dog’s comfort in mind, ensuring a seamless fit.</span></li> <li><span style="font-size:18px;">Wide Range of Stimulation: Accommodates all dog personalities, providing low to high stimulation levels.</span></li> <li><span style="font-size:18px;">Precise Control: The Rheostat Dial offers gradual and precise control over stimulation levels.</span></li> </ul>	[empty string]	N	249.99	249.99	[empty string]	40416-DEFAULT-s.jpg	[empty string]	1000	1000	1900S	99142	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dogtra/dogtra-1900s-remote-training-system-99142	1900s	0
4	[empty string]	DOGTRA	Dogtra	HUNTING	Hunting	[empty string]	1	299.99	0	299.99	13116-DEFAULT-l.jpg	299.99	13116-DEFAULT-m.jpg	DOGTRA 1900S HANDSFREE PLUS	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2128	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	250-to-300	0.00	[empty string]	Dogtra 1900s Handsfree Plus Training System	<p><strong>DESCRIPTION</strong>:</p> <p>The Dogtra 1900S HANDSFREE PLUS combines our most versatile 1900S e-collar with a compact Dogtra HANDSFREE SQUARE, which allows you to control a transmitter remotely. The new HANDSFREE SQUARE features allow users to add up to 14 SQUARES delivering a diverse range of training scenarios.</p> <p>Each SQUARE can be paired to different functions (Nick, Constant, or HPP Vibration) and allows many users to quickly access any feature, at any time within 33 feet of the transmitter. This versatile system allows for multiple users to engage in the training process simply by pairing additional HANDSFREE SQUARES. This hands-free system is great for a family household or a trainer working hands on with a client.</p> <p>With comfort and safety in mind, the -mile range 1900S HANDSFREE PLUS is IPX9K waterproof certified making it durable and reliable for demanding training conditions. In addition to the easy hands-free access, the 1900S HANDSFREE PLUS also offers 127 stimulation levels to choose from for accurate control, HPP (High Performance Pager) vibration, and an ergonomic receiver shaped to the dog's neck.</p> <ul> <li>HANDSFREE SQUARE for Remote Control</li> <li>Expandable up to 14 HANDSFREE SQUARES</li> <li>3/4-Mile Range</li> <li>IPX9K Waterproof Certified</li> <li>High Output Receiver</li> <li>127 Stimulation Levels/Rheostat Dial/LCD Screen</li> <li>Nick/Constant Stimulation & HPP (High Performance Pager) Vibration</li> </ul>	[empty string]	N	299.99	299.99	[empty string]	13116-DEFAULT-s.jpg	[empty string]	1000	1000	1900SHFPLUS	99143	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dogtra/dogtra-1900s-handsfree-plus-training-system-99143	1900SHFPLUS	0
5	[empty string]	DOGTRA	Dogtra	HUNTING	Hunting	[empty string]	1	429.99	0	429.99	13117-DEFAULT-l.jpg	429.99	13117-DEFAULT-m.jpg	DOGTRA PATHFINDER 2	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2128	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	400-to-450	0.00	[empty string]	Dogtra Pathfinder SE	<p>Tracking and Training in one system!</p><p>New features include: GPS Connector E-Collar Function button, Pager Vibration, LED Locate Light and a new PATHFINDER2 app with more features.</p><p>Explore more with you dogs on all outdoor activities from hiking to hunting with the newest GPS Dog Tracking and Training System. The new Dogtra PATHFINDER2 is a complete GPS tracking and training system featuring a newly redesigned FREE real time tracking and training app, tracking up to 21 dogs within a 9-mile range.* The new PATHFINDER2 system features the latest in dog tracking collars equipped with E-Collar training functions now including a LED Locate Light and Pager Vibration. The new GPS Connector is designed with a new E-Collar Function button for quicker response.</p><p>The PATHFINDER2 works with a FREE app based dog tracking system with no monthly subscription required, allowing users to track and train their dogs straight from their phone featuring offline maps access with no signal required. The app allows users to: share locations, create custom fences, customize activity modes and access e-collar training features, battery saving sleep mode, lost collar lock, a lost GPS Connector locator and more. Smart watch users can now track their dogs from their watch with quick access to the extended PATHFINDER2 dog tracking app that is available for Apple Watch Series 5 and Galaxy Watch4 and above. The Dogtra PATHFINDER2 App requires the Dogtra PATHFINDER2 system to operate. Range may vary depending on the surroundings.</p><p>PATHFINDER2 App Phone Requirements: iOS 12.1 or Android 6.0 and above and devices must include Bluetooth 5.0 and up.</p><p>New PATHFINDER2 System Features:</p><p>New GPS Connector with E-Collar Function Button<br />New GPS Receiver with Pager Vibration & LED Locate Light<br />New Receiver Lock Mode<br />New Sleep Mode<br />New E-Collar Functions: Pager Vibration & LED Locate Light<br />New USB 5V Charger<br />New PATHFINDER2 System is only compatible with the PATHFINDER2 Series Systems</p><p>New PATHFINDER2 App Features:</p><p>New FREE PATHFINDER2 App with updated user interface<br />New Smart Watch compatibility:<br /> Now available on Samsung Galaxy Watch4 Series<br /> Apple Watch Series 5 and above<br />Free maps powered by MapBox<br />New Fence Modes:<br /> E-Fence ( NEW)<br /> Geo-Fence<br /> Mobile-Fence</p><p>PATHFINDER2 App is only compatible with the PATHFINDER2 Series</p><p>Compatibility:<br />App: PATHFINDER2<br />Systems: PATHFINDER2 Receiver, PATHFINDER2 TRX Receiver, PATHFINDER2 GPS Connector</p><p>Not Compatible With:<br />Apps: PATHFINDER APP<br />Systems: PATHFINDER, PATHFINDER SE, PATHFINDER TRX, PATHFINDER MINI, PATHFINDER GPS Connector</p><p> </p>	[empty string]	N	429.99	429.99	[empty string]	13117-DEFAULT-s.jpg	[empty string]	1000	1000	PATHFINDERSE	99154	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dogtra/dogtra-pathfinder-se-99154	PATHFINDERSE	0
6	CAMO	MENDOTA	Mendota	HUNTING	Hunting	CAMO\|NULL\|NULL	1	16.99	0	16.99	523-DEFAULT-l.jpg	16.99	523-DEFAULT-m.jpg	MENDOTA 025 SMALL SLIP LEAD	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2401	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Mendota Small Slip Lead (Camo 3/8"x4')	Used for many years by trainers and handlers in field and show, now adapted for everyday use. The british style slip lead is a leash and collar in one design allowing for correction and ease of use. Adjustable leather slide eliminates slipping off, yet releases properly in relaxed position. Solid brass bolt snap is anti-corrosive. Genuine leather accents. Braided polypropylene rope for extreme durability. Water resistant and color fast. Available in 3/8" or 1/2" braided nylon in 4' or 6' lengths.	[empty string]	N	16.99	16.99	[empty string]	523-DEFAULT-s.jpg	[empty string]	1000	1000	025	183281	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	mendota/mendota-small-slip-lead-camo-3-8-x4-183281	025	0
7	[empty string]	MENDOTA	Mendota	HUNTING	Hunting	[empty string]	1	19.99	0	19.99	4165-DEFAULT-l.jpg	19.99	4165-DEFAULT-m.jpg	MENDOTA 027 SLIP LEAD	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2401	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Mendota Slip Lead (1/2"x4')	<p>Premium, strong 1/2" solid braid multi-filament UV coated polypropylene rope, leather sleeves and brass ring. Used by trainers, field trial and hunting test participants. Leash and slip collar in one allows for correction. Adjustable leather slide keeps "collar" in place. "Broken-in" feel is easy on the hands and allows easy folding to fit in a pocket. (1/2" x 4 Feet)</p>	[empty string]	N	19.99	19.99	[empty string]	4165-DEFAULT-s.jpg	[empty string]	1000	1000	027	183284	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	mendota/mendota-slip-lead-1-2-x4-183284	027	0
8	CAMO	MENDOTA	Mendota	HUNTING	Hunting	CAMO\|NULL\|NULL	1	19.99	0	19.99	524-DEFAULT-l.jpg	19.99	524-DEFAULT-m.jpg	MENDOTA 029 QUICK LEADS	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2401	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	15-to-20	0.00	[empty string]	Mendota Quick Leads (Camo1/2"x4')	<p>Discover the Mendota Quick Lead, the epitome of quality, durability, and versatility in dog accessories. Crafted by Mendota Products, renowned for their expertly designed pet products, this lead is the perfect accessory for your canine friend. What sets the Mendota Quick Lead apart is its innovative design. It can be used as a 'hands-free' leash, simply slip the leash onto your dog and clip the scissor snap to a belt loop. This feature allows you to multitask on walks, adding an extra level of convenience. Alternatively, you can clip the snap onto your dog and use the slip lead as a handhold loop, or secure the slip lead over a post for an instant tie-out.</p><p> </p><p><strong>FEATURES</strong></p><ul><li>1/2" x 4'</li><li>Strong and durable multi-filament material</li><li>Slip lead and scissor snap combo lead</li><li>Solid brass hardware</li></ul>	[empty string]	N	19.99	19.99	[empty string]	524-DEFAULT-s.jpg	[empty string]	1000	1000	029	183286	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	mendota/mendota-quick-leads-camo1-2-x4-183286	029	0
9	[empty string]	MENDOTA	Mendota	HUNTING	Hunting	[empty string]	1	16.99	0	19.99	528-DEFAULT-l.jpg	16.99	528-DEFAULT-m.jpg	MENDOTA 11105 SNAP BELL	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2401	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	9	15-to-20	0.00	[empty string]	Mendota Snap Bell	<p>In order to know where your dog is at all times, you must be able to hear him. Just snap it to the D-ring on your dog's collar and the solid brass sleigh bell will ring clearly whenever your dog is moving. Brass bell with mini-snap connector with leather backing. </p><p><strong>FEATURES</strong></p><p>Dimensions: 1 3/4"W x 4 7/8"H</p><p>Bell Diameter: 1 1/8"</p><p>Weight: 2.4 oz.</p>	[empty string]	N	19.99	19.99	[empty string]	528-DEFAULT-s.jpg	[empty string]	1000	1000	11105	183296	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	mendota/mendota-snap-bell-183296	11105	0
10	CAMO	MENDOTA	Mendota	HUNTING	Hunting	CAMO\|NULL\|NULL	1	12.99	0	14.99	8609-DEFAULT-l.jpg	12.99	8609-DEFAULT-m.jpg	MENDOTA DOUBLE BRAID COLLAR	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2401	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	10-to-15	0.00	[empty string]	Mendota Double Braid Collar - Brass - Camo	<p>These soft, yet durable collars are adjustable and come in both brass, or satin nickel hardware. Available in 2 different widths - Junior (9/16"") and Standard (1"").</p><ul><li>Junior puppy collar: 9/16"" x up to 12"" and 9/16"" x up to 14""</li><li>Standard: 1"" x up to 18"", 1"" x up to 21"" and 1"" x up to 24""</li></ul>	[empty string]	N	14.99	14.99	21	8609-DEFAULT-s.jpg	[empty string]	1000	1000	31105	183299	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	mendota/mendota-double-braid-collar-brass-camo-183299	31105	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 ? OR upper(brand) like ? OR upper(brand) like ? ) GROUP BY STYLE_ID

SQLPARAMETERS

array
1	Hunting
2	%mendota%
3	%mauser%
4	%dogtra%
5	%used%guns%
6	%cmmg%
7	%thief%

Filter By

Sort By

Item # 31105 $14.99

0 Reviews

Sign in

Hunting

Hunting

Availability

Brand

PRICE

Mendota Snap Lead (1/2 " X4 ')

Mendota Traffic Leash - Large 1/2 Inch

Dogtra 1900s Remote Training System

Dogtra 1900s Handsfree Plus Training System

Dogtra Pathfinder Se

Mendota Small Slip Lead (Camo 3/8 " X4 ')

Mendota Slip Lead (1/2 " X4 ')

Mendota Quick Leads (Camo1/2 " X4 ')

Mendota Snap Bell

Mendota Double Braid Collar - Brass - Camo

Store Information

Shop

Our Company

Guest Help

Are you over 18?

Please make a selection:

Sign up

Hunting

Hunting

Availability

Brand

PRICE

Mendota Snap Lead (1/2 " X4 ')

Mendota Traffic Leash - Large 1/2 Inch

Dogtra 1900s Remote Training System

Dogtra 1900s Handsfree Plus Training System

Dogtra Pathfinder Se

Mendota Small Slip Lead (Camo 3/8 " X4 ')

Mendota Slip Lead (1/2 " X4 ')

Mendota Quick Leads (Camo1/2 " X4 ')

Mendota Snap Bell

Mendota Double Braid Collar - Brass - Camo