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]	SCCY	Sccy	FIREARMS	Firearms>Pistols	[empty string]	1	235	0	240	56591-DEFAULT-l.jpg	235	56591-DEFAULT-m.jpg	SCCY CPX-1 MAN SAFTY 9MM BLUE	N	11 JJ	9MM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	SCCY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	PISTOL	3	200-to-250	0.00	[empty string]	Cpx-1 Cb - 9mm - Dao - 10 Rds - Black	<p>SPECIFICATIONS:<br /> -Model: SCCY CPX-1 CB<br /> -Item Number: CPX-1CB<br /> -Barrel: machined from bar stock with 7 lands and grooves having a 16?1 right hand twist.<br /> -Receiver: 7075?T6 aircraft grade heat treated aluminum alloy, machined from bar stock.<br /> -Grip/Frame: Made from Zytel polymer, with ergonomic finger grooves and an integral ``RE-COIL CUSHION`` on the back?strap.<br /> -Recoil Spring System: all steel, fully encapsulated for ease of disassembly and reassembly.<br /> -Slide Lock/Release: steel with a Zytel over molded polymer extension for ease of operation.<br /> -3 dot sight system: steel rear sight, adjustable for windage only with locking screw.<br /> -Hammer firing system: double action only, internal hammer with inertial firing pin to prevent accidental discharge if dropped.<br /> -Manual Guarded Safety: Newly designed with a guard molded into the frame.<br /> -Double action trigger: specifically designed for shooter comfort and accuracy by designing the system to have a smooth effortless, consistent 9 pound trigger pull.<br /> -Magazine: included with (2) double stack, 10 round capacity magazines with finger extension base installed and 2 flat magazine bases included.<br /> -Trigger Guard Lock: custom designed to properly fit and be child resistant. Includes 2 keys.<br /> -Barrel Length: 3.1``<br /> -Height: 4``<br /> -Length: 5.7``<br /> -Width: 1``<br /> -Weight: 15oz</p>	[empty string]	N	240	240	[empty string]	56591-DEFAULT-s.jpg	[empty string]	1000	CPX-1CB	160333	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	sccy/sccy-cpx-1-man-safty-9mm-blue-160333	1
2	[empty string]	SCCY	Sccy	FIREARMS	Firearms>Magazines	[empty string]	1	26.99	0	31.99	69745-DEFAULT-l.jpg	26.99	69745-DEFAULT-m.jpg	10RD MAG CPX SERIES	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]	10	25-to-50	0.00	[empty string]	10rd Mag Cpx Series	This 10-round magazines fits SCCY`s CPX-1 and CPX-2`s chambered in 9mm.	[empty string]	N	31.99	31.99	[empty string]	69745-DEFAULT-s.jpg	[empty string]	1000	01-006	161772	EMPTY	EMPTY	EMPTY	0	0	0	MAGAZINES	[empty string]	sccy/10rd-mag-cpx-series-161772	1
3	[empty string]	SCCY	Sccy	FIREARMS	Firearms>Pistols	[empty string]	1	235	0	240	57420-DEFAULT-l.jpg	235	57420-DEFAULT-m.jpg	SCCY CPX-1 MAN SAFTY 10RND 9MM BLUE	N	11 JJ	9MM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	SCCY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	PISTOL	1	200-to-250	0.00	[empty string]	Cpx-1 Tt - 9mm - Dbl - 10 Rds - Stainless And Black	<p>SPECIFICATIONS:<br /> -Model: SCCY CPX-1 TT Stainless steel & black, manual safety<br /> -Item Number: CPX-1 TT<br /> -Caliber: 9mm<br /> -Barrel Length: 3.1``<br /> -Height: 4``<br /> -Length: 5.7``<br /> -Width: 1``<br /> -Weight: 15oz<br /> -Barrel: machined from bar stock with 7 lands and grooves having a 16?1 right hand twist.<br /> -Receiver: 7075?T6 aircraft grade heat treated aluminum alloy, machined from bar stock.<br /> -Grip/Frame: Made from Zytel polymer, with ergonomic finger grooves and an integral ``RE-COIL CUSHION on the back?strap.<br /> -Recoil Spring System: all steel, fully encapsulated for ease of disassembly and reassembly.<br /> -Slide Lock/Release: steel with a Zytel over molded polymer extension for ease of operation.<br /> -3 dot sight system: steel rear sight, adjustable for windage only with locking screw.<br /> -Hammer firing system: double action only, internal hammer with inertial firing pin to prevent accidental discharge if dropped.<br /> -Manual Guarded Safety: Newly designed with a guard molded into the frame.<br /> -Double action trigger: specifically designed for shooter comfort and accuracy by designing the system to have a smooth effortless, consistent 9 pound trigger pull.<br /> -Magazine: included with (2) double stack, 10 round capacity magazines with finger extension base installed and 2 flat magazine bases included.<br /> -Trigger Guard Lock: custom designed to properly fit and be child resistant. Includes 2 keys.</p>	[empty string]	N	240	240	[empty string]	57420-DEFAULT-s.jpg	[empty string]	1000	CPX-1TT	166087	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	sccy/sccy-cpx-1-man-safty-10rnd-9mm-blue-166087	1
4	[empty string]	SCCY	Sccy	FIREARMS	Firearms>Pistols	[empty string]	1	235	0	240	57720-DEFAULT-l.jpg	235	57720-DEFAULT-m.jpg	SCCY CPX-1 9MM FDE	N	11 JJ	9MM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	SCCY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	SEMI AUTO	PISTOL	2	200-to-250	0.00	[empty string]	Cpx-1 Cbde - 9mm - Dbl - 10 Rds - Black - Flat Dark Earth	<p>SPECIFICATIONS:<br /> -Model: SCCY CPX-1 CBDE<br /> -Item Number: CPX-1 CBDE<br /> -Barrel Length: 3.1``<br /> -Height: 4``<br /> -Length: 5.7``<br /> -Width: 1``<br /> -Weight: 15oz<br /> -Barrel: machined from bar stock with 7 lands and grooves having a 16?1 right hand twist.<br /> -Receiver: 7075?T6 aircraft grade heat treated aluminum alloy, machined from bar stock.<br /> -Grip/Frame: Made from Zytel polymer, with ergonomic finger grooves and an integral ``RE-COIL CUSHION`` on the back?strap.<br /> -Recoil Spring System: all steel, fully encapsulated for ease of disassembly and reassembly.<br /> -Slide Lock/Release: steel with a Zytel over molded polymer extension for ease of operation.<br /> -3 dot sight system: steel rear sight, adjustable for windage only with locking screw.<br /> -Hammer firing system: double action only, internal hammer with inertial firing pin to prevent accidental discharge if dropped.<br /> -Manual Guarded Safety: Newly designed with a guard molded into the frame.<br /> -Double action trigger: specifically designed for shooter comfort and accuracy by designing the system to have a smooth effortless, consistent 9 pound trigger pull.<br /> -Magazine: included with (2) double stack, 10 round capacity magazines with finger extension base installed and 2 flat magazine bases included.<br /> -Trigger Guard Lock: custom designed to properly fit and be child resistant. Includes 2 keys.</p>	[empty string]	N	240	240	[empty string]	57720-DEFAULT-s.jpg	[empty string]	1000	CPX-1CBDE	278360	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	sccy/sccy-cpx-1-9mm-fde-278360	1
5	[empty string]	SCCY	Sccy	FIREARMS	Firearms>Pistols	[empty string]	1	235	0	240	57419-DEFAULT-l.jpg	235	57419-DEFAULT-m.jpg	SCCY CPX-1 9MM GRAY	N	11 JJ	9MM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	SCCY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	1	200-to-250	0.00	[empty string]	Sccy Cpx-1 9mm Gray	SCCY`s CPX-1 is designed for concealed carry but large enough to get a good firm grip. It is considered to be one of the best priced, precision made `Pocket Pistols` on the market. Chambered for 9mm, it has a 3.1` barrel with a 16:1` right hand twist. The receiver is made from 7075 T6 aircraft grade heat treated aluminum alloy. The Zytel polymer frame features ergonomic finger grooves and an integral recoil cushion on the backstrap. The slide is machined from stainless steel with a Zytel overmolded polymer extension for ease of operation. It has 3-dot sights with a windage-adjustable rear. This DAO has an internal hammer with inertial firing pin to prevent accidental discharge, and an external thumb safety with a guard molded into the frame. It has a smooth, consistent 9-pound trigger pull. It comes with two 10-round magazines with finger extensions bases installed and two flat magazine bases. This CPX-1 has a black nitride slide with a gray frame.	[empty string]	N	240	240	[empty string]	57419-DEFAULT-s.jpg	[empty string]	1000	CPX-1CBSG	301720	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	sccy/sccy-cpx-1-9mm-gray-301720	1
6	[empty string]	SCCY	Sccy	FIREARMS	Firearms>Shotguns	[empty string]	0	225	0	370	[empty string]	225	[empty string]	SCCY CPX-2 9MM BLUE RED DOT	N	11 JJ	9MM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	SCCY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	2	350-to-400	0.00	[empty string]	Sccy Cpx-2 9mm Blue Red Dot	[empty string]	[empty string]	N	370	370	[empty string]	[empty string]	[empty string]	1000	CPX-2CBRD	335457	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	sccy/sccy-cpx-2-9mm-blue-red-dot-335457	1
7	[empty string]	SCCY	Sccy	FIREARMS	Firearms>Pistols	[empty string]	0	370	0	370	[empty string]	370	[empty string]	SCCY CPX-2 9MM R EGG NIDTRIDE RED DOT	N	11 JJ	9MM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	SCCY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	1	350-to-400	0.00	[empty string]	Sccy Cpx-2 9mm R Egg Nidtride Red Dot	[empty string]	[empty string]	N	370	370	[empty string]	[empty string]	[empty string]	1000	CPX-2CBSBRD	344619	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	sccy/sccy-cpx-2-9mm-r-egg-nidtride-red-dot-344619	1
8	[empty string]	SCCY	Sccy	FIREARMS	Firearms>Pistols	[empty string]	0	380	0	380	[empty string]	380	[empty string]	SCCY CPX-1 9MM BLACK RED DOT	N	11 JJ	9MM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	SCCY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	1	350-to-400	0.00	[empty string]	Sccy Cpx-1 9mm Black Red Dot	[empty string]	[empty string]	N	380	380	[empty string]	[empty string]	[empty string]	1000	CPX-1CBRD	345058	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	sccy/sccy-cpx-1-9mm-black-red-dot-345058	1
9	[empty string]	SCCY	Sccy	FIREARMS	Firearms>Pistols	[empty string]	0	380	0	380	[empty string]	380	[empty string]	SCCY CPX-2 9MM SS/BLK PISTOL	N	11 JJ	9MM	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	SCCY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SEMI AUTO	PISTOL	1	350-to-400	0.00	[empty string]	Sccy Cpx-2 9mm Ss/blk Pistol	[empty string]	[empty string]	N	380	380	[empty string]	[empty string]	[empty string]	1000	CPX-2TTRD	355051	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	sccy/sccy-cpx-2-9mm-ss-blk-pistol-355051	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter