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]	NEBO	Nebo	HUNTING	Hunting	[empty string]	1	19.99	0	19.99	8637-DEFAULT-l.jpg	19.99	8637-DEFAULT-m.jpg	SKEETER HAWK BAIT STATION TUBE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3364	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	15-to-20	0.00	[empty string]	Skeeter Hawk Bait Station Replacement Tubes - 2 Pack	<p>The Bait Station Replacement Tube - 2 Pack features two replacement powdered insect bait station tubes with all-natural mosquito repelling ingredients for use with the Skeeter Hawk Backyard Mosquito Bait Station.</p><p><strong>FEATURES</strong></p><ul><li>- All Natural Powdered Insect Bait Formula</li><li>- 90-day Lifespan per Tube</li><li>Item #: SKE-ACC-0002</li></ul><p>**For optimal performance, each Bait Station's tube should be changed out once every 90 days.</p>	[empty string]	N	19.99	19.99	[empty string]	8637-DEFAULT-s.jpg	[empty string]	1000	1000	SKE-ACC-0002	147393	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	nebo/skeeter-hawk-bait-station-replacement-tubes-2-pack-147393	SKE-ACC-0002	0
2	[empty string]	NEBO	Nebo	HUNTING	Hunting	[empty string]	1	11.99	0	11.99	8636-DEFAULT-l.jpg	11.99	8636-DEFAULT-m.jpg	SKEETER HAWK CARABINER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3364	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	9	10-to-15	0.00	[empty string]	Skeeter Hawk Wearable Mosquito Carabiner	<p>Our Carabiner Repellent features a proprietary blend of essential oils that naturally repels mosquitoes and flying insects. The Carabiner Tag has a reflective logo and lettering for increased visibility while a stainless-steel carabiner quickly attaches to a backpack or belt loop. The Carabiner comes with 2 replaceable repellent tabs with a life of 30 days each.</p><p><strong>FEATURES</strong></p><ul><li>Proprietary Blend of All-Natural Essential Oils</li><li>Long-Lasting, Replaceable Repellent Tabs</li><li>Reflective Logo and Lettering</li><li>Stainless Steel Carabiner</li><li>Item #: SKE-WER-0002</li></ul>	[empty string]	N	11.99	11.99	[empty string]	8636-DEFAULT-s.jpg	[empty string]	1000	1000	SKE-WER-0002	147402	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	nebo/skeeter-hawk-wearable-mosquito-carabiner-147402	SKE-WER-0002	0
3	[empty string]	NEBO	Nebo	HUNTING	Hunting	[empty string]	1	29.99	0	29.99	13119-DEFAULT-l.jpg	29.99	13119-DEFAULT-m.jpg	SKEETER HAWK WRISTBAND	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3364	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Skeeter Hawk Wristband	<p>Our Repellent Bracelet features a proprietary blend of Essential oils that naturally repels mosquitoes and flying insects. The Hook and Loop Closure provides a custom fit and has a reflective logo and lettering for increased visibility. The Bracelet comes with 2 replaceable repellent tabs with a life of 30 days each.</p><p><strong>FEATURES</strong></p><ul><li>Proprietary blend of all-natural essential oils</li><li>Long-lasting, replaceable repellent tabs</li><li>No chemicals</li><li>Hook and loop closure for custom fit</li></ul><p> </p><p> </p>	[empty string]	N	29.99	29.99	[empty string]	13119-DEFAULT-s.jpg	[empty string]	1000	1000	SKE-WER-1002	147403	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	nebo/skeeter-hawk-wristband-147403	SKE-WER-1002	0
4	[empty string]	BULLDOG CASES	Bulldog Cases	HUNTING	Hunting	[empty string]	1	39.99	0	39.99	7605-DEFAULT-l.jpg	39.99	7605-DEFAULT-m.jpg	BULLDOG BDT917B PISTOL CASE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4409	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	BULLDOG DELUXE 2 PISTOL RANGE BAG W/MOLLE BLACK - BDT917B	<p><strong>DESCRIPTION:</strong></p><ul><li>Manufacturer Part Number BDT917B</li><li>UPC 672352012705</li><li>TYPE/COLOR BDT RANGE BAG/BLACK</li><li>SIZE/FINISH 12"H X 9"W X 4"D</li><li>MATERIAL HEAVY DUTY NYLON</li><li>NEWITEM YES</li><li>OTHER FEATURES: HOLDS 2 PISTOLS & 8 MAGS ACCESSORY COMPARTMENT CARRY HANDLE ADJ/REMOVEABLE SHOULDER STRAP</li><li>Dimension 3.45 X 12.10 X 15.15</li><li>HEIGHT 3.4500</li><li>WIDTH 12.1000</li><li>LENGTH 15.1500</li><li>Adjustable / Removable Shoulder Strap W/ Swivels</li><li>Heavy-Duty Zippers</li><li>MOLLE Webbing</li><li>Large Interior Pockets Hold 2 Pistols & 8 Magazines</li><li>Large Zippered Accessory Compartment</li><li>Water-Resistant Durable</li></ul>	[empty string]	N	39.99	39.99	[empty string]	7605-DEFAULT-s.jpg	[empty string]	1000	1000	BDT917B	227113	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bulldog-cases/bulldog-deluxe-2-pistol-range-bag-w-molle-black-bdt917b-227113	BDT917B	0
5	[empty string]	BULLDOG CASES	Bulldog Cases	HUNTING	Hunting	[empty string]	1	19.99	0	19.99	18210-DEFAULT-l.jpg	19.99	18210-DEFAULT-m.jpg	BULLDOG MAG POUCH	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4409	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Double Magazine Holder With Belt Loops Universal Black	<ul><li>Brand Bulldog</li><li>Category Magazine Holders</li><li>Model Double Mag Holder</li><li>Color Black</li><li>Material Nylon</li><li>Mount Type Belt Loop</li></ul>	[empty string]	N	19.99	19.99	[empty string]	18210-DEFAULT-s.jpg	[empty string]	1000	1000	WMAGL	227158	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bulldog-cases/double-magazine-holder-with-belt-loops-universal-black-227158	WMAGL	0
6	[empty string]	CASE + SONS CUTLERY	Case + Sons Cutlery	HUNTING	Hunting	[empty string]	1	54.99	0	54.99	24317-DEFAULT-l.jpg	54.99	24317-DEFAULT-m.jpg	CASE 00029 KNIFE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	53	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	24	50-to-100	0.00	[empty string]	CASE Trapper 2-Blade 3-1/2 In. Pocket Knife	<p>The Case Mini Trapper is a part of the Yellow Synthetic Family. The distinctive yellow handle brightens this family while maintaining its toughness. Mini Trappers are a smaller version of our Trapper carrying two full length blades, the Clip blade and the Spey blade. The Clip blade is commonly used as a multi-purpose blade and preferred for detail work. The Spey blade is commonly used as an all-purpose utility blade. This knife is made with our Chrome Vanadium steel blades and a smooth yellow synthetic handle. Case Chrome Vanadium blades are known for their edge-holding ability and easy re-sharpening. However, they are less resistant to rusting, pitting and discoloration than stainless steel. We recommend keeping a thin film of oil on the blade to maintain the finish. Made in Bradford, PA. USA from domestic and imported materials.</p><p><p>You must be 18 years of age or older to purchase a knife. Please check your local laws and regulations before ordering and using this product.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p></p>	[empty string]	N	54.99	54.99	[empty string]	24317-DEFAULT-s.jpg	[empty string]	1000	1000	00029	228448	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	case-sons-cutlery/case-trapper-2-blade-3-1-2-in-pocket-knife-228448	00029	0
7	[empty string]	CASE + SONS CUTLERY	Case + Sons Cutlery	HUNTING	Hunting	[empty string]	1	49.99	0	59.99	22834-DEFAULT-l.jpg	49.99	22834-DEFAULT-m.jpg	CASE 00031 KNIFE	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	53	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	9	50-to-100	0.00	[empty string]	Case Trapper Slimline 3.25" Clip Point Yellow Synthetic Handle	<p>The Case Slimline Trapper is a part of the Yellow Synthetic Family. The Slimline Trapper is a thinner version of the Trapper. The Clip blade is commonly used as a multi-purpose blade and preferred for detail work. The Slimline Trappers are commonly used for skinning and fleshing animals. Case Chrome Vanadium blades are known for their edge-holding ability and easy re-sharpening. However, they are less resistant to rusting, pitting and discoloration than stainless steel. We recommend keeping a thin film of oil on the blade to maintain the finish.</p><ul><li>UPC: 021205000312</li><li>Weight: 0.15 pounds</li><li>Dimensions: 5.25 1.5 0.5 inches</li><li>Model/Part/Item Number - CA031</li><li>Brand: Case XX Knives</li><li>Slimline Trapper Yellow</li><li>Yellow Synthetic Series</li><li>31048 CV pattern</li><li>4.125" closed</li><li>Chrome Vanadium carbon steel clip blade</li><li>Yellow synthetic handle</li><li>Nickel silver bolster(s)</li><li>Inlay shield</li><li>Boxed.</li></ul><p><p>You must be 18 years of age or older to purchase a knife. Please check your local laws and regulations before ordering and using this product.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p></p>	[empty string]	N	59.99	59.99	[empty string]	22834-DEFAULT-s.jpg	[empty string]	1000	1000	00031	228449	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	case-sons-cutlery/case-trapper-slimline-3-25-clip-point-yellow-synthetic-handle-228449	00031	0
8	[empty string]	CASE + SONS CUTLERY	Case + Sons Cutlery	HUNTING	Hunting	[empty string]	1	39.99	0	44.99	8742-DEFAULT-l.jpg	39.99	8742-DEFAULT-m.jpg	CASE 3137 KNIFE	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	53	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Case Yellow Synthetic Chrome Vanadium Sod Buster Jr	<p>This Sod Buster JR is a part of the Yellow Synthetic Family. The distinctive yellow handle brightens this family while maintaining its toughness, making it one of the most beloved in the Case line. The Sod Buster JR is smaller than the traditional Sod Buster without compromising durability. The Skinner blade is ideal for skinning purposes among other different everyday demands. This knife is constructed with our Chrome Vanadium (CV) steel. Some knife lovers will settle for nothing less than chrome vanadium blades, since this special formula of alloyed steel is the "original" Case blade steel. Case Chrome Vanadium blades are known for their edge-holding ability and easy re-sharpening. However, they are less resistant to rusting, pitting and discoloration than stainless steel. We recommend keeping a thin film of oil on the blade to maintain the finish. This ensures that your knife will be around for future generations to enjoy. Comes conveniently packaged in a box. Made in Bradford, PA, USA from domestic and imported materials.</p><ul><li>Chrome Vanadium (CV) steel blade</li><li>Skinner blade</li><li>Smooth yellow synthetic handle</li><li>Length: 3.63 inches closed and 2.1 ounces</li><li>Limited lifetime warranty</li></ul><p><strong>HANDLE</strong></p><ul><li>Yellow Synthetic</li></ul><p>Our Smooth Yellow Synthetic handle is one of the most prolific throughout the knife industry. It's been used in Case knives for more than 100 years.</p><p><strong>BLADES</strong></p><ul><li>Skinner</li></ul><p>The Skinner blade is ideal for the hunter and outdoorsman. The curved shape of the blade allows for a more aggressive cut.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Model No: 00032</li><li>Pattern: Sod Buster Jr </li><li>Pattern Stamp: 3137 CV</li><li>Handle Material: Yellow Synthetic</li><li>Handle Finish: Smooth</li><li>Blade Type: Skinner</li><li>Blade Length(s): 2.8 in</li><li>Lock Type: Non-Locking (Slip Joint)</li><li>Blade Material: Chrome Vanadium</li><li>Blade Finish: Tumble Polish</li><li>Closed Length: 3.625 in</li><li>Weight: 2.0 oz</li><li>Sheath: Sold Separately</li></ul>	[empty string]	N	44.99	44.99	[empty string]	8742-DEFAULT-s.jpg	[empty string]	1000	1000	00032	228450	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	case-sons-cutlery/case-yellow-synthetic-chrome-vanadium-sod-buster-jr-228450	00032	0
9	[empty string]	CASE + SONS CUTLERY	Case + Sons Cutlery	HUNTING	Hunting	[empty string]	1	59.99	0	64.99	18271-DEFAULT-l.jpg	59.99	18271-DEFAULT-m.jpg	CASE 00035 KNIFE	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	53	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Case 00035 Stockman Medium 2.57"/1.88"/1.71" Folding Clip/Sheepsfoot/Spey Plain Tumble Polish Chrome Vanadium Steel Blade/Yellow Synthetic Handle	<p>Case Medium Stockman's distinctive yellow handle brightens this family while maintaining its toughness. Stockman's pack three blades, the Clip and Sheepfoot blade sit on the pocket end while the Spey blade sits on the cap end. The Clip blade is commonly used as a multi-purpose blade and preferred for detail work. The Sheepfoot blade allows for added strength at the point making it great for carving and achieving a clean cut. Case chrome vanadium blades are known for their edge-holding ability and easy re-sharpening. However, they are less resistant to rusting, pitting and discoloration than stainless steel. We recommend keeping a thin film of oil on the blade to maintain the finish. Made in Bradford, PA. from domestic and imported materials.</p><p><p>You must be 18 years of age or older to purchase a knife. Please check your local laws and regulations before ordering and using this product.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p></p>	[empty string]	N	64.99	64.99	[empty string]	18271-DEFAULT-s.jpg	[empty string]	1000	1000	00035	228451	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	case-sons-cutlery/case-00035-stockman-medium-2-57-1-88-1-71-folding-clip-sheepsfoot-spey-plain-tumble-polish-chrome-vanadium-steel-blade-yellow-synthetic-handle-228451	00035	0
10	[empty string]	CASE + SONS CUTLERY	Case + Sons Cutlery	HUNTING	Hunting	[empty string]	1	69.99	0	74.99	8743-DEFAULT-l.jpg	69.99	8743-DEFAULT-m.jpg	CASE 00079 KNIFE	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	53	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Case Amber Bone Peach Seed Jig Chrome Vanadium Medium Stockman (Pen blade)	<p>This Medium Stockman is a part of the Amber Bone CV Family. Our Amber Bone color and Peach Seed jig are signatures of the Case brand and the true heart of the Case line. Stockmans pack three blades in a convenient but very practical pocket knife. The Clip and Sheepfoot blade sit on the pocket end while the Pen blade sits on the cap end. The Clip blade is commonly used as a multi-purpose blade and preferred for detail work. The Sheepfoot blade allows for added strength at the point making it great for carving and achieving a clean cut. The Pen blade is great for light work. This knife is constructed with our Chrome Vanadium (CV) steel. Some knife lovers will settle for nothing less than Chrome Vanadium blades, since this special formula of alloyed steel is the "original" Case blade steel. Case Chrome Vanadium blades are known for their edge-holding ability and easy re-sharpening. However, they are less resistant to rusting, pitting and discoloration than stainless steel. We recommend keeping a thin film of oil on the blade to maintain the finish. This ensures that your knife will be around for future generations to enjoy. Comes conveniently packaged in a box. Made in Bradford, PA, USA from domestic and imported materials.</p><ul><li>Chrome Vanadium steel blades</li><li>Clip, Sheepfoot, and Pen blades</li><li>Peach seed jig amber bone handle</li><li>Length: 3.63 inches closed and 2.5 ounces</li><li>Limited lifetime warranty</li></ul><p><strong>HANDLE</strong></p><ul><li>Amber Bone</li></ul><p>The heart of the Case line lies within this classic bone handle, with rich amber and honey tones. The material is procured internationally, rendered from the hearty shin bone of Zebu cattle, a substance tough enough for the rigors of Case knife demands.</p><p><strong>BLADES</strong></p><ul><li>Clip</li></ul><p>The Clip blade is extremely versatile -- just the thing for those everyday tasks at work or around the house. With a sharp point for piercing, the shape allows for better control of the cutting edge.</p><ul><li>Sheepfoot</li></ul><p>The Sheepfoot blade features a straight edge and a curved back, allowing for greater tip strength and control of the cutting edge with your fingers. Originally designed for trimming sheep's hooves, this blade is ideal for carving and carpentry work.</p><ul><li>Pen</li></ul><p>The Pen blade shape was originally designed to cut and sharpen turkey quills for use as ink pens. Today, it still makes a great blade for light-duty work.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Model No.: 00079</li><li>Pattern: Medium Stockman</li><li>Pattern Stamp: 63032 CV</li><li>Handle Material: Amber Bone</li><li>Handle Finish: Jigged</li><li>Blade Type: Clip, Sheepfoot, Pen</li><li>Blade Length(s): 2.57 in, 1.88 in, 1.76 in</li><li>Lock Type: Non-Locking (Slip Joint)</li><li>Blade Material: Chrome Vanadium</li><li>Blade Finish: Mirror-Polished</li><li>Closed Length: 3.63 in</li><li>Weight: 0.16 lb</li><li>Sheath: Sold Separately</li></ul>	[empty string]	N	74.99	74.99	[empty string]	8743-DEFAULT-s.jpg	[empty string]	1000	1000	00079	228454	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	case-sons-cutlery/case-amber-bone-peach-seed-jig-chrome-vanadium-medium-stockman-pen-blade-228454	00079	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	%bulldog%cases%
3	%redline%
4	%jebs%choke%tubes%
5	%case%sons%cutlery%
6	%nebo%
7	%flextone%game%calls%

