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] CMMG Cmmg FIREARMS Firearms>Tactical [empty string] 1 1099.99 0 1099.99 8332-DEFAULT-l.jpg 1099.99 8332-DEFAULT-m.jpg CMMG 22A5B62GB Banshee 300 N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] CMMG [empty string] RIFLE 22LR [empty string] 3525 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 500-or-more 0.00 [empty string] CMMG Banshee 300 MK4 22 LR 4.50" 25+1 Black Cerakote Black Magpul MOE CMMG 6 Position RipBrace - 22A5B62GB <p><strong>DESCRIPTION:</strong></p><p>The Banshee 300 is the lightest and most compact AR pistol firearm. It features 7075-T6 aluminum receivers, single-stage trigger, CMMG ambidextrous safety selector, and a CMMG ambidextrous charging handle. The barrel has a nitride finish. The Banshee 300 also has a M-Lok free-float handguard and Cerakote finish. This MK4 model features an 4.50&quot; medium taper barrel, Magpul MOE grip, CMMG 6 position RipBrace, Magpul MOE trigger guard, and a 25-round CMMG magazine.</p><p><strong>SPECIFICATONS:</strong></p><ul><li>Brand CMMG</li><li>Category Tactical Pistols</li><li>Caliber 22 LR</li><li>Model Banshee 300</li><li>Series MK4</li><li>Stock Finish Black</li><li>Action Semi-Auto</li><li>Barrel Length Range 4&quot; to 4.99&quot;</li><li>Sights None, Optic Ready</li><li>Capacity 25+1</li><li>Muzzle KAK Flash Can</li><li>Grips Black Magpul MOE</li><li>Hand Right</li><li>Handguards M-LOK Free-Float</li><li>OAL 20&quot;</li><li>Receiver Finish Graphite Black Cerakote</li><li>Receiver Material 7075-T6 Aluminum</li><li>Safety Ambidextrous</li><li>Stock Description CMMG 6 Position RipBrace</li><li>Stock Material Synthetic</li><li>Thread Pattern 1 / 2&quot;-28 tpi</li><li>Trigger Single-Stage</li><li>Weight 4.50 lbs</li><li>Barrel Description 4140 Chrome Moly Medium Taper</li><li>Barrel Finish Black Nitride</li><li>Barrel Length 4.50&quot;</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the &quot;pick up in store&quot; option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p> <p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p> [empty string] N 1099.99 1099.99 [empty string] 8332-DEFAULT-s.jpg [empty string] 1000 1000 22A5B62GB 64372 EMPTY EMPTY EMPTY 0 0 0 TACTICAL cmmg/cmmg-banshee-300-mk4-22-lr-4-50-25-1-black-cerakote-black-magpul-moe-cmmg-6-position-ripbrace-22a5b62gb-64372 22A5B62GB 0
2 TIMBER DR DUCK Dr Duck UNCATEGORIZED Uncategorized TIMBER|NULL|NULL 0 49.99 0 49.99 [empty string] 49.99 [empty string] DR DUCK HANDWARMER N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5680 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 25-to-50 0.00 [empty string] Dr Duck Handwarmer [empty string] [empty string] N 49.99 49.99 [empty string] [empty string] [empty string] 1000 1000 DDHW-1959T 99278 EMPTY EMPTY EMPTY 0 0 0 EMPTY dr-duck/dr-duck-handwarmer-99278 DDHW-1959T 0
3 [empty string] DR DUCK Dr Duck UNCATEGORIZED Uncategorized [empty string] 0 69.99 0 69.99 [empty string] 69.99 [empty string] DR DUCK WADER BAG N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 5680 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 50-to-100 0.00 [empty string] Dr Duck Wader Bag [empty string] [empty string] N 69.99 69.99 [empty string] [empty string] [empty string] 1000 1000 DDWB-1947T 99282 EMPTY EMPTY EMPTY 0 0 0 EMPTY dr-duck/dr-duck-wader-bag-99282 DDWB-1947T 0
4 [empty string] TINKS Tinks HUNTING Hunting>Scent Elimination [empty string] 1 9.99 0 9.99 8483-DEFAULT-l.jpg 9.99 8483-DEFAULT-m.jpg TINKS W5106 SCENT REEL N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2406 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 3 5-to-10 0.00 [empty string] Tink's Scent Reel <p>The new Tink's Scent Reel dispersal system enables you to maximize the effectiveness of your favorite Tink's lures and scents. Tink's Scent Reel is a retractable, compact and easy-to-use device that will put an abundant amount of scent in the woods with less mess.</p><p>Slide the lock switch to unlock the reservoir cap and fill with 1-ounce of your favorite Tink's lure. Replace the cap and lock. A leak-proof o-ring ensures you won't lose a drop. When you reach your hunt location, simply pull the hanging loop to unwind the wick to the desired length, up to 10&quot;, and hang. When the hunt is over, turn the reel to wind in the wick.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>10&quot; Retractable Wick</li><li>Convenient, Durable &amp; Rugged Design</li><li>Reflective Strip To Quickly Locate</li><li>Leak-Proof O-Ring System</li><li>Size: 2.5 Inches</li></ul> [empty string] N 9.99 9.99 [empty string] 8483-DEFAULT-s.jpg [empty string] 1000 1000 W5106 236770 EMPTY EMPTY EMPTY 0 0 0 SCENT ELIMINATION tinks/tink-s-scent-reel-236770 W5106 0
5 [empty string] TINKS Tinks HUNTING Hunting>Scent Elimination [empty string] 1 14.99 0 19.99 8507-DEFAULT-l.jpg 14.99 8507-DEFAULT-m.jpg TINKS #69 SCENT BOMB N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2406 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 15-to-20 0.00 [empty string] Tink's #69 Doe-In-Rut Value Pack 2 Oz. <p>A great buy for the avid whitetail deer hunter! Featuring a 2-ounce bottle of Tink's #69 Doe-in-Rut Buck Lure and a 1-ounce Scent Bomb. Pour the lure into the included Scent Bomb to soak the wick, then hang for all-day attraction.</p><p>Tink's #69 Doe-In-Rut Buck Lure is 100% natural doe estrous urine collected from live whitetail does during their estrous cycle. Tink's quality controlled formula keeps Tink's #69 Doe-In-Rut Buck Lure at the peak level of performance. Tink's #69 Doe-In-Rut Buck Lure, the standard on which all deer lures are measured, produces great results during the pre-rut and rut.</p> [empty string] N 19.99 19.99 [empty string] 8507-DEFAULT-s.jpg [empty string] 1000 1000 W5825 236795 EMPTY EMPTY EMPTY 0 0 0 SCENT ELIMINATION tinks/tink-s-69-doe-in-rut-value-pack-2-oz-236795 W5825 0
6 [empty string] TINKS Tinks HUNTING Hunting>Scent Elimination [empty string] 1 6.99 0 6.99 8476-DEFAULT-l.jpg 6.99 8476-DEFAULT-m.jpg TINKS W5841 SCENT BOMB N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2406 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 15 5-to-10 0.00 [empty string] Tink's Scent Bomb - 3 Pack <p>Tink's Scent Bombs the most efficient way to disperse scent today. They can be used as yardage markers, works with all cover scents and lures, and hangs in a tree to put more scent into the air.</p> [empty string] N 6.99 6.99 [empty string] 8476-DEFAULT-s.jpg [empty string] 1000 1000 W5841 236796 EMPTY EMPTY EMPTY 0 0 0 SCENT ELIMINATION tinks/tink-s-scent-bomb-3-pack-236796 W5841 0
7 [empty string] TINKS Tinks HUNTING Hunting>Scent Elimination [empty string] 1 29.99 0 29.99 8491-DEFAULT-l.jpg 29.99 8491-DEFAULT-m.jpg TINKS W5886 PEEFUSER N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2406 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 25-to-50 0.00 [empty string] Tink's #69 Doe-In-Rut PeeFuser Scent Diffuser <p>The Tink's Peefuser converts your favorite Tink's scent into a fine mist that will give deer in the area assurance to enter your hunting location and provide long range attraction for the big buck looking for a doe to breed. Every 2 mintues your hunting location will get a fresh 30 second burst of tantalizing Tink's attraction!</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Scent diffuser converts deer urine to irresistible mist</li><li>Diffuses scent for 30 seconds every 2 minutes while powered on</li><li>PeeFuser .5oz bottle lasts up to 7 hours</li><li>Battery powered (3 - AAA Batteries; not included)</li></ul> [empty string] N 29.99 29.99 [empty string] 8491-DEFAULT-s.jpg [empty string] 1000 1000 W5886 236803 EMPTY EMPTY EMPTY 0 0 0 SCENT ELIMINATION tinks/tink-s-69-doe-in-rut-peefuser-scent-diffuser-236803 W5886 0
8 [empty string] TINKS Tinks HUNTING Hunting>Scent Elimination [empty string] 1 9.99 0 9.99 8482-DEFAULT-l.jpg 9.99 8482-DEFAULT-m.jpg TINKS POWER SCRAPE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2406 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 5-to-10 0.00 [empty string] Tink's Power Scrape Mock Scrape Starter 4 Oz. <p>Tink's Power Scrape is a powerful synthetic buck lure designed for the entire season. Power Scrape can be used on natural or mock scrapes to condition deer to frequently return to your stand location. This revolutionary formula is designed to capitalize on a buck's curiosity in the early season and their drive for territorial dominance during the breeding season.</p><p>Use this 4-ounce bottle of Scrape Starter to start a new mock scrape or challenge bucks by applying to an existing scrape.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Conditions buck to revisit particular scrapes</li><li>Formulated to smell like an invader buck</li><li>Use on natural or mock scrapes</li><li>Size: 4 Ounce</li><li>Scent: Power Scrape Starter</li></ul> [empty string] N 9.99 9.99 [empty string] 8482-DEFAULT-s.jpg [empty string] 1000 1000 W5950 236809 EMPTY EMPTY EMPTY 0 0 0 SCENT ELIMINATION tinks/tink-s-power-scrape-mock-scrape-starter-4-oz-236809 W5950 0
9 [empty string] TINKS Tinks HUNTING Hunting>Scent Elimination [empty string] 1 16.99 1 14.99 8475-DEFAULT-l.jpg 16.99 8475-DEFAULT-m.jpg TINKS W6106 SMOKIN STICKS N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2406 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 16 10-to-15 0.00 [empty string] Tink's Smokin' Stick Synthetic Doe Estrous 6 Sticks <p>Tink's Smokin' Sticks are formulated to cover human scent and to attract game. When properly used, sticks will smoke for approximately 2 hours and the scent will stick to everything it comes into contact with.</p> [empty string] Y 14.99 14.99 [empty string] 8475-DEFAULT-s.jpg [empty string] 1000 1000 W6106 236820 EMPTY EMPTY EMPTY 0 0 0 SCENT ELIMINATION tinks/tink-s-smokin-stick-synthetic-doe-estrous-6-sticks-236820 W6106 0
10 [empty string] TINKS Tinks HUNTING Hunting>Scent Elimination [empty string] 1 9.99 0 9.99 12586-DEFAULT-l.jpg 9.99 12586-DEFAULT-m.jpg TINKS #69 SCENT PODS N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2406 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4 5-to-10 0.00 [empty string] Tink's #69 Scent Pods 3 Pack <p>No bottles to open, no scents to pour, no getting doe pee all over your hands and clothes. The Tink's Scent Pods are individually packaged and preloaded with America's #1 Buck Lure, Tink's #69 Doe-In-Rut. The unique pod design allows you to peel and hang virtually anywhere. Just pull the tab and Tink's #69 Doe-In-Rut soaks the felt pad. Then hang the pod and the alluring scent will disperse downwind for up to eight hours.</p><ul><li>Pull, Hang, Hunt</li><li>No spills, no mess</li><li>Tink's #69 Doe-In-Rut scent disperses naturally with air movement for up to eight hours</li><li>Comes in a 3 pack</li></ul> [empty string] N 9.99 9.99 [empty string] 12586-DEFAULT-s.jpg [empty string] 1000 1000 W6354 236832 EMPTY EMPTY EMPTY 0 0 0 SCENT ELIMINATION tinks/tink-s-69-scent-pods-3-pack-236832 W6354 0
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts ORDER BY sortposition asc