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]	SINGLETON	Singleton	HUNTING	Hunting	[empty string]	1	169.99	0	169.99	11039-DEFAULT-l.jpg	169.99	11039-DEFAULT-m.jpg	SINGLETON GAME CALLS 449316	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5612	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Singleton Game Calls Matte Black w/ Gray Band Speck - 449316	<p>The Speck Call is designed for maximum volume and minimal back pressure. Since you are not having to use your hand to choke the exhaust down to create back pressure, you have more control of the call. Designed to mimic the high pitch yodels and clucks of a modified Olt T-20, this call is capable of turning those "Tar-Bellies" from long range and has a great murmur and low end to keep them searching for you all the way to your gun barrel.</p><p> </p>	[empty string]	N	169.99	169.99	[empty string]	11039-DEFAULT-s.jpg	[empty string]	1000	1000	449316	156945	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	singleton/singleton-game-calls-matte-black-w-gray-band-speck-449316-156945	449316	0
2	[empty string]	SINGLETON	Singleton	HUNTING	Hunting	[empty string]	1	169.99	0	169.99	9458-DEFAULT-l.jpg	169.99	9458-DEFAULT-m.jpg	SINGLETON IVORY DIAL TONE CAMO BAND	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5612	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	14	150-to-200	0.00	[empty string]	Singleton Game Calls Dial Tone	<p>The "Dial Tone" is a conventional style j-frame call designed to mimic the nasally real life sounds of a mallard hen. With a range second to none in its class, it is sure to be a hit on any lanyard.</p>	[empty string]	N	169.99	169.99	[empty string]	9458-DEFAULT-s.jpg	[empty string]	1000	1000	4809823	156946	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	singleton/singleton-game-calls-dial-tone-156946	4809823	0
3	[empty string]	SINGLETON	Singleton	HUNTING	Hunting	[empty string]	1	134.99	0	134.99	11041-DEFAULT-l.jpg	134.99	11041-DEFAULT-m.jpg	SINGLETON SPECK CALL GRAY DELRIN	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5612	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Singleton Game Calls Speck GRAY DELRIN	<p><strong>DESCRIPTION:</strong></p><p>The Speck Call is designed for maximum volume and minimal back pressure. Since you are not having to use your hand to choke the exhaust down to create back pressure, you have more control of the call. Designed to mimic the high pitch yodels and clucks of a modified Olt T-20, this call is capable of turning those "Tar-Bellies" from long range and has a great murmur and low end to keep them searching for you all the way to your gun barrel.</p><p> </p>	[empty string]	N	134.99	134.99	[empty string]	11041-DEFAULT-s.jpg	[empty string]	1000	1000	6852358	156949	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	singleton/singleton-game-calls-speck-gray-delrin-156949	6852358	0
4	[empty string]	SINGLETON	Singleton	HUNTING	Hunting	[empty string]	1	149.99	0	149.99	21297-DEFAULT-l.jpg	149.99	21297-DEFAULT-m.jpg	SINGLETON GAME CALLS LA CUTDOWN	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5612	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Singleton Game Calls Duck Ivory LA Cutdown	<p>The LA Cutdown, is a single reed cutdown style call named from a deep seeded heritage that comes from North Louisiana and South Arkansas delta. Old timers would take a P.S. Olt duck call and cut the tip of the toneboard into a hard angle. In doing this they accomplished a unique sound and gave the calls a really easy to blow and soft low end with a very sharp top end, giving the call an incredible range. I feel this call captures all of the above with a low end that is second to none on a cutdown, a middle that is impossible not to find a duck in, and a top end everyone nearby is sure to be talking about. This call will do it all!</p>	[empty string]	N	149.99	149.99	[empty string]	21297-DEFAULT-s.jpg	[empty string]	1000	1000	SQ1784330	156957	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	singleton/singleton-game-calls-duck-ivory-la-cutdown-156957	SQ1784330	0
5	[empty string]	SINGLETON	Singleton	HUNTING	Hunting	[empty string]	1	149.99	0	149.99	20445-DEFAULT-l.jpg	149.99	20445-DEFAULT-m.jpg	SINGLETON ORIGINAL CUTDOWN OD GREEN TAN	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5612	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	100-to-150	0.00	[empty string]	Singleton Game Calls Original Cutdown Green and Tan	<p>Single reed, polished acrylic, "Cut down" style duck call. Designed to resemble the sounds of the D2 Keyhole Olt that was favored for its loud aggressive calling abilities. This call has a huge range from hard clear high licks and sharp high pitch chatter on top, to soft real duck quacks and clucks on bottom. We are convinced this call can do it all!</p>	[empty string]	N	149.99	149.99	[empty string]	20445-DEFAULT-s.jpg	[empty string]	1000	1000	SQ2849824	156961	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	singleton/singleton-game-calls-original-cutdown-green-and-tan-156961	SQ2849824	0
6	[empty string]	SINGLETON	Singleton	HUNTING	Hunting	[empty string]	1	149.99	0	149.99	17294-DEFAULT-l.jpg	149.99	17294-DEFAULT-m.jpg	SINGLETON CUTDOWN MATTE BLACK	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5612	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Singleton Game Calls Matte Black Cutdown	<p>Single reed, polished acrylic, "Cut down" style duck call. Designed to resemble the sounds of the D2 Keyhole Olt that was favored for its loud aggressive calling abilities. This call has a huge range from hard clear high licks and sharp high pitch chatter on top, to soft real duck quacks and clucks on bottom. We are convinced this call can do it all!</p>	[empty string]	N	149.99	149.99	[empty string]	17294-DEFAULT-s.jpg	[empty string]	1000	1000	SQ7033483	156976	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	singleton/singleton-game-calls-matte-black-cutdown-156976	SQ7033483	0
7	[empty string]	SINGLETON	Singleton	HUNTING	Hunting	[empty string]	1	99.99	0	119.99	16208-DEFAULT-l.jpg	99.99	16208-DEFAULT-m.jpg	SINGLETON CUTDOWN BLACK DELRIN	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5612	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Singleton Game Calls Original Cutdown Delrin - Black	<p>Single reed, polished acrylic, "Cut down" style duck call. Designed to resemble the sounds of the D2 Keyhole Olt that was favored for its loud aggressive calling abilities. This call has a huge range from hard clear high licks and sharp high pitch chatter on top, to soft real duck quacks and clucks on bottom. We are convinced this call can do it all!</p><p> </p>	[empty string]	N	119.99	119.99	[empty string]	16208-DEFAULT-s.jpg	[empty string]	1000	1000	SQ9053006	156979	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	singleton/singleton-game-calls-original-cutdown-delrin-black-156979	SQ9053006	0
8	[empty string]	SINGLETON	Singleton	HUNTING	Hunting	[empty string]	1	149.99	0	149.99	17333-DEFAULT-l.jpg	149.99	17333-DEFAULT-m.jpg	SINGLETON CUTDOWN POLISHED BLACK	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5612	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	100-to-150	0.00	[empty string]	Singleton Game Calls Polished Black Cutdown	<p>Single reed, polished acrylic, "Cut down" style duck call. Designed to resemble the sounds of the D2 Keyhole Olt that was favored for its loud aggressive calling abilities. This call has a huge range from hard clear high licks and sharp high pitch chatter on top, to soft real duck quacks and clucks on bottom. We are convinced this call can do it all!</p>	[empty string]	N	149.99	149.99	[empty string]	17333-DEFAULT-s.jpg	[empty string]	1000	1000	SQ9955408	156981	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	singleton/singleton-game-calls-polished-black-cutdown-156981	SQ9955408	0
9	[empty string]	SCENT LOK	Scent Lok	HUNTING	Hunting	[empty string]	1	199.99	0	199.99	8295-DEFAULT-l.jpg	199.99	8295-DEFAULT-m.jpg	SCENT LOK OZ 5K BAG IQ COMBO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1471	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	ScentLok Oz Chamber 5K Combo Kit	<p>Go beyond just containing gear and actively freshen it anywhere! The OZ Chamber 5K by ScentLok is equipped to destroy odors with the power of ozone. The included RadialIQ is intelligently designed to emit just the right amount of ozone to fill the bag and destroy odors throughout. The result, a storage bag that provides fresher and healthier gear.image</p><p><strong>Specifications for ScentLok OZ Chamber 5K Combo Kit:</strong></p><ul><li>Manufacturer: ScentLok</li><li>Application: Home</li><li>Color: Black</li><li>Dimensions: 26 x 14 x 14 in</li></ul><p><strong>Features of ScentLok OZ Chamber 5K Combo Kit:</strong></p><ul><li>The new Radial IQ features a one button design that runs for 30 minutes, the ideal ozone output and run time to actively refresh your gear</li><li>Extremely durable 600D PVC backed polyester fabric</li><li>Reinforced 2in grab straps for hauling heavy loads</li><li>Removable, adjustable shoulder strap for comfortable, convenient carrying</li><li>Bag includes a dedicated pocket to suspend the Radial IQ, allowing ozone to fill the whole bag</li></ul>	[empty string]	N	199.99	199.99	[empty string]	8295-DEFAULT-s.jpg	[empty string]	1000	1000	4153661-090	207988	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	scent-lok/scentlok-oz-chamber-5k-combo-kit-207988	4153661-090	0
10	[empty string]	SCENT LOK	Scent Lok	HUNTING	Hunting	[empty string]	1	299.99	0	299.99	8296-DEFAULT-l.jpg	299.99	8296-DEFAULT-m.jpg	SCENT LOK OZ 8K BAG IQ COMBO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1471	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	250-to-300	0.00	[empty string]	ScentLok Oz Rolling Chamber 8K Combo Kit	<p>Storing your hunting clothing in a OZ storage container is a vital step for success in the field. Our products are constantly adsorbing odors and contaminants in the air that surrounds them. Keeping your gear in the OZRolling Chamber 8K allows the new Radial IQ ozone generator to destroy lingering odors and keep them from contaminating your gear.image</p><p><strong>Specifications for ScentLok OZ Rolling Chamber 8K Combo Kit:</strong></p><ul><li>Manufacturer: ScentLok</li><li>Application: Home</li><li>Color: Black</li></ul><p><strong>Features of ScentLok OZ Rolling Chamber 8K Combo Kit:</strong></p><ul><li>The ultimate traveling odor destroying storage solution</li><li>The new Radial IQ features a one button design that runs for 30 minutes, the ideal ozone output and run time to actively refresh your gear</li><li>Extendable handle & durable wheels for easy transport</li><li>Extremely durable 600D PVC backed polyester fabric</li><li>Reinforced 2in grab straps for hauling heavy loads</li><li>Removable, adjustable shoulder strap for comfortable, convenient carrying</li><li>Bag includes a dedicated pocket to suspend the Radial IQ, allowing ozone to fill the whole bag</li></ul>	[empty string]	N	299.99	299.99	[empty string]	8296-DEFAULT-s.jpg	[empty string]	1000	1000	4153761-090	207989	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	scent-lok/scentlok-oz-rolling-chamber-8k-combo-kit-207989	4153761-090	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts4 ORDER BY sortposition asc