Filter By

Sort By

Item # 00079 $74.99

0 Reviews

Sign in

Hunting

Hunting

Availability

Brand

PRICE

Skeeter Hawk Bait Station Replacement Tubes - 2 Pack

Skeeter Hawk Wearable Mosquito Carabiner

Skeeter Hawk Wristband

Bulldog Deluxe 2 Pistol Range Bag W/Molle Black - Bdt917b

Double Magazine Holder With Belt Loops Universal Black

Case Trapper 2- Blade 3- 1/2 In.Pocket Knife

Case Trapper Slimline 3.25 " Clip Point Yellow Synthetic Handle

Case Yellow Synthetic Chrome Vanadium Sod Buster Jr

Case 00035 Stockman Medium 2.57 "/ 1.88 "/ 1.71 " Folding Clip/Sheepsfoot/Spey Plain Tumble Polish Chrome Vanadium Steel Blade/Yellow Synthetic Handle

Case Amber Bone Peach Seed Jig Chrome Vanadium Medium Stockman (Pen Blade)

Store Information

Shop

Our Company

Guest Help

Are you over 18?

Please make a selection:

Sign up

Hunting

Hunting

Availability

Brand

PRICE

Skeeter Hawk Bait Station Replacement Tubes - 2 Pack

Skeeter Hawk Wearable Mosquito Carabiner

Skeeter Hawk Wristband

Bulldog Deluxe 2 Pistol Range Bag W/Molle Black - Bdt917b

Double Magazine Holder With Belt Loops Universal Black

Case Trapper 2- Blade 3- 1/2 In.Pocket Knife

Case Trapper Slimline 3.25 " Clip Point Yellow Synthetic Handle

Case Yellow Synthetic Chrome Vanadium Sod Buster Jr

Case 00035 Stockman Medium 2.57 "/ 1.88 "/ 1.71 " Folding Clip/Sheepsfoot/Spey Plain Tumble Polish Chrome Vanadium Steel Blade/Yellow Synthetic Handle

Case Amber Bone Peach Seed Jig Chrome Vanadium Medium Stockman (Pen Blade)