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]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	1	655	0	655	99437-DEFAULT-l.jpg	655	99437-DEFAULT-m.jpg	700 ADL 300WIN MAG BOLT RIFLE	N	11 JJ	300 WIN MAG	26IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	4	500-or-more	0.00	[empty string]	700 ADL - 300 WIN MAG - 26" BBL - MATTE BLUED - BLACK SYNTHETIC	<ul> <li>Item: Remington 700 ADL</li> <li>Item Number: R27099</li> <li>Caliber: 300 Win Mag</li> <li>Action: Bolt</li> <li>Barrel Length: 26"</li> <li>OAL: 46.5"</li> <li>Capacity: 3</li> <li>Sights: None</li> <li>Barrel Finish: Matte Blued</li> <li>Stock: Black Synthetic</li> <li>Safety: 2 Position Thumb Safety</li> <li>Weight: 7 lbs 8 oz</li> </ul>	[empty string]	N	655	655	[empty string]	99437-DEFAULT-s.jpg	[empty string]	1000	R27099	354974	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/700-adl-300-win-mag-26-bbl-matte-blued-black-synthetic-354974	1
2	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	1	655	0	655	99438-DEFAULT-l.jpg	655	99438-DEFAULT-m.jpg	700 ADL 7MM MAG BOLT RIFLE	N	11 JJ	7MM REM MAG	26IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	REMINGTON	[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]	700 ADL - 7MM REM MAG - 26" BBL - MATTE BLUED - BLACK SYNTHETIC	[empty string]	[empty string]	N	655	655	[empty string]	99438-DEFAULT-s.jpg	[empty string]	1000	R27097	354975	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/700-adl-7mm-rem-mag-26-bbl-matte-blued-black-synthetic-354975	1
3	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	1	655	0	655	99545-DEFAULT-l.jpg	655	99545-DEFAULT-m.jpg	700 ADL 243WIN COMP BOLT RIFLE	N	11 JJ	243 WIN	20IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	4	500-or-more	0.00	[empty string]	700 ADL - 243 WIN - 20" BBL - MATTE BLUED - BLACK SYNTHETIC	<ul> <li>Item: Remington 700 ADL</li> <li>Item Number: R27092</li> <li>Caliber: 243 Win</li> <li>Action: Bolt</li> <li>Barrel Length: 20"</li> <li>OAL: 39.6"</li> <li>Capacity: 4</li> <li>Barrel Finish: Matte Blued</li> <li>Stock: Black Synthetic</li> <li>2 Position Thumb Safety</li> <li>Rate of Twist: 1 in 9 1/8</li> <li>Weight: 7 lbs 4 oz</li> </ul> <p> </p>	[empty string]	N	655	655	[empty string]	99545-DEFAULT-s.jpg	[empty string]	1000	R27092	354976	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/700-adl-243-win-20-bbl-matte-blued-black-synthetic-354976	1
4	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	1	655	0	655	99547-DEFAULT-l.jpg	655	99547-DEFAULT-m.jpg	700 ADL 6.5CM BOLT RIFLE	N	11 JJ	6.5 CREEDMOOR	24IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	8	500-or-more	0.00	[empty string]	700 ADL - 6.5 CREEDMOOR - 24" BBL - MATTE BLUED - BLACK SYNTHETIC	<ul> <li>Item: Remington 700 ADL</li> <li>Item Number: RE85447</li> <li>Caliber: 6.5 Creedmoor</li> <li>Action: Bolt</li> <li>Barrel Length: 24"</li> <li>OAL: 43.6"</li> <li>Capacity: 4</li> <li>Barrel Finish: Matte Blued</li> <li>Stock: Black Synthetic</li> <li>Rate of Twist: 1 in 8</li> <li>2 Position Thumb Safety</li> <li>Weight: 7 lbs 4 oz</li> </ul> <p> </p> <p> </p> <p> </p> <p> </p>	[empty string]	N	655	655	[empty string]	99547-DEFAULT-s.jpg	[empty string]	1000	R85447	354977	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/700-adl-6-5-creedmoor-24-bbl-matte-blued-black-synthetic-354977	1
5	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	1	655	0	655	99548-DEFAULT-l.jpg	655	99548-DEFAULT-m.jpg	700 ADL 308WIN BOLT RIFLE	N	11 JJ	308 WIN	24IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	5	500-or-more	0.00	[empty string]	700 ADL - 308 WIN - 24" BBL - MATTE BLUED - BLACK SYNTHETIC	<ul> <li>Item: Remington 700 ADL Rifle</li> <li>Item Number: R85407</li> <li>Caliber: 308 Win</li> <li>Action: Bolt</li> <li>Barrel Length: 24"</li> <li>OAL: 43.6"</li> <li>Capacity: 4</li> <li>Barrel Finish: Matte Blued</li> <li>Stock: Black Synthetic</li> <li>Rate of Twist: 1 in 10</li> <li>Safety: 2 Position Thumb Safety</li> <li>Weight: 7 lbs 4 oz</li> </ul> <p> </p> <p> </p> <p> </p>	[empty string]	N	655	655	[empty string]	99548-DEFAULT-s.jpg	[empty string]	1000	R85407	354978	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/700-adl-308-win-24-bbl-matte-blued-black-synthetic-354978	1
6	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	1	655	0	655	99533-DEFAULT-l.jpg	655	99533-DEFAULT-m.jpg	REM 700 ADL 30-06 BOLT RIFLE	N	11 JJ	30-06 SPRG	24IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	4	500-or-more	0.00	[empty string]	700 ADL - 30-06 - 24" BBL - MATTE BLUED - BLACK SYNTHETIC	<ul> <li>Item: Remington 700 ADL</li> <li>Item Number: R27095</li> <li>Caliber: 30-06</li> <li>Action: Bolt</li> <li>Barrel Length: 24"</li> <li>OAL: 44.5"</li> <li>Capacity: 4</li> <li>Barrel Finish: Matte Blued</li> <li>Stock: Black Synthetic</li> <li>Rate of Twist: 1 in 10</li> <li>Weight: 7 lbs 6 oz</li> <li>2 Position Thumb Safety</li> </ul> <p> </p> <p> </p> <p> </p>	[empty string]	N	655	655	[empty string]	99533-DEFAULT-s.jpg	[empty string]	1000	R27095	354979	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/700-adl-30-06-24-bbl-matte-blued-black-synthetic-354979	1
7	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	1	655	0	655	99474-DEFAULT-l.jpg	655	99474-DEFAULT-m.jpg	700 ADL 270WIN BOLT RIFLE	N	11 JJ	270 WIN	24IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	5	500-or-more	0.00	[empty string]	700 ADL - 270 2WIN - MATTE BLUED - BLACK SYNTHETIC	<ul> <li>Item: Remington 700 ADL</li> <li>Item Number: R27094</li> <li>Caliber: 270 Win</li> <li>Action: Bolt</li> <li>Barrel Length: 24"</li> <li>OAL: 44.50"</li> <li>Barrel Finish: Matte Blued</li> <li>Stock Finish: Black Synthetic</li> <li>Rate of Twist: 1 in 10</li> <li>Capacity: 4</li> <li>Safety: 2 Position Thumb Safety</li> <li>Features: Carbon Steel Barrel</li> </ul>	[empty string]	N	655	655	[empty string]	99474-DEFAULT-s.jpg	[empty string]	1000	R27094	354980	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/700-adl-270-2win-matte-blued-black-synthetic-354980	1
8	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	0	1085	0	1085	[empty string]	1085	[empty string]	REM 700 BDL 243 WIN BLT RIFLE	N	11 JJ	243 WIN	22IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	REMINGTON	[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]	Rem 700 Bdl 243 Win Blt Rifle	[empty string]	[empty string]	N	1085	1085	[empty string]	[empty string]	[empty string]	1000	R25787	354981	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/rem-700-bdl-243-win-blt-rifle-354981	1
9	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	1	1130	0	1130	99467-DEFAULT-l.jpg	1130	99467-DEFAULT-m.jpg	REM 700CDL 243 WIN BOLT RIFLE	N	11 JJ	243 WIN	24IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	3	500-or-more	0.00	[empty string]	700 CDL - 243 WIN - SATIN BLUED - AMERICAN WALNUT	<ul> <li>Item: Remington 700 CDL</li> <li>Item Number:R27007</li> <li>Caliber: 243 Win</li> <li>Action: Bolt</li> <li>Barrel Length: 24"</li> <li>OAL: 43.6"</li> <li>Capacity: 4</li> <li>Barrel Finish: Satin Blued</li> <li>Stock: Satin Finish American Walnut</li> <li>Rate of Twist: 1 in 9 - 1/8</li> <li>Safety: 2 Position Thumb Safety</li> <li>Features: X-Mark Pro Adjustable Trigger</li> </ul> <p> </p>	[empty string]	N	1130	1130	[empty string]	99467-DEFAULT-s.jpg	[empty string]	1000	R27007	354982	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/700-cdl-243-win-satin-blued-american-walnut-354982	1
10	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	1	780	0	780	99460-DEFAULT-l.jpg	780	99460-DEFAULT-m.jpg	REM 700SPS 6.5CM BOLT RIFLE	N	11 JJ	6.5 CREEDMOOR	24IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	3	500-or-more	0.00	[empty string]	700 SPS - 6.5 CREEDMOOR - MATTE BLUED - BLACK SYNTHETIC	<ul> <li>Item: Remington 700SPS</li> <li>Item Number:R84148</li> <li>Caliber: 6.5 Creedmoor</li> <li>Action: Bolt</li> <li>Barrel Length: 24"</li> <li>OAL: 43.6"</li> <li>Capacity: 4</li> <li>Barrel Finish: Matte Blued</li> <li>Stock: Black Synthetic with Gray Inserts</li> <li>Rate of Twist: 1 in 8</li> <li>Safety: 2 Position Thumb Safety</li> <li>Features: Carbon Steel Barrel</li> </ul> <p> </p>	[empty string]	N	780	780	[empty string]	99460-DEFAULT-s.jpg	[empty string]	1000	R84148	354986	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/700-sps-6-5-creedmoor-matte-blued-black-synthetic-354986	1
11	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	0	899	0	899	[empty string]	899	[empty string]	REM 700 SPS TACTICAL 308WIN BOLT RIFLE	N	11 JJ	308 WIN	20IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	18	500-or-more	0.00	[empty string]	Rem 700 Sps Tactical 308win Bolt Rifle	[empty string]	[empty string]	N	899	899	[empty string]	[empty string]	[empty string]	1000	R84203	354987	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/rem-700-sps-tactical-308win-bolt-rifle-354987	1
12	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns	[empty string]	1	670	0	670	100646-DEFAULT-l.jpg	670	100646-DEFAULT-m.jpg	870 EXP TACTICAL 12GA PUMP SHOTGUN	N	11 JJ	12 GA	18-1/2IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	PUMP	SHOTGUN	2	500-or-more	0.00	[empty string]	870 EXPRESS TACTICAL - 12 GA - 3 IN - 18.5" BBL - MATTE BLUED - 6 POSITION MAGPUL CTR	<ul> <li>Item: REM ARMS 870 Express Tactical</li> <li>Item Number: R81212</li> <li>Gauge: 12</li> <li>Chamber: 3"</li> <li>Capacity: 6+1</li> <li>Action: Pump</li> <li>Sights: Bead Front</li> <li>Grip: Black Hogue rubber</li> <li>Choke: C</li> <li>Safety: Crossbolt</li> <li>Stock: 6 Position Magpul CTR</li> <li>Barrel Length: 18.5"</li> <li>Receiver Finish: Matte Black</li> <li>Stock Finish: Matte Black</li> </ul>	[empty string]	N	670	670	[empty string]	100646-DEFAULT-s.jpg	[empty string]	1000	R81212	354999	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/870-express-tactical-12-ga-3-in-18-5-bbl-matte-blued-6-position-magpul-ctr-354999	1
13	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns	[empty string]	1	495	0	495	97517-DEFAULT-l.jpg	495	97517-DEFAULT-m.jpg	REMINGTON 870 EXPRESS TACT 12GA PUMP SHOTGUN	N	11 JJ	12 GA	18-1/2IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	PUMP	SHOTGUN	5	450-to-500	0.00	[empty string]	870 HOME DEFENSE - 12 GA - 3 IN - 18.5" BBL - MATTE BLUED - HARDWOOD	<p>SPECIFICATIONS:</p> <ul> <li>Item: Remington Model 870 Home Defense</li> <li>Item Number: R25559</li> <li>Gauge: 12</li> <li>Chambered: 3'</li> <li>Barrel Length: 18.5"</li> <li>Action: Pump</li> <li>Barrel Finish: Matte Blued</li> <li>Stock: Hardwood</li> </ul>	[empty string]	N	495	495	[empty string]	97517-DEFAULT-s.jpg	[empty string]	1000	R25559	355000	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/870-home-defense-12-ga-3-in-18-5-bbl-matte-blued-hardwood-355000	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter By

Filter

Remarms Llc
700 Adl - 300 Win Mag - 26 " Bbl - Matte Blued - Black Synthetic
Item # R27099 $655.00
Remarms Llc
700 Adl - 7mm Rem Mag - 26 " Bbl - Matte Blued - Black Synthetic
Item # R27097 $655.00
Remarms Llc
700 Adl - 243 Win - 20 " Bbl - Matte Blued - Black Synthetic
Item # R27092 $655.00
Remarms Llc
700 Adl - 6.5 Creedmoor - 24 " Bbl - Matte Blued - Black Synthetic
Item # R85447 $655.00
Remarms Llc
700 Adl - 308 Win - 24 " Bbl - Matte Blued - Black Synthetic
Item # R85407 $655.00
Remarms Llc
700 Adl - 30- 06 - 24 " Bbl - Matte Blued - Black Synthetic
Item # R27095 $655.00
Remarms Llc
700 Adl - 270 2win - Matte Blued - Black Synthetic
Item # R27094 $655.00
Remarms Llc
Rem 700 Bdl 243 Win Blt Rifle
Item # R25787 $1,085.00
Remarms Llc
700 Cdl - 243 Win - Satin Blued - American Walnut
Item # R27007 $1,130.00
Remarms Llc
700 Sps - 6.5 Creedmoor - Matte Blued - Black Synthetic
Item # R84148 $780.00
Remarms Llc
Rem 700 Sps Tactical 308win Bolt Rifle
Item # R84203 $899.00
Remarms Llc
870 Express Tactical - 12 Ga - 3 In - 18.5 " Bbl - Matte Blued - 6 Position Magpul Ctr
Item # R81212 $670.00
Remarms Llc
870 Home Defense - 12 Ga - 3 In - 18.5 " Bbl - Matte Blued - Hardwood
Item # R25559 $495.00

Filter By

Price

Categories

Brand

700 Adl - 300 Win Mag - 26 " Bbl - Matte Blued - Black Synthetic

700 Adl - 7mm Rem Mag - 26 " Bbl - Matte Blued - Black Synthetic

700 Adl - 243 Win - 20 " Bbl - Matte Blued - Black Synthetic

700 Adl - 6.5 Creedmoor - 24 " Bbl - Matte Blued - Black Synthetic

700 Adl - 308 Win - 24 " Bbl - Matte Blued - Black Synthetic

700 Adl - 30- 06 - 24 " Bbl - Matte Blued - Black Synthetic

700 Adl - 270 2win - Matte Blued - Black Synthetic

Rem 700 Bdl 243 Win Blt Rifle

700 Cdl - 243 Win - Satin Blued - American Walnut

700 Sps - 6.5 Creedmoor - Matte Blued - Black Synthetic

Rem 700 Sps Tactical 308win Bolt Rifle

870 Express Tactical - 12 Ga - 3 In - 18.5 " Bbl - Matte Blued - 6 Position Magpul Ctr

870 Home Defense - 12 Ga - 3 In - 18.5 " Bbl - Matte Blued - Hardwood