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]	BLACKHAWK PRODUCTS	BLACKHAWK PRODUCTS	FIREARMS	Firearms>Holsters	[empty string]	1	22.99	0	22.99	18456-DEFAULT-l.jpg	22.99	18456-DEFAULT-m.jpg	CQC SINGLE ROW MAGE HOLDER	N	16 DEVON	[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	NOT ONLINE	[empty string]	[empty string]	5	20-to-25	0.00	[empty string]	Single Stack Mag Case - 9mm / .40 Cal - Matte Finish - Black	In the Carbon-Fiber Composite line, Blackhawk offers single magazine pouches for both 9mm/40 cal. singlestack mags and 9mm/40 cal. double-stack mags. These have a built-in tension spring that keeps your mag secure but allow rapid removal when you need it. They also offer two different light carriers, one for the detachable pistol lights, such as the M-3 style and one for small personal lights, like the Streamlight and Surefire lights.<br/> <br/> The magazine pouches have a built-in tension spring, to hold your magazine in place until you need it and to allow the use of a variety of magazines in each pouch. The most interesting thing about these magazine pouches is that the unique belt clip can be removed and they can be placed side by side on our Dual Rail Accessory Platform, for those wanting a double magazine pouch, on the same carrier. Or, they can be placed beside one of the light carriers, for a combo light/mag carrier. <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	22.99	22.99	[empty string]	18456-DEFAULT-s.jpg	[empty string]	1000	410500PBK	7967	EMPTY	EMPTY	EMPTY	0	0	0	HOLSTERS	[empty string]	blackhawk-products/cqc-single-row-mage-holder-7967	1
2	[empty string]	BLACKHAWK PRODUCTS	BLACKHAWK PRODUCTS	FIREARMS	Firearms>Holsters	[empty string]	1	23.99	0	23.99	13399-DEFAULT-l.jpg	23.99	13399-DEFAULT-m.jpg	CQC SINGLE MAG CASE CARBON FIBER	N	16 DEVON	[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	ONLINE	[empty string]	[empty string]	3	20-to-25	0.00	[empty string]	Double Stack Mag Case - Carbon Fiber Finish	<p>In the carbon-fiber composite line, Blackhawk offers single magazine cases for 9mm/40 cal/.45 cal/10mm single-stack mags and 9mm/40 cal double-stack mags. Built-in tension springs keep your magazine secure but allow rapid removal when you need it.They also offer two different light carriers: one for detachable pistol lights like the M-3 style and one for small personal lights like the Streamlight and Surefire lights.</p>	[empty string]	N	23.99	23.99	[empty string]	13399-DEFAULT-s.jpg	[empty string]	1000	410600CBK	7977	EMPTY	EMPTY	EMPTY	0	0	0	HOLSTERS	[empty string]	blackhawk-products/cqc-single-mag-case-carbon-fiber-7977	1
3	[empty string]	BLACKHAWK PRODUCTS	BLACKHAWK PRODUCTS	FIREARMS	Firearms>Holsters	[empty string]	1	22.99	0	22.99	13400-DEFAULT-l.jpg	22.99	13400-DEFAULT-m.jpg	CQC DBL ROW MAG CASE	N	16 DEVON	[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	ONLINE	[empty string]	[empty string]	1	20-to-25	0.00	[empty string]	Double Stack Mag Case - Matte Finish	<p>In the Carbon-Fiber Composite line, Blackhawk offers single magazine pouches for both 9mm/40 cal. single-stack mags and 9mm/40 cal. double-stack mags. These have molded-in tension springs that keep your mag secure but allow rapid removal when you need it. They also offer two different light carriers, one for the detachable pistol lights, such as the M-3 style and one for small personal lights, like the Streamlight and Surefire lights.<br /> <br /> The magazine pouches have a built-in tension spring, to hold your magazine in place until you need it and to allow the use of a variety of magazines in each pouch. The most interesting thing about the magazine pouches is that the unique belt clip can be removed and they can be placed side by side on the Dual Rail Accessory Platform, for those wanting a double magazine pouch, on the same carrier. Or, they can be placed beside one of Blackhawk`s light carriers, for a combo light/mag carrier.</p>	[empty string]	N	22.99	22.99	[empty string]	13400-DEFAULT-s.jpg	[empty string]	1000	410600PBK	7978	EMPTY	EMPTY	EMPTY	0	0	0	HOLSTERS	[empty string]	blackhawk-products/cqc-dbl-row-mag-case-7978	1
4	[empty string]	BLACKHAWK PRODUCTS	BLACKHAWK PRODUCTS	FIREARMS	Firearms>Storage>Cases	[empty string]	1	43.99	0	43.99	102773-DEFAULT-l.jpg	43.99	102773-DEFAULT-m.jpg	SPORSTER TACTICAL RIFLE CASE	N	16 DEVON	[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	ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	SPORTSTER TACTICAL RIFLE CASE	<ul> <li>Tight-weave 600 denier polyester with thick PVC laminate and dual-density foam padding</li> <li>Holds rifles up to 42.5” long (74SG02) or 44” long (74SG03)</li> <li>Five external mag pockets and two large accessory pockets for gear</li> <li>Size: Small</li> </ul>	[empty string]	N	43.99	43.99	[empty string]	102773-DEFAULT-s.jpg	[empty string]	1000	74SG02BK	95115	EMPTY	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	blackhawk-products/sportster-tactical-rifle-case-95115	1
5	[empty string]	BLACKHAWK PRODUCTS	BLACKHAWK PRODUCTS	FIREARMS	Firearms>Slings	[empty string]	1	39.99	0	39.99	98971-DEFAULT-l.jpg	39.99	98971-DEFAULT-m.jpg	STORM XT SLING BLACK	N	16 DEVON	[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	NOT ONLINE	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	STORM SINGLE-POINT SLINGS	<p>This unique single-point sling is constructed of high-strength 1.25" wide nylon webbing with an elliptical bungee for comfort and support. It adjusts from 46" to 64" in diameter and also features robust bar tacking and box stitching for maximum strength.</p> <ul> <li>4 flex for weapon agility and CQB tactics</li> <li>Compressed tubular nylon sheathing limits bounce and enhances retention</li> <li>Elliptical bungee provides comfort and support</li> <li>Single-point sling design</li> <li>Elastic-encased mash clip for single-point weapon attachment</li> </ul>	[empty string]	N	39.99	39.99	[empty string]	98971-DEFAULT-s.jpg	[empty string]	1000	70GS16BK	97101	EMPTY	EMPTY	EMPTY	0	0	0	SLINGS	[empty string]	blackhawk-products/storm-single-point-slings-97101	1
6	[empty string]	BLACKHAWK PRODUCTS	BLACKHAWK PRODUCTS	FIREARMS	Firearms>Holsters	[empty string]	1	31.99	0	31.99	13623-DEFAULT-l.jpg	31.99	13623-DEFAULT-m.jpg	CQC DBL MAG CASE MATTE FINISH	N	16 DEVON	[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	ONLINE	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	Double Mag Case - Double Stack - 9mm/.40 Cal	<p>FEATURES:<br /> - Double the capacity of the Single Mag Case<br /> - Built-in tension spring securely holds magazines of various sizes<br /> - Available in both single-stack and staggered column magazine versions<br /> - Includes belt loops and belt clip<br /> - Adjustable belt-clip hook for belts of different widths<br /> - Curved to waistline for slimmer profile<br /> - Fits 9MM/.40 Cal</p>	[empty string]	N	31.99	31.99	[empty string]	13623-DEFAULT-s.jpg	[empty string]	1000	410610PBK	97742	EMPTY	EMPTY	EMPTY	0	0	0	HOLSTERS	[empty string]	blackhawk-products/cqc-dbl-mag-case-matte-finish-97742	1
7	[empty string]	BLACKHAWK PRODUCTS	BLACKHAWK PRODUCTS	FIREARMS	Firearms>Slings	[empty string]	1	27.99	0	27.99	13790-DEFAULT-l.jpg	27.99	13790-DEFAULT-m.jpg	KUDU STRETCH SLING WITH SWIVELS	N	16 DEVON	[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	NOT ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Kudu Stretch Sling With Swivels	FEATURES:<br/> - Constructed of high-quality 2`` nylon webbing<br/> - Elastic webbing conforms to shoulder for comfort and ease of carry<br/> - Fully adjustable length to fit all body sizes and around bulky tactical vests or gear<br/> - Strap features integrated non-slip rubber ribs<br/> - Includes two 1`` LOK-DOWN swivels<br/> - Compatible with a wide variety of rifles and shotguns<br/> - Fully adjustable, ambidextrous design <br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	27.99	27.99	[empty string]	13790-DEFAULT-s.jpg	[empty string]	1000	73KS01BK	114691	EMPTY	EMPTY	EMPTY	0	0	0	SLINGS	[empty string]	blackhawk-products/kudu-stretch-sling-with-swivels-114691	1
8	[empty string]	BLACKHAWK PRODUCTS	BLACKHAWK PRODUCTS	FIREARMS	Firearms>Slings	[empty string]	1	39.99	0	39.99	13784-DEFAULT-l.jpg	39.99	13784-DEFAULT-m.jpg	UNIVERSAL SWIFT SLING 3 POINT SLING	N	16 DEVON	[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	NOT ONLINE	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Universal Swift Sling - 3 Point	FEATURES:<br/> - Constructed of high-quality 1.25`` nylon webbing<br/> - Three-point sling design for fixed or collapsible stocks<br/> - Quick-cam buckle provides rapid one-hand adjustment<br/> - Heavy-duty tri-glide buckle, metal oval ring, and 300 lb. test side-release buckle for quick sling detachment, firearm attachment, and weapon removal<br/> - Quick shoulder-to-shoulder transition<br/> - Fully adjustable, ambidextrous design<br/> - Robust bar tacking and box stitching for maximum strength<br/> - Replaces ALL previous versions of BLACKHAWK! Swift Slings<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	39.99	39.99	[empty string]	13784-DEFAULT-s.jpg	[empty string]	1000	70GS17BK	117151	EMPTY	EMPTY	EMPTY	0	0	0	SLINGS	[empty string]	blackhawk-products/universal-swift-sling-3-point-sling-117151	1
9	[empty string]	BLACKHAWK PRODUCTS	BLACKHAWK PRODUCTS	FIREARMS	Firearms>Slings	[empty string]	1	24.99	0	24.99	18535-DEFAULT-l.jpg	24.99	18535-DEFAULT-m.jpg	STORM SINGLE POINT SLING	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2011	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	20-to-25	0.00	[empty string]	Storm Single Point Sling Qd - 1 Pt	FEATURES:<BR/> - Constructed of high-quality 1.25`` nylon webbing<BR/> - Single-point sling design<BR/> - Removable, elastic-encased MASH Clip for quick, positive firearm attachment<BR/> - Heavy-duty tri-glide buckle, metal oval ring, and dual 300 lb. test side-release buckles for quick sling detachment, firearm attachment, and weapon removal<BR/> - Adjusts from 30`` to 50`` in diameter with tri-glide buckle to fit all body sizes and around bulky tactical vests or gear<BR/> - Robust bar tacking and box stitching for maximum strength<BR/>	[empty string]	N	24.99	24.99	[empty string]	18535-DEFAULT-s.jpg	[empty string]	1000	70GS15BK	128429	EMPTY	EMPTY	EMPTY	0	0	0	SLINGS	[empty string]	blackhawk-products/storm-single-point-sling-128429	1
10	[empty string]	BLACKHAWK PRODUCTS	BLACKHAWK PRODUCTS	FIREARMS	Firearms>Slings	[empty string]	1	39.99	0	39.99	98972-DEFAULT-l.jpg	39.99	98972-DEFAULT-m.jpg	STORM SLING RS	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2013	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	STORM SINGLE-POINT SLINGS	<p>This unique single-point sling is constructed of high-strength 1.25" wide nylon webbing with an elliptical bungee for comfort and support. It adjusts from 46" to 64" in diameter and also features robust bar tacking and box stitching for maximum strength.</p> <ul> <li>4 flex for weapon agility and CQB tactics</li> <li>Compressed tubular nylon sheathing limits bounce and enhances retention</li> <li>Elliptical bungee provides comfort and support</li> <li>Single-point sling design</li> <li>Elastic-encased mash clip for single-point weapon attachment</li> </ul>	[empty string]	N	39.99	39.99	[empty string]	98972-DEFAULT-s.jpg	[empty string]	1000	70GS20BK	160677	EMPTY	EMPTY	EMPTY	0	0	0	SLINGS	[empty string]	blackhawk-products/storm-single-point-slings-160677	1
11	CT,BLK	BLACKHAWK PRODUCTS	BLACKHAWK PRODUCTS	FIREARMS	Firearms>Holsters	CT\|NULL\|NULL,BLK\|NULL\|NULL	1	24.99	0	24.99	85766-DEFAULT-l.jpg	24.99	85766-DEFAULT-m.jpg	TECGRIP IWB HOLSTER	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2016	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	16	20-to-25	0.00	[empty string]	Tecgrip Iwb Holster	[empty string]	[empty string]	N	24.99	24.99	02,03,06	85766-DEFAULT-s.jpg	[empty string]	1000	40IP	273813	EMPTY	EMPTY	EMPTY	0	0	0	HOLSTERS	[empty string]	blackhawk-products/tecgrip-iwb-holster-273813	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Size

Filter