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	3	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	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	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	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	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]	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	1	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
9	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Rifles	[empty string]	0	1625	0	1625	[empty string]	1625	[empty string]	REM 700 SENDERO SFII 300 WIN MAG 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	1	500-or-more	0.00	[empty string]	Rem 700 Sendero Sfii 300 Win Mag Rifle	[empty string]	[empty string]	N	1625	1625	[empty string]	[empty string]	[empty string]	1000	R27313	354985	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	remarms-llc/rem-700-sendero-sfii-300-win-mag-rifle-354985	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	4	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]	1	899	0	899	103677-DEFAULT-l.jpg	899	103677-DEFAULT-m.jpg	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	11	500-or-more	0.00	[empty string]	700 SPS TACTICAL - 308 WIN - MATTE BLUED - GHILLIE GREEN	<ul> <li>Item: Rem Arms 700 SPS Tactical</li> <li>Item Number: R842036</li> <li>Caliber: 308 Win</li> <li>Action: Bolt</li> <li>Stock Finish: Ghillie Green</li> <li>Barrel Finish: Matte Blued</li> <li>Barrel Length: 20"</li> <li>Barrel Description: Heavy</li> <li>Safety: Two Position</li> <li>Drilled and Tapped</li> </ul> <p> </p>	[empty string]	Y	899	899	[empty string]	103677-DEFAULT-s.jpg	[empty string]	1000	R84203	354987	EMPTY	EMPTY	EMPTY	1	899	775	RIFLES	[empty string]	remarms-llc/700-sps-tactical-308-win-matte-blued-ghillie-green-354987	1
12	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns>Pump Action	[empty string]	1	945	0	945	108616-DEFAULT-l.jpg	945	108616-DEFAULT-m.jpg	870 MARINE MAGNUM 12GA 18IN SYN PUMP	N	11 JJ	12 GA	18IN	[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	3	500-or-more	0.00	[empty string]	SPECIAL PURPOSE MARINE MAGNUM - 12 GA - 3 IN - 18.5" BBL - ELECTROLESS NICKEL-PLATED - MATTE BLACK	<ul> <li>Item: Remington Special Purpose Marine Magnum</li> <li>Item Number: R25012</li> <li>Gauge: 12</li> <li>Action: Pump</li> <li>Chamber: 3"</li> <li>Capacity: 6</li> <li>Barrel Finish: Electroless Nickel-Plated</li> <li>Stock: Matte Black </li> <li>Barrel Length: 18.5"</li> <li>OAL: 38.50"</li> <li>Sights: Bead Front</li> <li>Safety: Crossbolt</li> <li>Weight: 7.5 lbs</li> </ul>	[empty string]	N	945	945	[empty string]	108616-DEFAULT-s.jpg	[empty string]	1000	R25012	354991	PUMP ACTION	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/special-purpose-marine-magnum-12-ga-3-in-18-5-bbl-electroless-nickel-plated-matte-black-354991	1
13	[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
14	[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	4	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
15	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns>Pump Action	[empty string]	1	955	0	955	108614-DEFAULT-l.jpg	955	108614-DEFAULT-m.jpg	870 WINGMASTER 20GA SHOTGUN	N	11 JJ	20 GA	28 IN	[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	3	500-or-more	0.00	[empty string]	870 WINGMASTER - 20 GA - 3 IN - 28" - HIGH POLISHED BLUED - SATIN AMERICAN WALNUT	<ul> <li>Item: Remington 870 Wingmaster</li> <li>Item Number: R26947</li> <li>Gauge: 20</li> <li>Chamber: 3 inch</li> <li>Action: Pump</li> <li>Capacity: 4</li> <li>Barrel Length: 28" Vent Rib</li> <li>OAL: 48.50"</li> <li>Barrel Finish: High Polished Blued</li> <li>Stock: Satin American Walnut</li> <li>Sights: Dual Bead</li> <li>Choke Configuration: Rem Choke</li> <li>Safety: Crossbolt</li> <li>LOP: 14"</li> <li>Trigger: Gold Plated</li> </ul>	[empty string]	N	955	955	[empty string]	108614-DEFAULT-s.jpg	[empty string]	1000	R26947	355002	PUMP ACTION	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/870-wingmaster-20-ga-3-in-28-high-polished-blued-satin-american-walnut-355002	1
16	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns>Pump Action	[empty string]	1	560	0	560	109190-DEFAULT-l.jpg	560	109190-DEFAULT-m.jpg	870 FIELD 28IN WOOD 12 GA SHOTGUN PUMP	N	11 JJ	12 GA	28 IN	[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	4	500-or-more	0.00	[empty string]	870 FIELDMASTER - 12 GA - 3 IN - 28" BBL - MATTE BLUED - HARDWOOD	<ul> <li>Item: Remington Firearms 870 Fieldmaster Shotgun</li> <li>Item Number: R68864</li> <li>Gauge: 12</li> <li>Action: Pump</li> <li>Capacity: 4</li> <li>Barrel Finish: Matte Blued</li> <li>Stock: Walnut</li> <li>Barrel Length: 28"</li> <li>OAL: 48.50"</li> <li>LOP: 14.25"</li> <li>Choke System: Rem Choke</li> <li>Chokes: F,M,IC</li> <li>Safety: Crossbolt</li> <li>Weight: 7 lbs</li> </ul> <p> </p> <p> </p> <p> </p>	[empty string]	N	560	560	[empty string]	109190-DEFAULT-s.jpg	[empty string]	1000	R68864	361508	PUMP ACTION	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/870-fieldmaster-12-ga-3-in-28-bbl-matte-blued-hardwood-361508	1
17	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns>Pump Action	[empty string]	1	560	0	560	107703-DEFAULT-l.jpg	560	107703-DEFAULT-m.jpg	REMINGTON 870 FIELD JR 20GA 18IN PUMP	N	11 JJ	20 GA	21IN	[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	7	500-or-more	0.00	[empty string]	870 FIELDMASTER - COMPACT - 20 GA - 3 IN - 21" BBL - MATTE BLUED - BLACK SYNTHETIC	<ul> <li>Item: Remington 870 Fieldmaster</li> <li>Item: R68876</li> <li>Caliber: 20 Ga</li> <li>Cambered: 3"</li> <li>Capacity: 4</li> <li>Action: Pump</li> <li>Barrel Finish: Matte blued</li> <li>Stock: Black Synthetic</li> <li>Barrel Length: 21" Vent Rib</li> <li>OAL: 40.5"</li> <li>Sight: Single Bead</li> <li>Weight: 7.75 lbs</li> </ul>	[empty string]	N	560	560	[empty string]	107703-DEFAULT-s.jpg	[empty string]	1000	R68876	361511	PUMP ACTION	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/870-fieldmaster-compact-20-ga-3-in-21-bbl-matte-blued-black-synthetic-361511	1
18	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns>Pump Action	[empty string]	1	955	0	955	109256-DEFAULT-l.jpg	955	109256-DEFAULT-m.jpg	870 WINGMASTER 12GA SHOTGUN	N	11 JJ	12 GA	28 IN	[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 WINGMASTER - 12 GA - 3 IN - 28" - HIGH POLISHED BLUED - AMERICAN WALNUT	<ul> <li>Item: Remington 870 Wingmaster Shotgun</li> <li>Item Number: R26927</li> <li>Gauge: 12</li> <li>Chamber: 3 in </li> <li> Capacity: 4</li> <li>Action: Pump</li> <li>Barrel Length: 28" Vent Rib</li> <li>OAL: 48.5"</li> <li>Barrel Finish: High Polished Blued</li> <li>Stock: American Walnut</li> <li>Sights: Fixed Twin Bead Sights</li> <li>Rem Chokes</li> <li>Gold Plated Trigger</li> <li>Weight: 7 lbs</li> </ul>	[empty string]	N	955	955	[empty string]	109256-DEFAULT-s.jpg	[empty string]	1000	R26927	361514	PUMP ACTION	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/870-wingmaster-12-ga-3-in-28-high-polished-blued-american-walnut-361514	1
19	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns>Pump Action	[empty string]	1	515	0	515	108029-DEFAULT-l.jpg	515	108029-DEFAULT-m.jpg	870 TAC HOME DEF 12GA 18.5IN PUMP	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	4	500-or-more	0.00	[empty string]	870 HOME DEFENSE - 12 GA - 3 IN - 18.5" BBL - MATTE BLUED - SATIN HARDWOOD	<ul> <li>Item: Remington 870 Home Defense Pump Shotgun</li> <li>Item Number: #R81197</li> <li>Gauge: 12</li> <li>Action: Pump</li> <li>Capacity: 6</li> <li>Barrel Length: 18.5"</li> <li>OAL: 38.50"</li> <li>Barrel Finish: Matte Blued</li> <li>Stock: Satin Hardwood</li> <li>Chokes Included: C</li> <li>Safety: Crossbolt</li> <li>LOP: 14"</li> <li>Weight: 7.50 lbs</li> </ul> <p> </p>	[empty string]	N	515	515	[empty string]	108029-DEFAULT-s.jpg	[empty string]	1000	R81197	362183	PUMP ACTION	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/870-home-defense-12-ga-3-in-18-5-bbl-matte-blued-satin-hardwood-362183	1
20	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns>Pump Action	[empty string]	1	660	0	660	108783-DEFAULT-l.jpg	660	108783-DEFAULT-m.jpg	870 FIELD 23IN CANT WOOD 12 GA SHOTGUN PUMP	N	11 JJ	12 GA	23IN	[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 FIELDMASTER - 12 GA - 3 IN - 23" BBL - MATTE BLUED - HARDWOOD	<ul> <li>Item: Remington 870 Fieldmaster</li> <li>Item Number: V</li> <li>Gauge: 12</li> <li>Chamber: 3"</li> <li>Capacity: 4</li> <li>Barrel Length: 23"</li> <li>OAL: 40.50"</li> <li>Barrel Finish: Matte Blued</li> <li>Stock: Hardwood</li> <li>Sights: Adjustable Rifle Sights</li> <li>Weight: 8.8 lbs</li> </ul>	[empty string]	N	660	660	[empty string]	108783-DEFAULT-s.jpg	[empty string]	1000	R68879	377992	PUMP ACTION	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/870-fieldmaster-12-ga-3-in-23-bbl-matte-blued-hardwood-377992	1
21	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns>Pump Action	[empty string]	1	560	0	560	108291-DEFAULT-l.jpg	560	108291-DEFAULT-m.jpg	870 FIELD 20GA 21IN YTH WLNT PUMP SHOTGUN	N	11 JJ	20 GA	21IN	[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	4	500-or-more	0.00	[empty string]	870 FIELDMASTER COMPACT - 20 GA - 21" BBL - SATIN BLACK - AMERICAN WALNUT	<ul> <li>Item: Remington 870 Fieldmaster - Compact</li> <li>Item Number: R68863</li> <li>Gauge: 20</li> <li>Action: Pump</li> <li>Capacity: 4</li> <li>Barrel Length: 21" Vent Rib</li> <li>OAL: 40 1/2"</li> <li>Sight: Bead</li> <li>Barrel Finish: satin Black Carbon Steel</li> <li>Stock: Satin Standard Grad American Walnut</li> <li>LOP: 13"</li> <li>Weight: 6 lbs</li> </ul>	[empty string]	N	560	560	[empty string]	108291-DEFAULT-s.jpg	[empty string]	1000	R68863	378407	PUMP ACTION	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/870-fieldmaster-compact-20-ga-21-bbl-satin-black-american-walnut-378407	1
22	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns>Pump Action	[empty string]	1	560	0	560	107349-DEFAULT-l.jpg	560	107349-DEFAULT-m.jpg	REMINGTON 870 FIELD 20GA 28IN PUMP	N	11 JJ	20 GA	28 IN	[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 FIELDMASTER - 20 GA - 3 IN - 28" BBL - MATTE BLUED - HARDWOOD	<ul> <li>Item: Rem Arms 870 Fieldmaster Shotgun</li> <li>Item Number: R68870</li> <li>Gauge: 20</li> <li>Action: Pump</li> <li>Capacity: 4</li> <li>Chambered: 3 inch</li> <li>Barrel: 28" Vent Rib Matte Blued Barrel</li> <li>Stock: Satin Hardwood</li> <li>Sights: Fixed Single Bead</li> <li>Choke: Rem Choke (Mod)</li> <li>Weight: 6.25 lbs</li> </ul>	[empty string]	N	560	560	[empty string]	107349-DEFAULT-s.jpg	[empty string]	1000	R68870	379025	PUMP ACTION	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/870-fieldmaster-20-ga-3-in-28-bbl-matte-blued-hardwood-379025	1
23	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns>Pump Action	[empty string]	1	595	0	595	109262-DEFAULT-l.jpg	595	109262-DEFAULT-m.jpg	870 FIELD SUPER MAG 12GA 28IN PUMP	N	11 JJ	12 GA	28 IN	[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 FIELDMASTER SUPER MAGNUM - 12 GA - 3.5 IN - 28" BBL - MATTE BLUED - HARDWOOD	<ul> <li>Item: Remington 870 Fieldmaster Super Magnum Shotgun</li> <li>Item Number: R68860</li> <li>Gauge: 12</li> <li>Chamber: 3.5"</li> <li>Action: Pump</li> <li>Capacity: 3</li> <li>Barrel Finish: Matte Blued</li> <li>Stock Hardwood</li> <li>Barrel Length: 28" Vent Rib</li> <li>OAL: 48"</li> <li>Sight: Fixed Single Bead</li> <li>Choke System: Rem Choke (Mod)</li> </ul> <p> </p> <p> </p>	[empty string]	N	595	595	[empty string]	109262-DEFAULT-s.jpg	[empty string]	1000	R68860	385417	PUMP ACTION	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/870-fieldmaster-super-magnum-12-ga-3-5-in-28-bbl-matte-blued-hardwood-385417	1
24	[empty string]	REMARMS LLC	Remarms Llc	FIREARMS	Firearms>Shotguns>Pump Action	[empty string]	1	665	0	665	108612-DEFAULT-l.jpg	665	108612-DEFAULT-m.jpg	870 TACT 12GA 18.5IN MT SN SGTS 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 EXPRESS TACTICAL - 12 GA - 3 IN - 18.5" BBL - MATTE BLUED - MATTE BLACK	<ul> <li>Item: Remington Arms 870 Express Tactical Shotgun</li> <li>Item Number: R81198</li> <li>Gauge: 12</li> <li>Action: Pump</li> <li>Chamber: 3 inch</li> <li>Capacity: 6</li> <li>Barrel Length: 18.5"</li> <li>OAL: 38.50"-40.50"</li> <li>Sights: XS Ghost ring</li> <li>Barrel Finish: Matte Blued</li> <li>Receiver Finish: Matte Blued</li> <li>Stock Finish: Matte Black Synthetic</li> <li>Safety: Crossbolt</li> <li>LOP: 14"</li> <li>Rem Choke</li> </ul> <p> </p>	[empty string]	N	665	665	[empty string]	108612-DEFAULT-s.jpg	[empty string]	1000	R81198	388828	PUMP ACTION	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	remarms-llc/870-express-tactical-12-ga-3-in-18-5-bbl-matte-blued-matte-black-388828	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
700 Cdl - 243 Win - Satin Blued - American Walnut
Item # R27007 $1,130.00
Remarms Llc
Rem 700 Sendero Sfii 300 Win Mag Rifle
Item # R27313 $1,625.00
Remarms Llc
700 Sps - 6.5 Creedmoor - Matte Blued - Black Synthetic
Item # R84148 $780.00
Remarms Llc
700 Sps Tactical - 308 Win - Matte Blued - Ghillie Green
Item # R84203 $899.00 $775.00
Remarms Llc
Special Purpose Marine Magnum - 12 Ga - 3 In - 18.5 " Bbl - Electroless Nickel- Plated - Matte Black
Item # R25012 $945.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
Remarms Llc
870 Wingmaster - 20 Ga - 3 In - 28 "- High Polished Blued - Satin American Walnut
Item # R26947 $955.00
Remarms Llc
870 Fieldmaster - 12 Ga - 3 In - 28 " Bbl - Matte Blued - Hardwood
Item # R68864 $560.00
Remarms Llc
870 Fieldmaster - Compact - 20 Ga - 3 In - 21 " Bbl - Matte Blued - Black Synthetic
Item # R68876 $560.00
Remarms Llc
870 Wingmaster - 12 Ga - 3 In - 28 "- High Polished Blued - American Walnut
Item # R26927 $955.00
Remarms Llc
870 Home Defense - 12 Ga - 3 In - 18.5 " Bbl - Matte Blued - Satin Hardwood
Item # R81197 $515.00
Remarms Llc
870 Fieldmaster - 12 Ga - 3 In - 23 " Bbl - Matte Blued - Hardwood
Item # R68879 $660.00
Remarms Llc
870 Fieldmaster Compact - 20 Ga - 21 " Bbl - Satin Black - American Walnut
Item # R68863 $560.00
Remarms Llc
870 Fieldmaster - 20 Ga - 3 In - 28 " Bbl - Matte Blued - Hardwood
Item # R68870 $560.00
Remarms Llc
870 Fieldmaster Super Magnum - 12 Ga - 3.5 In - 28 " Bbl - Matte Blued - Hardwood
Item # R68860 $595.00
Remarms Llc
870 Express Tactical - 12 Ga - 3 In - 18.5 " Bbl - Matte Blued - Matte Black
Item # R81198 $665.00

Filter By

Price

Categories

Featured

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

700 Cdl - 243 Win - Satin Blued - American Walnut

Rem 700 Sendero Sfii 300 Win Mag Rifle

700 Sps - 6.5 Creedmoor - Matte Blued - Black Synthetic

700 Sps Tactical - 308 Win - Matte Blued - Ghillie Green

Special Purpose Marine Magnum - 12 Ga - 3 In - 18.5 " Bbl - Electroless Nickel- Plated - Matte Black

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

870 Wingmaster - 20 Ga - 3 In - 28 "- High Polished Blued - Satin American Walnut

870 Fieldmaster - 12 Ga - 3 In - 28 " Bbl - Matte Blued - Hardwood

870 Fieldmaster - Compact - 20 Ga - 3 In - 21 " Bbl - Matte Blued - Black Synthetic

870 Wingmaster - 12 Ga - 3 In - 28 "- High Polished Blued - American Walnut

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

870 Fieldmaster - 12 Ga - 3 In - 23 " Bbl - Matte Blued - Hardwood

870 Fieldmaster Compact - 20 Ga - 21 " Bbl - Satin Black - American Walnut

870 Fieldmaster - 20 Ga - 3 In - 28 " Bbl - Matte Blued - Hardwood

870 Fieldmaster Super Magnum - 12 Ga - 3.5 In - 28 " Bbl - Matte Blued - Hardwood

870 Express Tactical - 12 Ga - 3 In - 18.5 " Bbl - Matte Blued - Matte Black