| 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 |
SORTPOSITION |
STYLE |
STYLE_ID |
SUBTYP1 |
SUBTYP2 |
SUBTYP3 |
TERMSALE |
TERMSALELISTPRICE |
TERMSALEPRICE |
TYP |
URL |
WEBSTYLE |
WEIGHTED_SEARCH |
| 1 |
[empty string]
|
BOND ARMS, INC
|
Bond Arms, Inc
|
FIREARMS
|
Firearms
|
[empty string]
|
1
|
299.99
|
0
|
299.99
|
6522-DEFAULT-l.jpg
|
299.99
|
6522-DEFAULT-m.jpg
|
BOND ARMS ROUGHNECK
|
N
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
BOND ARMS, INC
|
[empty string]
|
PISTOL
|
9MM
|
[empty string]
|
2641
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
1
|
250-to-300
|
0.00
|
[empty string]
|
Bond Arms Rough Neck 9mm Luger 2.50" Barrel | Stainless Steel & Black
|
<p>Roughneck is compatible with all standard Bond Arms barrels for easy caliber conversions. The pistol has stainless steel double-barrel and frame, the barrels and trigger are polished and the frame is sand blasted. Features- patented rebounding hammer, retracting firing pins, cross-bolt safety and spring-loaded, cammed locking lever.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Bond Arms</li><li>Category Break-Action Handguns</li><li>Caliber 9mm Luger</li><li>Model Roughneck</li><li>Frame Finish Stainless Steel</li><li>Action Break Open</li><li>Barrel Length Range 2" to 2.99"</li><li>Capacity 2rd</li><li>Frame Description Bead Blasted</li><li>Frame Material Stainless Steel</li><li>Grips Black Rubber</li><li>Max Capacity 2</li><li>Safety Crossbolt</li><li>Barrel Type Double</li><li>Barrel Length 2.50"</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p> <p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p>
|
[empty string]
|
N
|
299.99
|
299.99
|
[empty string]
|
6522-DEFAULT-s.jpg
|
[empty string]
|
1000
|
1000
|
BARN9MM
|
64061
|
EMPTY
|
EMPTY
|
EMPTY
|
0
|
0
|
0
|
EMPTY
|
bond-arms-inc/bond-arms-rough-neck-9mm-luger-2-50-barrel-stainless-steel-black-64061
|
BARN9MM
|
0
|
| 2 |
[empty string]
|
BOND ARMS, INC
|
Bond Arms, Inc
|
FIREARMS
|
Firearms
|
[empty string]
|
1
|
299.99
|
0
|
299.99
|
21306-DEFAULT-l.jpg
|
299.99
|
21306-DEFAULT-m.jpg
|
BOND ARMS BASRS STINGER 9MM
|
N
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
BOND ARMS, INC
|
[empty string]
|
PISTOL
|
9MM
|
[empty string]
|
2641
|
[empty string]
|
[empty string]
|
ITEM CAN BE ADDED TO WISH LIST
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
0
|
250-to-300
|
0.00
|
[empty string]
|
Bond Arms Stinger 9mm Luger 2.5" Matte Stainless Steel Double Barrel | Black Rubber Grip, Manual Safety
|
<p>The Stinger by Bond Arms features a black anodized aluminum frame, stainless steel matte barrel, and an overall length of 4.50".</p><ul><li>Brand Bond Arms</li><li>Category Break-Action Handguns</li><li>Model Stinger</li><li>Caliber 9mm Luger</li><li>Barrel Length Range 2" to 2.99"</li><li>Capacity 2rd</li><li>Action Break Open</li><li>OAL 4.50"</li><li>Frame Material Stainless Steel</li><li>Sights Blade Front / Fixed Rear</li><li>Barrel Finish Matte Stainless</li><li>Grips Black Rubber</li><li>Safety Crossbolt</li><li>Barrel Length 2.50"</li><li>Max Capacity 2</li><li>Weight 12 oz</li><li>Metal Finish Stainless Steel</li></ul><p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p>
|
[empty string]
|
N
|
299.99
|
299.99
|
[empty string]
|
21306-DEFAULT-s.jpg
|
[empty string]
|
1000
|
1000
|
BASRS
|
64063
|
EMPTY
|
EMPTY
|
EMPTY
|
0
|
0
|
0
|
EMPTY
|
bond-arms-inc/bond-arms-stinger-9mm-luger-2-5-matte-stainless-steel-double-barrel-black-rubber-grip-manual-safety-64063
|
BASRS
|
0
|
| 3 |
[empty string]
|
BOND ARMS, INC
|
Bond Arms, Inc
|
FIREARMS
|
Firearms
|
[empty string]
|
1
|
279.99
|
0
|
299.99
|
6895-DEFAULT-l.jpg
|
279.99
|
6895-DEFAULT-m.jpg
|
BOND ARMS ROUGHNECK 357/38
|
N
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
BOND ARMS, INC
|
[empty string]
|
REVOLVER
|
357MAG
|
[empty string]
|
2641
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
2
|
250-to-300
|
0.00
|
[empty string]
|
Bond Arms Roughneck 357 Magnum/38 Special 2.50" Barrel | Stainless Steel & Black
|
<p>The compact, yet rough-looking, Roughneck is a new type of Bond Arm gun. This model is built with a 2.5 barrel and chambered for 357/38. It features a stainless steel double-barrel and frame, is compatible with all standard Bond Arms barrels, and has a patented rebound hammer. It also features a spring-loaded, cammed locking lever, retracting firing pins, and cross-bolt safety.</p><p><strong>SPECIFICATIONS:</strong></p><ul><li>Brand Bond Arms</li><li>Category Break-Action Handguns</li><li>Caliber 357 Mag</li><li>Model Roughneck</li><li>Action Break Open</li><li>Barrel Length Range 2" to 2.99"</li><li>Sights Blade Front, Fixed Rear</li><li>Capacity 2rd</li><li>Grips Black Rubber</li><li>Metal Finish Stainless Steel</li><li>OAL 4.50"</li><li>Safety Crossbolt</li><li>Weight 19 oz</li><li>Barrel Description Stainless Steel</li><li>Barrel Length 2.50"</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p> </p><p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p>
|
[empty string]
|
N
|
299.99
|
299.99
|
[empty string]
|
6895-DEFAULT-s.jpg
|
[empty string]
|
1000
|
1000
|
ROUGHNECK
|
64066
|
EMPTY
|
EMPTY
|
EMPTY
|
0
|
0
|
0
|
EMPTY
|
bond-arms-inc/bond-arms-roughneck-357-magnum-38-special-2-50-barrel-stainless-steel-black-64066
|
ROUGHNECK
|
0
|
| 4 |
[empty string]
|
BOND ARMS, INC
|
Bond Arms, Inc
|
FIREARMS
|
Firearms
|
[empty string]
|
1
|
299.99
|
0
|
309.99
|
36035-DEFAULT-l.jpg
|
299.99
|
36035-DEFAULT-m.jpg
|
BOND ARMS ROWDY
|
N
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
BOND ARMS, INC
|
[empty string]
|
PISTOL
|
410/45LC
|
[empty string]
|
2641
|
[empty string]
|
[empty string]
|
ITEM CAN BE ADDED TO WISH LIST
|
[empty string]
|
[empty string]
|
[empty string]
|
2-NIB
|
[empty string]
|
0
|
300-to-350
|
0.00
|
[empty string]
|
Bond Arms BARW Rowdy 410/45 Colt (LC) Derringer 3" Barrel | Black Rubber Grip & Polished Stainless Steel
|
<p>Rowdy is compatible with all standard Bond Arms barrels for easy caliber conversions. The pistol has stainless steel double-barrel and frame, the barrels and trigger are polished and the frame is sand blasted. Features- Automatic spent casting extractor, patented rebounding hammer, retracting firing pins, cross-bolt safety and spring-loaded, cammed locking lever.</p><p><strong>Specifications</strong></p><ul><li>Brand: Bond Arms</li><li>Model: Rowdy</li><li>Category: Pistols</li><li>Caliber: 45 Colt (LC) / 410 Gauge</li><li>Type: Derringer</li><li>Frame Finish: Stainless Steel</li><li>Action: Derringer</li><li>Capacity: 2</li><li>Frame Description: Bead Blasted</li><li>Frame Material: Stainless Steel</li><li>Grips: Black Rubber</li><li>Safety: Crossbolt</li><li>Barrel Type: Double</li><li>Barrel Length: 3"</li><li>Chamber: 2.5"</li></ul><p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p>
|
[empty string]
|
N
|
309.99
|
309.99
|
[empty string]
|
36035-DEFAULT-s.jpg
|
[empty string]
|
1000
|
1000
|
BARW45410
|
66396
|
EMPTY
|
EMPTY
|
EMPTY
|
0
|
0
|
0
|
EMPTY
|
bond-arms-inc/bond-arms-barw-rowdy-410-45-colt-lc-derringer-3-barrel-black-rubber-grip-polished-stainless-steel-66396
|
BARW45410
|
0
|
| 5 |
[empty string]
|
BOND ARMS, INC
|
Bond Arms, Inc
|
FIREARMS
|
Firearms
|
[empty string]
|
1
|
399.99
|
0
|
399.99
|
22409-DEFAULT-l.jpg
|
399.99
|
22409-DEFAULT-m.jpg
|
BOND ARMS BASL STINGER 380ACP
|
N
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
BOND ARMS, INC
|
[empty string]
|
PISTOL
|
380ACP
|
[empty string]
|
2641
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
1
|
350-to-400
|
0.00
|
[empty string]
|
Bond Arms Stinger Derringer 380 ACP 3" Barrel | Stainless Steel & Black
|
<p>The Stinger by Bond Arms features a black anodized aluminum frame, stainless steel matte barrel, and an overall length of 5".</p><p><strong>SPECIFICATIONS</strong></p><ul><li>Manufacturer Number BASL</li><li>Break Action Derringer</li><li>.380 ACP</li><li>2 Rounds</li><li>3" Matte Stainless Steel Barrel</li><li>Blade Front Sight</li><li>Fixed Rear Sight</li><li>Rebounding Hammer</li><li>Retracting Firing Pins</li><li>Crossbolt Safety</li><li>Spring Loaded Cammed Locking Lever</li><li>Comes with standard rubber grips and a slimmer set of polymer grips</li><li>7075 anodized aluminum frame</li><li>Accepts Bond Arms Interchangeable Barrels</li><li>Weight 12 oz</li><li>Made In The USA</li></ul><p><p>The purchaser of a hand gun must be 21 years of age or older. The purchaser is responsible for knowing his/her state and federal gun laws. Federal gun laws and regulations prohibits the transfer of a handgun to an out of state resident, therefore the "pick up in store" option is not avaliable to non Louisiana residents.</p><p>The purchaser of a long gun must be 18 years of age. The purchaser is responsible for knowing his/her state and federal gun laws.</p><p> </p><p><strong>WARNING: Cancer and Reproductive Harm:</strong> p65warnings.ca.gov</p><p> </p><p> </p></p><p><p><strong><em><span style="color:red">PLEASE NOTE:</span> If the customer<span style="color:red"> provides the FFL </span>for the order firearms usually </em></strong><span style="color:red"><strong><em>ship in 5-7 business days</em></strong></span><strong><em>.</em> If we have to contact the FFL and obtain the license please expect<span style="color:red"> 7-14 days</span> processing time. <span style="color:red">Send all FFLs to FFL@SIMMONSSG.COM</span></strong></p></p>
|
[empty string]
|
N
|
399.99
|
399.99
|
[empty string]
|
22409-DEFAULT-s.jpg
|
[empty string]
|
1000
|
1000
|
BASL380
|
241594
|
EMPTY
|
EMPTY
|
EMPTY
|
0
|
0
|
0
|
EMPTY
|
bond-arms-inc/bond-arms-stinger-derringer-380-acp-3-barrel-stainless-steel-black-241594
|
BASL380
|
0
|
| 6 |
[empty string]
|
BOND ARMS, INC
|
Bond Arms, Inc
|
FIREARMS
|
Firearms
|
[empty string]
|
1
|
299.99
|
1
|
279.99
|
29109-DEFAULT-l.jpg
|
299.99
|
29109-DEFAULT-m.jpg
|
BOND ARMS BASRS STINGER 22LR
|
N
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
BOND ARMS, INC
|
[empty string]
|
PISTOL
|
22LR
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
ITEM CAN BE ADDED TO WISH LIST
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
0
|
250-to-300
|
0.00
|
[empty string]
|
Bond BASRS Stinger 22 LR 2rd Shot 3" Matte Stainless Barrel | Rough Series Finish Stainless Steel Frame, Black Rubber Grips
|
<p>The Stinger RS has the same quality as Bond Arms' regular Double Barrel Handguns but has a slimmer profile and weight. Features Stainless steel 3" Rough series style barrel, Stainless Steel frame with Rough series finish, Rebounding hammer, Retracting firing pins and Cross-bolt safety. Comes with standard rubber grips and a slimmer set of polymer grips</p><table><tr><td><em><strong>Attribute</strong></em></td><td><em><strong>Value</strong></em></td></tr><tr><td>Action</td><td>SAO</td></tr><tr><td>Caliber</td><td>22 LR</td></tr><tr><td>Barrel Length</td><td>3"</td></tr><tr><td>Capacity</td><td>2rd</td></tr><tr><td>Safety</td><td>Crossbolt</td></tr><tr><td>Grips</td><td>Black Rubber</td></tr><tr><td>Weight</td><td>16 oz</td></tr><tr><td>Metal Finish</td><td>Stainless</td></tr><tr><td>Barrel Length Range</td><td>3" to 3.99"</td></tr><tr><td>Weight Range</td><td>16 oz to 31.99 oz</td></tr><tr><td>Manufacturer Part Number</td><td>BASRS </td></tr></table>
|
[empty string]
|
Y
|
279.99
|
279.99
|
[empty string]
|
29109-DEFAULT-s.jpg
|
[empty string]
|
1000
|
1000
|
BASRS-1
|
247951
|
EMPTY
|
EMPTY
|
EMPTY
|
0
|
0
|
0
|
EMPTY
|
bond-arms-inc/bond-basrs-stinger-22-lr-2rd-shot-3-matte-stainless-barrel-rough-series-finish-stainless-steel-frame-black-rubber-grips-247951
|
BASRS-1
|
0
|
