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]	HSM	Hsm	SHOOTING	Shooting	[empty string]	1	39.99	0	39.99	19457-DEFAULT-l.jpg	39.99	19457-DEFAULT-m.jpg	HSM 24322N AMMO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	243WIN	[empty string]	4028	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	18	25-to-50	0.00	[empty string]	HSM Ammunition .243 Winchester 95 Grain Jacketed Soft Point Hornady SST Rifle Ammunition	<ul><li>Manufacturer: HSM Ammunition</li><li>Cartridge: .243 Winchester</li><li>Number of Rounds: 20</li><li>Bullet Type: Jacketed Soft Point (JSP)</li><li>Bullet Weight: 95 grain</li><li>Application: Hunting</li><li>Package Type: Box</li><li>Included Accessories: None</li></ul><p><br /><strong>Features of HSM Ammunition .243 Winchester 95 Grain Jacketed Soft Point Hornady SST Rifle Ammunition</strong></p><ul><li>Superformance Propellants are the heart of Superformance ammunition and usher in a new era of performance</li><li>Like all Hornady ammunition, the Superformance rounds use the highest quality cases and primers available. Consistent components translate to consistent shooting in the field</li><li>100 to 200 fps faster than conventional ammunition</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	39.99	39.99	[empty string]	19457-DEFAULT-s.jpg	[empty string]	1000	1000	24322N	108065	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hsm/hsm-ammunition-243-winchester-95-grain-jacketed-soft-point-hornady-sst-rifle-ammunition-108065	24322N	0
2	[empty string]	HSM	Hsm	SHOOTING	Shooting	[empty string]	1	54.99	0	54.99	17996-DEFAULT-l.jpg	54.99	17996-DEFAULT-m.jpg	HSM AMMO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	270WIN	[empty string]	4028	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	26	50-to-100	0.00	[empty string]	HSM 27014N Low Recoil 270 Win 130 gr 2318 fps Orange Polymer Tip 20 Bx/20 Cs	<ul><li>Brand HSM</li><li>Category Centerfire Rifle Rounds</li><li>Caliber 270 Win</li><li>Model Low Recoil</li><li>Rounds Per Box 20</li><li>Casing Material Brass</li><li>Muzzle Energy 1551 ft lbs</li><li>Muzzle Velocity 2318 fps</li><li>Game Type Medium</li><li>Application Hunting</li><li>Boxes Per Case 20</li><li>Bullet Type Orange Polymer Tip</li><li>Bullet Weight 130 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	54.99	54.99	[empty string]	17996-DEFAULT-s.jpg	[empty string]	1000	1000	27014N	108069	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hsm/hsm-27014n-low-recoil-270-win-130-gr-2318-fps-orange-polymer-tip-20-bx-20-cs-108069	27014N	0
3	[empty string]	HSM	Hsm	SHOOTING	Shooting	[empty string]	1	44.99	0	44.99	21124-DEFAULT-l.jpg	44.99	21124-DEFAULT-m.jpg	HSM 27019N AMMO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	270WIN	[empty string]	4028	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	HSM 270 Cal 150 gr Hornady SST 20 Bx /20 Cs	<p>Designed to deliver tremendous shock on impact while expanding quickly and reliably, particularly at higher velocities. Flat shooting and deadly accurate, it's an ideal bullet for whitetails, as well as most North American game animals from antelope to moose and similar-sized African plains game. The SST creates a devastatingly large wound channel.</p><ul><li>Brand HSM</li><li>Category Centerfire Rifle Rounds</li><li>Caliber 270 Cal</li><li>Rounds Per Box 20</li><li>Game Type Medium</li><li>Application Hunting</li><li>Boxes Per Case 20</li><li>Bullet Type Hornady SST</li><li>Bullet Weight 150 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]	21124-DEFAULT-s.jpg	[empty string]	1000	1000	27019N	108072	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hsm/hsm-270-cal-150-gr-hornady-sst-20-bx-20-cs-108072	27019N	0
4	[empty string]	HSM	Hsm	SHOOTING	Shooting	[empty string]	1	48.99	0	48.99	18028-DEFAULT-l.jpg	48.99	18028-DEFAULT-m.jpg	HSM 2702N AMMO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	270WIN	[empty string]	4028	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	27	25-to-50	0.00	[empty string]	HSM Ammunition .270 150 Grain Soft Point (SP) 20/20 Centerfire Rifle Ammunition	<ul><li>Caliber 270 Win</li><li>Bullet Type Soft Point (SP)</li><li>Bullet Weight 150 gr</li><li>Boxes Per Case 20</li><li>Rounds Per Box 20</li><li>Casing Material Brass</li><li>Unit Of Measure box</li></ul><p> </p><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	48.99	48.99	[empty string]	18028-DEFAULT-s.jpg	[empty string]	1000	1000	2702N	108073	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hsm/hsm-ammunition-270-150-grain-soft-point-sp-20-20-centerfire-rifle-ammunition-108073	2702N	0
5	[empty string]	HSM	Hsm	SHOOTING	Shooting	[empty string]	1	44.99	0	44.99	21123-DEFAULT-l.jpg	44.99	21123-DEFAULT-m.jpg	HSM 300646N AMMO	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	30-06	[empty string]	4028	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	HSM Tipping Point 30-06 Cal 165 gr Hornady SST 20 Bx/20 Cs	<ul><li>Brand HSM</li><li>Category Centerfire Rifle Rounds</li><li>Model Tipping Point</li><li>Caliber 30-06 Cal</li><li>Rounds Per Box 20</li><li>Casing Material Brass</li><li>Game Type Medium</li><li>Application Hunting</li><li>Boxes Per Case 20</li><li>Bullet Type Hornady SST</li><li>Bullet Weight 165 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]	21123-DEFAULT-s.jpg	[empty string]	1000	1000	300646N	108078	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hsm/hsm-tipping-point-30-06-cal-165-gr-hornady-sst-20-bx-20-cs-108078	300646N	0
6	[empty string]	HSM	Hsm	SHOOTING	Shooting	[empty string]	1	39.99	0	39.99	27418-DEFAULT-l.jpg	39.99	27418-DEFAULT-m.jpg	HSM 454C4N20 BEAR LOAD 454	N	[empty string]	[empty string]	[empty string]	RESTRICTION 2	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	454CAS	[empty string]	4028	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	HSM .454 Casull Ammunition 20 Rounds WFN HCGC 325 Grains	<p>Hunting Shack Munitions is a Montana based ammunition manufacturer that has been providing some of the finest ammunition to shooters, hunters, law enforcement agencies and military units for over 40 years! HSM was founded in 1968 and has grown to become one of the leading manufacturers of specialized ammunition products in the country. Made in the USA, and proud to be Veteran owned and operated.</p><p>When headed out for your next hike or hunting trip, make sure you stay vigilant in the remote wilderness where danger appears in the blink of an eye! Take HSM's best selling back country defense and hunting load, the Bear Load. These heavy caliber hard cast lead bullets are matched to temperature stable powders and primers for reliable performance when you need it most. You can expect hard hitting precision from these expertly crafted loads built with the best components and years of experience. HSM Ammo offers you the right load, for taking game, or defending yourself from game that wants to take you. Don't do without the very best ammo for the job. Make sure you have Hunting Shack Inc in your pack!</p><ul><li>Hunting Shack Munitions Bear Load HSM-454C-4-N20</li><li>.454 Casull</li><li>325 Grain</li><li>Wide Flat Nose</li><li>Hard Cast Lead</li><li>Gas Check</li><li>Reloadable brass case</li><li>Muzzle velocity 1330 fps</li><li>Muzzle energy 1277 ft/lbs</li><li>Use for handgun hunting, large game, and defense</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	39.99	39.99	[empty string]	27418-DEFAULT-s.jpg	[empty string]	1000	1000	454C4N20	108100	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hsm/hsm-454-casull-ammunition-20-rounds-wfn-hcgc-325-grains-108100	454C4N20	0
7	[empty string]	HSM	Hsm	SHOOTING	Shooting	[empty string]	1	69.99	0	69.99	17997-DEFAULT-l.jpg	69.99	17997-DEFAULT-m.jpg	HSM BEAR LOAD	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	458SOCOM	[empty string]	4028	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	7	50-to-100	0.00	[empty string]	HSM Bear Load 458 SOCOM 350 gr Jacketed Flat Point (JFP)	<ul><li>Manufacturer Hsm</li><li>Pricing Unit BX</li><li>Model Bear Load</li><li>UPC 810742027049</li><li>SKU 458SOCOM1N</li><li>Width 3.1000</li><li>Length 6.4000</li><li>Height 1.5000</li><li>Weight 1.8000</li><li>Caliber 458 SOCOM</li><li>Bullet Weight 350 GR</li><li>Application Hunting,Target</li><li>Bullet Type Jacketed Flat Point (JFP)</li><li>Dimension 1.45 X 3.25 X 14.90</li><li>Rounds Per Box 20</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]	17997-DEFAULT-s.jpg	[empty string]	1000	1000	458SOCOM1N	108103	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hsm/hsm-bear-load-458-socom-350-gr-jacketed-flat-point-jfp-108103	458SOCOM1N	0
8	[empty string]	HSM	Hsm	SHOOTING	Shooting	[empty string]	1	69.99	0	69.99	27504-DEFAULT-l.jpg	69.99	27504-DEFAULT-m.jpg	HSM AMMO	N	[empty string]	[empty string]	[empty string]	RESTRICTION 2	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	460S&W	[empty string]	4028	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	13	50-to-100	0.00	[empty string]	HSM .460 S&W Mag 325 Grain Bear Ammo	<p>When traveling through bear country, it's always best to leave nothing to chance. HSM's Bear Load consistently delivers simply incredible terminal performance on even the biggest, angriest and most aggressive North American animals when it matters most. Technologically advanced powders push the premium, hard-cast bullets at significantly higher velocities for terminal energy superior to standard loads.</p><p><strong>Specifications and Features:</strong></p><ul><li>.460 S&W Magnum</li><li>Wide flat nose bullets</li><li>325 Grain bullet weight</li><li>2402 ft-lbs Muzzle energy</li><li>1824 FPS</li><li>Large game</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]	27504-DEFAULT-s.jpg	[empty string]	1000	1000	460SW4N	108106	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hsm/hsm-460-s-w-mag-325-grain-bear-ammo-108106	460SW4N	0
9	[empty string]	HSM	Hsm	SHOOTING	Shooting	[empty string]	1	70.99	0	70.99	11875-DEFAULT-l.jpg	70.99	11875-DEFAULT-m.jpg	HSM 65CM250VLDL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6.5CREEDMOOR	[empty string]	4028	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	HSM Trophy Gold 6.5 Creedmoor 140 Grain Berger Match Hunt VLD \| 20 Rounds	<ul><li>Manufacturer Hsm</li><li>Pricing Unit BX</li><li>Model Trophy Gold</li><li>UPC 810742028534</li><li>SKU 65CREEDMOOR140VLDL</li><li>Width 3.1000</li><li>Length 6.1000</li><li>Height 1.5000</li><li>Weight 1.1450</li><li>Caliber 6.5 Creedmoor</li><li>Bullet Type Jacketed Hollow 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]	N	70.99	70.99	[empty string]	11875-DEFAULT-s.jpg	[empty string]	1000	1000	65CM250VLDL	108110	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	hsm/hsm-trophy-gold-6-5-creedmoor-140-grain-berger-match-hunt-vld-20-rounds-108110	65CM250VLDL	0
10	[empty string]	DEAD RINGER	Dead Ringer	SHOOTING	Shooting	[empty string]	1	124.99	0	124.99	5266-DEFAULT-l.jpg	124.99	5266-DEFAULT-m.jpg	DEAD RINGER DR4357 GUN SIGHT	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	4094	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Dead Ringer Sight \| S&W M&P \| Green \| DR4357	<p>Dead Ringer DR4357 Snake Eyes S&W M&P Front/Rear Tritium Night Grn/Grn - When faced with self-defense or close quarters situations, it is paramount that one be able to acquire the target as quickly as possible. Snake Eyes' design lends itself to the natural shooting position, while allowing quick target acquisition with minimal learning curve. Even in low-light conditions, the tritium front and rear sights glow continuously. Additionally, Snake Eyes are manufactured with 100% military grade metals, making it both durable and reliable. Product features white paint on the front sight only. Rear sight is a press fit application and should be done by a professional gunsmith to avoid potential harm to slide or sight.</p>	[empty string]	N	124.99	124.99	[empty string]	5266-DEFAULT-s.jpg	[empty string]	1000	1000	DR4357	132048	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	dead-ringer/dead-ringer-sight-s-w-m-p-green-dr4357-132048	DR4357	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 ltrim(rtrim(dept)) = ? and ltrim(rtrim(typ)) = 'EMPTY' AND ( 1=2 OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? 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