Filter By

Sort By

Items Per Page

Singleton Game Calls Matte Black w/ Gray Band Speck - 449316

details

Singleton Game Calls Matte Black W/Gray Band Speck - 449316

Item # 449316 $169.99

Singleton Game Calls Dial Tone

details

Singleton Game Calls Dial Tone

Item # 4809823 $169.99

Singleton Game Calls Speck GRAY DELRIN

details

Singleton Game Calls Speck Gray Delrin

Item # 6852358 $134.99

Singleton Game Calls Duck Ivory LA Cutdown

details

Singleton Game Calls Duck Ivory La Cutdown

Item # SQ1784330 $149.99

Singleton Game Calls Original Cutdown Green and Tan

details

Singleton Game Calls Original Cutdown Green And Tan

Item # SQ2849824 $149.99

Singleton Game Calls Matte Black Cutdown

details

Singleton Game Calls Matte Black Cutdown

Item # SQ7033483 $149.99

Singleton Game Calls Original Cutdown Delrin - Black

details

Singleton Game Calls Original Cutdown Delrin - Black

Item # SQ9053006 $119.99

Singleton Game Calls Polished Black Cutdown

details

Singleton Game Calls Polished Black Cutdown

Item # SQ9955408 $149.99

ScentLok Oz Chamber 5K Combo Kit

details

Scentlok Oz Chamber 5k Combo Kit

Item # 4153661-090 $199.99

ScentLok Oz Rolling Chamber 8K Combo Kit

details

Scentlok Oz Rolling Chamber 8k Combo Kit

Item # 4153761-090 $299.99