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	685	0	745	1468-DEFAULT-l.jpg	685	1468-DEFAULT-m.jpg	T-BOLT 22LR RIFLE	N	11 JJ	22 LR	22IN	[empty string]	[empty string]	[empty string]	[empty string]	BROWNING ARMS	MIROKU	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	BOLT	RIFLE	2	500-or-more	0.00	[empty string]	T-bolt Sporter - 22 L.r. - 22`` Bbl - Polished Blued	<p>SPECIFICATIONS:<br /> -Item Number: 025175202<br /> -UPC: 023614252733<br /> -Caliber: 22 LR<br /> -Barrel Length: 22``<br /> -Overall Length: 40 1/8``<br /> -Length of Pull: 13 1/2``<br /> -Drop at Comb: 5/8``<br /> -Drop at Heel: 5/8``<br /> -Weight: 4 lbs 14 oz<br /> -Magazine Capacity: 10<br /> -Twist Rate: 16``<br /> -Barrel Finish: Polished Blued<br /> -Stock Finish: Satin<br /> -Wood Grade: Grade I<br /> -Receiver Finish: Polished Blued<br /> -Chamber Finish: Polished<br /> -Barrel Material: Steel<br /> -Barrel Contour: Sporter<br /> -Stock Material: Black Walnut<br /> -Recoil Pad: Plastic Buttplate<br /> -Checkering: Cut 20 LPI<br /> -Sling Swivel Studs: Gloss Blued<br /> -Receiver Material: Steel<br /> -Trigger Finish: Gold Plated<br /> -Trigger Guard Finish: Matte<br /> -Bolt Slide Finish: Brushed Polish<br /> -Magazine Type: Double Helix<br /> -Trigger Material: Alloy<br /> -Trigger Guard Material: Composite<br /> -Drilled and Tapped for Scope: Yes. Scope and ring mounts are not included.<br /> <br /> -NOTE: SCOPE AND SCOPE MOUNTS ARE NOT INCLUDED</p>	[empty string]	N	745	745	[empty string]	1468-DEFAULT-s.jpg	[empty string]	1000	025175202	10050	BOLT ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	browning/t-bolt-22lr-rifle-10050	1
2	[empty string]	BROWNING	Browning	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	1	880	0	999	1530-DEFAULT-l.jpg	880	1530-DEFAULT-m.jpg	X BOLT HUNTER 243 WIN BOLT RIFLE	N	11 JJ	243 WIN	22IN	[empty string]	[empty string]	[empty string]	[empty string]	BROWNING ARMS	MIROKU	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	BOLT	RIFLE	2	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
3	[empty string]	BROWNING	Browning	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	1	880	0	999	1539-DEFAULT-l.jpg	880	1539-DEFAULT-m.jpg	X-BOLT HUNTER 30-06 SPRG BOLT RIFLE	N	11 JJ	30-06 SPRG	22IN	[empty string]	[empty string]	[empty string]	[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 - 30-06 Sprg - Matte Blued	<p>SPECIFICATIONS:<br /> -Item Numbe: 035208226<br /> -UPC: 023614258087<br /> -Action Length: Long Action<br /> -Caliber: 30-06 Spfld<br /> -Barrel Length: 22``<br /> -Overall Length: 42 3/4``<br /> -Length of Pull: 13 5/8``<br /> -Drop at Comb: 11/16``<br /> -Drop at Heel: 1/2``<br /> -Weight: 6 lbs 14 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 /> -NOTE: SCOPE AND MOUNTS ARE NOT INCLUDED.</p>	[empty string]	N	999	999	[empty string]	1539-DEFAULT-s.jpg	[empty string]	1000	035208226	81727	BOLT ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	browning/x-bolt-hunter-30-06-sprg-bolt-rifle-81727	1
4	[empty string]	BROWNING	Browning	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	1	915	0	1050	1542-DEFAULT-l.jpg	915	1542-DEFAULT-m.jpg	X-BOLT 300 WIN MAG BOLT RIFLE	N	11 JJ	300 WIN MAG	26IN	[empty string]	[empty string]	[empty string]	[empty string]	BROWNING ARMS	MIROKU	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	BOLT	RIFLE	2	500-or-more	0.00	[empty string]	X-bolt Hunter - 300 Win Mag - Matte Blued - Satin Finish Walnut	SPECIFICATIONS:<BR/> -Model: X-Bolt Hunter, SCOPE IS NOT INCLUDED<br/> -Item Number: 035208229<br/> -UPC: 023614258100<br/> -Action Length: Long Action<br/> -Caliber: 300 Win Mag<br/> -Barrel Length: 26``<br/> -Overall Length: 46 3/4``<br/> -Length of Pull: 13 5/8``<br/> -Drop at Comb: 11/16``<br/> -Drop at Heel: 1/2``<br/> -Weight: 7 lbs 0 oz<br/> -Magazine Capacity: 3<br/> -Twist Rate: 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/> -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/> -NOTE: SCOPE IS NOT INCLUDED<BR/>	[empty string]	N	1050	1050	[empty string]	1542-DEFAULT-s.jpg	[empty string]	1000	035208229	83192	BOLT ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	browning/x-bolt-300-win-mag-bolt-rifle-83192	1
5	[empty string]	BROWNING	Browning	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	1	880	0	999	1569-DEFAULT-l.jpg	880	1569-DEFAULT-m.jpg	X-BOLT HUNT 308WIN BOLT RIFLE	N	11 JJ	308 WIN	22IN	[empty string]	[empty string]	[empty string]	[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
6	[empty string]	BROWNING	Browning	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	1	880	0	999	1575-DEFAULT-l.jpg	880	1575-DEFAULT-m.jpg	X-BOLT HUNT 7MM08	N	11 JJ	7MM-08 REM	22IN	[empty string]	[empty string]	[empty string]	[empty string]	BROWNING ARMS	MIROKU	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	BOLT	RIFLE	1	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
7	[empty string]	BROWNING	Browning	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	1	550	0	640	70334-DEFAULT-l.jpg	550	70334-DEFAULT-m.jpg	BRO A-BOLT III MICRO 243WIN 22IN	N	11 JJ	243 WIN	20IN	[empty string]	[empty string]	[empty string]	[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]	Ab3 Micro Stalker - 243 Win - 20`` Bbl - Blued	SPECIFICATIONS:<BR/> -Model: Browning AB3 Micro Stalker<BR/> -Item Number: 035808211<BR/> -UPC: 023614439158<BR/> -Action Length: Short Action<BR/> -Caliber: 243 Win<BR/> -Barrel Length: 20``<BR/> -Overall Length: 39 3/8``<BR/> -Length of Pull: 13``<BR/> -Drop at Comb: 11/16``<BR/> -Drop at Heel: 1/2``<BR/> -Weight: 6 lbs 8 oz<BR/> -Magazine Capacity: 5<BR/> -Twist Rate: 10``<BR/> -Barrel Finish: Matte Blued<BR/> -Stock Finish: Matte Black<BR/> -Receiver Finish: Matte Blued<BR/> -Chamber Finish: Polished<BR/> -Barrel Material: Steel<BR/> -Barrel Contour: Sporter<BR/> -Stock Material: Composite<BR/> -Recoil Pad: Polymer<BR/> -Pistol Grip Cap: None<BR/> -Checkering: Textured Grip Panels<BR/> -Receiver Material: Steel<BR/> -Trigger Finish: Matte Blued<BR/> -Bolt Slide Finish: Chrome<BR/> -Magazine Type: Detachable<BR/> -Trigger Material: Composite<BR/> -Trigger Guard Material: Composite<BR/> -Trigger Guard Engraving: None<BR/> -Drilled and Tapped for Scope: Yes<BR/> <br/> NOTE: SCOPE AND SCOPE MOUNTS ARE NOT INCLUDED.<BR/>	[empty string]	N	640	640	[empty string]	70334-DEFAULT-s.jpg	[empty string]	1000	035808211	276220	BOLT ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	browning/bro-a-bolt-iii-micro-243win-22in-276220	1
8	[empty string]	BROWNING	Browning	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	1	830	0	940	84910-DEFAULT-l.jpg	830	84910-DEFAULT-m.jpg	X-BOLT 243WIN COMP STALKER RIFLE	N	11 JJ	243 WIN	22IN	[empty string]	[empty string]	[empty string]	[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
9	[empty string]	BROWNING	Browning	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	1	995	0	1040	95571-DEFAULT-l.jpg	995	95571-DEFAULT-m.jpg	X-BOLT PREDHNT ATACAU 223REM MB RIFLE	N	11 JJ	223 REM	22IN	[empty string]	[empty string]	[empty string]	[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 Predator Hunter - 223 Reb - A-tacs Au - Elite Sand Cerakote	<p> SPECIFICAITONS: </p> <p>-Model: Browning X-Bolt Predator Hunter</p> <p>-Item Number: 035479208</p> <p>-Caliber: 223 Rem</p> <p>-Stock Finish: A-TACS AU</p> <p>-Action: Bolt</p> <p>-Sights: None, Drilled and Tapped</p> <p>-Capacity: 5+1</p> <p>-Muzzle: Muzzle Break</p> <p>-Drop: 11/16" @ Comb and 1/5" @ Heel</p> <p>-Hand: Right</p> <p>-LOP: 13.63"</p> <p>-Barrel Length: 22"</p> <p>-OAL: 41.50"</p> <p>-Receiver Finish: Elite Sand Cerakote</p> <p>-Receiver material: Steel</p> <p>-Safety: Tang</p> <p>-Stock Material: Synthetic</p> <p>-Thread Pattern: 1/2"-28 tpi</p> <p>-Trigger: Gold Plated</p> <p>-Twist: 1:8"</p> <p>-Weight: 6.00 lbs</p> <p>-Barrel Description: Heavy Sporter</p> <p>-Barrel Finish: Elite Sand Cerakote</p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p>	[empty string]	N	1040	1040	[empty string]	95571-DEFAULT-s.jpg	[empty string]	1000	035479208	328114	BOLT ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	browning/x-bolt-predhnt-atacau-223rem-mb-rifle-328114	1
10	[empty string]	BROWNING	Browning	FIREARMS	Firearms>Rifles>Bolt Action	[empty string]	0	995	0	1040	[empty string]	995	[empty string]	X-BOLT PREDHNT ATACAU 204RUG MB RIFLE	N	11 JJ	204 RUGER	22IN	[empty string]	[empty string]	[empty string]	[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 Predhnt Atacau 204rug Mb Rifle	[empty string]	[empty string]	N	1040	1040	[empty string]	[empty string]	[empty string]	1000	035479274	337666	BOLT ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	browning/x-bolt-predhnt-atacau-204rug-mb-rifle-337666	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts382 ORDER BY sortposition asc

Firearms

Sort By:

Items per page:

Filter By

Filter

Browning
T- Bolt Sporter - 22 L.R.- 22 `` Bbl - Polished Blued
Item # 025175202 $745.00
Browning
X- Bolt Hunter - 243 Win - Matte Blued - Satin
Item # 035208211 $999.00
Browning
X- Bolt Hunter - 30- 06 Sprg - Matte Blued
Item # 035208226 $999.00
Browning
X- Bolt Hunter - 300 Win Mag - Matte Blued - Satin Finish Walnut
Item # 035208229 $1,050.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
Ab3 Micro Stalker - 243 Win - 20 `` Bbl - Blued
Item # 035808211 $640.00
Browning
X- Bolt 243win Comp Stalker Rifle
Item # 035496211 $940.00
Browning
X- Bolt Predator Hunter - 223 Reb - A- Tacs Au - Elite Sand Cerakote
Item # 035479208 $1,040.00
Browning
X- Bolt Predhnt Atacau 204rug Mb Rifle
Item # 035479274 $1,040.00

Filter By

Price

Brand

T- Bolt Sporter - 22 L.R.- 22 `` Bbl - Polished Blued

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

X- Bolt Hunter - 30- 06 Sprg - Matte Blued

X- Bolt Hunter - 300 Win Mag - Matte Blued - Satin Finish Walnut

X- Bolt Hunter - 308 Win - Matte Blued

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

Ab3 Micro Stalker - 243 Win - 20 `` Bbl - Blued

X- Bolt 243win Comp Stalker Rifle

X- Bolt Predator Hunter - 223 Reb - A- Tacs Au - Elite Sand Cerakote

X- Bolt Predhnt Atacau 204rug Mb Rifle