array
1	Shooting
2	%cooper%
3	%techna%clip%
4	%easton%arrows%
5	%vsharp%
6	%hsm%
7	%weatherby%inc%
8	%dead%ringer%
9	%lbe%unlimited%

Filter By

Sort By

Item # DR4357 $124.99

0 Reviews

Sign in

Shooting

Shooting

Availability

Brand

PRICE

Caliber

Hsm Ammunition .243 Winchester 95 Grain Jacketed Soft Point Hornady Sst Rifle Ammunition

Hsm 27014n Low Recoil 270 Win 130 Gr 2318 Fps Orange Polymer Tip 20 Bx/20 Cs

Hsm 270 Cal 150 Gr Hornady Sst 20 Bx/20 Cs

Hsm Ammunition .270 150 Grain Soft Point (Sp) 20/20 Centerfire Rifle Ammunition

Hsm Tipping Point 30- 06 Cal 165 Gr Hornady Sst 20 Bx/20 Cs

Hsm .454 Casull Ammunition 20 Rounds Wfn Hcgc 325 Grains

Hsm Bear Load 458 Socom 350 Gr Jacketed Flat Point (Jfp)

Hsm .460 S & W Mag 325 Grain Bear Ammo

Hsm Trophy Gold 6.5 Creedmoor 140 Grain Berger Match Hunt Vld | 20 Rounds

Dead Ringer Sight | S & W M & P | Green | Dr4357

Store Information

Shop

Our Company

Guest Help

Are you over 18?

Please make a selection:

Sign up

Shooting

Shooting

Availability

Brand

PRICE

Caliber

Hsm Ammunition .243 Winchester 95 Grain Jacketed Soft Point Hornady Sst Rifle Ammunition

Hsm 27014n Low Recoil 270 Win 130 Gr 2318 Fps Orange Polymer Tip 20 Bx/20 Cs

Hsm 270 Cal 150 Gr Hornady Sst 20 Bx/20 Cs

Hsm Ammunition .270 150 Grain Soft Point (Sp) 20/20 Centerfire Rifle Ammunition

Hsm Tipping Point 30- 06 Cal 165 Gr Hornady Sst 20 Bx/20 Cs

Hsm .454 Casull Ammunition 20 Rounds Wfn Hcgc 325 Grains

Hsm Bear Load 458 Socom 350 Gr Jacketed Flat Point (Jfp)

Hsm .460 S & W Mag 325 Grain Bear Ammo

Hsm Trophy Gold 6.5 Creedmoor 140 Grain Berger Match Hunt Vld | 20 Rounds

Dead Ringer Sight | S & W M & P | Green | Dr4357