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]	EUROPEAN AMERICAN AR	European American Ar	FIREARMS	Firearms>Shotgun	[empty string]	1	219.99	0	219.99	7269-DEFAULT-l.jpg	219.99	7269-DEFAULT-m.jpg	EAA 111375	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AKKAR	EAA	SHOTGUN	12GA	[empty string]	95	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2-NIB	[empty string]	1	200-to-250	0.00	[empty string]	EAA Akkar Churchill 612 12 Gauge 18.50" Barrel 3" \| Blued Black \| Pistol Grip \| Pump Action	<p>The Churchill 612 is for the traditionalist looking for a home defense shotgun. It features a pistol grip stock and 18.50" barrel.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Akkar</li><li>Category Shotguns</li><li>Model Churchill</li><li>Series 612</li><li>Gauge 12 Gauge</li><li>Stock Finish Black</li><li>Action Pump</li><li>Barrel Length Range 18" to 18.99"</li><li>Capacity 5+1</li><li>Chamber 3"</li><li>Size Full Size</li><li>Application Home Defense</li><li>Hand Right</li><li>OAL 37.50"</li><li>Receiver Finish Blued</li><li>Receiver Material Steel</li><li>Stock Description Fixed Pistol Grip</li><li>Stock Finish Group Black</li><li>Stock Material Synthetic</li><li>Weight 5.50 lbs</li><li>Barrel Finish Blued</li><li>Barrel Length 18.50"</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><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	219.99	219.99	[empty string]	7269-DEFAULT-s.jpg	[empty string]	1000	1000	111375	64504	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUN	european-american-ar/eaa-akkar-churchill-612-12-gauge-18-50-barrel-3-blued-black-pistol-grip-pump-action-64504	111375	0
2	[empty string]	EUROPEAN AMERICAN AR	European American Ar	FIREARMS	Firearms>Tactical	[empty string]	1	599.99	0	599.99	9467-DEFAULT-l.jpg	599.99	9467-DEFAULT-m.jpg	RADIKAL IFCNK1 SHOTGUN	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	AKKAR	EAA	SHOTGUN	12GA	[empty string]	95	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2-NIB	[empty string]	2	500-or-more	0.00	[empty string]	Radikal Arms NK1 Bullpup 12 Gauge 24" Barrell 3" \| Black \| Pistol Grips & Optic Ready Rail	<ul><li>No Sale To California:</li><li>Gauge: 12</li><li>Action Type: Semi-auto</li><li>Max Chamber Size: 3"</li><li>Weight: 8.7</li><li>Metal Finish: Colored</li><li>Barrel Length In Inches: 24</li><li>Overall Length In Inches: 34</li><li>Checkering: N</li><li>Montecarlo: N</li><li>Recoil Pad: Y</li><li>Stock Material: Synthetic</li><li>Stock Color: Black</li><li>Stock Style: Tactical</li><li>Swivels Studs: Yes</li><li>Internal Choke Tubes Y/n: Y</li><li>Includes X-full Tube: N</li><li>Incl Full Tube: Y</li><li>Incl Imp Mod Tube: N</li><li>Metal Color: Black</li><li>Incl Modified Tube: Y</li><li>Incl Imp Cyl Tube: Y</li><li>Incl Skeet Tube: N</li></ul><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>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	599.99	599.99	[empty string]	9467-DEFAULT-s.jpg	[empty string]	1000	1000	IFCNK1	64508	EMPTY	EMPTY	EMPTY	0	0	0	TACTICAL	european-american-ar/radikal-arms-nk1-bullpup-12-gauge-24-barrell-3-black-pistol-grips-optic-ready-rail-64508	IFCNK1	0
3	[empty string]	KIMBER	Kimber	FIREARMS	Firearms>Handgun	[empty string]	1	1499.99	1	1449.99	16347-DEFAULT-l.jpg	1499.99	16347-DEFAULT-m.jpg	KIMBER 3000236 PISTOL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	KIMBER	[empty string]	PISTOL	45ACP	[empty string]	165	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Kimber Desert Warrior Pistol .45 ACP 5" Barrel Ambi Safety KimPro II Frame/Slide 7 Rd	<p>Details<br />Shipping<br />Description<br />The Kimber Warrior 1911 was clearly built for combat. This feature-heavy pistol is ideal for duty carry or personal defense. Both the slide and frame are machined from solid steel and wear a self-lubricating finish resistant to the elements. The G-10 grip panels ensures a positive handle regardless of the conditions. The best pistol to carry is the 1911, and the best 1911 comes from Kimber. The Kimber Warrior feels right the second you pick it up.</p><ul><li>Features:</li><li>Aluminum Match-Grade Trigger</li><li>G-10 Tactical Grips</li><li>Tritrium Night Sights</li><li>Ambidextrous Thumb Safety</li><li>1913 Picatinny Rail</li><li>Specifications</li><li>Item Condition New</li><li>Caliber: .45 ACP</li><li>Weight: 40 oz</li><li>Action: Single Action Only Semi-Automatic</li><li>Safety: Ambidextrous thumb safety</li><li>Sights: Tactical Wedge tritium night sights, fixed</li><li>Magazines Included: 1</li><li>Magazine Capacity: 7</li><li>Grips: Kimber G-10 tactical grips</li><li>Barrel Length: 5"</li><li>Slide Finish: Desert Tan</li><li>Frame Finish: Desert Tan</li><li>Caliber or Gauge: .45 ACP</li><li>Product Type Handguns</li><li>UPC 669278302362</li><li>MPN 3000236</li></ul><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>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	1449.99	1449.99	[empty string]	16347-DEFAULT-s.jpg	[empty string]	1000	1000	3000236	64795	EMPTY	EMPTY	EMPTY	0	0	0	HANDGUN	kimber/kimber-desert-warrior-pistol-45-acp-5-barrel-ambi-safety-kimpro-ii-frame-slide-7-rd-64795	3000236	0
4	[empty string]	KIMBER	Kimber	FIREARMS	Firearms>Handgun	[empty string]	1	1299.99	1	1249.99	6692-DEFAULT-l.jpg	1299.99	6692-DEFAULT-m.jpg	KIMBER ECLIPSE CUSTOM	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	KIMBER	[empty string]	PISTOL	45ACP	[empty string]	165	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Kimber Eclipse Custom Charcoal Grey .45 ACP	<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>Kimber Eclipse Custom 1911 Charcoal gray .45 ACP 5-inch Barrel 669278302386<br /></p>	[empty string]	Y	1249.99	1249.99	[empty string]	6692-DEFAULT-s.jpg	[empty string]	1000	1000	3000238	64797	EMPTY	EMPTY	EMPTY	0	0	0	HANDGUN	kimber/kimber-eclipse-custom-charcoal-grey-45-acp-64797	3000238	0
5	[empty string]	KIMBER	Kimber	FIREARMS	Firearms>Handgun	[empty string]	1	1399.99	1	1299.99	6686-DEFAULT-l.jpg	1399.99	6686-DEFAULT-m.jpg	KIMBER KHX CUSTOM	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	KIMBER	[empty string]	PISTOL	45ACP	[empty string]	165	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Kimber KHX Custom .45 ACP	<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 Kimber KHX Custom is complete with laser-equipped Hogue Enhanced MagGrip G10 Grips and mainspring housing that form an external magwell and continuous wrap grip surface. There are green and red fiber optic sights for a bright, clear sight picture.</p><p><strong>Other Features:</strong></p><ul><li>Hexagonal slide serrations are stairstepped for additional purchase during slide manipulations</li><li>KimPro II matte black finish on slide and frame</li><li>Stiplex front strap stippling surface for confidence in grip</li><li>Hexagonal pattern extends along topstrap</li></ul>	[empty string]	Y	1299.99	1299.99	[empty string]	6686-DEFAULT-s.jpg	[empty string]	1000	1000	3000358	64799	EMPTY	EMPTY	EMPTY	0	0	0	HANDGUN	kimber/kimber-khx-custom-45-acp-64799	3000358	0
6	[empty string]	KIMBER	Kimber	FIREARMS	Firearms>Handgun	[empty string]	1	1699.99	1	1599.99	6694-DEFAULT-l.jpg	1699.99	6694-DEFAULT-m.jpg	KIMBER RAPIDE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	KIMBER	[empty string]	PISTOL	45ACP	[empty string]	165	[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]	Kimber Rapide .45 ACP 3000383	<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>Kimber Rapide 1911 .45acp 5in TiN Barrel 8rd Black 3000383 669278303833<br /></p>	[empty string]	Y	1599.99	1599.99	[empty string]	6694-DEFAULT-s.jpg	[empty string]	1000	1000	3000383	64801	EMPTY	EMPTY	EMPTY	0	0	0	HANDGUN	kimber/kimber-rapide-45-acp-3000383-64801	3000383	0
7	[empty string]	KIMBER	Kimber	FIREARMS	Firearms>Handgun	[empty string]	1	1549.99	1	1449.99	6691-DEFAULT-l.jpg	1549.99	6691-DEFAULT-m.jpg	KIMBER STAINLESS RAPTOR II	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	KIMBER	[empty string]	PISTOL	45ACP	[empty string]	165	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2	500-or-more	0.00	[empty string]	Kimber Stainless Raptor II .45 ACP	<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>Kimber gives you the cure for the common pistol. Built in the Kimber Custom Shop, Raptor .45 ACPs take their name from dynamic slide and frame serrations, feathered logo grips and finish accents. While the design theme is unique, performance is exactly what shooters expect from Kimber -- unequaled. Night sights, ambidextrous thumb safety, bumped and grooved grip safety and match grade barrel, chamber and trigger are standard. This unique pistol offers dynamic serrations, zebrawood grips, and striking finish accents.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>-Twist rate (left hand): 16</li><li>-Stainless steel match grade barrels are machined oversize and fit by hand in the Custom Shop for best accuracy</li><li>-Satin stainless steel slide and frame with polished flats for elegance, strength, and long life</li><li>-Full-length guide rod</li><li>-Trigger: Aluminum, match grade; Factory setting (approximate pounds): 4.0 - 5.0</li><li>-Tactical Wedge 3-dot Tritium night sights are self-illuminating, a low light tactical advantage</li><li>-Patented Raptor serrations offer a secure grip and uniquely-Kimber aesthetic</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	1449.99	1449.99	[empty string]	6691-DEFAULT-s.jpg	[empty string]	1000	1000	3200181	64806	EMPTY	EMPTY	EMPTY	0	0	0	HANDGUN	kimber/kimber-stainless-raptor-ii-45-acp-64806	3200181	0
8	[empty string]	KIMBER	Kimber	FIREARMS	Firearms>Handgun	[empty string]	1	1899.99	1	1499.99	11333-DEFAULT-l.jpg	1899.99	11333-DEFAULT-m.jpg	KIMBER 3200263 PISTOL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	KIMBER	[empty string]	PISTOL	45ACP	[empty string]	165	[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]	Kimber Royal II 45acp 5" Bone Grips	<ul><li>Caliber: .45 ACP</li><li>Height (inches) 90?? to barrel: 5.25</li><li>Weight (ounces) with empty magazine: 38</li><li>Length (inches): 8.7</li><li>Magazine capacity: 7 rounds</li><li>Recoil spring (pounds): 16</li><li>Full-length guide rod</li><li>FRAME</li><li>Material: Steel</li><li>Finish: Charcoal blue over highly-polished flats</li><li>Width (inches): 1.28</li><li>SLIDE</li><li>Material: Steel</li><li>Finish: Charcoal blue over highly-polished flats</li><li>Front and rear serrations</li><li>BARREL</li><li>Length (inches): 5</li><li>Material: Steel</li><li>Finish: Charcoal blue</li><li>Twist rate (left hand): 16</li><li>SIGHTS</li><li>Fixed low profile</li><li>Radius (inches): 6.8</li><li>GRIPS</li><li>Solid bone</li><li>Smooth</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><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]	Y	1499.99	1499.99	[empty string]	11333-DEFAULT-s.jpg	[empty string]	1000	1000	3200263	64808	EMPTY	EMPTY	EMPTY	0	0	0	HANDGUN	kimber/kimber-royal-ii-45acp-5-bone-grips-64808	3200263	0
9	[empty string]	KIMBER	Kimber	FIREARMS	Firearms>Handgun	[empty string]	1	1249.99	1	1149.99	19019-DEFAULT-l.jpg	1249.99	19019-DEFAULT-m.jpg	KIMBER 3000360 PISTOL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	KIMBER	[empty string]	PISTOL	45ACP	[empty string]	165	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Kimber KHX Custom Optics Ready Gray .45 ACP 5-inch 8Rds	<p>The Kimber Custom KHX OR 45acp, is a full size 1911. This is a great all around 1911 for target shooting or home protection. The KHX OR series guns are milled to accept optic plates from Leupold, Trijicon, and Vortex. For easy mounting of red dot optics.</p><p><strong>Features:</strong></p><ul><li>5"" Stainless Steel match grade barrel & stainless Steel match grade bushing.</li><li>Stainless steel slide, matte black finish with Kimpro II front slide serrations.</li><li>Stainless steel frame, matte black Kimpro II finish.</li><li>Front strap stippling.</li><li>Optics ready.</li><li>Premium aluminum, factory set to 4.0 to 5.0 lbs.</li><li>Hogue Magrip G-10 Mag Grip</li></ul><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>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	1149.99	1149.99	[empty string]	19019-DEFAULT-s.jpg	[empty string]	1000	1000	3000360	67577	EMPTY	EMPTY	EMPTY	0	0	0	HANDGUN	kimber/kimber-khx-custom-optics-ready-gray-45-acp-5-inch-8rds-67577	3000360	0
10	[empty string]	KIMBER	Kimber	FIREARMS	Firearms>Handgun	[empty string]	1	1699.99	1	1549.99	19022-DEFAULT-l.jpg	1699.99	19022-DEFAULT-m.jpg	KIMBER 3000426 PISTOL	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	KIMBER	[empty string]	PISTOL	10MM	[empty string]	165	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Kimber 1911 Custom Rapide (Scorpius) 10mm 8rd Pistol	<p>Like all of Kimber's premium 1911 handguns, the Rapide Scorpius comes fully equipped with a wide assortment of performance enhancing features. The sights are composed of Tru-Glo's TFX Pro Day/Night sights with a high contrast orange front ring, promoting fast and intuitive target acquisition even in low light environments. Like many of Kimber's 1911 handguns, the Rapide Scorpius features a match-grade barrel, but also features a DLC - not only does this give the handgun a distinct, striking appearance, but also enhances both performance and durability. To ensure optimal control over the weapon, the Rapide Scorpius is outfitted with aggressively textured G10 grips, and the frame's Stiplex front strap texture and high undercut trigger guard provide excellent grip purchase. In addition, the Rapide Scorpius's slide features lightening cuts for faster lockup, and an ambidextrous thumb safety accommodates both left and right handed shooters.</p><p><strong>Features of the Rapide Scorpius:</strong></p><ul><li>Tru-Glo's TFX Pro Day/Night Sights with high contrast orange front ring</li><li>Match-grade barrel with Gold TiN finish</li><li>Aggressively textured G10 grips</li><li>Stiplex front strap texture and high undercut trigger guard for excellent grip purchase</li><li>Lightening cuts on slide for faster lockup</li><li>Ambidextrous thumb safety</li></ul><p><strong>Specifications</strong></p><ul><li>Item ConditionNew</li><li>Caliber:10mm Auto</li><li>Action:Single Action Only Semiautomatic</li><li>Safety:Ambidextrous thumb safety</li><li>Grip Safety</li><li>Sights:Tru-Glo TFX Pro Day/Night Sights</li><li>Magazine Capacity:8 rounds</li><li>Grips:Black G10 Grips</li><li>Slide Finish:KimPro Black</li><li>Frame Finish:KimPro Black</li><li>Caliber or Gauge:10mm Auto</li><li>Pistol Night Sights:Yes</li><li>Pistol Optics Ready:No</li><li>Product TypeHandguns</li><li>UPC669278304267</li><li>MPN3000426</li></ul><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>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]	19022-DEFAULT-s.jpg	[empty string]	1000	1000	3000426	67581	EMPTY	EMPTY	EMPTY	0	0	0	HANDGUN	kimber/kimber-1911-custom-rapide-scorpius-10mm-8rd-pistol-67581	3000426	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 ( 1=2 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