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]	KIMBER	KIMBER	FIREARMS	Firearms>Pistols>Semi Auto Pistols	[empty string]	1	2640	0	2745	94552-DEFAULT-l.jpg	2640	94552-DEFAULT-m.jpg	KIMBER SUPER JAGARE 6IN 10MM	N	11 JJ	10MM	6IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	KIMBER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	2	500-or-more	0.00	[empty string]	SUPER JAGARE - 10MM - SEMI AUTO - 8 RDS	<h4>SPECIFICATIONS </h4> <ul> <li> <h4>Product #: 3000278  </h4> </li> <li> <h4>Height (inches) 90° from barrel: 5.25</h4> </li> <li>Weight (ounces) with empty magazine: 42</li> <li>Length (inches): 9.7</li> <li>Magazine capacity: 8</li> <li>Recoil spring (pounds): 18.5</li> <li>Carry melt treatment</li> <li>Ambidextrous thumb safety</li> <li>Super Carry pattern front strap checkering</li> <li>Standard or military-length guide rod</li> </ul> <h4>FRAME</h4> <ul> <li>Material: Stainless steel</li> <li>Finish: KimPro, Charcoal gray</li> <li>Width (inches): 1.28</li> <li>Round heel frame</li> <li> </li> <li>High cut under trigger guard</li> </ul> <h4>SLIDE</h4> <ul> <li>Material: Stainless steel</li> <li>Finish: Diamond-like carbon coating</li> <li>Super Carry pattern flat top</li> </ul> <h4>BARREL</h4> <ul> <li>Length (inches): 6</li> <li>Material: Stainless steel</li> <li>Twist rate (left hand): 16</li> <li>Match grade bushing</li> </ul> <h4>SIGHTS</h4> <ul> <li>DeltaPoint Pro optic</li> </ul> <h4>GRIPS</h4> <ul> <li>Micarta</li> </ul> <h4>TRIGGER</h4> <ul> <li>Solid Aluminum</li> <li>Factory setting (approximate pounds): 4-5</li> </ul>	[empty string]	N	2745	2745	[empty string]	94552-DEFAULT-s.jpg	[empty string]	1000	3000278	278708	SEMI AUTO PISTOLS	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	kimber/super-jagare-10mm-semi-auto-8-rds-278708	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts370 ORDER BY sortposition asc

Firearms

Sort By:

Items per page:

Close

Filter By

Filter

KIMBER
Super Jagare - 10mm - Semi Auto - 8 Rds
Item # 3000278 $2,745.00