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]	BROWNING	Browning	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	1	999	0	999	1530-DEFAULT-l.jpg	999	1530-DEFAULT-m.jpg	X BOLT HUNTER 243 WIN BOLT RIFLE	N	11 JJ	243 WIN	22IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	BROWNING ARMS	MIROKU	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	BOLT	RIFLE	1	500-or-more	0.00	[empty string]	X-bolt Hunter - 243 Win - Matte Blued - Satin	<p>SPECIFICATIONS:<br /> -Item Number: 035208211<br /> -UPC: 023614257998<br /> -Action Length: Short Action<br /> -Caliber: 243 Win<br /> -Barrel Length: 22``<br /> -Overall Length: 42``<br /> -Length of Pull: 13 5/8``<br /> -Drop at Comb: 11/16``<br /> -Drop at Heel: 1/2``<br /> -Weight: 6 lbs 8 oz<br /> -Magazine Capacity: 4<br /> -Twist Rate: 1 in 10``<br /> -Barrel Finish: Matte Blued<br /> -Stock Finish: Satin<br /> -Wood Grade: Grade I<br /> -Receiver Finish: Matte Blued<br /> -Chamber Finish: Polished<br /> -Barrel Material: Steel<br /> -Barrel Contour: Sporter<br /> -Stock Material: Black Walnut<br /> -Recoil Pad: Inflex 1, Small<br /> -Checkering: Cut 18 LPI<br /> -Sling Swivel Studs: Matte Blued<br /> -Receiver Material: Steel<br /> -Trigger Finish: Gold Plated<br /> -Trigger Guard Finish: Matte Black<br /> -Bolt Slide Finish: High Gloss<br /> -Magazine Type: Detachable<br /> -Trigger Material: Alloy<br /> -Trigger Guard Material: Alloy<br /> -Trigger Guard Engraving: Buck Mark in Gold<br /> -Floor Plate Material: Composite<br /> -Drilled and Tapped for Scope: Yes<br /> <br /> <br /> NOTE: SCOPE AND RING MOUNTS ARE NOT INCLUDED.</p>	[empty string]	N	999	999	[empty string]	1530-DEFAULT-s.jpg	[empty string]	1000	035208211	10181	BOLT ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	browning/x-bolt-hunter-243-win-bolt-rifle-10181	1
2	[empty string]	BROWNING	Browning	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	1	999	0	999	1569-DEFAULT-l.jpg	999	1569-DEFAULT-m.jpg	X-BOLT HUNT 308WIN BOLT RIFLE	N	11 JJ	308 WIN	22IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	BROWNING ARMS	MIROKU	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	BOLT	RIFLE	1	500-or-more	0.00	[empty string]	X-bolt Hunter - 308 Win - Matte Blued	<p>SPECIFICATIONS:<br /> -Item Number: 035208218<br /> -UPC 023614258001<br /> -Action Length: Short Action<br /> -Caliber: 308 Win<br /> -Barrel Length: 22``<br /> -Overall Length: 42``<br /> -Length of Pull: 13 5/8``<br /> -Drop at Comb: 11/16``<br /> -Drop at Heel: 1/2``<br /> -Weight: 6 lbs 8 oz<br /> -Magazine Capacity: 4<br /> -Twist Rate: 12``<br /> -Barrel Finish: Matte Blued<br /> -Stock Finish: Satin<br /> -Wood Grade: Grade I<br /> -Receiver Finish: Matte Blued<br /> -Chamber Finish: Polished<br /> -Barrel Material Steel<br /> -Barrel Contour: Sporter<br /> -Stock Material: Black Walnut<br /> -Recoil Pad: Inflex 1, Small<br /> -Pistol Grip Cap: None<br /> -Checkering: Cut 18 LPI<br /> -Sling Swivel Studs: Matte Blued<br /> -Receiver Material: Steel<br /> -Trigger Finish: Gold Plated<br /> -Bolt Slide Finish High Gloss<br /> -Magazine Type: Detachable<br /> -Trigger Material: Alloy<br /> -Trigger Guard Material: Alloy<br /> -Trigger Guard Engraving: Buck Mark in Gold<br /> -Floor Plate Material: Composite<br /> -Drilled and Tapped for Scope: Yes<br /> <br /> -NOTE: SCOPE AND SCOPE MOUNTS ARE NOT INCLUDED</p>	[empty string]	N	999	999	[empty string]	1569-DEFAULT-s.jpg	[empty string]	1000	035208218	86734	BOLT ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	browning/x-bolt-hunt-308win-bolt-rifle-86734	1
3	[empty string]	BROWNING	Browning	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	1	999	0	999	1575-DEFAULT-l.jpg	999	1575-DEFAULT-m.jpg	X-BOLT HUNT 7MM08	N	11 JJ	7MM-08 REM	22IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	BROWNING ARMS	MIROKU	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	BOLT	RIFLE	3	500-or-more	0.00	[empty string]	X-bolt Hunter - 7mm-08 Rem - Matte Blued - Satin Black Walnut	<p>SPECIFICATIONS:</p> <p>-Model: Browning X-Bolt Hunter</p> <p>-Item Number: 035208216<br /> <br /> <i><font size=`1`> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i></p>	[empty string]	N	999	999	[empty string]	1575-DEFAULT-s.jpg	[empty string]	1000	035208216	87452	BOLT ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	browning/x-bolt-hunt-7mm08-87452	1
4	[empty string]	BROWNING	Browning	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	1	1550	0	1550	55648-DEFAULT-l.jpg	1550	55648-DEFAULT-m.jpg	BROWNING X-BOLT WHITE GOLD 270WIN BOLT	N	11 JJ	270 WIN	22IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	BROWNING ARMS	MIROKU	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	BOLT	RIFLE	1	500-or-more	0.00	[empty string]	X Bolt White Gold - 270 Win - Stainless	<p>SPECIFICATIONS:<br /> -Item Number: 035235224<br /> -UPC: 023614067351<br /> -Action Length: Long Action<br /> -Caliber: 270 Win<br /> -Barrel Length: 22``<br /> -Overall Length: 42 3/4``<br /> -Length of Pull: 13 5/8``<br /> -Drop at Comb: 3/4``<br /> -Drop at Heel: 1 7/16``<br /> -Weight: 6 lbs 12 oz<br /> -Magazine Capacity: 4<br /> -Twist Rate: 1 in 10``<br /> -Barrel Finish: Satin<br /> -Stock Finish: Gloss<br /> -Wood Grade: Grade IV/V<br /> -Receiver Finish: Satin<br /> -Chamber Finish: Polished<br /> -Barrel Material: Stainless<br /> -Barrel Contour: Sporter<br /> -Stock Material: Black Walnut<br /> -Recoil Pad: Inflex 1, Small<br /> -Pistol Grip Cap: Rosewood<br /> -Checkering: Cut 18 LPI<br /> -Sling Swivel Studs: Nickel<br /> -Forend Cap: Rosewood<br /> -Receiver Material: Stainless<br /> -Trigger Finish: Gold Plated<br /> -Trigger Guard Finish: Polished Sliver<br /> -Bolt Slide Finish: High Gloss<br /> -Magazine Type: Detachable<br /> -Trigger Material: Alloy<br /> -Trigger Guard Material: Alloy<br /> -Trigger Guard Engraving: Buck Mark in Gold<br /> -Receiver Engraving: Roll<br /> -Floor Plate Material: Composite<br /> -Drilled and Tapped for Scope: Yes<br /> <br /> NOTE: SCOPE AND SCOPE MOUNTS ARE NOT INCLUDED</p>	[empty string]	N	1550	1550	[empty string]	55648-DEFAULT-s.jpg	[empty string]	1000	035235224	158734	BOLT ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	browning/browning-x-bolt-white-gold-270win-bolt-158734	1
5	[empty string]	BROWNING	Browning	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	1	940	0	940	84910-DEFAULT-l.jpg	940	84910-DEFAULT-m.jpg	X-BOLT 243WIN COMP STALKER RIFLE	N	11 JJ	243 WIN	22IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	BROWNING ARMS	MIROKU	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	1	500-or-more	0.00	[empty string]	X-bolt 243win Comp Stalker Rifle	[empty string]	[empty string]	N	940	940	[empty string]	84910-DEFAULT-s.jpg	[empty string]	1000	035496211	323570	BOLT ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	browning/x-bolt-243win-comp-stalker-rifle-323570	1
6	[empty string]	MOSSBERG	MOSSBERG	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	1	470	0	470	99389-DEFAULT-l.jpg	470	99389-DEFAULT-m.jpg	PATRIOT 6.5 CREEDMOOR SPORT FLTD RIFLE BOLT	N	11 JJ	6.5 CREEDMOOR	22IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	MOSSBERG	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	1	450-to-500	0.00	[empty string]	Patriot 6.5 Creedmoor Sport Fltd Rifle Bolt	[empty string]	[empty string]	N	470	470	[empty string]	99389-DEFAULT-s.jpg	[empty string]	1000	28153	372660	BOLT ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	mossberg/patriot-6-5-creedmoor-sport-fltd-rifle-bolt-372660	1
7	[empty string]	RUGER	RUGER	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	1	610	0	610	99636-DEFAULT-l.jpg	610	99636-DEFAULT-m.jpg	RUG AMERICAN B BRONZE 16` 350 LEGEND BOLT	N	11 JJ	350 LEGEND	16IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	RUGER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	2	500-or-more	0.00	[empty string]	AMERICAN RANCH RIFLE - 350 LEGEND - BURNT BRONZE CERAKOTE - BLACK SYNTHETIC	<p>Item: Ruger American Ranch Rifle</p> <p>Item Number: 26990</p> <p>Caliber: 350 Legend</p> <p>Barrel Length: 16.38"</p> <p>Overall Length: 36"</p> <p>Stock: Black Synthetic</p> <p>Finish: Burnt Bronze Cerakote</p> <p>Capacity: 5</p> <p>Twist: 1:16" RH</p> <p>Thread Pattern: 1/2"-28 x 0.4"</p> <p>LOP: 13.75"</p> <p>Grooves: 5</p> <p>Weight: 6.1 lb</p> <p> </p>	[empty string]	N	610	610	[empty string]	99636-DEFAULT-s.jpg	[empty string]	1000	26990	377874	BOLT ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	ruger/american-ranch-rifle-350-legend-burnt-bronze-cerakote-black-synthetic-377874	1
8	[empty string]	WEATHERBY INC	WEATHERBY INC	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	1	895	0	895	99739-DEFAULT-l.jpg	895	99739-DEFAULT-m.jpg	VANGUARD LAM SPORTER 308WIN RIFLE BOLT	N	11 JJ	308 WIN	24IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	WEATHERBY	HOWA	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	1	500-or-more	0.00	[empty string]	VANGUARD LAMINATE SPORTER - 308 WIN - MATTE BLUED - BOYDS NUTMEG LAMINATE	<p>The Laminate Sporter builds on the classic platform of the sporter package with the addition of a high quality Boyds® laminate stock finished in beautiful nutmeg. Every Boyds gunstock is constructed of top-grade laminated hardwood that’s dried to exact specifications to ensure rigidity and stability. sealed with chemical-resistant finishes for longlasting durability in all weather conditions.</p> <ul> <li>Item: Weatherby Laminate Sporter</li> <li>Item Number: VLM308NR40</li> <li>Caliber: 308 Win</li> <li>Action: Bolt</li> <li>Barrel Length: 24"</li> <li>Capacity: 5+1</li> <li>All Vanguard rifles are guaranteed to shoot a 3-shot group of .99” or less at 100 yards (SUB-MOA) from a cold barrel when used with Weatherby factory or premium ammunition within Two-Years of Verified Purchase Date to Original Purchaser.</li> <li>Adjustable Match Quality, Two-stage Trigger</li> <li>Fluted Bolt Body</li> <li>One-piece Machined Bolt Body</li> <li>Fully Enclosed Bolt Sleeve</li> <li>Vanguard Recoil Pad</li> <li>3-Position Safety</li> <li>Cold Hammer Forged Barrel</li> <li>Integral Recoil Lug</li> <li>Monte Carlo stock features textured forearm and grip areas</li> <li>Boyds Nutmeg Laminate with Pachmayer Decelerator</li> <li>Matte Blued Cold Hammer Forged Barrel</li> <li>#2 contour barrel</li> </ul>	[empty string]	N	895	895	[empty string]	99739-DEFAULT-s.jpg	[empty string]	1000	VLM308NR40	378214	BOLT ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	weatherby-inc/vanguard-laminate-sporter-308-win-matte-blued-boyds-nutmeg-laminate-378214	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts382 ORDER BY sortposition asc

Firearms

Sort By:

Items per page:

Filter

Browning
X- Bolt Hunter - 243 Win - Matte Blued - Satin
Item # 035208211 $999.00
Browning
X- Bolt Hunter - 308 Win - Matte Blued
Item # 035208218 $999.00
Browning
X- Bolt Hunter - 7mm- 08 Rem - Matte Blued - Satin Black Walnut
Item # 035208216 $999.00
Browning
X Bolt White Gold - 270 Win - Stainless
Item # 035235224 $1,550.00
Browning
X- Bolt 243win Comp Stalker Rifle
Item # 035496211 $940.00
MOSSBERG
Patriot 6.5 Creedmoor Sport Fltd Rifle Bolt
Item # 28153 $470.00
RUGER
American Ranch Rifle - 350 Legend - Burnt Bronze Cerakote - Black Synthetic
Item # 26990 $610.00
WEATHERBY INC
Vanguard Laminate Sporter - 308 Win - Matte Blued - Boyds Nutmeg Laminate
Item # VLM308NR40 $895.00

Filter By

Price

Brand

X- Bolt Hunter - 243 Win - Matte Blued - Satin

X- Bolt Hunter - 308 Win - Matte Blued

X- Bolt Hunter - 7mm- 08 Rem - Matte Blued - Satin Black Walnut

X Bolt White Gold - 270 Win - Stainless

X- Bolt 243win Comp Stalker Rifle

Patriot 6.5 Creedmoor Sport Fltd Rifle Bolt

American Ranch Rifle - 350 Legend - Burnt Bronze Cerakote - Black Synthetic

Vanguard Laminate Sporter - 308 Win - Matte Blued - Boyds Nutmeg Laminate