Jay's 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	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	UPC	URL	VENDOR_INTEGRATE_ID
1	[empty string]	CALDWELL	Caldwell	FIREARMS	Firearms>Reloading>Reloading Accessories	[empty string]	1	204.99	0	204.99	46974-DEFAULT-l.jpg	204.99	46974-DEFAULT-m.jpg	BALLISTIC PRECISION CHRONOGRAPH PREMIUM	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2014	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	4	200-to-250	0.00	[empty string]	Ballistic Precision Chronograph Premium Kit	FEATURES:<BR/> -Caldwell Ballistic Precision Chronograph Premium Kit Contains everything you need to capture reliable velocity data in one convenient kit.<BR/> -Includes Chronograph, IR LED Light Kit, Tripod and Custom Carry Case that conveniently holds all items.<BR/> -The Ballistic Precision Chronograph provides accurate velocity measurements across a wide range of shooting conditions. Higher accuracy was achieved by using a high speed 48 MHz processor and by designing a circuit with an advanced data interface that allows each unit to be computer calibrated at the factory after assembly. The end result is the ability to provide much better accuracy than other chronographs on the market (+/- .25%).<BR/> -Although technologically advanced, the unit is designed to be simple to operate, displaying velocity in Feet per second or Meters per second on the large built in LCD screen. The Chrono can also deliver the shot string velocity data through the 15` foot audio jack cable (included) to an iPhone or iPad.<BR/> -A free App is available for download that displays the velocity of each shot on the phone screen and records it with other data identifying the load and environmental conditions. The App also automatically calculates Average Velocity, Standard Deviation, Min, Max and Velocity Spread for the shot string. The data is stored and can be exported via Email or simply recalled for reference at a later date.<BR/> -The sunshades are extra wide for better reliability on sunny days and are constructed of a durable synthetic material. Measures from 5 to 9,999 FPS. There is a 1/4-20 threaded insert on bottom of housing for tripod mounting, operates on a 9 Volt battery (not included).<BR/> -Each unit factory calibrated to within +/- 0.25% accuracy Ideal for Firearms, Archery, Airgun and Paintball Simple operation, large LCD screen Meters Per Second (MPS) or Feet Per Second (FPS) readings Extra wide sun screens for added shading in full sun operation Option to interfa	[empty string]	N	204.99	204.99	[empty string]	46974-DEFAULT-s.jpg	[empty string]	1000	721122	178059	RELOADING ACCESSORIES	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	caldwell/ballistic-precision-chronograph-premium-178059	1
2	[empty string]	CALDWELL	Caldwell	FIREARMS	Firearms>Reloading>Reloading Accessories	[empty string]	0	123.99	0	123.99	[empty string]	123.99	[empty string]	BALLISTIC PRECISION CHRONOGRAPH	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2014	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Ballistic Precision Chronograph	<p>FEATURES:<br /> -The Ballistic Precision Chronograph provides accurate velocity measurements across a wide range of shooting conditions.<br /> -Higher accuracy was achieved by using a high speed 48 MHz processor and by designing a circuit with an advanced data interface that allows each unit to be computer calibrated at the factory after assembly.<br /> -Although technologically advanced, the unit is designed to be simple to operate, displaying velocity in Feet per second or Meters per second on the large built in LCD screen.<br /> -The Chrono can also deliver the shot string velocity data through the 15` foot audio jack cable (included) to an iPhone or iPad.<br /> -A free App is available for download that displays the velocity of each shot on the phone screen and records it with other data identifying the load and environmental conditions. The App also automatically calculates Average Velocity, Standard Deviation, Min, Max and Velocity Spread for the shot string. The data is stored and can be exported via Email or simply recalled for reference at a later date.<br /> -The sunshades are extra wide for better reliability on sunny days and are constructed of a durable synthetic material. Measures from 5 to 9,999 FPS. There is a 1/4-20 threaded insert on bottom of housing for tripod mounting, operates on a 9 Volt battery (not included).</p>	[empty string]	N	123.99	123.99	[empty string]	[empty string]	[empty string]	1000	720001	178062	RELOADING ACCESSORIES	EMPTY	EMPTY	0	0	0	RELOADING	[empty string]	caldwell/ballistic-precision-chronograph-178062	1
3	[empty string]	CALDWELL	Caldwell	FIREARMS	Firearms>Slings	[empty string]	0	22.99	0	22.99	[empty string]	22.99	[empty string]	MAX GRIP SLIM SLING BLACK	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	21	20-to-25	0.00	[empty string]	Max Grip Slim Sling	<p>The Caldwell Max Grip Slim Sling is adjustable from 20" to 41" for full comfort out on the range or the trails. The non-slip ergonomic design is sure to keep your firearm secure while you're out in the wilderness. With quick detach metal sling swivels, the Max Grip Slim Sling is the easiest and quickest way to keep your firearm secure.</p>	[empty string]	N	22.99	22.99	[empty string]	[empty string]	[empty string]	1000	1131995	347328	EMPTY	EMPTY	EMPTY	0	0	0	SLINGS	[empty string]	caldwell/max-grip-slim-sling-347328	1
4	[empty string]	CALDWELL	Caldwell	FIREARMS	Firearms>Slings	[empty string]	0	22.99	0	22.99	[empty string]	22.99	[empty string]	MAX GRIP SLING BLACK	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	27	20-to-25	0.00	[empty string]	Max Grip Sling	<p>The Caldwell Max Grip Sling’s ergonomic shape is designed to spread the weight of the firearm for a comfortable carry. The over molded design of the material grips your shoulder so the firearm stays put no matter how strenuous your hike is. The sling is completely sealed to be scent free and not take in any moisture as you hunt through all of the elements. If you want a sling that is going to stay put and be comfortable to carry all day, the Caldwell Max Grip is the sling for you!</p>	[empty string]	N	22.99	22.99	[empty string]	[empty string]	[empty string]	1000	156219	358429	EMPTY	EMPTY	EMPTY	0	0	0	SLINGS	[empty string]	caldwell/max-grip-sling-358429	1
5	[empty string]	CALDWELL	Caldwell	FIREARMS	Firearms>Targets and Throwers	[empty string]	1	99.99	0	99.99	103813-DEFAULT-l.jpg	99.99	103813-DEFAULT-m.jpg	AR500 33% PEPPER POPPER TARGET	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	AR500 33% PEPPER POPPER AUTO RESET TARGET	<p>Add some fun interactive targets to your range with these Caldwell AR500 Auto Resetting Targets. Constructed using AR500, the finest rifle rated target steel available on the market. Each target includes a free-standing frame, popper, or prairie dog shape AR500 target and ground stakes. The base of the frame sits 7-Inches off the ground. When the target is struck with a bullet it falls backward and is automatically reset with the integrated reset spring. For maximum life expectancy impact velocities of 3,000 fps or below and impact energies of 3,500 ft. lbs. or less are recommended.</p>	[empty string]	N	99.99	99.99	[empty string]	103813-DEFAULT-s.jpg	[empty string]	1000	1178560	385859	EMPTY	EMPTY	EMPTY	0	0	0	TARGETS AND THROWERS	[empty string]	caldwell/ar500-33-pepper-popper-auto-reset-target-385859	1
6	[empty string]	CALDWELL	Caldwell	FIREARMS	Firearms>Targets and Throwers	[empty string]	1	109.99	0	109.99	103814-DEFAULT-l.jpg	109.99	103814-DEFAULT-m.jpg	AR500 PRAIRIE DOG POPPER TARGET CP=2	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	100-to-150	0.00	[empty string]	AR500 PRAIRIE DOG AUTO RESET TARGET	<p>Add some fun interactive targets to your range with these Caldwell AR500 Auto Resetting Targets. Constructed using AR500, the finest rifle rated target steel available on the market. Each target includes a free-standing frame, popper, or prairie dog shape AR500 target and ground stakes. The base of the frame sits 7-Inches off the ground. When the target is struck with a bullet it falls backward and is automatically reset with theintegrated reset spring. For maximum life expectancy impact velocities of 3,000 fps or below and impact energies of 3,500 ft. lbs. or less are recommended.</p>	[empty string]	N	109.99	109.99	[empty string]	103814-DEFAULT-s.jpg	[empty string]	1000	1178561	385860	EMPTY	EMPTY	EMPTY	0	0	0	TARGETS AND THROWERS	[empty string]	caldwell/ar500-prairie-dog-auto-reset-target-385860	1
7	[empty string]	CALDWELL	Caldwell	FIREARMS	Firearms>Targets and Throwers	[empty string]	1	79.99	0	79.99	103816-DEFAULT-l.jpg	79.99	103816-DEFAULT-m.jpg	AR500 TARGET POST	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	AR500 Target Post	<p>The Caldwell AR500 Target Post is the strongest target hanger on the market. Constructed using the same 3/8"" AR500 rifle rated steel as our targets, capable of withstanding thousands of rounds. Compact 2-piece design for easy transportation with a replaceable AR500 hook that works with all targets with a 1/2"" x 1"" slot. Assembled length of 70"" supports targets up to 50 lbs.</p> <p> </p> <ul> <li><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="font-size:10.0pt"><span style="color:#2c2c2c">Ar500 construction can withstand impacts from centerfire rifles</span></span></span></span></span></li> <li><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="font-size:10.0pt"><span style="color:#2c2c2c">Spike-leg design creates for quick and easy set up</span></span></span></span></span></li> <li><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="font-size:10.0pt"><span style="color:#2c2c2c">2 piece design for transportation and storage</span></span></span></span></span></li> </ul>	[empty string]	N	79.99	79.99	[empty string]	103816-DEFAULT-s.jpg	[empty string]	1000	4001137	385861	EMPTY	EMPTY	EMPTY	0	0	0	TARGETS AND THROWERS	[empty string]	caldwell/ar500-target-post-385861	1
8	[empty string]	CALDWELL	Caldwell	FIREARMS	Firearms>Targets and Throwers	[empty string]	1	29.99	0	29.99	103817-DEFAULT-l.jpg	29.99	103817-DEFAULT-m.jpg	SHEPHERD`S HOOK STEEL TARGET HOLDER	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Shepherd’s Hook Steel Target Hanger	<p>The Caldwell Shepherd's Hook Target Hanger is a quick and easy target hanging solution for any range. A nylon reinforced rubber strap means these hangers won't fatigue with extended shooting like traditional wire shepherd's hooks. This extremely durable stand comes in at 45 inches tall and can hold targets up to 16 pounds, equivalent to the Caldwell 13" AR500 Octagon Target. Upgrade your range with the Caldwell Shepherd's Hook.</p>	[empty string]	N	29.99	29.99	[empty string]	103817-DEFAULT-s.jpg	[empty string]	1000	3002281	385862	EMPTY	EMPTY	EMPTY	0	0	0	TARGETS AND THROWERS	[empty string]	caldwell/shepherd-s-hook-steel-target-hanger-385862	1
9	[empty string]	CALDWELL	Caldwell	FIREARMS	Firearms>Targets and Throwers	[empty string]	1	49.99	0	49.99	103820-DEFAULT-l.jpg	49.99	103820-DEFAULT-m.jpg	ULTIMATE STEEL TARGET STAND	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	Ultimate Steel Target Stand	<p>Ultimate Steel Target Stand can be used to set both steel and paper targets on almost any range. The H-stand design allows flexibility in target setup without driving posts or stakes into the ground. The angled center 2x4 pocket can be combined with the Caldwell 2x4 Plate Hanger (sold separately) to hang any Caldwell AR500 steel, including full size IPSC targets on any 2x4 post.The 1x2 stake pockets are perfect for setting up paper or cardboard targets at any distance. Comes with 2 ground stakes.</p> <p> </p> <ul> <li><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="font-size:10.0pt"><span style="color:#2c2c2c">Dual purpose design holds 1x2 or 2x4 for both steel and paper target use</span></span></span></span></span></li> <li><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="font-size:10.0pt"><span style="color:#2c2c2c">Angled 2x4 holds up to full-size ipsc target without falling over</span></span></span></span></span></li> <li><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="font-size:10.0pt"><span style="color:#2c2c2c">1x2 stake pockets for common paper/cardboard targets</span></span></span></span></span></li> </ul> <p> </p>	[empty string]	N	49.99	49.99	[empty string]	103820-DEFAULT-s.jpg	[empty string]	1000	4001148	385864	EMPTY	EMPTY	EMPTY	0	0	0	TARGETS AND THROWERS	[empty string]	caldwell/ultimate-steel-target-stand-385864	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter