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	499	0	499	64561-DEFAULT-l.jpg	499	64561-DEFAULT-m.jpg	BOND ARMS COWBOY DEFENDER O/U PISTOL	N	11 JJ	45 COLT/410	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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	450-to-500	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	499	499	[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	595	0	595	55391-DEFAULT-l.jpg	595	55391-DEFAULT-m.jpg	BNDARMS SNAKESLAYER IV 45LC/410 O/U PIST	N	11 JJ	45 COLT/410	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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	595	595	[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	495	0	495	55389-DEFAULT-l.jpg	495	55389-DEFAULT-m.jpg	BOND ARMS TEXAS DEFENDER O/U PISTOL	N	11 JJ	45 COLT/410	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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	450-to-500	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	495	495	[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	550	0	550	55413-DEFAULT-l.jpg	550	55413-DEFAULT-m.jpg	BONDARMS SNAKESLAYER 45/410 O/U PISTOL	N	11 JJ	45 COLT/410	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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]	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	550	550	[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	595	0	595	55758-DEFAULT-l.jpg	595	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]	FIREARM SHIP CHARGE FOR WEB	[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	595	595	[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	595	0	595	55535-DEFAULT-l.jpg	595	55535-DEFAULT-m.jpg	BOND ARMS PATRIOT DEFENDER O/U PISTOL	N	11 JJ	45 COLT/410	3IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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	595	595	[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]	FIREARM SHIP CHARGE FOR WEB	[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	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	280	0	280	81687-DEFAULT-l.jpg	280	81687-DEFAULT-m.jpg	BOND ARMS ROUGHNECK 2.5IN 357 38 PISTOL	N	11 JJ	357MAG / 38SPL	2.5 IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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	4	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	280	280	[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]	FIREARM SHIP CHARGE FOR WEB	[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	4	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>Other Pistols	[empty string]	1	635	0	635	99849-DEFAULT-l.jpg	635	99849-DEFAULT-m.jpg	BOND ARMS BLACKJACK 3IN 45 410 PISTL	N	11 JJ	45 COLT/410	3IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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]	BLACK JACK - 45 LC/410 GA - BREAK OPEN - BLACK - BLACK ASH	<ul> <li>Item: Bond Arms Black Jack</li> <li>Item Number: BABJ</li> <li>Caliber: 45LC</li> <li>Gauge: 410</li> <li>Capacity: 2</li> <li>Action: Break Open</li> <li>Frame Finish: Black</li> <li>Grips: Black Ash</li> <li>Barrel Length: 3.5"</li> <li>OAL: 5.50"</li> <li>Capacity: 2</li> <li>Safety: Crossbolt</li> <li>Features: Engraved Spade</li> </ul> <p> </p>	[empty string]	N	635	635	[empty string]	99849-DEFAULT-s.jpg	[empty string]	1000	BABJ	342965	OTHER PISTOLS	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/black-jack-45-lc-410-ga-break-open-black-black-ash-342965	1
11	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	370	0	370	99850-DEFAULT-l.jpg	370	99850-DEFAULT-m.jpg	BOND ARMS GRIZZLY BEAR 3IN 45LC 410 PISTL	N	11 JJ	45 COLT/410	3IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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]	GRIZZLY - 45LC/410 - BREAK OPEN - MATTE STAINLESS - ROSEWOOD	<p>SPECIFICATIONS:</p> <ul> <li>Item: Bond Grizzly</li> <li>Item Number: BARG</li> <li>Caliber: 45 LC</li> <li>Gauge: 410</li> <li>Action: Break Open</li> <li>Capacity: 2</li> <li>Finish: Bead Blasted Matte Stainless</li> <li>Grips: Rosewood</li> <li>Barrel Length: 3"</li> <li>OAL: 5"</li> <li>Sights: Fixed sights</li> <li>Safety: Cross Bolt Safety</li> </ul>	[empty string]	N	370	370	[empty string]	99850-DEFAULT-s.jpg	[empty string]	1000	BAGR	345116	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/grizzly-45lc-410-break-open-matte-stainless-rosewood-345116	1
12	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	280	0	280	87988-DEFAULT-l.jpg	280	87988-DEFAULT-m.jpg	BOND ARMS ROUGHNECK 2.5IN 9MM PISTOL	N	11 JJ	9MM	2.5 IN	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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 - 9MM - SINGLE - 2 RDS - 2.5" BBL	<ul> <li>Item: Bond Roughneck </li> <li>Item Number: BARN9</li> <li>Caliber: 9mm</li> <li>Action: Single Action</li> <li>Finish: Bead Blasted Matte Stainless</li> <li>Grips: Black Rubber</li> <li>Barrel Length: 2.5"</li> <li>OAL: 4.5"</li> <li>Capacity: 2</li> <li>Sights: Front Blade and Fixe Rear</li> <li>Safety: Cross Bolt Safety</li> <li>Retracting Firing Pins</li> <li>Rebounding Hammer</li> </ul>	[empty string]	N	280	280	[empty string]	87988-DEFAULT-s.jpg	[empty string]	1000	BARN9	348591	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/roughneck-9mm-single-2-rds-2-5-bbl-348591	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 $499.00
Bond Arms, Inc.
Snake Slayer Iv - Over/Under - 45lc /.410 - Sa - 2 Rds
Item # BASS4 $595.00
Bond Arms, Inc.
Texas Defender - Over/Under - 45 Colt /.410 - Sa - 2 Rds
Item # BATD45/410 $495.00
Bond Arms, Inc.
Snake Slayer - Over/Under - 45lc /.410 - Sa - 2 Rds - 3.5 `` Bbl
Item # BASS $550.00
Bond Arms, Inc.
Ranger Ii - Over/Under - 45lc /.410 - Sa - 2 Rds
Item # BARII $595.00
Bond Arms, Inc.
Patriot - Over/Under - 45 Colt /.410 - Sa - 2 Rds
Item # BAPA45410 $595.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 $280.00
Bond Arms, Inc.
Bond Arms Roughneck 2.5in 45acp Pistol
Item # BARN45ACP $280.00
Bond Arms, Inc.
Black Jack - 45 Lc/410 Ga - Break Open - Black - Black Ash
Item # BABJ $635.00
Bond Arms, Inc.
Grizzly - 45lc/410 - Break Open - Matte Stainless - Rosewood
Item # BAGR $370.00
Bond Arms, Inc.
Roughneck - 9mm - Single - 2 Rds - 2.5 " Bbl
Item # BARN9 $280.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

Black Jack - 45 Lc/410 Ga - Break Open - Black - Black Ash

Grizzly - 45lc/410 - Break Open - Matte Stainless - Rosewood

Roughneck - 9mm - Single - 2 Rds - 2.5 " Bbl