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]	UMERX GERMANY	Umerx Germany	FIREARMS	Firearms>Tactical	[empty string]	1	449.99	0	449.99	10329-DEFAULT-l.jpg	449.99	10329-DEFAULT-m.jpg	WALTHER HAMMERLI TAC R1	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	UMERX GERMANY	WALTHER ARMS	RIFLE	22LR	[empty string]	4133	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	2-NIB	[empty string]	0	400-to-450	0.00	[empty string]	Walther Hammerli Tac R1 22 LR 16.10" Threaded Barrel \| Matte Black Metal & 5 Position Black Stock	<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><p>This Walther Hammerli Tac R1 rifle features a 5-position stock, aluminum upper and lower receiver, flip-up sights and a matte black finish.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Hammerli Arms</li><li>Category Rimfire Rifles</li><li>Caliber 22 LR</li><li>Barrel Length Range 16" to 16.99"</li><li>Model Tac R1</li><li>Stock Finish Group Black</li><li>Capacity 20+1</li><li>Stock Material Synthetic</li><li>Action Semi-Auto</li><li>OAL 35.83"</li><li>Hand Right</li><li>Sights Flip Up Front & Rear</li><li>Size Full Size</li><li>Barrel Finish Matte Black</li><li>Muzzle Flash Hider</li><li>Gun Platform AR-Style</li><li>Grips Black Polymer</li><li>Receiver Material Aluminum</li><li>Safety Ambidextrous</li><li>Stock Description 5 Position</li><li>Barrel Length 16.10"</li><li>Max Capacity 20</li><li>Receiver Finish Matte Black</li><li>Weight 5.62 lbs</li><li>Stock Finish Black</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 "pick up in store" 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	449.99	449.99	[empty string]	10329-DEFAULT-s.jpg	[empty string]	1000	1000	5760500	65888	EMPTY	EMPTY	EMPTY	0	0	0	TACTICAL	umerx-germany/walther-hammerli-tac-r1-22-lr-16-10-threaded-barrel-matte-black-metal-5-position-black-stock-65888	5760500	0
2	CIWD7242X_54_GUN	RHINO METALS INC	Rhino Metals Inc	SHOOTING	Shooting>Safes	CIWD7242X_54_GUN\|NULL\|NULL	1	3199.99	0	3199.99	2635-DEFAULT-l.jpg	3199.99	2635-DEFAULT-m.jpg	RHINO METALS IRONWORKS SAFE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4247	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Rhino Metals Ironworks USA Series Gun Safes Multiple Options In-Store (We Do Custom Order)	<p><strong>For more information about custom orders, purchase information, and delivery please call store for details 318-282-2688 or 800-726-9930, Delivery Map in images, prices and distance may vary</strong></p><p>PRODUCT DETAILS: IRONWORKS safes look like something out of the 1800's. Part art, part furniture, and all security with 85 minute fire protection. Each safe is hand antiqued and distressed to accentuate the natural variations in the steel, producing an heirloom quality piece for your home or office! Limited Lifetime Warranty</p><p><strong>Fire Protection:</strong></p><ul><li>A full 85 minutes of protection at 1400 F</li><li>Advanced protection with 3 layers of 5/8" fireboard in the ceiling, 2 layers on the walls, floor, and door</li><li>Heat activated door seal expands up to 7 times its size which seals the door edge to help keep out heat and smoke</li></ul><p><strong>Security Features:</strong></p><ul><li>Heavy Duty 12 gauge formed steel body with external corner reinforcements on critical attack points</li><li>12 gauge composite door with external reinforcement ring for pry-point protection</li><li>Ball bearing drill Plate</li><li>Patented F-4 Locking system featuring an Internal Anti-Tamper clutch</li><li>Anti-Punch and Anti-Drill Boltworks</li><li>Spring loaded re-locker keeps safe secure if lock is tampered with or removed</li><li>Large door bolts (1.25" diameter), 4-sided protection (13 door bolts total)</li><li>Certified with UL as a Residential Security Container and meets or exceeds California DOJ acceptable gun safe standards</li><li>Sargent and Greenleaf EMP Resistant UL Listed Lock</li></ul><p><strong>CIWD6030X Style and Function:</strong></p><ul><li>Holds up to 35 long guns & 6 handguns</li><li>660 lbs</li><li>External dimensions: 60"H x 30"W x 25"D (not including handle)</li><li>Deluxe door organizer standard for more storage options</li><li>Distressed leatherette interior fabric</li><li>Plush adjustable shelving and interior walls</li><li>Large 3-spoke cast iron hand wheel</li><li>Factory installed USB equipped electrical outlet</li><li>Predrilled and compatible for our patented Swing Out Gun Rac</li></ul><p><strong>CIWD6040X Style and Function:</strong></p><ul><li>Holds up to 54 long guns & 8 handguns</li><li>790 lbs</li><li>External dimensions: 60"H x 40"W x 25"D (not including handle)</li><li>Deluxe door organizer standard for more storage options</li><li>Distressed leatherette interior fabric</li><li>Plush adjustable shelving and interior walls</li><li>Large 3-spoke cast iron hand wheel</li><li>Factory installed USB equipped electrical outlet</li><li>Predrilled and compatible for our patented Swing Out Gun Rack</li></ul><p><strong>CIWD7242X Style and Function:</strong></p><ul><li>Holds up to 54 long guns & 10 handguns</li><li>980 lbs</li><li>External dimensions: 72"H x 42"W x 27"D (not including handle)</li><li>Deluxe door organizer standard for more storage options</li><li>Distressed leatherette interior fabric</li><li>Plush adjustable shelving and interior walls</li><li>Large 3-spoke cast iron hand wheel</li><li>Factory installed USB equipped electrical outlet</li><li>Predrilled and compatible for our patented Swing Out Gun Rack</li></ul><p><strong>CIWD7256X Style and Function:</strong></p><ul><li>Holds up to 76 long guns & 16 handguns</li><li>1250 lbs</li><li>External dimensions: 72"H x 56"W x 27"D (not including handle)</li><li>Deluxe door organizer standard for more storage options</li><li>Distressed leatherette interior fabric</li><li>Plush adjustable shelving and interior walls</li><li>Large 3-spoke cast iron hand wheel</li><li>Factory installed USB equipped electrical outlet</li><li>Predrilled and compatible for our patented Swing Out Gun Rack</li></ul>	[empty string]	N	3199.99	3199.99	[empty string]	2635-DEFAULT-s.jpg	[empty string]	1000	1000	CIWD7242X	154093	EMPTY	EMPTY	EMPTY	0	0	0	SAFES	rhino-metals-inc/rhino-metals-ironworks-usa-series-gun-safes-multiple-options-in-store-we-do-custom-order-154093	CIWD7242X	0
3	[empty string]	HICKS INC	Hicks Inc	UNCATEGORIZED	Uncategorized	[empty string]	0	24.99	0	24.99	[empty string]	24.99	[empty string]	MILI CUSTOM DEFENSE AMMUNITION	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	12GA	[empty string]	2928	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	20-to-25	0.00	[empty string]	Mili Custom Defense Ammunition	[empty string]	[empty string]	N	24.99	24.99	[empty string]	[empty string]	[empty string]	1000	1000	86000504000	199436	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hicks-inc/mili-custom-defense-ammunition-199436	86000504000	0
4	[empty string]	BULLDOG CASES	Bulldog Cases	SHOOTING	Shooting>Accessories>Holsters	[empty string]	1	39.99	0	39.99	7015-DEFAULT-l.jpg	39.99	7015-DEFAULT-m.jpg	BULLDOG RAPID RELEASE GLOCK 20	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]	5	25-to-50	0.00	[empty string]	Bulldog Rapid Release Polymer Holster With Paddle For Glock 21 Gen 1-4 Black Right Hand	<p>Right-handed only. Specially designed Quick-Draw safety locking mechanism. Paddle includes comfort wear silicone lining for extra comfort. Fully adjustable draw angle (tool included). Gun specific design. Suitable for civilian, duty and military use. Includes holster, paddle, attachment and adjustment tool. Black only. Polymer construction.</p>	[empty string]	N	39.99	39.99	[empty string]	7015-DEFAULT-s.jpg	[empty string]	1000	1000	01107	227009	HOLSTERS	EMPTY	EMPTY	0	0	0	EMPTY	bulldog-cases/bulldog-rapid-release-polymer-holster-with-paddle-for-glock-21-gen-1-4-black-right-hand-227009	01107	0
5	[empty string]	BULLDOG CASES	Bulldog Cases	SHOOTING	Shooting>Accessories>Holsters	[empty string]	1	39.99	0	39.99	7084-DEFAULT-l.jpg	39.99	7084-DEFAULT-m.jpg	BULLDOG RAPID RELEASE LC9	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]	1	2	25-to-50	0.00	[empty string]	Bulldog Rapid Release Polymer Holster With Paddle For Ruger LC9 Black Right Hand	<p>Right-handed only. Specially designed Quick-Draw safety locking mechanism. Paddle includes comfort wear silicone lining for extra comfort. Fully adjustable draw angle (tool included). Gun specific design. Suitable for civilian, duty and military use. Includes holster, paddle, attachment and adjustment tool. Black only. Polymer construction.</p>	[empty string]	N	39.99	39.99	[empty string]	7084-DEFAULT-s.jpg	[empty string]	1000	1000	01121	227011	HOLSTERS	EMPTY	EMPTY	0	0	0	EMPTY	bulldog-cases/bulldog-rapid-release-polymer-holster-with-paddle-for-ruger-lc9-black-right-hand-227011	01121	0
6	[empty string]	BULLDOG CASES	Bulldog Cases	SHOOTING	Shooting>Accessories>Holsters	[empty string]	1	34.99	1	19.99	7021-DEFAULT-l.jpg	34.99	7021-DEFAULT-m.jpg	BULLDOG RAPID RELEASE SIG P365	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]	11	15-to-20	0.00	[empty string]	Bulldog Rapid Release Polymer Holster With Paddle For Sig Sauer P365	<p>Specifically Designed "Quick Draw" Safety Locking Mechanism</p><ul><li>Specifically Designed "Quick Draw" Safety Locking Mechanism</li><li>Paddle Includes "Comfort Wear" Silicone Lining for Extra Comfort</li><li>Fully Adjustable Draw Angle</li><li>Fits The Sig Sauer P365 Series</li><li>Includes Holster, Paddle, Attachment& Adjustment Tool</li></ul>	[empty string]	Y	19.99	19.99	[empty string]	7021-DEFAULT-s.jpg	[empty string]	1000	1000	01193	227012	HOLSTERS	EMPTY	EMPTY	0	0	0	EMPTY	bulldog-cases/bulldog-rapid-release-polymer-holster-with-paddle-for-sig-sauer-p365-227012	01193	0
7	[empty string]	BULLDOG CASES	Bulldog Cases	ARCHERY	Archery>Accessories>Cases & Bags	[empty string]	1	49.99	0	49.99	7566-DEFAULT-l.jpg	49.99	7566-DEFAULT-m.jpg	BULLDOG AR120 BOW 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]	15	25-to-50	0.00	[empty string]	Bulldog Deluxe Bow Case w/ 36" Quill Pocket	<p><strong>SPECIFICATIONS:</strong></p><ul><li>1 " Total Soft Padding</li><li>Full-Length Heavy-Duty Zipper W/ Pull</li><li>Water-Resistant</li><li>Soft Scratch-Resistant Inner Lining</li><li>Attractive 3D Camo Panels</li><li>Durable, Extra Heavy Duty Nylon</li><li>Water-Resistant Outer Shell</li></ul>	[empty string]	N	49.99	49.99	[empty string]	7566-DEFAULT-s.jpg	[empty string]	1000	1000	AR120	227013	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bulldog-cases/bulldog-deluxe-bow-case-w-36-quill-pocket-227013	AR120	0
8	[empty string]	BULLDOG CASES	Bulldog Cases	SHOOTING	Shooting>Accessories>Gun Cases	[empty string]	1	14.99	0	14.99	908-DEFAULT-l.jpg	14.99	908-DEFAULT-m.jpg	BULLDOG BD100 RIFLE CASE	N	AMAZON	[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]	20	10-to-15	0.00	[empty string]	Bulldog Pit Bull Rifle Case - 48" Black	<p><strong>SPECIFICATIONS:</strong></p><ul><li>1 1/2" Total Soft Close Cell Soft Padding</li><li>#8 Full Length Zipper W/ Pull</li><li>Durable Nylon Water-Resistant Outer Shell</li><li>Laminated, Brushed Tricot, Soft Scratch-Resistant Inner Lining</li><li>It Floats!</li><li>Black with Black Trim 48"</li><li>Case Measurements are external dimensions. For best weapon fit, deduct 2".</li></ul>	[empty string]	N	14.99	14.99	[empty string]	908-DEFAULT-s.jpg	[empty string]	1000	1000	BD100	227014	GUN CASES	EMPTY	EMPTY	0	0	0	EMPTY	bulldog-cases/bulldog-pit-bull-rifle-case-48-black-227014	BD100	0
9	[empty string]	BULLDOG CASES	Bulldog Cases	SHOOTING	Shooting>Accessories>Gun Cases	[empty string]	1	14.99	0	14.99	7579-DEFAULT-l.jpg	14.99	7579-DEFAULT-m.jpg	BULLDOG BD10040 RIFLE 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]	1	10-to-15	0.00	[empty string]	Bulldog Pit Bull Rifle Case - 40" Black	<p><strong>SPECIFICATIONS:</strong></p><ul><li>1 1/2" Total Soft Close Cell Soft Padding</li><li>#8 Full Length Zipper W/ Pull</li><li>Durable Nylon Water-Resistant Outer Shell</li><li>Laminated, Brushed Tricot, Soft Scratch-Resistant Inner Lining</li><li>It Floats!</li><li>Black with Black Trim 40"</li><li>Case Measurements are external dimensions. For best weapon fit, deduct 2".</li></ul>	[empty string]	N	14.99	14.99	[empty string]	7579-DEFAULT-s.jpg	[empty string]	1000	1000	BD10040	227015	GUN CASES	EMPTY	EMPTY	0	0	0	EMPTY	bulldog-cases/bulldog-pit-bull-rifle-case-40-black-227015	BD10040	0
10	[empty string]	BULLDOG CASES	Bulldog Cases	SHOOTING	Shooting>Safes	[empty string]	1	69.99	0	69.99	7617-DEFAULT-l.jpg	69.99	7617-DEFAULT-m.jpg	BULLDOG BD1050 PISTOL VAULT	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	50-to-100	0.00	[empty string]	Bulldog Standard Digital Pistol Vault Exterior Dimensions 7x12x10 Inches	<p><strong>FEATURES</strong></p><p>-12 Digit Key Pad For More Secure Combination Options<br />- More Than 1000 Combinations Available<br />- Secure Hidden Key Override<br />- Pre-Drilled Mounting Holes<br />- Soft Bottom Carpet For Protection<br />- Heavy Duty Steel Construction<br />- Durable Powder Coated Black Matte Finish<br />- 2 3/4" Steel Locking Bolts On Door<br />- Mounting Hardware Included<br />- Low Voltage LED Light<br />- Tamper Alarm For Extra Security<br />- 12" x 8" x 7"</p><p>Requires 4 "AA" Batteries- Batteries Are Not Included</p><p> </p>	[empty string]	N	69.99	69.99	[empty string]	7617-DEFAULT-s.jpg	[empty string]	1000	1000	BD1050	227017	EMPTY	EMPTY	EMPTY	0	0	0	SAFES	bulldog-cases/bulldog-standard-digital-pistol-vault-exterior-dimensions-7x12x10-inches-227017	BD1050	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc