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	650	0	650	99438-DEFAULT-l.jpg	650	99438-DEFAULT-m.jpg	700 ADL 7MM MAG BOLT RIFLE	N	11 JJ	7MM REM MAG	26IN	[empty string]	[empty string]	[empty string]	[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	650	650	[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
2	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	1	650	0	650	99545-DEFAULT-l.jpg	650	99545-DEFAULT-m.jpg	700 ADL 243WIN COMP BOLT RIFLE	N	11 JJ	243 WIN	20IN	[empty string]	[empty string]	[empty string]	[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 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	650	650	[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
3	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	1	599	0	599	99547-DEFAULT-l.jpg	599	99547-DEFAULT-m.jpg	700 ADL 6.5CM BOLT RIFLE	N	11 JJ	6.5 CREEDMOOR	24IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	11	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	599	599	[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
4	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	1	650	0	650	99548-DEFAULT-l.jpg	650	99548-DEFAULT-m.jpg	700 ADL 308WIN BOLT RIFLE	N	11 JJ	308 WIN	24IN	[empty string]	[empty string]	[empty string]	[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 - 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	650	650	[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
5	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	1	650	0	650	99533-DEFAULT-l.jpg	650	99533-DEFAULT-m.jpg	REM 700 ADL 30-06 BOLT RIFLE	N	11 JJ	30-06 SPRG	24IN	[empty string]	[empty string]	[empty string]	[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 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	650	650	[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
6	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	1	650	0	650	99474-DEFAULT-l.jpg	650	99474-DEFAULT-m.jpg	700 ADL 270WIN BOLT RIFLE	N	11 JJ	270 WIN	24IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	BOLT	RIFLE	6	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	650	650	[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
7	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	1	1095	0	1095	99467-DEFAULT-l.jpg	1095	99467-DEFAULT-m.jpg	REM 700CDL 243 WIN BOLT RIFLE	N	11 JJ	243 WIN	24IN	[empty string]	[empty string]	[empty string]	[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	1095	1095	[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
8	[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]	[empty string]	[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]	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
9	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns	[empty string]	1	475	0	475	97516-DEFAULT-l.jpg	475	97516-DEFAULT-m.jpg	870 EXP SUPER MAG SYNTH 12GA PUMP	N	11 JJ	12 GA	28 IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	REMINGTON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	PUMP	SHOTGUN	1	450-to-500	0.00	[empty string]	870 EXPRESS SUPER MAGNUM - 12 GA - 3.5 IN - 28" BBL - MATTE BLACK	<p>SPECIFICATIONS:</p> <ul> <li>Item: Remington Model 870 Express Super Magnum </li> <li>Item: Number: R25103</li> <li>Gauge 12</li> <li>Chambered: 3.5"</li> <li>Barrel Length: 28"</li> <li>Capacity: 3</li> <li>Finish: Matte Black</li> </ul>	[empty string]	N	475	475	[empty string]	97516-DEFAULT-s.jpg	[empty string]	1000	R25103	354989	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/870-express-super-magnum-12-ga-3-5-in-28-bbl-matte-black-354989	1
10	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns	[empty string]	0	660	0	660	[empty string]	660	[empty string]	870 EXP TACTICAL 12GA PUMP SHOTGUN	N	11 JJ	12 GA	18-1/2IN	[empty string]	[empty string]	[empty string]	[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 Exp Tactical 12ga Pump Shotgun	[empty string]	[empty string]	N	660	660	[empty string]	[empty string]	[empty string]	1000	R81212	354999	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/870-exp-tactical-12ga-pump-shotgun-354999	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter By

Filter

Remarms Llc
700 Adl - 7mm Rem Mag - 26 " Bbl - Matte Blued - Black Synthetic
Item # R27097 $650.00
Remarms Llc
700 Adl - 243 Win - 20 " Bbl - Matte Blued - Black Synthetic
Item # R27092 $650.00
Remarms Llc
700 Adl - 6.5 Creedmoor - 24 " Bbl - Matte Blued - Black Synthetic
Item # R85447 $599.00
Remarms Llc
700 Adl - 308 Win - 24 " Bbl - Matte Blued - Black Synthetic
Item # R85407 $650.00
Remarms Llc
700 Adl - 30- 06 - 24 " Bbl - Matte Blued - Black Synthetic
Item # R27095 $650.00
Remarms Llc
700 Adl - 270 2win - Matte Blued - Black Synthetic
Item # R27094 $650.00
Remarms Llc
700 Cdl - 243 Win - Satin Blued - American Walnut
Item # R27007 $1,095.00
Remarms Llc
700 Sps - 6.5 Creedmoor - Matte Blued - Black Synthetic
Item # R84148 $780.00
Remarms Llc
870 Express Super Magnum - 12 Ga - 3.5 In - 28 " Bbl - Matte Black
Item # R25103 $475.00
Remarms Llc
870 Exp Tactical 12ga Pump Shotgun
Item # R81212 $660.00

Filter By

Price

Categories

Brand

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

700 Cdl - 243 Win - Satin Blued - American Walnut

700 Sps - 6.5 Creedmoor - Matte Blued - Black Synthetic

870 Express Super Magnum - 12 Ga - 3.5 In - 28 " Bbl - Matte Black

870 Exp Tactical 12ga Pump Shotgun