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]	REMINGTON AMMO	Remington Ammo	SHOOTING	Shooting>Ammo>Rifle	[empty string]	1	62.99	0	62.99	6271-DEFAULT-l.jpg	62.99	6271-DEFAULT-m.jpg	REMINGTON CORELOKT 220 SWIFT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	220SW	[empty string]	256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Remington Core-Lokt .220 Swift 50 Grain PSP \| 20 Rounds	<p>High Performance Rifle series consists of a multitude of calibers and popular bullet styles to match your specialized hunting and shooting pursuits. All assembled with premium components and the ultra-tight tolerances that put more home reloading presses on the back shelf than any other brand. Remington High Performance Rifle.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Remington Ammunition</li><li>Category Centerfire Rifle Rounds</li><li>Caliber 220 Swift</li><li>Model High Performance</li><li>Bullet Weight 50 gr</li><li>Rounds Per Box 20</li><li>Casing Material Brass</li><li>Application Hunting</li><li>Boxes Per Case 10</li><li>Bullet Type Pointed Soft Point (PSP)</li><li>Muzzle Energy 1586 ft lbs</li><li>Muzzle Velocity 3780 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	62.99	62.99	[empty string]	6271-DEFAULT-s.jpg	[empty string]	1000	1000	R220S1	153624	RIFLE	EMPTY	EMPTY	0	0	0	EMPTY	remington-ammo/remington-core-lokt-220-swift-50-grain-psp-20-rounds-153624	R220S1	0
2	[empty string]	REMINGTON AMMO	Remington Ammo	SHOOTING	Shooting>Ammo>Rifle	[empty string]	1	34.99	0	34.99	17139-DEFAULT-l.jpg	34.99	17139-DEFAULT-m.jpg	REMINGTON HP 55GR PSP	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	22-250	[empty string]	256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	Remington High Performance Core-Lokt 22-250 Remington 55 Grain PSP \| 20 Rounds	<p>Assembled with premium components honed to ultra-tight tolerances, Remington's High-Performance Rifle series more than lives up to its name. In the field, forest, or at the range, there's a Remington High-Performance Rifle round tailor-made to match any pursuit and honor Remington's proud heritage of innovative rifle ammunition.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Remington Ammunition</li><li>Category Centerfire Rifle Rounds</li><li>Caliber 22-250 Rem</li><li>Model High Performance</li><li>Rounds Per Box 20</li><li>Casing Material Brass</li><li>Muzzle Energy 1654 ft lbs</li><li>Muzzle Velocity 3680 fps</li><li>Game Type Small Game</li><li>Application Hunting</li><li>Boxes Per Case 10</li><li>Bullet Type Pointed Soft Point (PSP)</li><li>Bullet Weight 55 gr</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	34.99	34.99	[empty string]	17139-DEFAULT-s.jpg	[empty string]	1000	1000	R22501	153628	RIFLE	EMPTY	EMPTY	0	0	0	EMPTY	remington-ammo/remington-high-performance-core-lokt-22-250-remington-55-grain-psp-20-rounds-153628	R22501	0
3	[empty string]	REMINGTON AMMO	Remington Ammo	SHOOTING	Shooting>Ammo>Rifle	[empty string]	1	29.99	0	34.99	6605-DEFAULT-l.jpg	29.99	6605-DEFAULT-m.jpg	REMINGTON CORELOKT 243 WIN	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	243WIN	[empty string]	256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	99	25-to-50	0.00	[empty string]	Remington Core-Lokt 243 Winchester 100 Grain JSP \| 20 Rounds	<p>The Core-Lokt bullet design is the original controlled expansion bullet, and one of the most effective ever developed. Its progressively tapered copper jacket is locked to a solid lead core, promoting perfectly controlled expansion and high weight retention for absolutely dependable on game results. You'll find its time proven performance in both soft point and pointed soft point versions, and in a range of bullet weights for virtually every centerfire hunting caliber made.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Remington Ammunition</li><li>Category Centerfire Rifle Rounds</li><li>Caliber 243 Win</li><li>Model Core-Lokt</li><li>Bullet Weight 100 gr</li><li>Rounds Per Box 20</li><li>Casing Material Brass</li><li>Application Hunting</li><li>Boxes Per Case 10</li><li>Bullet Type Core-Lokt Pointed Soft Point (PSPCL)</li><li>Muzzle Energy 1945 ft lbs</li><li>Muzzle Velocity 2960 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	34.99	34.99	[empty string]	6605-DEFAULT-s.jpg	[empty string]	1000	1000	R243W3	153633	RIFLE	EMPTY	EMPTY	0	0	0	EMPTY	remington-ammo/remington-core-lokt-243-winchester-100-grain-jsp-20-rounds-153633	R243W3	0
4	[empty string]	REMINGTON AMMO	Remington Ammo	SHOOTING	Shooting>Ammo>Rifle	[empty string]	1	44.99	0	44.99	17141-DEFAULT-l.jpg	44.99	17141-DEFAULT-m.jpg	REMINGTON CORELOKT 25-06 REM	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	25-06REM	[empty string]	256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	46	25-to-50	0.00	[empty string]	Remington Core-Lokt 25-06 Remington 100 Grain PSP \| 20 Rounds	<p>Since 1939, more hunters have relied on Remington Core-Lokt than any other big game ammunition. Core-Lokt is the original controlled expansion bullet. Its time-proven performance has made it hunting's first choice for over 75 years. The tapered copper jacket is locked to a solid lead core delivering massive 2X expansion, weight retention, and consistent on-game results. Trust your next hunt to the best-selling hunting ammunition of all time.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Remington Ammunition</li><li>Category Centerfire Rifle Rounds</li><li>Caliber 25-06 Rem</li><li>Model Core-Lokt</li><li>Rounds Per Box 20</li><li>Casing Material Brass</li><li>Muzzle Energy 2316 ft lbs</li><li>Muzzle Velocity 3230 fps</li><li>Game Type Big Game</li><li>Application Hunting</li><li>Boxes Per Case 10</li><li>Bullet Type Pointed Soft Point Core-Lokt (PSPCL)</li><li>Bullet Weight 100 gr</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	44.99	44.99	[empty string]	17141-DEFAULT-s.jpg	[empty string]	1000	1000	R25062	153634	RIFLE	EMPTY	EMPTY	0	0	0	EMPTY	remington-ammo/remington-core-lokt-25-06-remington-100-grain-psp-20-rounds-153634	R25062	0
5	[empty string]	REMINGTON AMMO	Remington Ammo	SHOOTING	Shooting>Ammo>Rifle	[empty string]	1	49.99	1	44.99	26104-DEFAULT-l.jpg	49.99	26104-DEFAULT-m.jpg	REMINGTON CLOKT 25-06 REM 120G	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	25-06REM	[empty string]	256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Remington Core-Lokt 25-06 Remington 120 Grain PSP \| 20 Rounds	<p>The Core-Lokt bullet design is the original controlled expansion bullet, and one of the most effective ever developed. Its progressively tapered copper jacket is locked to a solid lead core, promoting perfectly controlled expansion and high weight retention for absolutely dependable on game results. You'll find its time proven performance in both soft point and pointed soft point versions, and in a range of bullet weights for virtually every centerfire hunting caliber made.</p><p><strong>SPECIFICATIONS</strong></p><ul><li>Manufacturer Remington</li><li>Pricing Unit BX</li><li>Model Core-Lokt</li><li>UPC 047700052205</li><li>SKU 21515</li><li>Width 3.6000</li><li>Length 5.9000</li><li>Height 1.5000</li><li>Weight 1.1500</li><li>Caliber 25-06 Rem</li><li>Bullet Weight 120 GR</li><li>Application Hunting</li><li>Bullet Type Core-Lokt Pointed Soft Point (PSPCL)</li><li>Muzzle Velocity 2990 fps</li><li>Rounds Per Box 20</li><li>Series Pointed Soft Point</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	44.99	44.99	[empty string]	26104-DEFAULT-s.jpg	[empty string]	1000	1000	R25063	153635	RIFLE	EMPTY	EMPTY	0	0	0	EMPTY	remington-ammo/remington-core-lokt-25-06-remington-120-grain-psp-20-rounds-153635	R25063	0
6	[empty string]	REMINGTON AMMO	Remington Ammo	SHOOTING	Shooting>Ammo>Rifle	[empty string]	1	69.99	0	69.99	10687-DEFAULT-l.jpg	69.99	10687-DEFAULT-m.jpg	REMINGTON CORELOKT 264 WIN	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	306	50-to-100	0.00	[empty string]	Remington Core-Lokt 264 Winchester Magnum 140 Grain PSP \| 20 Rounds	<p>The Core-Lokt bullet design is the original controlled expansion bullet, and one of the most effective ever developed. Its progressively tapered copper jacket is locked to a solid lead core, promoting perfectly controlled expansion and high weight retention for absolutely dependable on game results. You'll find its time proven performance in both soft point and pointed soft point versions, and in a range of bullet weights for virtually every centerfire hunting caliber made.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Remington Ammunition</li><li>Category Centerfire Rifle Rounds</li><li>Caliber 264 Win Mag</li><li>Model Core-Lokt</li><li>Bullet Weight 140 gr</li><li>Rounds Per Box 20</li><li>Casing Material Brass</li><li>Application Hunting</li><li>Boxes Per Case 10</li><li>Bullet Type Pointed Soft Point (PSP)</li><li>Muzzle Energy 2854 ft lbs</li><li>Muzzle Velocity 3030 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	69.99	69.99	[empty string]	10687-DEFAULT-s.jpg	[empty string]	1000	1000	R264W2	153640	RIFLE	EMPTY	EMPTY	0	0	0	EMPTY	remington-ammo/remington-core-lokt-264-winchester-magnum-140-grain-psp-20-rounds-153640	R264W2	0
7	[empty string]	REMINGTON AMMO	Remington Ammo	SHOOTING	Shooting>Ammo>Rifle	[empty string]	1	32.99	0	34.99	6804-DEFAULT-l.jpg	32.99	6804-DEFAULT-m.jpg	REMINGTON CLOKT 270WIN 130GR	N	[empty string]	[empty string]	[empty string]	RESTRICTION 2	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	270WIN	[empty string]	256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	220	25-to-50	0.00	[empty string]	Remington Core-Lokt .270 Winchester 130 Grain PSP \| 20 Rounds	<p>The Core-Lokt bullet design is the original controlled expansion bullet, and one of the most effective ever developed. Its progressively tapered copper jacket is locked to a solid lead core, promoting perfectly controlled expansion and high weight retention for absolutely dependable on game results. You'll find its time proven performance in both soft point and pointed soft point versions, and in a range of bullet weights for virtually every centerfire hunting caliber made.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Remington Ammunition</li><li>Category Centerfire Rifle Rounds</li><li>Caliber 270 Win</li><li>Model Core-Lokt</li><li>Bullet Weight 130 gr</li><li>Rounds Per Box 20</li><li>Casing Material Brass</li><li>Application Hunting</li><li>Boxes Per Case 10</li><li>Bullet Type Core-Lokt Pointed Soft Point (PSPCL)</li><li>Muzzle Energy 2702 ft lbs</li><li>Muzzle Velocity 3060 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	34.99	34.99	[empty string]	6804-DEFAULT-s.jpg	[empty string]	1000	1000	R270W2	153641	RIFLE	EMPTY	EMPTY	0	0	0	EMPTY	remington-ammo/remington-core-lokt-270-winchester-130-grain-psp-20-rounds-153641	R270W2	0
8	[empty string]	REMINGTON AMMO	Remington Ammo	SHOOTING	Shooting>Ammo>Rifle	[empty string]	1	30.99	0	34.99	17142-DEFAULT-l.jpg	30.99	17142-DEFAULT-m.jpg	REMINGTON CORELOKT 270WIN 150	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	270WIN	[empty string]	256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	179	25-to-50	0.00	[empty string]	Remington Core-Lokt 270 Winchester 150 Grain SP \| 20 Rounds	<p>Progressively tapered copper jacket is locked to a solid lead core promoting controlled expansion and high weight retention.</p><table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Quantity Case</td><td>10</td></tr><tr><td>Bullet Weight</td><td>150 gr.</td></tr><tr><td>Made In The USA</td><td>Made In The USA</td></tr><tr><td>Caliber</td><td>.270 Win.</td></tr><tr><td>Quantity per Box</td><td>20</td></tr><tr><td>Caliber-Gauge</td><td>.270 WIN.</td></tr><tr><td>Bullet Style</td><td>SP Core-Lokt</td></tr><tr><td>Manufacturer Part Number</td><td>27810</td></tr></table><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	34.99	34.99	[empty string]	17142-DEFAULT-s.jpg	[empty string]	1000	1000	R270W4	153642	RIFLE	EMPTY	EMPTY	0	0	0	EMPTY	remington-ammo/remington-core-lokt-270-winchester-150-grain-sp-20-rounds-153642	R270W4	0
9	[empty string]	REMINGTON AMMO	Remington Ammo	SHOOTING	Shooting>Ammo>Rifle	[empty string]	1	64.99	1	54.9	6805-DEFAULT-l.jpg	64.99	6805-DEFAULT-m.jpg	REMINGTON CLOKT 280 REM 150GR	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	280	[empty string]	256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	29	50-to-100	0.00	[empty string]	Remington Core-Lokt .280 Remington 150 Grain PSP \| 20 Rounds	<p>Progressively tapered copper jacket is locked to a solid lead core promoting controlled expansion and high weight retention.</p><table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Quantity Case</td><td>10</td></tr><tr><td>Bullet Weight</td><td>150 gr.</td></tr><tr><td>Made In The USA</td><td>Made In The USA</td></tr><tr><td>Caliber</td><td>.280 Rem.</td></tr><tr><td>Quantity per Box</td><td>20</td></tr><tr><td>Caliber-Gauge</td><td>.280 REM.</td></tr><tr><td>Bullet Style</td><td>PSP Core-Lokt</td></tr><tr><td>Manufacturer Part Number</td><td>29069 </td></tr></table>	[empty string]	Y	54.9	54.9	[empty string]	6805-DEFAULT-s.jpg	[empty string]	1000	1000	R280R1	153644	RIFLE	EMPTY	EMPTY	0	0	0	EMPTY	remington-ammo/remington-core-lokt-280-remington-150-grain-psp-20-rounds-153644	R280R1	0
10	[empty string]	REMINGTON AMMO	Remington Ammo	SHOOTING	Shooting>Ammo>Rifle	[empty string]	1	40.99	0	49.99	6806-DEFAULT-l.jpg	40.99	6806-DEFAULT-m.jpg	REMINGTON CORELOKT 280 REM 165	N	[empty string]	[empty string]	[empty string]	RESTRICTION 2	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	280	[empty string]	256	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	68	25-to-50	0.00	[empty string]	Remington Core-Lokt .280 Remington 165 Grain SP \| 20 Rounds	<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><ul><li>Brand Remington Ammunition</li><li>Category Centerfire Rifle Rounds</li><li>Caliber 280 Rem</li><li>Model Core-Lokt</li><li>Rounds Per Box 20</li><li>Casing Material Brass</li><li>Muzzle Energy 2913 ft lbs</li><li>Muzzle Velocity 2820 fps</li><li>Game Type Big Game</li><li>Application Hunting</li><li>Boxes Per Case 10</li><li>Bullet Type Soft Point Core-Lokt (SPCL)</li><li>Bullet Weight 165 gr</li></ul>	[empty string]	N	49.99	49.99	[empty string]	6806-DEFAULT-s.jpg	[empty string]	1000	1000	R280R2	153645	RIFLE	EMPTY	EMPTY	0	0	0	EMPTY	remington-ammo/remington-core-lokt-280-remington-165-grain-sp-20-rounds-153645	R280R2	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 ( 1=2 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