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	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
2	[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
3	[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
4	[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
5	[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	3	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
6	[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	2	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
7	[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	5	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
8	[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	2	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
9	[empty string]	BOND ARMS, INC.	Bond Arms, Inc.	FIREARMS	Firearms>Pistols>Other Pistols	[empty string]	1	595	0	595	107406-DEFAULT-l.jpg	595	107406-DEFAULT-m.jpg	BOND ARMS RUSTIC DEFENDER 45COLT /410 SS 4.25IN	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]	RUSTIC DEFENDER - 45LC/410 GA - STAINLESS - ROSEWOOD - HOLSTER	<ul> <li>Item: Bond Arms Rustic Defender</li> <li>Item Number: BARD</li> <li>Caliber/Gauge: 45LC/410 Ga</li> <li>Action: Break Open</li> <li>Barrel Length: 3"</li> <li>OAL: 5"</li> <li>Frame: Stainless Steel</li> <li>Grip: Rosewood</li> <li>Sights: Front blade, fixed rear</li> <li>Weight: 20 oz</li> <li>Patented rebounding hammer</li> <li>Retracting firing pins</li> <li>Cross-bolt safety</li> <li>Matching Driving Holster</li> </ul>	[empty string]	N	595	595	[empty string]	107406-DEFAULT-s.jpg	[empty string]	1000	BARD	364586	OTHER PISTOLS	EMPTY	EMPTY	0	0	0	PISTOLS	[empty string]	bond-arms-inc/rustic-defender-45lc-410-ga-stainless-rosewood-holster-364586	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter By

Filter

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.
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.
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
Bond Arms, Inc.
Rustic Defender - 45lc/410 Ga - Stainless - Rosewood - Holster
Item # BARD $595.00

Filter By

Price

Categories

Brand

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

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

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

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

Rustic Defender - 45lc/410 Ga - Stainless - Rosewood - Holster