Simmons' 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	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEBSTYLE	WEIGHTED_SEARCH
1	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms	[empty string]	1	1349.99	0	1349.99	27415-DEFAULT-l.jpg	1349.99	27415-DEFAULT-m.jpg	CHRISTENSEN MESA 300WINMAG BZ	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CHRISTENSEN ARMS	[empty string]	RIFLE	300WIN	[empty string]	403	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0	500-or-more	0.00	[empty string]	Christensen Arms Mesa 300 Win Mag 3+1 24" Threaded Barrel, Burnt Bronze Cerakote, Green with Black/Tan Webbing Stock	<p>The Mesa is a premium quality lightweight hunting rifle offered at an accessible price. The build features a featherlight contour stainless steel barrel with a seamless removable radial muzzle brake and a carbon fiber composite gunstock. The Mesa weighs in starting at 6.5 pounds and is backed by the Christensen Arms Sub-MOA Guarantee.</p><p><strong>MESA BOLT ACTION RIFLE SPECIFICATIONS</strong></p><ul><li>Manufacturer: Christensen Arms</li><li>Family: Mesa Series</li><li>Model: Mesa</li><li>Type: Rifle</li><li>Action: Bolt Action</li><li>Caliber: 300 Win Mag</li><li>Finish: Bronze Cerakote</li><li>Finish Type: Applied Finish</li><li>Stock: Synthetic Stock</li><li>Stock: Green W/black & Tan Webbing</li><li>Barrel: 24"</li><li>Rate-of-Twist: 1-in-10</li><li>Capacity: 3 plus 1</li><li>Sights: None</li><li>Sight Type: None</li><li>Thread Pattern: 1/2x28</li><li>Special: Threaded Barrel Model</li><li>Weight: 7.3 lbs.</li><li>Shipping Weight: 10.35 lbs.</li><li>Additional Info: Sub-MOA Guarantee</li><li>Additional Info: Match Grade Trigger</li><li>Additional Info: Carbon Fiber Composite Stock</li><li>Mfg Model No: 801-01008-00</li><li>UPC: 810651029196</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p><p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p>	[empty string]	N	1349.99	1349.99	[empty string]	27415-DEFAULT-s.jpg	[empty string]	1000	1000	801-01008-00	64299	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	christensen-arms/christensen-arms-mesa-300-win-mag-3-1-24-threaded-barrel-burnt-bronze-cerakote-green-with-black-tan-webbing-stock-64299	801-01008-00	0
2	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms	[empty string]	1	1349.99	0	1349.99	16701-DEFAULT-l.jpg	1349.99	16701-DEFAULT-m.jpg	CHRISTENSEN MESA	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CHRISTENSEN ARMS	[empty string]	RIFLE	28NOS	[empty string]	403	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	2-NIB	[empty string]	1	500-or-more	0.00	[empty string]	Christensen Arms Mesa 28 Nosler Bronze Barrell Green/Black & Tan	<p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p><p>The Mesa is a premium quality lightweight hunting rifle offered at an accessible price. The build features a featherlight contour stainless steel barrel with a seamless removable radial muzzle brake and a carbon fiber composite gunstock. The Mesa weighs in starting at 6.5 pounds and is backed by the Christensen Arms Sub-MOA Guarantee.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>CALIBER: 28 NOSLER</li><li>BARREL LENGTH: 26"</li><li>TWIST: 1:9"</li><li>BARREL FINISH: Burnt Bronze Cerakote</li><li>STOCK FINISH: Green with Black / Tan Webbing</li><li>ITEM: 801-01011-00</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p>	[empty string]	N	1349.99	1349.99	[empty string]	16701-DEFAULT-s.jpg	[empty string]	1000	1000	801-01011-00	64300	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	christensen-arms/christensen-arms-mesa-28-nosler-bronze-barrell-green-black-tan-64300	801-01011-00	0
3	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms	[empty string]	1	1349.99	0	1349.99	16702-DEFAULT-l.jpg	1349.99	16702-DEFAULT-m.jpg	CHRISTENSEN MESA 7MM-08 REM BZ	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CHRISTENSEN ARMS	[empty string]	RIFLE	7MM-08	[empty string]	403	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0	500-or-more	0.00	[empty string]	Christensen Arms Mesa 7mm-08 Rem Bronze Barrel Green/Black & Tan	<p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p><p>The Mesa is a premium quality lightweight hunting rifle offered at an accessible price. The build features a featherlight contour stainless steel barrel with a seamless removable radial muzzle brake and a carbon fiber composite gunstock. The Mesa weighs in starting at 6.5 pounds and is backed by the Christensen Arms Sub-MOA Guarantee.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>CALIBER: 7MM-08 REM</li><li>BARREL LENGTH: 22"</li><li>TWIST: 1:9"</li><li>BARREL FINISH:Burnt Bronze Cerakote</li><li>STOCK FINISH: Green with Black / Tan Webbing</li><li>ITEM: 801-01012-00</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p>	[empty string]	N	1349.99	1349.99	[empty string]	16702-DEFAULT-s.jpg	[empty string]	1000	1000	801-01012-00	64301	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	christensen-arms/christensen-arms-mesa-7mm-08-rem-bronze-barrel-green-black-tan-64301	801-01012-00	0
4	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms	[empty string]	1	1299.99	0	1299.99	27417-DEFAULT-l.jpg	1299.99	27417-DEFAULT-m.jpg	CHRISTENSEN MESA BRZ	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CHRISTENSEN ARMS	[empty string]	RIFLE	6.5CREEDMOOR	[empty string]	403	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	2-NIB	[empty string]	3	500-or-more	0.00	[empty string]	Christensen Arms Mesa 6.5 Creedmoor 4+1 22" Threaded Barrel, Burnt Bronze Cerakote, Green with Black/Tan Webbing Stock	<p>The Mesa is a premium quality lightweight hunting rifle offered at an accessible price. The build features a featherlight contour stainless steel barrel with a seamless removable radial muzzle brake and a carbon fiber composite gunstock. The Mesa weighs in starting at 6.5 pounds and is backed by the Christensen Arms Sub-MOA Guarantee.</p><p><strong>MESA RIFLE SPECIFICATIONS</strong></p><ul><li>Manufacturer: Christensen Arms</li><li>Family: Mesa Series</li><li>Model: Mesa</li><li>Type: Rifle</li><li>Action: Bolt Action</li><li>Caliber: 6.5 Creedmoor</li><li>Finish: Bronze Cerakote</li><li>Finish Type: Applied Finish</li><li>Stock: Synthetic Stock</li><li>Stock: Green w/ Black & Tan Webbing</li><li>Barrel: 22"</li><li>Rate-of-Twist: 1-in-8</li><li>Capacity: 4 plus 1</li><li>Sights: None</li><li>Sight Type: None</li><li>Thread Pattern: 1/2x28</li><li>Special: Threaded Barrel Model</li><li>Weight: 6.5 lbs.</li><li>Shipping Weight: 9.9 lbs.</li><li>Additional Info: Sub-MOA Guarantee</li><li>Additional Info: Match Grade Trigger</li><li>Additional Info: Carbon Fiber Composite Stock</li><li>Mfg Model No: 801-01013-00</li><li>UPC: 810651029240</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p><p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p>	[empty string]	N	1299.99	1299.99	[empty string]	27417-DEFAULT-s.jpg	[empty string]	1000	1000	801-01013-00	64302	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	christensen-arms/christensen-arms-mesa-6-5-creedmoor-4-1-22-threaded-barrel-burnt-bronze-cerakote-green-with-black-tan-webbing-stock-64302	801-01013-00	0
5	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms	[empty string]	1	1349.99	1	1299.99	7834-DEFAULT-l.jpg	1349.99	7834-DEFAULT-m.jpg	CHRISTENSEN MESA BRZ	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CHRISTENSEN ARMS	[empty string]	RIFLE	6.5PRC	[empty string]	403	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	2-NIB	[empty string]	0	500-or-more	0.00	[empty string]	Christensen Arms Mesa 6.5 PRC Bronze Barrel Green/Black & Tan	<p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p><p>The Mesa is a premium quality lightweight hunting rifle offered at an accessible price. The build features a featherlight contour stainless steel barrel with a seamless removable radial muzzle brake and a carbon fiber composite gunstock. The Mesa weighs in starting at 6.5 pounds and is backed by the Christensen Arms Sub-MOA Guarantee.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>CALIBER: 6.5 PRC</li><li>BARREL LENGTH: 24"</li><li>TWIST: 1:8"</li><li>BARREL FINISH: Burnt Bronze Cerakote</li><li>STOCK FINISH: Green with Black / Tan Webbing</li><li>ITEM: 801-01022-00</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p>	[empty string]	Y	1299.99	1299.99	[empty string]	7834-DEFAULT-s.jpg	[empty string]	1000	1000	801-01022-00	64304	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	christensen-arms/christensen-arms-mesa-6-5-prc-bronze-barrel-green-black-tan-64304	801-01022-00	0
6	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms	[empty string]	1	1349.99	0	1349.99	7835-DEFAULT-l.jpg	1349.99	7835-DEFAULT-m.jpg	CHRISTENSEN MESA BRZ	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CHRISTENSEN ARMS	[empty string]	RIFLE	300PRC	[empty string]	403	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0	500-or-more	0.00	[empty string]	Christensen Arms Mesa 300 PRC Green/Black & Tan Rifle	<p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p><p>The Mesa is a premium quality lightweight hunting rifle offered at an accessible price. The build features a featherlight contour stainless steel barrel with a seamless removable radial muzzle brake and a carbon fiber composite gunstock. The Mesa weighs in starting at 6.5 pounds and is backed by the Christensen Arms Sub-MOA Guarantee.</p><p><strong>SPECIFICATIONS:</strong> </p><ul><li>CALIBER: 300 PRC</li><li>BARREL LENGTH: 24"</li><li>TWIST: 1:8"</li><li>BARREL FINISH: Burnt Bronze Cerakote</li><li>STOCK FINISH: Green with Black / Tan Webbing</li><li>ITEM: 801-01024-00</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p>	[empty string]	N	1349.99	1349.99	[empty string]	7835-DEFAULT-s.jpg	[empty string]	1000	1000	801-01024-00	64305	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	christensen-arms/christensen-arms-mesa-300-prc-green-black-tan-rifle-64305	801-01024-00	0
7	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms	[empty string]	1	1599.99	1	1549.99	13471-DEFAULT-l.jpg	1599.99	13471-DEFAULT-m.jpg	CHRISTENSEN MESA LH TUNG	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CHRISTENSEN ARMS	[empty string]	RIFLE	6.5PRC	[empty string]	403	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	2-NIB	[empty string]	1	500-or-more	0.00	[empty string]	Christensen Arms Mesa 6.5 PRC Black/Grey Left Hand Rifle	<p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p><p>The Mesa is a premium quality lightweight hunting rifle offered at an accessible price. The build features a featherlight contour stainless steel barrel with a seamless removable radial muzzle brake and a carbon fiber composite gunstock. The Mesa weighs in starting at 6.5 pounds and is backed by the Christensen Arms Sub-MOA Guarantee.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>CALIBER: 6.5 PRC</li><li>BARREL LENGTH: 24"</li><li>TWIST: 1:8"</li><li>BARREL FINISH: Tungsten Gray Cerakote</li><li>STOCK FINISH: Black with Gray Webbing</li><li>ITEM: 801-01047-00</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p>	[empty string]	Y	1549.99	1549.99	[empty string]	13471-DEFAULT-s.jpg	[empty string]	1000	1000	801-01047-00	64306	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	christensen-arms/christensen-arms-mesa-6-5-prc-black-grey-left-hand-rifle-64306	801-01047-00	0
8	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms	[empty string]	1	1599.99	1	1549.99	13472-DEFAULT-l.jpg	1599.99	13472-DEFAULT-m.jpg	CHRISTENSEN MESA LH TUNG	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CHRISTENSEN ARMS	[empty string]	RIFLE	300PRC	[empty string]	403	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	2-NIB	[empty string]	2	500-or-more	0.00	[empty string]	Christensen Arms Mesa 300 PRC Black/Grey Rifle	<p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p><p>The Mesa is a premium quality lightweight hunting rifle offered at an accessible price. The build features a featherlight contour stainless steel barrel with a seamless removable radial muzzle brake and a carbon fiber composite gunstock. The Mesa weighs in starting at 6.5 pounds and is backed by the Christensen Arms Sub-MOA Guarantee.</p><p><strong>SPECIFICATIONS</strong>:</p><ul><li>CALIBER: 300 PRC</li><li>BARREL LENGTH: 24"</li><li>TWIST: 1:8"</li><li>BARREL FINISH: Tungsten Gray Cerakote</li><li>STOCK FINSIH: Black with Gray Webbing</li><li>ITEM: 801-01054-00</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p><p> </p>	[empty string]	Y	1549.99	1549.99	[empty string]	13472-DEFAULT-s.jpg	[empty string]	1000	1000	801-01054-00	64307	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	christensen-arms/christensen-arms-mesa-300-prc-black-grey-rifle-64307	801-01054-00	0
9	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms	[empty string]	1	1599.99	1	1549.99	13473-DEFAULT-l.jpg	1599.99	13473-DEFAULT-m.jpg	CHRISTENSEN MESA LH TUNG	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CHRISTENSEN ARMS	[empty string]	RIFLE	7MM	[empty string]	403	[empty string]	[empty string]	ITEM CAN BE ADDED TO WISH LIST	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0	500-or-more	0.00	[empty string]	Christensen Arms Mesa 7mm Rem Mag Black/Grey Left Hand Rifle	<p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p><p>The Mesa is a premium quality lightweight hunting rifle offered at an accessible price. The build features a featherlight contour stainless steel barrel with a seamless removable radial muzzle brake and a carbon fiber composite gunstock. The Mesa weighs in starting at 6.5 pounds and is backed by the Christensen Arms Sub-MOA Guarantee.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>CALIBER: 7mm Rem Mag</li><li>BARREL LENGTH: 24"</li><li>TWIST: 1:9"</li><li>BARREL FINISH: Tungsten Gray Cerakote</li><li>STOCK FINISH: Black with Gray Webbing</li><li>ITEM: 801-01055-00</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p>	[empty string]	Y	1549.99	1549.99	[empty string]	13473-DEFAULT-s.jpg	[empty string]	1000	1000	801-01055-00	64308	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	christensen-arms/christensen-arms-mesa-7mm-rem-mag-black-grey-left-hand-rifle-64308	801-01055-00	0
10	[empty string]	CHRISTENSEN ARMS	Christensen Arms	FIREARMS	Firearms	[empty string]	1	1599.99	0	1599.99	13467-DEFAULT-l.jpg	1599.99	13467-DEFAULT-m.jpg	CHRISTENSEN MESA FFT BRZ	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	CHRISTENSEN ARMS	[empty string]	RIFLE	6.5CREEDMOOR	[empty string]	403	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Christensen Arms Mesa FFT Bronze Green/Tan 6.5 Creedmoor 20"	<p><strong>DESCRIPTION:</strong></p><p>The new Mesa FFT is a great solution for backcountry hunting. Weighing in starting at 5.5 pounds, the Mesa FFT is ideal on those long hikes up the mountain. It utilizes an ultralight contour stainless steel barrel with a Cerakote finish, "seamless" removable radial muzzle brake, and is backed by the Christensen Arms Sub-MOA Guarantee.</p><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p><p> </p>	[empty string]	N	1599.99	1599.99	[empty string]	13467-DEFAULT-s.jpg	[empty string]	1000	1000	801-01073-00	64309	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	christensen-arms/christensen-arms-mesa-fft-bronze-green-tan-6-5-creedmoor-20-64309	801-01073-00	0

CACHED

false

EXECUTIONTIME

SQL

SELECT top 10 style_id , max(webstyle) as webstyle , max(url) as url , max(realName) as realName , max(style) as style , max(overallqoh) as overallqoh , max(sale) as sale , max(new) as new , max(SmallPicture) as SmallPicture , max(MediumPicture) as MediumPicture , max(LargePicture) as LargePicture , max(sortposition) as sortposition , max(dept) as dept , max(typ) as typ , max(subtyp1) as subtyp1 , max(subtyp2) as subtyp2 , max(subtyp3) as subtyp3 , max(brand) as brand , max(branddisplay) as branddisplay , max(priceRange) as priceRange , min(salePriceRangeBottom) as salePriceRangeBottom , max(salePriceRangeTop) as salePriceRangeTop , max(ListPrice) as ListPrice , max(ranking) as ranking , max(romanticcopylong) as romanticcopylong , max(romanticcopyshort) as romanticcopyshort , max(depttree) as depttree , max(attr1list) as attr1list , max(famlist) as famlist , max(sizelist) as sizelist , max(name) as name , max(prodreviewsaverage) as prodreviewsaverage , max(INTERNALLISTPRICE) as INTERNALLISTPRICE , max(INTERNALMARKDOWN) as INTERNALMARKDOWN , max(INTERNALPRICE) as INTERNALPRICE , max(TERMSALELISTPRICE) as TERMSALELISTPRICE , max(TERMSALEPRICE) as TERMSALEPRICE , max(TERMSALE) as TERMSALE , max(of1) as of1 , max(of2) as of2 , max(of3) as of3 , max(of4) as of4 , max(of5) as of5 , max(of6) as of6 , max(of7) as of7 , max(of8) as of8 , max(of9) as of9 , max(of10) as of10 , max(of11) as of11 , max(of12) as of12 , max(of13) as of13 , max(of14) as of14 , max(of15) as of15 , max(of16) as of16 , max(of17) as of17 , max(of18) as of18 , max(of19) as of19 , max(of20) as of20 , min(sortposition) as sortposition , max(quantitysoldsum) as sold , CASE WHEN isNull(max(picture_id),0) = 0 THEN 0 ELSE 1 END as hasImage , CASE WHEN isNull(max(weighted_search),0) = 1 THEN 900000000 ELSE 0 END as weighted_search FROM web_all_products WHERE 1=1 --AND pictureid is not null and ltrim(rtrim(dept)) = ? and ltrim(rtrim(typ)) = 'EMPTY' AND ( 1=2 OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? OR upper(brand) like ? ) GROUP BY STYLE_ID

SQLPARAMETERS