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]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	47.99	0	47.99	65612-DEFAULT-l.jpg	47.99	65612-DEFAULT-m.jpg	KAHR K920 MAGAZINE	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Kahr K920 Magazine	The Kahr magazine tube is constructed of corrosive resistant 400 series stainless steel and heat treated to 50 rockwell hardness for durability.	[empty string]	N	47.99	47.99	[empty string]	65612-DEFAULT-s.jpg	[empty string]	1000	K920	35288	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-k920-magazine-35288	1
2	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	43.99	0	43.99	65588-DEFAULT-l.jpg	43.99	65588-DEFAULT-m.jpg	KAHR MK720 MAGAZINE	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Kahr Mk720 Magazine	The Kahr magazine tube is constructed of corrosive resistant 400 series stainless steel and heat treated to 50 rockwell hardness for durability.	[empty string]	N	43.99	43.99	[empty string]	65588-DEFAULT-s.jpg	[empty string]	1000	MK720	35299	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-mk720-magazine-35299	1
3	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Rifles	[empty string]	1	1390	0	1540	43805-DEFAULT-l.jpg	1390	43805-DEFAULT-m.jpg	AUTO-ORDNANCE T1 TOMMY GUN SEMI AUTO	N	11 JJ	45 AUTO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	AUTO ORDNANCE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	RIFLE	1	500-or-more	0.00	[empty string]	1927a-1 Deluxe Semi Auto - 45 Acp - Walnut	<p>SPECIFICATIONS:<br /> -Model: T1<br /> -Caliber: .45 ACP<br /> -Barrel: 16.5`` Finned (with compensator 18``)<br /> -Weight: 13 lbs<br /> -Length: 41`` overall<br /> -Sight: Blade front, open rear adjustable<br /> -Stock: Walnut fixed stock and vertical foregrip<br /> -Magazines: One 30 Round Stick Magazine<br /> -Warranty: 1 year</p>	[empty string]	N	1540	1540	[empty string]	43805-DEFAULT-s.jpg	[empty string]	1000	T1	35305	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	kahr-arms/auto-ordnance-t1-tommy-gun-semi-auto-35305	1
4	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	78.99	0	78.99	66472-DEFAULT-l.jpg	78.99	66472-DEFAULT-m.jpg	KAHR AUTO ORD T11 MAGAZINE	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Kahr Auto Ord T11 Magazine	Auto Ordnance Mag 45 ACP 30Rd Blue 1927 T11. Replacement magazine.	[empty string]	N	78.99	78.99	[empty string]	66472-DEFAULT-s.jpg	[empty string]	1000	T11	35306	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-auto-ord-t11-magazine-35306	1
5	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Rifles	[empty string]	1	1630	0	1835	66470-DEFAULT-l.jpg	1630	66470-DEFAULT-m.jpg	AUT-ORD TOMMY GUN 45 ACP SA RIFLE	N	11 JJ	45 AUTO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	AUTO ORDNANCE	[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]	Aut-ord Tommy Gun 45 Acp Sa Rifle	Thompson 1927A-1 `Deluxe Semi-Auto` with 50 round drum magazine. All the classic details of the time honored original are reproduced in today`s semi-auto Thompson. The frame and receiver are machined from solid steel or aluminum. The wood is genuine American walnut. This .45 caliber carbine features a 16 1/2` finned barrel, compensator and is available with a blued steel receiver or a lighter weight aluminum receiver. This configuration is our most popular model.	[empty string]	N	1835	1835	[empty string]	66470-DEFAULT-s.jpg	[empty string]	1000	T150D	35307	EMPTY	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	kahr-arms/aut-ord-tommy-gun-45-acp-sa-rifle-35307	1
6	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	43.99	0	43.99	65595-DEFAULT-l.jpg	43.99	65595-DEFAULT-m.jpg	KAHR MK620 MK9 6RD	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	14	25-to-50	0.00	[empty string]	Kahr Mk620 Mk9 6rd	The Kahr magazine tube is constructed of corrosive resistant 400 series stainless steel and heat treated to 50 rockwell hardness for durability.	[empty string]	N	43.99	43.99	[empty string]	65595-DEFAULT-s.jpg	[empty string]	1000	MK620	84218	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-mk620-mk9-6rd-84218	1
7	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	43.99	0	43.99	67434-DEFAULT-l.jpg	43.99	67434-DEFAULT-m.jpg	KAHR P380 380ACP 6RD MAG	N	11 JJ	380 AUTO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	6	25-to-50	0.00	[empty string]	Kahr P380 380acp 6rd Mag	The Kahr magazine tube is constructed of corrosive resistant 400 series stainless steel and heat treated to 50 rockwell hardness for durability.	[empty string]	N	43.99	43.99	[empty string]	67434-DEFAULT-s.jpg	[empty string]	1000	K386	98748	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-p380-380acp-6rd-mag-98748	1
8	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	0	38.99	0	38.99	[empty string]	38.99	[empty string]	KAHR 30CAR 15RD MAGAZINE	N	11 JJ	30 CARBINE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	Kahr 30car 15rd Magazine	You can finally put your collectible USGI magazines away, and use these for every day blasting at the range. These magazines have been manufactured from the ground up with 100% reliability being the primary focus. No corners have been cut to maximize profits at the expense of quality.	[empty string]	N	38.99	38.99	[empty string]	[empty string]	[empty string]	1000	MC3015	138427	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-30car-15rd-magazine-138427	1
9	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	0	47.99	0	47.99	[empty string]	47.99	[empty string]	KAHR 7RD SS MAG 40SW	N	11 JJ	40 SW	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Kahr 7rd Ss Mag 40sw	This magazine will fit all Kahr 40 S&W models and has a max capacity of 7-rounds.	[empty string]	N	47.99	47.99	[empty string]	[empty string]	[empty string]	1000	K720	260189	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-7rd-ss-mag-40sw-260189	1
10	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	1	75.99	0	75.99	88558-DEFAULT-l.jpg	75.99	88558-DEFAULT-m.jpg	KAHR AUTO ORD T10 20 RDS 45ACP MAGAZINE	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	50-to-100	0.00	[empty string]	Kahr Auto Ord T10 20 Rds 45acp Magazine	[empty string]	[empty string]	N	75.99	75.99	[empty string]	88558-DEFAULT-s.jpg	[empty string]	1000	T10	300529	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-auto-ord-t10-20-rds-45acp-magazine-300529	1
11	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Pistols	[empty string]	1	695	0	820	65331-DEFAULT-l.jpg	695	65331-DEFAULT-m.jpg	1911 A1 #80 WOOD GRIP S/A PISTOL	N	11 JJ	45 ACP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	AUTO ORDNANCE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	9	500-or-more	0.00	[empty string]	1911 A1 #80 Wood Grip S/a Pistol	The Auto-Ordnance 1911BKO frame incorporates GI specs, and features a matte black finished frame, barrel, and slide. The carbon steel slide, sear, and disconnector are machined from solid bar stock, then heat treated properly to assure durability and long life over many thousands of rounds. The low-profile sights feature a blade front sight and a rear drift adjustable for windage. This model 1911 pistol is chambered in .45 ACP, has a 5` barrel, 8.5` overall length, and weighs 39 oz. The 1911BKO is 100% made in the USA, and ships with one 7-round magazine. The BKO has a thumb safety, grip safety, and firing pin block.	[empty string]	N	820	820	[empty string]	65331-DEFAULT-s.jpg	[empty string]	1000	1911BKOW	301411	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	kahr-arms/1911-a1-80-wood-grip-s-a-pistol-301411	1
12	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Pistols	[empty string]	1	1195	0	1360	88559-DEFAULT-l.jpg	1195	88559-DEFAULT-m.jpg	1911 A1 CASE HARDENED 45ACP S/A PISTOL	N	11 JJ	45 ACP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	AUTO ORDNANCE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	1	500-or-more	0.00	[empty string]	1911 A1 Case Hardened 45acp S/a Pistol	[empty string]	[empty string]	N	1360	1360	[empty string]	88559-DEFAULT-s.jpg	[empty string]	1000	1911GCH	315922	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	kahr-arms/1911-a1-case-hardened-45acp-s-a-pistol-315922	1
13	[empty string]	KAHR ARMS	Kahr Arms	FIREARMS	Firearms>Magazines	[empty string]	0	48.99	0	48.99	[empty string]	48.99	[empty string]	KAHR 30CAR 30RD MAGAZINE	N	11 JJ	30 CARBINE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Kahr 30car 30rd Magazine	[empty string]	[empty string]	N	48.99	48.99	[empty string]	[empty string]	[empty string]	1000	MC3030	315926	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	kahr-arms/kahr-30car-30rd-magazine-315926	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter