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>Shotguns	[empty string]	1	570	1	545	55536-DEFAULT-l.jpg	570	55536-DEFAULT-m.jpg	BOND ARMS BAC2K45/410 CENTURY 2000 PISTL	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	3	500-or-more	0.00	[empty string]	Century 2000 - Over/under - 45lc/.410 - Sa - 2 Rds	<p>SPECIFICATIONS:<br /> -Model: Century 2000<br /> -Item Number: BAC2K45/410<br /> -Caliber: .45LC/.410<br /> -Action: Single Action<br /> -Barrel: 3.5``<br /> -Grip: Rosewood<br /> -Sights: Front blade, fixed rear<br /> -Rounds: 2<br /> -Length: 5.5``<br /> -Weight: 21.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]	Y	545	545	[empty string]	55536-DEFAULT-s.jpg	[empty string]	1000	BAC2K45/410	8791	EMPTY	EMPTY	EMPTY	0	0	0	SHOTGUNS	[empty string]	bond-arms-inc/bond-arms-bac2k45-410-century-2000-pistl-8791	1
2	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	545	1	520	92639-DEFAULT-l.jpg	545	92639-DEFAULT-m.jpg	BOND ARMS COWBOY DEF 357MAG O/U PISTOL	N	11 JJ	357MAG / 38SPL	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]	SO	[empty string]	OVER/UNDER	PISTOL	2	500-or-more	0.00	[empty string]	Bond Arms Cowboy Def 357mag O/u Pistol	The Cowboy Defender by Bond Arms was designed for Cowboy Action Shooting. This derringer is available in 357 Magnum/.38 Special, 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]	Y	520	520	[empty string]	92639-DEFAULT-s.jpg	[empty string]	1000	BACD357MAG	8792	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bond-arms-cowboy-def-357mag-o-u-pistol-8792	1
3	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	545	1	520	64561-DEFAULT-l.jpg	545	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	1	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]	Y	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
4	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	0	545	0	545	[empty string]	545	[empty string]	BOND ARMS COWBOY 45COLT O/U PISTOL	N	11 JJ	45 LONG COLT	[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]	SO	[empty string]	OVER/UNDER	REVOLVER	1	500-or-more	0.00	[empty string]	Bond Arms Cowboy 45colt O/u Pistol	[empty string]	[empty string]	N	545	545	[empty string]	[empty string]	[empty string]	1000	BACD45COLT	8794	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bond-arms-cowboy-45colt-o-u-pistol-8794	1
5	[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	2	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
6	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	540	1	520	64560-DEFAULT-l.jpg	540	64560-DEFAULT-m.jpg	BOND TEXAS DEFENDER 357 MAG O/U PISTOL	N	11 JJ	357MAG / 38SPL	[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]	SO	NOT ONLINE	OVER/UNDER	PISTOL	1	500-or-more	0.00	[empty string]	Texas Defender -	The Texas Defender by Bond Arms is a derringer available in 357 Magnum caliber and compatible with all Bond Arms interchangeable barrels. The Texas Defender features a cross-bolt safety and rosewood grips. The trigger guard aids in the control of the pistol when shooting larger calibers, and the spring-loaded cammed locking lever allows for a tighter barrel/frame fit and rapid loading and unloading.	[empty string]	Y	520	520	[empty string]	64560-DEFAULT-s.jpg	[empty string]	1000	BATD357MG	8796	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bond-texas-defender-357-mag-o-u-pistol-8796	1
7	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	540	1	520	55389-DEFAULT-l.jpg	540	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	3	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]	Y	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
8	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	595	1	580	55413-DEFAULT-l.jpg	595	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	1	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]	Y	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
9	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	760	1	730	55758-DEFAULT-l.jpg	760	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]	Y	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
10	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	495	0	495	69908-DEFAULT-l.jpg	495	69908-DEFAULT-m.jpg	BOND MINI GIRL 357MAG O/U 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]	SO	[empty string]	OVER/UNDER	PISTOL	1	450-to-500	0.00	[empty string]	Bond Mini Girl 357mag O/u Pistol	Bond Arms has reduced and redecorated its sturdy double-barrel pistol for better concealed carry. Especially for the ladies, the Bond Mini features a 2.5-inch .357/.38 Spl. barrel, pink wood grips and a selection of purse-friendly holsters in a variety of designs.	[empty string]	N	495	495	[empty string]	69908-DEFAULT-s.jpg	[empty string]	1000	MINIGIRL	170336	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bond-mini-girl-357mag-o-u-pistol-170336	1
11	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	645	1	625	55535-DEFAULT-l.jpg	645	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	2	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]	Y	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
12	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Holsters	[empty string]	1	99.99	0	99.99	92630-DEFAULT-l.jpg	99.99	92630-DEFAULT-m.jpg	HOLSTER LEATHER TAN RH	N	16 TOM	[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]	SO	NOT ONLINE	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Holster Leather Tan Rh	[empty string]	[empty string]	N	99.99	99.99	[empty string]	92630-DEFAULT-s.jpg	[empty string]	1000	BAH-DT-350-TN-R-BT	268604	EMPTY	EMPTY	EMPTY	0	0	0	HOLSTERS	[empty string]	bond-arms-inc/holster-leather-tan-rh-268604	1
13	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Components>Barrels	[empty string]	1	160	0	160	88930-DEFAULT-l.jpg	160	88930-DEFAULT-m.jpg	BOND ARMS 45ACP 3IN BARREL	N	11 JJ	45 ACP	[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]	SO	[empty string]	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	Bond Arms 45acp 3in Barrel	[empty string]	[empty string]	N	160	160	[empty string]	88930-DEFAULT-s.jpg	[empty string]	1000	BABL-300-45ACP	305016	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	bond-arms-inc/bond-arms-45acp-3in-barrel-305016	1
14	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Components>Barrels	[empty string]	1	160	0	160	87987-DEFAULT-l.jpg	160	87987-DEFAULT-m.jpg	BOND ARMS 357MAG 38 3IN BARREL	N	11 JJ	357 MAG	[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]	SO	[empty string]	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	Bond Arms 357mag 38 3in Barrel	[empty string]	[empty string]	N	160	160	[empty string]	87987-DEFAULT-s.jpg	[empty string]	1000	BABL-300-357/38	305017	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	bond-arms-inc/bond-arms-357mag-38-3in-barrel-305017	1
15	[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
16	[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
17	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	285	1	280	88071-DEFAULT-l.jpg	285	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	1	250-to-300	0.00	[empty string]	Bond Arms Roughneck 2.5in 45acp Pistol	[empty string]	[empty string]	Y	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
18	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	0	625	0	625	[empty string]	625	[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	1	500-or-more	0.00	[empty string]	Bond Arms Blackjack 3in 45 410 Pistl	[empty string]	[empty string]	N	625	625	[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
19	[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	2	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
20	[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
21	[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
22	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols	[empty string]	1	615	0	615	88931-DEFAULT-l.jpg	615	88931-DEFAULT-m.jpg	BNDARMS SNAKESLAYER IV 357/38 O/U PIST	N	11 JJ	357MAG / 38SPL	[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]	SO	[empty string]	OVER/UNDER	PISTOL	1	500-or-more	0.00	[empty string]	Bndarms Snakeslayer Iv 357/38 O/u Pist	[empty string]	[empty string]	N	615	615	[empty string]	88931-DEFAULT-s.jpg	[empty string]	1000	BASSIV35738	354413	EMPTY	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/bndarms-snakeslayer-iv-357-38-o-u-pist-354413	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter

Bond Arms, Inc.
Century 2000 - Over/Under - 45lc /.410 - Sa - 2 Rds
Item # BAC2K45/410 $570.00 $545.00
Bond Arms, Inc.
Bond Arms Cowboy Def 357mag O/U Pistol
Item # BACD357MAG $545.00 $520.00
Bond Arms, Inc.
Bond Arms Cowboy Defender O/U Pistol
Item # BACD45410L $545.00 $520.00
Bond Arms, Inc.
Bond Arms Cowboy 45colt O/U Pistol
Item # BACD45COLT $545.00
Bond Arms, Inc.
Snake Slayer Iv - Over/Under - 45lc /.410 - Sa - 2 Rds
Item # BASS4 $625.00
Bond Arms, Inc.
Texas Defender -
Item # BATD357MG $540.00 $520.00
Bond Arms, Inc.
Texas Defender - Over/Under - 45 Colt /.410 - Sa - 2 Rds
Item # BATD45/410 $540.00 $520.00
Bond Arms, Inc.
Snake Slayer - Over/Under - 45lc /.410 - Sa - 2 Rds - 3.5 `` Bbl
Item # BASS $595.00 $580.00
Bond Arms, Inc.
Ranger Ii - Over/Under - 45lc /.410 - Sa - 2 Rds
Item # BARII $760.00 $730.00
Bond Arms, Inc.
Bond Mini Girl 357mag O/U Pistol
Item # MINIGIRL $495.00
Bond Arms, Inc.
Patriot - Over/Under - 45 Colt /.410 - Sa - 2 Rds
Item # BAPA45410 $645.00 $625.00
Bond Arms, Inc.
Holster Leather Tan Rh
Item # BAH-DT-350-TN-R-BT $99.99
Bond Arms, Inc.
Bond Arms 45acp 3in Barrel
Item # BABL-300-45ACP $160.00
Bond Arms, Inc.
Bond Arms 357mag 38 3in Barrel
Item # BABL-300-357/38 $160.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 $285.00 $280.00
Bond Arms, Inc.
Bond Arms Blackjack 3in 45 410 Pistl
Item # BABJ $625.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
Bond Arms, Inc.
Bndarms Snakeslayer Iv 357/38 O/U Pist
Item # BASSIV35738 $615.00

Filter By

Price

Categories

Featured

Brand

Century 2000 - Over/Under - 45lc /.410 - Sa - 2 Rds

Bond Arms Cowboy Def 357mag O/U Pistol

Bond Arms Cowboy Defender O/U Pistol

Bond Arms Cowboy 45colt O/U Pistol

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

Texas Defender -

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

Bond Mini Girl 357mag O/U Pistol

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

Holster Leather Tan Rh

Bond Arms 45acp 3in Barrel

Bond Arms 357mag 38 3in Barrel

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

Bndarms Snakeslayer Iv 357/38 O/U Pist