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]	LEGACY SPORTS	Legacy Sports	FIREARMS	Firearms>Shotgun	[empty string]	1	249.99	1	199.99	11344-DEFAULT-l.jpg	249.99	11344-DEFAULT-m.jpg	LEGACY PUMA 12GA PUMP WOOD	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	LEGACY SPORTS	LEGACY INT	SHOTGUN	12GA	[empty string]	4064	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	2-NIB	[empty string]	0	150-to-200	0.00	[empty string]	Legacy Puma 12 Gauge 28" Barrel 3" \| Turkish Walnut & Blue/Black \| Pump Action	<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><ul><li>Metal Finish Blue/Black</li><li>Action Pump</li><li>Gauge 12 Gauge</li><li>Barrel Length 28</li><li>Overall Length Not Listed</li><li>Trigger N/A</li><li>Safety 2 Position</li><li>Capacity 4+1</li><li>Stock Material Wood</li><li>Drop Not Listed</li><li>Ignition Not Listed</li><li>Chamber 3"</li><li>Hand Right</li><li>Item Type Shotgun</li><li>Stock Color Turkish Walnut</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]	Y	199.99	199.99	[empty string]	11344-DEFAULT-s.jpg	[empty string]	1000	1000	FRPPA1228WS	64838	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUN	legacy-sports/legacy-puma-12-gauge-28-barrel-3-turkish-walnut-blue-black-pump-action-64838	FRPPA1228WS	0
2	[empty string]	HOWA/LEGACY SPORTS I	Howa/legacy Sports I	SHOOTING	Shooting>Accessories>Magazine	[empty string]	1	99.99	0	99.99	26927-DEFAULT-l.jpg	99.99	26927-DEFAULT-m.jpg	HOWA ATIK10R223REM BOX MAG	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	138	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Howa Legacy 10rd 223Rem 204Rug Rem700 Detachable Magazine Conversion Kits	<p>ATI MAG CONVERSION KITS by LEGACY SPORTS - REMINGTON M700 RIFLES</p><ul><li>-.223/.204</li><li>-10-round mag. conversion kit</li><li>-Includes replacement 1-pc. floor plate trigger guard housing & (1) black polymer mag.</li></ul>	[empty string]	N	99.99	99.99	[empty string]	26927-DEFAULT-s.jpg	[empty string]	1000	1000	ATIK10R223REM	107882	MAGAZINE	EMPTY	EMPTY	0	0	0	EMPTY	howa-legacy-sports-i/howa-legacy-10rd-223rem-204rug-rem700-detachable-magazine-conversion-kits-107882	ATIK10R223REM	0
3	[empty string]	HOWA/LEGACY SPORTS I	Howa/legacy Sports I	SHOOTING	Shooting>Accessories>Magazine	[empty string]	1	99.99	0	99.99	26928-DEFAULT-l.jpg	99.99	26928-DEFAULT-m.jpg	HOWA ATIK10R250REM BOX MAG	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	138	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Howa Legacy Sports Remington 700 .22-250 Rem Detachable Magazine Kit 10 Rounds	<p>Upgrade your Remington 700 to detachable magazine capability. Get faster reloads and shoot longer between reloads with the Ammo Boost Conversion Kit from Legacy Sports International. The one piece replacement floor plate and trigger guard housing is made from tough, durable polymer materials. The kit includes one black polymer 10 round magazine. Simple drop in installation can be completed in just a few minutes.</p><p><strong>Specifications and Features:</strong></p><ul><li>Legacy Sports ATIK10R250REM</li><li>Polymer construction</li><li>.22-250 Remington</li><li>Simple drop in installation</li><li>Includes 10 round magazine</li><li>Black</li></ul><p><strong>Fits:</strong></p><ul><li>Remington 700</li></ul>	[empty string]	N	99.99	99.99	[empty string]	26928-DEFAULT-s.jpg	[empty string]	1000	1000	ATIK10R250REM	107883	MAGAZINE	EMPTY	EMPTY	0	0	0	EMPTY	howa-legacy-sports-i/howa-legacy-sports-remington-700-22-250-rem-detachable-magazine-kit-10-rounds-107883	ATIK10R250REM	0
4	[empty string]	BIG ROCK SPORTS	Big Rock Sports	UNCATEGORIZED	Uncategorized	[empty string]	1	29.99	0	29.99	780-DEFAULT-l.jpg	29.99	780-DEFAULT-m.jpg	LUBRIMATIC30190 GREASE GUN	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1294	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Lubrimatic30190 Grease Gun	[empty string]	[empty string]	N	29.99	29.99	[empty string]	780-DEFAULT-s.jpg	[empty string]	1000	1000	30190	124511	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	big-rock-sports/lubrimatic30190-grease-gun-124511	30190	0
5	[empty string]	BIG ROCK SPORTS	Big Rock Sports	UNCATEGORIZED	Uncategorized	[empty string]	0	32.99	0	32.99	[empty string]	32.99	[empty string]	PPU PP2506P RIFLE AMMO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	25-06REM	[empty string]	1294	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Ppu Pp2506p Rifle Ammo	[empty string]	[empty string]	N	32.99	32.99	[empty string]	[empty string]	[empty string]	1000	1000	PP2506P	124556	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	big-rock-sports/ppu-pp2506p-rifle-ammo-124556	PP2506P	0
6	[empty string]	BIG ROCK SPORTS	Big Rock Sports	SHOOTING	Shooting>Ammo>Rifle	[empty string]	1	32.99	0	32.99	16228-DEFAULT-l.jpg	32.99	16228-DEFAULT-m.jpg	PPU PP2701 RIFLE AMMO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	270WIN	[empty string]	1294	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	10	25-to-50	0.00	[empty string]	PPU PP2701 Standard Rifle 270 Win 130 Gr 3060 Fps Soft Point	<ul><li>Caliber 270 Winchester</li><li>Bullet Type Soft Point (SP)</li><li>Bullet Weight 130 GR</li><li>Muzzle Energy 2703 ft lbs</li><li>Muzzle Velocity 3060 fps</li><li>Rounds Per Box 20</li><li>Boxes Per Case 10</li><li>Application Big Game</li><li>Casing Material Brass</li></ul><p><p>Many of our images are stock photos from the manufacturer and may not necessarily represent the actual item. Please read the title and description carefully before purchasing.</p><ul><li>You must be 18 to purchase long gun ammunition & 21 for hand gun ammunition.</li><li>We cannot accept returns on ammunition for safety reasons.</li><li>Make sure you use the correct ammunition in your gun.</li><li>Check your local laws and regulations before purchasing ammunition.</li><li>The purchaser is responsible for knowing his/her state laws and restrictions.</li><li>All ammunition is considered hazardous and will be shipped ground, contiguous 48 states only. A street address is required for delivery.</li></ul><p> </p><p><strong>WARNING: Cancer and Reproductive Harm</strong>: <a href="https://www.p65warnings.ca.gov" onclick="window.open(this.href);return false;" onkeypress="window.open(this.href);return false;">p65warnings.ca.gov</a></p></p>	[empty string]	N	32.99	32.99	[empty string]	16228-DEFAULT-s.jpg	[empty string]	1000	1000	PP2701	124558	RIFLE	EMPTY	EMPTY	0	0	0	EMPTY	big-rock-sports/ppu-pp2701-standard-rifle-270-win-130-gr-3060-fps-soft-point-124558	PP2701	0
7	[empty string]	BIG ROCK SPORTS	Big Rock Sports	SHOOTING	Shooting>Ammo>Rifle	[empty string]	1	32.99	1	29.99	16229-DEFAULT-l.jpg	32.99	16229-DEFAULT-m.jpg	PPU PP2702 RIFLE AMMO	N	[empty string]	[empty string]	[empty string]	RESTRICTION 2	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	270WIN	[empty string]	1294	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	PPU Standard Rifle .270 Winchester 150 Grain Soft Point Brass	<ul><li>Manufacturer: PPU</li><li>Cartridge: .270 Winchester</li><li>Number of Rounds: 20</li><li>Bullet Type: Soft Point (SP)</li><li>Bullet Weight: 150 grain</li><li>Cartridge Case Material: Brass</li><li>Muzzle Velocity: 2850 ft/s</li><li>Muzzle Energy: 2705 ft-lbs</li><li>Application: Large Game</li><li>Primer Style: Centerfire</li><li>Lead Free: No</li></ul><p><p>Many of our images are stock photos from the manufacturer and may not necessarily represent the actual item. Please read the title and description carefully before purchasing.</p><ul><li>You must be 18 to purchase long gun ammunition & 21 for hand gun ammunition.</li><li>We cannot accept returns on ammunition for safety reasons.</li><li>Make sure you use the correct ammunition in your gun.</li><li>Check your local laws and regulations before purchasing ammunition.</li><li>The purchaser is responsible for knowing his/her state laws and restrictions.</li><li>All ammunition is considered hazardous and will be shipped ground, contiguous 48 states only. A street address is required for delivery.</li></ul><p> </p><p><strong>WARNING: Cancer and Reproductive Harm</strong>: <a href="https://www.p65warnings.ca.gov" onclick="window.open(this.href);return false;" onkeypress="window.open(this.href);return false;">p65warnings.ca.gov</a></p></p>	[empty string]	Y	29.99	29.99	[empty string]	16229-DEFAULT-s.jpg	[empty string]	1000	1000	PP2702	124559	RIFLE	EMPTY	EMPTY	0	0	0	EMPTY	big-rock-sports/ppu-standard-rifle-270-winchester-150-grain-soft-point-brass-124559	PP2702	0
8	[empty string]	BIG ROCK SPORTS	Big Rock Sports	SHOOTING	Shooting>Ammo>Rifle	[empty string]	1	24.99	0	24.99	7113-DEFAULT-l.jpg	24.99	7113-DEFAULT-m.jpg	PPU PP300BH RIFLE AMMO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1294	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	10	20-to-25	0.00	[empty string]	PPU 300 AAC Blackout/Whisper 7.62x35mm 125 Grain HPBT \| 20 Rounds	<p>Prvi Partizan PP300BH: PPU's Standard line of rifle ammunition is designed especially for big game hunting. Only the best quality components are used during production to ensure that these cartridges are accurate, dependable, and effective. This 300 Blackout features a hollow point boat tail bullet and comes packaged 20 rounds per box.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>SKU PP300BH</li><li>License Requirement None</li><li>Manufacturer Prvi Partizan</li><li>Mfg. Part Number PP300BH</li><li>UPC 8605003812432</li><li>Caliber/Gauge .300 Blackout</li><li>Number of Rounds 20</li><li>Ammo Rounds 1-50</li><li>Rounds per Box 20</li><li>Ammo Casing Brass</li><li>Price Per Round 0.8806</li><li>Ammo Application General Use</li><li>Ammo Features Boat Tail, Hollow Point</li><li>Ammo Shot Type Not Specified</li><li>Bullet Type Hollow Point Boat Tail</li><li>Muzzle Energy 1340 ft lbs</li><li>Muzzle Velocity 2198 fps</li></ul><p><p>Many of our images are stock photos from the manufacturer and may not necessarily represent the actual item. Please read the title and description carefully before purchasing.</p><ul><li>You must be 18 to purchase long gun ammunition & 21 for hand gun ammunition.</li><li>We cannot accept returns on ammunition for safety reasons.</li><li>Make sure you use the correct ammunition in your gun.</li><li>Check your local laws and regulations before purchasing ammunition.</li><li>The purchaser is responsible for knowing his/her state laws and restrictions.</li><li>All ammunition is considered hazardous and will be shipped ground, contiguous 48 states only. A street address is required for delivery.</li></ul><p> </p><p><strong>WARNING: Cancer and Reproductive Harm</strong>: <a href="https://www.p65warnings.ca.gov" onclick="window.open(this.href);return false;" onkeypress="window.open(this.href);return false;">p65warnings.ca.gov</a></p></p>	[empty string]	N	24.99	24.99	[empty string]	7113-DEFAULT-s.jpg	[empty string]	1000	1000	PP300BH	124563	RIFLE	EMPTY	EMPTY	0	0	0	EMPTY	big-rock-sports/ppu-300-aac-blackout-whisper-7-62x35mm-125-grain-hpbt-20-rounds-124563	PP300BH	0
9	[empty string]	BIG ROCK SPORTS	Big Rock Sports	UNCATEGORIZED	Uncategorized	[empty string]	0	23.99	0	23.99	[empty string]	23.99	[empty string]	PPU PP6M RIFLE AMMO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1294	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	20-to-25	0.00	[empty string]	Ppu Pp6m Rifle Ammo	[empty string]	[empty string]	N	23.99	23.99	[empty string]	[empty string]	[empty string]	1000	1000	PP6M	124567	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	big-rock-sports/ppu-pp6m-rifle-ammo-124567	PP6M	0
10	[empty string]	BIG ROCK SPORTS	Big Rock Sports	SHOOTING	Shooting>Ammo>Rifle	[empty string]	1	21.99	0	21.99	7101-DEFAULT-l.jpg	21.99	7101-DEFAULT-m.jpg	PPU PPM7 RIFLE AMMO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1294	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	20-to-25	0.00	[empty string]	PPU Match 7.62x54mmR 182 Grain FMJ \| 20 Rounds	<p><strong>DESCRIPTION:</strong></p><p>Prvi Partizan PPM7: PPU's Match line ammunition is designed for precise shooting at both short and long ranges. Its exceptional accuracy is the result of special production and control processes which demand holding very narrow tolerances. It uses reliable primers for extreme consistency and carefully chosen powders for loading, ensuring uniform ballistics. This 7.62x54R load features a 182 GR full metal jacket bullet and comes packaged 20 rounds per box.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>SKU PPM7</li><li>License Requirement None</li><li>Manufacturer Prvi Partizan</li><li>Mfg. Part Number PPM7</li><li>UPC 8605003812173</li><li>Caliber/Gauge 7.62x54R</li><li>Number of Rounds 20</li><li>Ammo Rounds 1-50</li><li>Rounds per Box 20</li><li>Ammo Casing Brass</li><li>Price Per Round 0.8594</li><li>Ammo Application General Use</li><li>Ammo Features Full Metal Jacket</li><li>Ammo Shot Type Not Specified</li><li>Bullet Type Full Metal Jacket</li><li>Muzzle Energy 2784 ft lbs</li><li>Muzzle Velocity 2626 fps</li></ul><p><p>Many of our images are stock photos from the manufacturer and may not necessarily represent the actual item. Please read the title and description carefully before purchasing.</p><ul><li>You must be 18 to purchase long gun ammunition & 21 for hand gun ammunition.</li><li>We cannot accept returns on ammunition for safety reasons.</li><li>Make sure you use the correct ammunition in your gun.</li><li>Check your local laws and regulations before purchasing ammunition.</li><li>The purchaser is responsible for knowing his/her state laws and restrictions.</li><li>All ammunition is considered hazardous and will be shipped ground, contiguous 48 states only. A street address is required for delivery.</li></ul><p> </p><p><strong>WARNING: Cancer and Reproductive Harm</strong>: <a href="https://www.p65warnings.ca.gov" onclick="window.open(this.href);return false;" onkeypress="window.open(this.href);return false;">p65warnings.ca.gov</a></p></p>	[empty string]	N	21.99	21.99	[empty string]	7101-DEFAULT-s.jpg	[empty string]	1000	1000	PPM7	124577	RIFLE	EMPTY	EMPTY	0	0	0	EMPTY	big-rock-sports/ppu-match-7-62x54mmr-182-grain-fmj-20-rounds-124577	PPM7	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc