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]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	520	0	520	64561-DEFAULT-l.jpg	520	64561-DEFAULT-m.jpg	BOND ARMS COWBOY DEFENDER O/U PISTOL	N	11 JJ	45 COLT/410	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	BOND ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	OVER/UNDER	PISTOL	2	500-or-more	0.00	[empty string]	Bond Arms Cowboy Defender O/u Pistol	The Cowboy Defender by Bond Arms was designed for Cowboy Action Shooting and to be the most compact concealed-carry 410 shotshell protection available. This derringer is available in 45 Colt (LC)/410 gauge, and it`s compatible with all Bond Arms interchangeable barrels. The spring-loaded cammed locking lever allows for a tighter barrel/frame fit and rapid loading and unloading. The Cowboy Defender features a cross-bolt safety and laminated rosewood stocks. This model does NOT have a trigger guard.	[empty string]	N	520	520	[empty string]	64561-DEFAULT-s.jpg	[empty string]	1000	BACD45410L	8793	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bond-arms-cowboy-defender-o-u-pistol-8793	1
2	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	625	0	625	55391-DEFAULT-l.jpg	625	55391-DEFAULT-m.jpg	BNDARMS SNAKESLAYER IV 45LC/410 O/U PIST	N	11 JJ	45 COLT/410	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	BOND ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	OVER/UNDER	PISTOL	1	500-or-more	0.00	[empty string]	Snake Slayer Iv - Over/under - 45lc/.410 - Sa - 2 Rds	<p>SPECIFICATIONS:<br /> -Model: Snake Slayer IV<br /> -Item Number: BASS4<br /> -Caliber: .45LC/.410<br /> -Action: Single Action<br /> -Barrel: 4.25``<br /> -Grip: Extended Rosewood<br /> -Sights: Front blade, fixed rear<br /> -Rounds: 2<br /> -Length: 6.25``<br /> -Weight: 23.5 oz<br /> -Features: Stainless steel double-barrel and frame, Compatible with all Bond Arms barrels, Automatic spent casing extractor, Patented rebounding hammer, Retracting ring pins, Cross-bolt safety and Spring-loaded, cammed locking lever.</p>	[empty string]	N	625	625	[empty string]	55391-DEFAULT-s.jpg	[empty string]	1000	BASS4	8795	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bndarms-snakeslayer-iv-45lc-410-o-u-pist-8795	1
3	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	520	0	520	55389-DEFAULT-l.jpg	520	55389-DEFAULT-m.jpg	BOND ARMS TEXAS DEFENDER O/U PISTOL	N	11 JJ	45 COLT/410	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	BOND ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	OVER/UNDER	PISTOL	1	500-or-more	0.00	[empty string]	Texas Defender - Over/under - 45 Colt/.410 - Sa - 2 Rds	<p>SPECIFICATIONS:<br /> -Model: Texas Defender<br /> -Item Number: BATD45/410<br /> -Caliber: .45Colt / .410<br /> -Action: Single Action<br /> -Barrel: 3.0``<br /> -Grip: Rosewood<br /> -Sights: Front blade, fixed rear<br /> -Length: 5.0``<br /> -Weight: 20.0<br /> -Features: Stainless steel double-barrel and frame, Compatible with all Bond Arms barrels, Automatic spent casing extractor, Patented rebounding hammer, Retracting ring pins, Cross-bolt safety, Spring-loaded and cammed locking lever.</p>	[empty string]	N	520	520	[empty string]	55389-DEFAULT-s.jpg	[empty string]	1000	BATD45/410	8798	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bond-arms-texas-defender-o-u-pistol-8798	1
4	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	580	0	580	55413-DEFAULT-l.jpg	580	55413-DEFAULT-m.jpg	BONDARMS SNAKESLAYER 45/410 O/U PISTOL	N	11 JJ	45 COLT/410	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	BOND ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	OVER/UNDER	PISTOL	4	500-or-more	0.00	[empty string]	Snake Slayer - Over/under - 45lc/.410 - Sa - 2 Rds - 3.5`` Bbl	<p>SPECIFICATONS:<br /> -Model: Snake Slayer<br /> -Item Number: BASS<br /> -Caliber: .45LC/.410<br /> -Action: Single Action<br /> -Barrel: 3.5``<br /> -Grip: Extended Rosewood<br /> -Sights: Front blade, fixed rear<br /> -Rounds: 2<br /> -Length: 5.5``<br /> -Weight: 22.0 oz<br /> -Features: Stainless steel double-barrel and frame, Compatible with all Bond Arms barrels, Automatic spent casing extractor, Patented rebounding hammer, Retracting ring pins, Cross-bolt safety and Spring-loaded, cammed locking lever.</p>	[empty string]	N	580	580	[empty string]	55413-DEFAULT-s.jpg	[empty string]	1000	BASS	89291	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bondarms-snakeslayer-45-410-o-u-pistol-89291	1
5	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	730	0	730	55758-DEFAULT-l.jpg	730	55758-DEFAULT-m.jpg	BOND ARMS RANGER II 45 410 4.25IN PISTO	N	11 JJ	45 COLT/410	4.25 IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	BOND ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	OVER/UNDER	PISTOL	2	500-or-more	0.00	[empty string]	Ranger Ii - Over/under - 45lc/.410 - Sa - 2 Rds	<p>SPECIFICATIONS:<br /> -Model: Ranger II<br /> -Item Number: BARII<br /> -Caliber: .45LC/.410<br /> -Barrel: 4.25``<br /> -Grip: Black Ash with Metal Star<br /> -Sights: Front blade, fixed rear<br /> -Length: 6.25``<br /> -Weight: 23.5 oz.<br /> -Features: Automatic spent casing extractor, Patented rebounding hammer, Retracting ring pins, Cross-bolt safety, Spring-loaded, cammed locking lever.</p>	[empty string]	N	730	730	[empty string]	55758-DEFAULT-s.jpg	[empty string]	1000	BARII	149080	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bond-arms-ranger-ii-45-410-4-25in-pisto-149080	1
6	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	625	0	625	55535-DEFAULT-l.jpg	625	55535-DEFAULT-m.jpg	BOND ARMS PATRIOT DEFENDER O/U PISTOL	N	11 JJ	45 COLT/410	3IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	BOND ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	OVER/UNDER	PISTOL	3	500-or-more	0.00	[empty string]	Patriot - Over/under - 45 Colt/.410 - Sa - 2 Rds	<p>SPECIFICATIONS:<br /> -Model: Patriot<br /> -Item Number: BAPA45410<br /> -Caliber: 45Colt / .410<br /> -Action: Single Action<br /> -Barrel: 3.0``<br /> -Grip: Rosewood<br /> -Sights: Front blade, fixed rear<br /> -Rounds: 2<br /> -Length: 5.0``<br /> -Weight: 21.5 oz<br /> -Features: Stainless steel double-barrel and frame, Compatible with all Bond Arms barrels, Automatic spent casing extractor, Patented rebounding hammer, Retracting ring pins, Cross-bolt safety and Spring-loaded, cammed locking lever.</p>	[empty string]	N	625	625	[empty string]	55535-DEFAULT-s.jpg	[empty string]	1000	BAPA45410	262403	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bond-arms-patriot-defender-o-u-pistol-262403	1
7	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	295	0	295	80560-DEFAULT-l.jpg	295	80560-DEFAULT-m.jpg	BOND ARMS ROWDY 3IN 45 410 PISTL	N	11 JJ	45 COLT/410	3IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	BOND ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	OVER/UNDER	PISTOL	3	250-to-300	0.00	[empty string]	Rowdy - 45 Colt (lc) / 410 Ga - Derringer - 2 Rds - 3` Bbl	<p> SPECIFICATIONS: </p> <p>-Bond Arms Rowdy</p> <p>-Item Number: BARW</p> <p>-Caliber: 45 Colt (LC) / 410 ga</p> <p>-Frame Finish: Stainless Steel</p> <p>-Action: Derringer</p> <p>-Barrel Length: 3"</p> <p>-Capacity: 2</p> <p>-Frame Description: Bead Blaster</p> <p>-Frame Material: Stainless Steel</p> <p>-Grips: Black Rubber</p> <p>-Safety: Crossbolt</p> <p>-Barrel Type: Double</p> <p> </p>	[empty string]	N	295	295	[empty string]	80560-DEFAULT-s.jpg	[empty string]	1000	BARW	325598	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bond-arms-rowdy-3in-45-410-pistl-325598	1
8	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	295	0	295	81687-DEFAULT-l.jpg	295	81687-DEFAULT-m.jpg	BOND ARMS ROUGHNECK 2.5IN 357 38 PISTOL	N	11 JJ	357MAG / 38SPL	2.5 IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	BOND ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	O/U	PISTOL	2	250-to-300	0.00	[empty string]	Roughneck - 357 Mag / 38 Spec - Sa - 2 Rds - 2.5` Bbl	<p> SPECIFICATIONS: </p> <p>-Model: Bond Arms Roughneck</p> <p>-Item Number: BARN-357/38</p> <p>-Caliber: 357 MAG / 38 SPEC</p> <p>-Action: Single</p> <p>-Finish: Bead Blasted Matte Stainless</p> <p>-Frame Material: Steel</p> <p>-Grips: Black Rubber</p> <p>-Barrel Length: 2.5"</p> <p>-OAL: 4.5"</p> <p>-Capacity: 2</p> <p>-Sights: Front Blade / Fixed Rear</p> <p>-Sight Type: Fixed Sights</p> <p>-Weight: 18.5 oz</p> <p>-Shipping Weight: 2.15 lbs</p> <p>-Safety: Cross Bolt Safety</p> <p>-Features: Retracting Firing Pins, Interchangeable Barrels and Rebounding Hammer</p> <p> </p> <p> </p>	[empty string]	N	295	295	[empty string]	81687-DEFAULT-s.jpg	[empty string]	1000	BARN35738	329636	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bond-arms-roughneck-2-5in-357-38-pistol-329636	1
9	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	280	0	280	88071-DEFAULT-l.jpg	280	88071-DEFAULT-m.jpg	BOND ARMS ROUGHNECK 2.5IN 45ACP PISTOL	N	11 JJ	45 ACP	2.5 IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	BOND ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	O/U	PISTOL	3	250-to-300	0.00	[empty string]	Bond Arms Roughneck 2.5in 45acp Pistol	[empty string]	[empty string]	N	280	280	[empty string]	88071-DEFAULT-s.jpg	[empty string]	1000	BARN45ACP	336036	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bond-arms-roughneck-2-5in-45acp-pistol-336036	1
10	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	0	650	0	650	[empty string]	650	[empty string]	BOND ARMS BLACKJACK 3IN 45 410 PISTL	N	11 JJ	45 COLT/410	3IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	BOND ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	OVER/UNDER	PISTOL	2	500-or-more	0.00	[empty string]	Bond Arms Blackjack 3in 45 410 Pistl	[empty string]	[empty string]	N	650	650	[empty string]	[empty string]	[empty string]	1000	BABJ	342965	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bond-arms-blackjack-3in-45-410-pistl-342965	1
11	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	0	395	0	395	[empty string]	395	[empty string]	BOND ARMS GRIZZLY BEAR 3IN 45LC 410 PISTL	N	11 JJ	45 COLT/410	3IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	BOND ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	OVER/UNDER	PISTOL	3	350-to-400	0.00	[empty string]	Bond Arms Grizzly Bear 3in 45lc 410 Pistl	[empty string]	[empty string]	N	395	395	[empty string]	[empty string]	[empty string]	1000	BAGR	345116	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bond-arms-grizzly-bear-3in-45lc-410-pistl-345116	1
12	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	285	0	285	87988-DEFAULT-l.jpg	285	87988-DEFAULT-m.jpg	BOND ARMS ROUGHNECK 2.5IN 9MM PISTOL	N	11 JJ	9MM	2.5 IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	BOND ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	O/U	PISTOL	3	250-to-300	0.00	[empty string]	Roughneck - 357 Mag / 38 Spec - Sa - 2 Rds - 2.5` Bbl	<p>nbsp;SPECIFICATIONS:nbsp;</p> <p>-Model: Bond Arms Roughneck</p> <p>-Item Number: BARN-357/38</p> <p>-Caliber: 357 MAG / 38 SPEC</p> <p>-Action: Single</p> <p>-Finish: Bead Blasted Matte Stainless</p> <p>-Frame Material: Steel</p> <p>-Grips: Black Rubber</p> <p>-Barrel Length: 2.5quot;</p> <p>-OAL: 4.5quot;</p> <p>-Capacity: 2</p> <p>-Sights: Front Blade / Fixed Rear</p> <p>-Sight Type: Fixed Sights</p> <p>-Weight: 18.5 oz</p> <p>-Shipping Weight: 2.15 lbs</p> <p>-Safety: Cross Bolt Safety</p> <p>-Features: Retracting Firing Pins, Interchangeable Barrels and Rebounding Hammer</p> <p>nbsp;</p> <p>nbsp;</p>	[empty string]	N	285	285	[empty string]	87988-DEFAULT-s.jpg	[empty string]	1000	BARN9	348591	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bond-arms-roughneck-2-5in-9mm-pistol-348591	1
13	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	0	575	0	575	[empty string]	575	[empty string]	BNDARMS SNAKESLAYER 357/38 O/U PIST	N	11 JJ	357MAG / 38SPL	3.5 IN	[empty string]	[empty string]	[empty string]	[empty string]	NONE	BOND ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	OVER/UNDER	PISTOL	1	500-or-more	0.00	[empty string]	Bndarms Snakeslayer 357/38 O/u Pist	[empty string]	[empty string]	N	575	575	[empty string]	[empty string]	[empty string]	1000	BASS35738	354412	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bndarms-snakeslayer-357-38-o-u-pist-354412	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter By

Filter

Bond Arms, Inc.
Bond Arms Cowboy Defender O/U Pistol
Item # BACD45410L $520.00
Bond Arms, Inc.
Snake Slayer Iv - Over/Under - 45lc /.410 - Sa - 2 Rds
Item # BASS4 $625.00
Bond Arms, Inc.
Texas Defender - Over/Under - 45 Colt /.410 - Sa - 2 Rds
Item # BATD45/410 $520.00
Bond Arms, Inc.
Snake Slayer - Over/Under - 45lc /.410 - Sa - 2 Rds - 3.5 `` Bbl
Item # BASS $580.00
Bond Arms, Inc.
Ranger Ii - Over/Under - 45lc /.410 - Sa - 2 Rds
Item # BARII $730.00
Bond Arms, Inc.
Patriot - Over/Under - 45 Colt /.410 - Sa - 2 Rds
Item # BAPA45410 $625.00
Bond Arms, Inc.
Rowdy - 45 Colt (Lc)/410 Ga - Derringer - 2 Rds - 3 ` Bbl
Item # BARW $295.00
Bond Arms, Inc.
Roughneck - 357 Mag/38 Spec - Sa - 2 Rds - 2.5 ` Bbl
Item # BARN35738 $295.00
Bond Arms, Inc.
Bond Arms Roughneck 2.5in 45acp Pistol
Item # BARN45ACP $280.00
Bond Arms, Inc.
Bond Arms Blackjack 3in 45 410 Pistl
Item # BABJ $650.00
Bond Arms, Inc.
Bond Arms Grizzly Bear 3in 45lc 410 Pistl
Item # BAGR $395.00
Bond Arms, Inc.
Roughneck - 357 Mag/38 Spec - Sa - 2 Rds - 2.5 ` Bbl
Item # BARN9 $285.00
Bond Arms, Inc.
Bndarms Snakeslayer 357/38 O/U Pist
Item # BASS35738 $575.00

Filter By

Price

Categories

Brand

Bond Arms Cowboy Defender O/U Pistol

Snake Slayer Iv - Over/Under - 45lc /.410 - Sa - 2 Rds

Texas Defender - Over/Under - 45 Colt /.410 - Sa - 2 Rds

Snake Slayer - Over/Under - 45lc /.410 - Sa - 2 Rds - 3.5 `` Bbl

Ranger Ii - Over/Under - 45lc /.410 - Sa - 2 Rds

Patriot - Over/Under - 45 Colt /.410 - Sa - 2 Rds

Rowdy - 45 Colt (Lc)/410 Ga - Derringer - 2 Rds - 3 ` Bbl

Roughneck - 357 Mag/38 Spec - Sa - 2 Rds - 2.5 ` Bbl

Bond Arms Roughneck 2.5in 45acp Pistol

Bond Arms Blackjack 3in 45 410 Pistl

Bond Arms Grizzly Bear 3in 45lc 410 Pistl

Roughneck - 357 Mag/38 Spec - Sa - 2 Rds - 2.5 ` Bbl

Bndarms Snakeslayer 357/38 O/U Pist