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]	AMERICAN TACTICAL	American Tactical	FIREARMS	Firearms>Shotgun	[empty string]	1	599.99	0	599.99	6945-DEFAULT-l.jpg	599.99	6945-DEFAULT-m.jpg	ATI CALVARY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	KOFS	AMERICAN TACTICAL	SHOTGUN	12GA	[empty string]	3757	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2-NIB	[empty string]	1	500-or-more	0.00	[empty string]	American Tactical Cavalry SVE 12 Gauge 28" Barrel 3" \| Silver Engraved Metal & Oiled Turkish Walnut \| Over & Under	<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>ATI's Cavalry hunting and sporting shotgun has a receiver made from lightweight, high-grade 7075 aluminum and features an intricate, laser-engraved design. It has an oil-finished Turkish Walnut stock and forend with blued 4140 chrome moly steel barrels with a brass bead front sight. These over/under shotguns have a single selective trigger, and includes five (5) interchangeable chokes. The Cavalry series weigh in at just over 6 lbs., and they are hand fit at the factory. This SVE model is a 12-gauge with 3" chamber, ejector, and 28" barrel. It has a 14.23" LOP, with a 1.45" drop at comb, and 2.2" drop at the heel.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand ATI</li><li>Category Shotguns</li><li>Model Cavalry</li><li>Series SVE</li><li>Gauge 12 Gauge</li><li>Stock Finish Oiled Turkish Walnut</li><li>Action Break Open</li><li>Barrel Length Range 28" to 28.99"</li><li>Sights Brass Bead Front</li><li>Capacity 2rd</li><li>Chamber 3"</li><li>Choke Configuration MobilChoke</li><li>Application Hunting, Sporting</li><li>Chokes Included 5</li><li>Drop 1 9 / 20" @ Comb & 2 1 / 5" @ Heel</li><li>Hand Right</li><li>Length of Pull 14.23"</li><li>Receiver Description Engraved</li><li>Receiver Finish Silver</li><li>Receiver Material 7075-T6 Aluminum</li><li>Safety Top Tang</li><li>Stock Finish Group Brown / Tan</li><li>Stock Material Wood</li><li>Trigger Single Selective</li><li>Weight 6 lbs</li><li>Barrel Description 4140 Chrome Moly Vent Rib</li><li>Barrel Finish Blued</li><li>Barrel Length 28"</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>	[empty string]	N	599.99	599.99	[empty string]	6945-DEFAULT-s.jpg	[empty string]	1000	1000	ATIGKOF12SVE	63721	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUN	american-tactical/american-tactical-cavalry-sve-12-gauge-28-barrel-3-silver-engraved-metal-oiled-turkish-walnut-over-under-63721	ATIGKOF12SVE	0
2	[empty string]	AMERICAN TACTICAL	American Tactical	FIREARMS	Firearms>Shotgun	[empty string]	1	579.99	0	579.99	8542-DEFAULT-l.jpg	579.99	8542-DEFAULT-m.jpg	ATI ATIGKOF12SVE26 CAVALRY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	KOFS	AMERICAN TACTICAL	SHOTGUN	12GA	[empty string]	3757	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2-NIB	[empty string]	1	500-or-more	0.00	[empty string]	American Tactical Cavalry Engraved 12 Gauge 26" Barrel 3" \| Silver & Turkish Walnut	<p>The Cavalry Over/Under are made from light weight high grade 7075 aluminum with an intricate laser engraved design. Featuring a single selective trigger, oil finished Turkish Walnut wood stock, brass bead front sight and auto ejetors. Includes 5 interchangeable chokes.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand ATI</li><li>Category Shotguns</li><li>Model Cavalry</li><li>Series Engraved</li><li>Gauge 12 Gauge</li><li>Stock Finish Oiled Turkish Walnut</li><li>Action Break Open</li><li>Barrel Length Range 26" to 26.99"</li><li>Sights Brass Bead Front</li><li>Capacity 2rd</li><li>Chamber 3"</li><li>Size Full Size</li><li>Choke Configuration Beretta / Benelli Choke</li><li>Application Hunting, Sporting</li><li>Drop 1.45" @ Comb & 2.20" @ Heel</li><li>Hand Right</li><li>Length of Pull 14.23"</li><li>Receiver Description Engraved</li><li>Receiver Finish Silver</li><li>Receiver Material Aluminum</li><li>Stock Finish Group Brown / Tan</li><li>Stock Material Wood</li><li>Trigger Single Selective</li><li>Weight 6 lbs</li><li>Barrel Description 4140 Chrome Moly Vent Rib</li><li>Barrel Finish Blued</li><li>Barrel Length 26"</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	579.99	579.99	[empty string]	8542-DEFAULT-s.jpg	[empty string]	1000	1000	ATIGKOF12SVE26	63722	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUN	american-tactical/american-tactical-cavalry-engraved-12-gauge-26-barrel-3-silver-turkish-walnut-63722	ATIGKOF12SVE26	0
3	[empty string]	CENTURY ARMS	Century Arms	FIREARMS	Firearms>Handgun	[empty string]	1	419.99	0	419.99	6770-DEFAULT-l.jpg	419.99	6770-DEFAULT-m.jpg	CENTURY INTERNATIONAL ARMS	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CENTURY INTERNATIONAL ARMS	CENTURY ARMS	PISTOL	9MM	[empty string]	2840	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	400-to-450	0.00	[empty string]	Century TP9 Elite Sub-Compact 9mm Luger 3.60" 15+1, 12+1 Black Tungsten Gray Cerakote Steel Slide Black Interchangeable Backstrap Grip - HG5610TN	<p><strong>DESCRIPTION:</strong></p><p>The TP9 Elite Subcompact 9mm features a black finish on the stock, and a tungsten finish on the slide. It has interchangeable back straps in 2 sizes, small and large, and be converted from sub compact to a compact by switching from the 12 round magazine to the 15 round magazine included. it has a reversible magazine release, match grade nitride barrel, and integral accessory picatinny rail. It has a blackout rear and phosphorous front white dot sight and micro red-dot interface with co-witness feature.</p><p><strong>FEATURES:</strong></p><ul><li>Brand Century</li><li>Category Pistols</li><li>Caliber 9mm Luger</li><li>Model TP9 Elite</li><li>Series Sub-Compact</li><li>Frame Finish Black</li><li>Action DAO</li><li>Barrel Length Range 3"" to 3.99""</li><li>Slide Description Tungsten Gray Cerakote Steel</li><li>Slide Finish Tungsten</li><li>Capacity 15+1</li><li>Frame Material Polymer</li><li>Grips Black Interchangeable Backstrap</li><li>Hand Right</li><li>OAL 3.60""</li><li>Sight Configuration Blackout Rear / White dot / Micro Red Dot</li><li>Weight 24.78 oz</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	419.99	419.99	[empty string]	6770-DEFAULT-s.jpg	[empty string]	1000	1000	HG5610TN	64278	EMPTY	EMPTY	EMPTY	0	0	0	HANDGUN	century-arms/century-tp9-elite-sub-compact-9mm-luger-3-60-15-1-12-1-black-tungsten-gray-cerakote-steel-slide-black-interchangeable-backstrap-grip-hg5610tn-64278	HG5610TN	0
4	[empty string]	CENTURY ARMS	Century Arms	FIREARMS	Firearms>Tactical	[empty string]	1	1799.99	0	1799.99	9853-DEFAULT-l.jpg	1799.99	9853-DEFAULT-m.jpg	CENTURY INT ARMS HG6036N AP5	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CENTURY INTERNATIONAL ARMS	CENTURY ARMS	PISTOL	9MM	[empty string]	2840	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Century AP5 9mm 4.50" TB 30+1 Black Polymer Grip RH - HG6036N	<p><strong>DESCRIPTION:</strong></p><p>The AP5 or Apparatus Pistol, is a roller delayed blowback firearm based and built off of the original and historic design from the 1970s. The roller-lock platform has been widely respected as the preeminent design for over 50 years. Adopted for use across the globe, no other firearm of its type has been more successful. Each model of the AP5 includes standard: a rugged plastic carry case, two (2) 30-round magazines, a factory cleaning kit, factory picatinny style optics mount, factory sling, and a gun lock.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Century Arms</li><li>Category Tactical Pistols</li><li>Caliber 9mm Luger</li><li>Model AP5</li><li>Action Semi-Auto</li><li>Barrel Length Range 4" to 4.99"</li><li>Sights Fixed Front, Drum Rear</li><li>Capacity 30+1</li><li>Muzzle Threaded</li><li>Grips Black Polymer</li><li>Hand Right</li><li>Includes 2 Magazines</li><li>OAL 17.90"</li><li>Receiver Finish Black</li><li>Receiver Material Steel</li><li>Weight 5.50 lbs</li><li>Barrel Length 4.50"</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	1799.99	1799.99	[empty string]	9853-DEFAULT-s.jpg	[empty string]	1000	1000	HG6036N	64282	EMPTY	EMPTY	EMPTY	0	0	0	TACTICAL	century-arms/century-ap5-9mm-4-50-tb-30-1-black-polymer-grip-rh-hg6036n-64282	HG6036N	0
5	[empty string]	AMERICAN TACTICAL	American Tactical	FIREARMS	Firearms>Tactical	[empty string]	1	599.99	1	399.99	6937-DEFAULT-l.jpg	599.99	6937-DEFAULT-m.jpg	ATI OMNI HYBRID AR-15	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AMERICAN TACTICAL	[empty string]	RIFLE	5.56	[empty string]	3757	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0	350-to-400	0.00	[empty string]	American Tactical Omni Hybrid Maxx 5.56x45mm 16" Barrel with 10" M-LOK Rail \| Black	<p>ATI OMNI HYBRID MAXX RIA P3P 5.56X45MM 16 BBL 1:8 10 MLOK ALPHA STK NANO PARTS KIT 30RND - MIlspec AR15 polymer upper and lower Omni Hybrid Maxx. Includes a Nano composite parts kit. Complete rifle weighs 5.5 lbs. - Specs - Caliber: 5.56 NATO - Capacity: 30rnd - Barrel: 16 - Forend: 10 MLOK - Stock: Alpha Stock - FCG: Nano composite parts kit - Color: Black<br /></p><ul><li>Model: Omni Hybrid</li><li>Weight: 8.7500</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><p> </p>	[empty string]	Y	399.99	399.99	[empty string]	6937-DEFAULT-s.jpg	[empty string]	1000	1000	ATIGOMX556MP3P	66084	EMPTY	EMPTY	EMPTY	0	0	0	TACTICAL	american-tactical/american-tactical-omni-hybrid-maxx-5-56x45mm-16-barrel-with-10-m-lok-rail-black-66084	ATIGOMX556MP3P	0
6	[empty string]	AMERICAN TACTICAL	American Tactical	SHOOTING	Shooting>Accessories>AR Accessories	[empty string]	1	49.99	0	69.99	28541-DEFAULT-l.jpg	49.99	28541-DEFAULT-m.jpg	ATI AR15 BUFFER TUBE ASSEMBLY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3757	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	American Tactical AR-15 Military Buffer Tube	<p>Constructed of Military Type III anodized, 6061 T6 aluminum. Military diameter threads for maximum fit into AR-15 receiver. Laser etched logo. Includes steel Military Grade E-Coated castle nut and locking ring. Includes AR-15 recoil plug and buffer spring. Manufactured in the USA.</p><ul><li>Brand ATI Outdoors</li><li>Category Stock Accessories</li><li>Model Buffer Tube Assembly</li><li>Firearm Fit AR-15</li><li>Color Black</li><li>Finish Anodized</li><li>Style Mil-Spec</li><li>Type Buffer Assembly</li><li>Gun Style AR-Platform</li><li>Diameter 1.148"</li><li>Includes Castle Nut & Locking Ring</li></ul>	[empty string]	N	69.99	69.99	[empty string]	28541-DEFAULT-s.jpg	[empty string]	1000	1000	A.5.10.2240	116481	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	american-tactical/american-tactical-ar-15-military-buffer-tube-116481	A.5.10.2240	0
7	[empty string]	CENTURY ARMS	Century Arms	SHOOTING	Shooting>Accessories>AR Accessories	[empty string]	1	169.99	0	169.99	12138-DEFAULT-l.jpg	169.99	12138-DEFAULT-m.jpg	MESA TACTICAL 91470	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2840	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	Mesa Tactical Urbino Tactical 91470	<p>Mesa Tactical Urbino Tactical Stock, Fits Benelli M4, Fixed, Fits with a Tactical Length of Pull, Riser, Limbsaver, Black 91470</p>	[empty string]	N	169.99	169.99	[empty string]	12138-DEFAULT-s.jpg	[empty string]	1000	1000	91470	129322	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	century-arms/mesa-tactical-urbino-tactical-91470-129322	91470	0
8	[empty string]	CENTURY ARMS	Century Arms	SHOOTING	Shooting>Accessories>Magazine	[empty string]	1	54.99	0	54.99	9549-DEFAULT-l.jpg	54.99	9549-DEFAULT-m.jpg	CENTURY INTERNATIONAL ARMS	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2840	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Century International Arms Magazine Tp9 15rd 9mm Pkg	<ul><li>MANUFACTURER: CANIK</li><li>FAMILY: TP9 Series</li><li>MODEL: TP9 Magazine</li><li>TYPE: Accessory-Magazines</li><li>CALIBER/GAUGE: 9mm</li><li>CAPACITY: 15 rd.</li><li>SHIPPING WEIGHT: 0.3 lbs.</li><li>MFG MODEL NO: MA2082</li><li>UPC: 787450716834</li></ul>	[empty string]	N	54.99	54.99	[empty string]	9549-DEFAULT-s.jpg	[empty string]	1000	1000	MA2082	129334	MAGAZINE	EMPTY	EMPTY	0	0	0	EMPTY	century-arms/century-international-arms-magazine-tp9-15rd-9mm-pkg-129334	MA2082	0
9	[empty string]	RIGEMRIGHT	Rigemright	UNCATEGORIZED	Uncategorized	[empty string]	1	41.99	0	41.99	38431-DEFAULT-l.jpg	41.99	38431-DEFAULT-m.jpg	RIG EM RIGHT CABLE RIGS	N	AMAZON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3590	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Rig Em Right Xtreme Coated Cable Decoy Anchors	<p>Rig'Em Right 's Xtreme Coated Cable Decoy Anchors are built to last a lifetime. In fact, they have a lifetime warranty. The coated steel cable has less memory than traditional mono-filament decoy anchor line and each pack includes a large padded carabiner. Like all Rig' Em Right rigging products, these anchors are built with super heavy-duty crimps and swivels to handle all the rigors that waterfowl hunting can dish out.</p>	[empty string]	N	41.99	41.99	18``_4OZ	38431-DEFAULT-s.jpg	[empty string]	1000	1000	00118TXC	154330	EMPTY	WEIGHTS & RIGGING	EMPTY	0	0	0	EMPTY	rigemright/rig-em-right-xtreme-coated-cable-decoy-anchors-154330	00118TXC	0
10	[empty string]	RIGEMRIGHT	Rigemright	HUNTING	Hunting>Decoys>Accessories>Weights & Rigging	[empty string]	1	39.99	0	39.99	4139-DEFAULT-l.jpg	39.99	4139-DEFAULT-m.jpg	RIG EM RIGHT 00130	N	AMAZON,EBAY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3590	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	Rig Em Right 30" Anchors w/ 4-oz Weights	<p>If you're tired of winding up decoy line and stuffing your decoys in a bag, this system is for you. The looped end allows decoys to be stored and carried on the provided spring clip without the use of a bag. The sliding weight design allows fast and accurate placement of decoys with one hand. Retrieval of your ducks is quick and easy and always tangle-free. </p><p>This system is super-fast, field proven and has earned the Duck Commander stamp of approval. Pre-rigged. 1-dozen or 1/2 dozen weights per package.</p><p><strong>FEATURES</strong></p><ul><li>Decoys carry easily with the provided spring clip - No bags required</li><li>No need to wind the line around the decoy</li><li>Sliding weight makes tossing out decoys quick and accurate</li><li>30" length with 4 oz weight</li><li>Sold 12 to a package</li><li>30" length</li><li>4 oz weight</li></ul><p> </p>	[empty string]	N	39.99	39.99	[empty string]	4139-DEFAULT-s.jpg	[empty string]	1000	1000	00130	154331	EMPTY	WEIGHTS & RIGGING	EMPTY	0	0	0	EMPTY	rigemright/rig-em-right-30-anchors-w-4-oz-weights-154331	00130	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc