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]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	2095	0	2095	87204-DEFAULT-l.jpg	2095	87204-DEFAULT-m.jpg	RIDGELINE 6.5 PRC GREEN BLACK TAN	N	11 JJ	6.5 PRC	24IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	Ridgeline 6.5 Prc Green Black Tan	[empty string]	[empty string]	N	2095	2095	[empty string]	87204-DEFAULT-s.jpg	[empty string]	1000	801-06015-00	313724	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/ridgeline-6-5-prc-green-black-tan-313724	1
2	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	2095	0	2095	87363-DEFAULT-l.jpg	2095	87363-DEFAULT-m.jpg	RIDGELINE 6.5 CM BLACK GRAY	N	11 JJ	6.5 CREEDMOOR	24IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	Ridgeline 6.5 Cm Black Gray	[empty string]	[empty string]	N	2095	2095	[empty string]	87363-DEFAULT-s.jpg	[empty string]	1000	CA10299-H14211	313726	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/ridgeline-6-5-cm-black-gray-313726	1
3	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	1350	0	1350	88153-DEFAULT-l.jpg	1350	88153-DEFAULT-m.jpg	MESA 6.5 PRC BLACK GRAY	N	11 JJ	6.5 PRC	24IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	Mesa 6.5 Prc Black Gray	[empty string]	[empty string]	N	1350	1350	[empty string]	88153-DEFAULT-s.jpg	[empty string]	1000	801-01021-00	313732	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/mesa-6-5-prc-black-gray-313732	1
4	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	1350	0	1350	88735-DEFAULT-l.jpg	1350	88735-DEFAULT-m.jpg	MESA 300 WIN MAG GREEN BLACK TAN	N	11 JJ	300 WIN MAG	24IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	Mesa 300 Win Mag Green Black Tan	[empty string]	[empty string]	N	1350	1350	[empty string]	88735-DEFAULT-s.jpg	[empty string]	1000	801-01008-00	313735	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/mesa-300-win-mag-green-black-tan-313735	1
5	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	1445	0	1445	97987-DEFAULT-l.jpg	1445	97987-DEFAULT-m.jpg	MESA 450BM BLACK GRAY	N	11 JJ	450 BUSHMASTER	20IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	MESA - 450 BUSHMATER 4+1 RDS - TUNGSTEN GRAY CERAKOTE - BLACK WITH GRAY WEBBING	<p>SPECIFICATIONS:</p> <ul> <li>Model: Christensen Arms Mesa</li> <li>Item Number: CA10280-Y12711</li> <li>Caliber: 450 Bushmaster</li> <li>Capacity: 4+1</li> <li>Stock Material: carbon Fiber</li> <li>Action: Bolt</li> <li>Barrel Length: 20 inch</li> <li>OAL 40.75"</li> <li>Barrel Finish: Tungsten Gray Cerakote</li> <li>Muzzle: Radial Muzzle Brake</li> <li>Safety: Two-Postition</li> <li>Stock Finish: Black with Gray Webbing</li> </ul>	[empty string]	N	1445	1445	[empty string]	97987-DEFAULT-s.jpg	[empty string]	1000	CA10280-Y12711	313737	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/mesa-450-bushmater-4-1-rds-tungsten-gray-cerakote-black-with-gray-webbing-313737	1
6	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	1445	0	1445	97989-DEFAULT-l.jpg	1445	97989-DEFAULT-m.jpg	MESA 450BM GREEN BLACK TAN	N	11 JJ	450 BUSHMASTER	20IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	MESA - 450 BUSHMATER 4+1 RDS - BURNT BRONZE CERAKOTE - GREEN WITH BLK/TAN WEBBING	<p>SPECIFICATIONS:</p> <ul> <li>Model: Christensen Arms Mesa - Green</li> <li>Item Number: 801-01014-00</li> <li>Caliber: 450 Bushmaster </li> <li>Capacity: 4+1</li> <li>Action: Bolt</li> <li>Barrel Length: 20"</li> <li>OAL: 40.75"</li> <li>Barrel Finish: Burnt Bronze Caerakote</li> <li>Stock Finish: Green with Black/Tan Webbing</li> </ul>	[empty string]	N	1445	1445	[empty string]	97989-DEFAULT-s.jpg	[empty string]	1000	801-01014-00	313738	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/mesa-450-bushmater-4-1-rds-burnt-bronze-cerakote-green-with-blk-tan-webbing-313738	1
7	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	2095	0	2095	97990-DEFAULT-l.jpg	2095	97990-DEFAULT-m.jpg	RIDGELINE 280AI BLACK GRAY	N	11 JJ	280 ACK	26IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	RIDGELINE - 280 ACKLEY IMPROVED - 4+1 RDS - TUNGSTEN GRAY CERAKOTE - BLK WITH GRAY WEBBING	<p>SPECIFICATIONS:</p> <ul> <li>Model: Christensen Arms Ridgeline</li> <li>Item Number: CA10299-M15311</li> <li>Caliber: 280 Ackley Improved</li> <li>Action: Bolt</li> <li>Barrel Length: 26"</li> <li>OAL: 45.50"</li> <li>Stock Material: Carbon Fiber</li> <li>Capacity: 4+1</li> <li>Barrel Finish: Tungsten Gray Cerakote</li> <li>Stock Finish: Black with Gray Webbing</li> </ul>	[empty string]	N	2095	2095	[empty string]	97990-DEFAULT-s.jpg	[empty string]	1000	CA10299-M15311	313921	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/ridgeline-280-ackley-improved-4-1-rds-tungsten-gray-cerakote-blk-with-gray-webbing-313921	1
8	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	2095	0	2095	98619-DEFAULT-l.jpg	2095	98619-DEFAULT-m.jpg	RIDGELINE 300 PRC BLACK GRAY	N	11 JJ	300 PRC	26IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	RIDGELINE - 300 PRC - 3 RDS - TUNGSTEN GRAY CERAKOTE	<p>SPECIFICATIONS:</p> <ul> <li>Item: Christensen Arms Ridgeline Rifle</li> <li>Item Number: 801-06051-00</li> <li>Caliber; 300 PRC</li> <li>Action: Bolt </li> <li>Capacity: 3</li> <li>Barrel Length: 26"</li> <li>Barrel Description: 416 Stainless Steel Carbon Fiber Wrapped</li> <li>Barrel Finish: Tungsten Gray Cerakote</li> <li>Stock Finish: Tungsten Gray Cerakote</li> <li>Stock Material: Carbon Fiber</li> <li>Twist: 1:8"</li> <li>Muzzle: radial Muzzle Brake</li> <li>OAL: 47.5"</li> </ul>	[empty string]	N	2095	2095	[empty string]	98619-DEFAULT-s.jpg	[empty string]	1000	801-06051-00	316064	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/ridgeline-300-prc-3-rds-tungsten-gray-cerakote-316064	1
9	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	1350	0	1350	88154-DEFAULT-l.jpg	1350	88154-DEFAULT-m.jpg	MESA 6.5 PRC GREEN BLACK TAN	N	11 JJ	6.5 PRC	24IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	Mesa 6.5 Prc Green Black Tan	[empty string]	[empty string]	N	1350	1350	[empty string]	88154-DEFAULT-s.jpg	[empty string]	1000	801-01022-00	316071	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/mesa-6-5-prc-green-black-tan-316071	1
10	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	2145	0	2145	88016-DEFAULT-l.jpg	2145	88016-DEFAULT-m.jpg	RIDGELINE 300 PRC BB BLACK TAN	N	11 JJ	300 PRC	26IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	Ridgeline 300 Prc Bb Black Tan	[empty string]	[empty string]	N	2145	2145	[empty string]	88016-DEFAULT-s.jpg	[empty string]	1000	801-06054-00	316080	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/ridgeline-300-prc-bb-black-tan-316080	1
11	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	835	0	835	88017-DEFAULT-l.jpg	835	88017-DEFAULT-m.jpg	RANGER 22 22LR TAN BLACK 18IN	N	11 JJ	22 LR	18IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	Ranger 22 22lr Tan Black 18in	[empty string]	[empty string]	N	835	835	[empty string]	88017-DEFAULT-s.jpg	[empty string]	1000	801-12001-00	332149	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/ranger-22-22lr-tan-black-18in-332149	1
12	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	2145	0	2145	98629-DEFAULT-l.jpg	2145	98629-DEFAULT-m.jpg	RIDGELINE 280AI BB BLACK TAN	N	11 JJ	280 ACK	26IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	RIDGELINE - 280 ACKLEY IMPROVED - 3 RDS - BURNT BRONZE CERAKOTE - GREEN BLACK TAN WEBBING	<p>SPECIFICATIONS:</p> <ul> <li>Item: Christensen arms Ridgeline rifle</li> <li>Item Number: 801-06027-00</li> <li>Caliber: 280 Ackley Improved</li> <li>Action: Bolt</li> <li>Rounds: 3</li> <li>Barrel Length: 26"</li> <li>Barrel Finish: Burnt Bronze Cerakote, Carbon Fiber Wrapped SS Barrel</li> <li>Stock: Synthetic</li> <li>Stock Finish: Green with Black and Tan Webbing</li> <li>Removable Burnt Bronze Brake</li> </ul>	[empty string]	N	2145	2145	[empty string]	98629-DEFAULT-s.jpg	[empty string]	1000	801-06027-00	332152	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/ridgeline-280-ackley-improved-3-rds-burnt-bronze-cerakote-green-black-tan-webbing-332152	1
13	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	835	0	835	98679-DEFAULT-l.jpg	835	98679-DEFAULT-m.jpg	RANGER 22 22LR GRAY BLACK 18IN	N	11 JJ	22 LR	18IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	RANGER - 22 LR - 10 RDS - CARBON FIBER BARREL - BLACK WITH GRAY WEBBING	<p>SPECIFICATIONS:</p> <ul> <li>Item: Christensen Arms #801-12002-00</li> <li>Item Number: 801-12002-00</li> <li>Caliber: 22LR</li> <li>Rounds: 10</li> <li>Barrel Length: 18"</li> <li>OAL: 38.25"</li> <li>Barrel: Carbon Fiber</li> <li>Receiver Finish: Black Anodized</li> <li>Stock: Carbon Fiber, Black with Gray Webbing</li> </ul>	[empty string]	N	835	835	[empty string]	98679-DEFAULT-s.jpg	[empty string]	1000	801-12002-00	339637	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/ranger-22-lr-10-rds-carbon-fiber-barrel-black-with-gray-webbing-339637	1
14	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	1695	0	1695	98680-DEFAULT-l.jpg	1695	98680-DEFAULT-m.jpg	CA5FIVE6 5.56 16IN BLACK SA	N	11 JJ	223 WYLDE	16IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	RIFLE	4	500-or-more	0.00	[empty string]	CA5FIVE6 - 223 WYLDE - 30 RDS - BLACK - ADJ MFT BATTLELINK MINIMALIST	<p>SPECIFICATIONS:</p> <ul> <li>Item: Christensen Arms CA5five6 Tactical Rifle</li> <li>Item Number: 801-09003-00</li> <li>Caliber: 223 Wylde</li> <li>Rounds: 30</li> <li>Action: Semi Auto</li> <li>Sights: Integrated Base</li> <li>Muzzle: 3 Prong Flash Hider</li> <li>Twist: 1:8"</li> <li>Stock Description: adjustable MFT Battlelink Minimalist</li> <li>Barrel Description: 416 Stainless Steel Carbon Fiber Wrapped, Button Rifled</li> <li>Barrel Length: 16"</li> <li>Receiver Finish: Black Anodized</li> <li>Weight: 6.3 lbs</li> </ul> <p> </p> <p> </p>	[empty string]	N	1695	1695	[empty string]	98680-DEFAULT-s.jpg	[empty string]	1000	801-09003-00	339640	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/ca5five6-223-wylde-30-rds-black-adj-mft-battlelink-minimalist-339640	1
15	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	1745	0	1745	98681-DEFAULT-l.jpg	1745	98681-DEFAULT-m.jpg	CA5FIVE6 223WY 16IN TUNGSTEN SA	N	11 JJ	223 WYLDE	16IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	RIFLE	1	500-or-more	0.00	[empty string]	CA5FIVE6 - 223 WYLDE - 30 RDS - BLACK - TUNGSTEN GRAY CERAKOTE	<p>SPECIFICATIONS:</p> <ul> <li>Item: Christensen Arms CA5five6</li> <li>Item Number: 801-09003-02</li> <li>Caliber: 223 Wylde</li> <li>Capacity: 30</li> <li>Action: Semi Auto</li> <li>Sights: Integrated Base</li> <li>Barrel Finish: Black</li> <li>Muzzle: 3 Prong Flash Hider</li> <li>Twist: 1:8"</li> <li>Grips: Black Polymer</li> <li>Handguards: 14.75" Carbon Aluminum Hybrid</li> <li>Safety: Switch</li> <li>Stock Description: Adjustable MFT Battlelink Minimalist</li> <li>Barrel Description: 416 Stainless Steel Carbon Fiber Wrapped, Button Rifled</li> <li>Barrel Length: 16"</li> <li>Receiver Finish: Tungsten Gray Cerakote</li> <li>Trigger: TriggerTech</li> <li>Weight: 6.3lbs</li> <li>Stock Finish: Black</li> </ul>	[empty string]	N	1745	1745	[empty string]	98681-DEFAULT-s.jpg	[empty string]	1000	801-09003-02	339641	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/ca5five6-223-wylde-30-rds-black-tungsten-gray-cerakote-339641	1
16	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	2145	0	2145	87791-DEFAULT-l.jpg	2145	87791-DEFAULT-m.jpg	RIDGELINE 6.5 CM GREEN BRONZE	N	11 JJ	6.5 CREEDMOOR	24IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	Ridgeline 6.5 Cm Green Bronze	[empty string]	[empty string]	N	2145	2145	[empty string]	87791-DEFAULT-s.jpg	[empty string]	1000	801-06020-00	344898	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/ridgeline-6-5-cm-green-bronze-344898	1
17	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	2145	0	2145	88015-DEFAULT-l.jpg	2145	88015-DEFAULT-m.jpg	RIDGELINE 300 WIN MAG BB BLACK TAN	N	11 JJ	300 WIN MAG	26IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	Ridgeline 300 Win Mag Bb Black Tan	[empty string]	[empty string]	N	2145	2145	[empty string]	88015-DEFAULT-s.jpg	[empty string]	1000	801-06034-00	345540	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/ridgeline-300-win-mag-bb-black-tan-345540	1
18	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	1745	0	1745	98773-DEFAULT-l.jpg	1745	98773-DEFAULT-m.jpg	CA5FIVE6 223WY 16IN BURNT BRONZE SA	N	11 JJ	223 WYLDE	16IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	RIFLE	1	500-or-more	0.00	[empty string]	CA5FIVE6 - 223 WYLDE - 30 RDS - BLACK - BURNT BRONZE - ADJ MFT BATTLELINK MINIMALIST	<p>SPECIFICATIONS:</p> <ul> <li>Item: Christensen Arms CA5five6</li> <li>Item Number: 801-09003-01</li> <li>Caliber: 223 Wylde</li> <li>Capacity: 30</li> <li>Stock Material: Synthetic</li> <li>Action: Semi Auto</li> <li>Sights: Integrated Base</li> <li>Barrel Finish: Black</li> <li>Muzzle: 3 Prong Flash Holder</li> <li>Twist: 1:8"</li> <li>Grips: Black Polymer</li> <li>Handguards: 14.75" Carbon-Aluminum</li> <li>Safety: Switch</li> <li>Thread Pattern: 1/2"28 tpi</li> <li>Stock Description: Adjustable MFT Battlelink Minimalist</li> <li>Barrel Description: 416 Stainless Steel Carbon Fiber Wrapped, Button Rifled</li> <li>Barrel Length: 16</li> <li>Receiver Finish: Burnt Bronze Cerakote</li> <li>Trigger: TriggerTech</li> <li>Weight: 6.3 lbs</li> </ul>	[empty string]	N	1745	1745	[empty string]	98773-DEFAULT-s.jpg	[empty string]	1000	801-09003-01	345544	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/ca5five6-223-wylde-30-rds-black-burnt-bronze-adj-mft-battlelink-minimalist-345544	1
19	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	2095	0	2095	98796-DEFAULT-l.jpg	2095	98796-DEFAULT-m.jpg	RIDGELINE 6.5 CM 16IN BLACK LIMITED SIMU	N	11 JJ	6.5 CREEDMOOR	16IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	Ridgeline 6.5 Cm 16in Black Limited Simu	[empty string]	[empty string]	N	2095	2095	[empty string]	98796-DEFAULT-s.jpg	[empty string]	1000	801-06111-00	346595	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/ridgeline-6-5-cm-16in-black-limited-simu-346595	1
20	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	0	2245	0	2245	[empty string]	2245	[empty string]	RIDGELINE 450BM BB GREEN BLACK TAN	N	11 JJ	450 BUSHMASTER	20IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	Ridgeline 450bm Bb Green Black Tan	[empty string]	[empty string]	N	2245	2245	[empty string]	[empty string]	[empty string]	1000	801-06017-00	346597	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/ridgeline-450bm-bb-green-black-tan-346597	1
21	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	1350	0	1350	98799-DEFAULT-l.jpg	1350	98799-DEFAULT-m.jpg	MESA 7MM REM MAG TUNG CERA BLK W/GRY	N	11 JJ	7MM REM MAG	24IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	MESA - 7MM REM MAG - 3 RDS - TUNGSTEN GRAY CERAKOTE - BLACK WITH GRAY WEBBING	<p>SPECIFICATIONS:</p> <ul> <li>Item: Christensen Arms</li> <li>Item Number: CA10280-314311</li> <li>Caliber: 7mm Rem Mag</li> <li>Action: Bolt</li> <li>Barrel Length: 24"</li> <li>OAL: 44.75"</li> <li>Capacity: 3</li> <li>Barrel Finish: Tungsten Gray Cerakote</li> <li>Stock Finish: Black with Gray Webbing</li> <li>Muzzle: Radial Muzzle Brake</li> </ul>	[empty string]	N	1350	1350	[empty string]	98799-DEFAULT-s.jpg	[empty string]	1000	CA10280-314311	353932	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/mesa-7mm-rem-mag-3-rds-tungsten-gray-cerakote-black-with-gray-webbing-353932	1
22	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms>Rifles	[empty string]	1	2395	0	2395	98807-DEFAULT-l.jpg	2395	98807-DEFAULT-m.jpg	RIDGELINE 300 WIN MAG LH BB BLACK TAN	N	11 JJ	300 WIN MAG	26IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	CHRISTENSEN ARMS	[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]	RIDGELINE - 300 WIN MAG - 3 RDS - BURNT BRONZE CERAKOTE - GREEN WITH BLACK AND TAN WEBBING - LEFT HAND	<p>SPECIFICATIONS:</p> <ul> <li>Item: Christensen Arms Ridgeline Rifle - LEFT HAND</li> <li>Item Number: 801-06084-00</li> <li>Caliber: 300 Win Mag</li> <li>Action: Bolt</li> <li>Barrel Length: 26</li> <li>Barrel Finish: Burnt Bronze Cerakote</li> <li>Stock Finish: Green with Black and Tan Webbing</li> <li>Rate of Twist: 1 in 10"</li> <li>Capacity: 3</li> <li>Weight: 9.15 lbs</li> </ul>	[empty string]	N	2395	2395	[empty string]	98807-DEFAULT-s.jpg	[empty string]	1000	801-06084-00	355624	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	christensen-arms/ridgeline-300-win-mag-3-rds-burnt-bronze-cerakote-green-with-black-and-tan-webbing-left-hand-355624	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter By

Filter

Christensen Arms
Ridgeline 6.5 Prc Green Black Tan
Item # 801-06015-00 $2,095.00
Christensen Arms
Ridgeline 6.5 Cm Black Gray
Item # CA10299-H14211 $2,095.00
Christensen Arms
Mesa 6.5 Prc Black Gray
Item # 801-01021-00 $1,350.00
Christensen Arms
Mesa 300 Win Mag Green Black Tan
Item # 801-01008-00 $1,350.00
Christensen Arms
Mesa - 450 Bushmater 4 + 1 Rds - Tungsten Gray Cerakote - Black With Gray Webbing
Item # CA10280-Y12711 $1,445.00
Christensen Arms
Mesa - 450 Bushmater 4 + 1 Rds - Burnt Bronze Cerakote - Green With Blk/Tan Webbing
Item # 801-01014-00 $1,445.00
Christensen Arms
Ridgeline - 280 Ackley Improved - 4 + 1 Rds - Tungsten Gray Cerakote - Blk With Gray Webbing
Item # CA10299-M15311 $2,095.00
Christensen Arms
Ridgeline - 300 Prc - 3 Rds - Tungsten Gray Cerakote
Item # 801-06051-00 $2,095.00
Christensen Arms
Mesa 6.5 Prc Green Black Tan
Item # 801-01022-00 $1,350.00
Christensen Arms
Ridgeline 300 Prc Bb Black Tan
Item # 801-06054-00 $2,145.00
Christensen Arms
Ranger 22 22lr Tan Black 18in
Item # 801-12001-00 $835.00
Christensen Arms
Ridgeline - 280 Ackley Improved - 3 Rds - Burnt Bronze Cerakote - Green Black Tan Webbing
Item # 801-06027-00 $2,145.00
Christensen Arms
Ranger - 22 Lr - 10 Rds - Carbon Fiber Barrel - Black With Gray Webbing
Item # 801-12002-00 $835.00
Christensen Arms
Ca5five6 - 223 Wylde - 30 Rds - Black - Adj Mft Battlelink Minimalist
Item # 801-09003-00 $1,695.00
Christensen Arms
Ca5five6 - 223 Wylde - 30 Rds - Black - Tungsten Gray Cerakote
Item # 801-09003-02 $1,745.00
Christensen Arms
Ridgeline 6.5 Cm Green Bronze
Item # 801-06020-00 $2,145.00
Christensen Arms
Ridgeline 300 Win Mag Bb Black Tan
Item # 801-06034-00 $2,145.00
Christensen Arms
Ca5five6 - 223 Wylde - 30 Rds - Black - Burnt Bronze - Adj Mft Battlelink Minimalist
Item # 801-09003-01 $1,745.00
Christensen Arms
Ridgeline 6.5 Cm 16in Black Limited Simu
Item # 801-06111-00 $2,095.00
Christensen Arms
Ridgeline 450bm Bb Green Black Tan
Item # 801-06017-00 $2,245.00
Christensen Arms
Mesa - 7mm Rem Mag - 3 Rds - Tungsten Gray Cerakote - Black With Gray Webbing
Item # CA10280-314311 $1,350.00
Christensen Arms
Ridgeline - 300 Win Mag - 3 Rds - Burnt Bronze Cerakote - Green With Black And Tan Webbing - Left Hand
Item # 801-06084-00 $2,395.00

Filter By

Price

Categories

Brand

Ridgeline 6.5 Prc Green Black Tan

Ridgeline 6.5 Cm Black Gray

Mesa 6.5 Prc Black Gray

Mesa 300 Win Mag Green Black Tan

Mesa - 450 Bushmater 4 + 1 Rds - Tungsten Gray Cerakote - Black With Gray Webbing

Mesa - 450 Bushmater 4 + 1 Rds - Burnt Bronze Cerakote - Green With Blk/Tan Webbing

Ridgeline - 280 Ackley Improved - 4 + 1 Rds - Tungsten Gray Cerakote - Blk With Gray Webbing

Ridgeline - 300 Prc - 3 Rds - Tungsten Gray Cerakote

Mesa 6.5 Prc Green Black Tan

Ridgeline 300 Prc Bb Black Tan

Ranger 22 22lr Tan Black 18in

Ridgeline - 280 Ackley Improved - 3 Rds - Burnt Bronze Cerakote - Green Black Tan Webbing

Ranger - 22 Lr - 10 Rds - Carbon Fiber Barrel - Black With Gray Webbing

Ca5five6 - 223 Wylde - 30 Rds - Black - Adj Mft Battlelink Minimalist

Ca5five6 - 223 Wylde - 30 Rds - Black - Tungsten Gray Cerakote

Ridgeline 6.5 Cm Green Bronze

Ridgeline 300 Win Mag Bb Black Tan

Ca5five6 - 223 Wylde - 30 Rds - Black - Burnt Bronze - Adj Mft Battlelink Minimalist

Ridgeline 6.5 Cm 16in Black Limited Simu

Ridgeline 450bm Bb Green Black Tan

Mesa - 7mm Rem Mag - 3 Rds - Tungsten Gray Cerakote - Black With Gray Webbing

Ridgeline - 300 Win Mag - 3 Rds - Burnt Bronze Cerakote - Green With Black And Tan Webbing - Left Hand