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]	HENRY REPEATING ARMS	Henry Repeating Arms	FIREARMS	Firearms>Rifles>Lever Action	[empty string]	1	880	0	945	40856-DEFAULT-l.jpg	880	40856-DEFAULT-m.jpg	HENRY H006 BIG BOY 44MAG/44SPL RIFLE LEV	N	11 JJ	44REM MAG /44SPL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	HENRY REPEATING ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	LEVER	RIFLE	14	500-or-more	0.00	[empty string]	Big Boy - 44 Mag/44 Special - Brass	<p>Back when the West was still wild and the rifle was the tool of choice for survival and frontier justice, the venerable .44-caliber put more meat on the table and outlaws in the ground than any other bullet. The West may have been tamed and fenced long ago, but its unbridled spirit lives on in this line of traditional big-bore Big Boy Henry rifles.<br /> <br /> Choose from .44 Magnum, .45 Colt and .357 Magnum. All are SASS approved so Cowboy Action shooters who enjoy stepping back to that bygone era can use them in competition. Don`t let the retro look fool you, these rifles are much more than shootin` irons for today`s new breed of cowboy.<br /> <br /> The ``Big Boy`` is also the unbeatable choice of big-game hunters who prefer the traditional look, feel, reliability and accuracy that comes from an authentic Henry rifle. The traditional 20`` octagonal barrel is outfitted with a classic fully adjustable semi-buckhorn rear sight with a reversible white diamond insert and a brass beaded front sight. The tubular magazine tops off at 10 rounds.<br /> <br /> Both the straight-grip stock and forearm are crafted of select American walnut accented with a brass barrel band and Henry`s recognizable brass receiver. All have that crisp, smooth action that sets an authentic American-made Henry apart from other lever action rifles on the range and in the woods today.<br /> <br /> The .44 Magnum can also shoot .44 special rounds, and the .357 Magnum can also shoot .38 special rounds.</p>	[empty string]	N	945	945	[empty string]	40856-DEFAULT-s.jpg	[empty string]	1000	H006	29778	LEVER ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	henry-repeating-arms/henry-h006-big-boy-44mag-44spl-rifle-lev-29778	1
2	[empty string]	HENRY REPEATING ARMS	Henry Repeating Arms	FIREARMS	Firearms>Rifles>Lever Action	[empty string]	1	850	0	915	94121-DEFAULT-l.jpg	850	94121-DEFAULT-m.jpg	HENRY 45/70 18IN SIDE G LEVER ACTION RIFLE	N	11 JJ	45-70 GOVT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	HENRY REPEATING ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	LEVER	RIFLE	11	500-or-more	0.00	[empty string]	Henry 45/70 18in Side G Lever Action Rifle	<ul> <li>Henry Steel Lever Action Side Gate</li> <li>.45-70</li> <li>Large Loop</li> <li>Barrel Length: 18.43"</li> <li>Barrel Type: Round Blued Steel</li> <li>Receiver Finish: Blued Steel</li> <li>Drilled and Tapped</li> <li>Stock: American Walnut</li> </ul>	[empty string]	N	915	915	[empty string]	94121-DEFAULT-s.jpg	[empty string]	1000	H010G	345558	LEVER ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	henry-repeating-arms/henry-45-70-18in-side-g-lever-action-rifle-345558	1
3	[empty string]	HENRY REPEATING ARMS	Henry Repeating Arms	FIREARMS	Firearms>Rifles>Lever Action	[empty string]	1	915	0	915	94117-DEFAULT-l.jpg	915	94117-DEFAULT-m.jpg	HENRY BIG BOY STEEL 45LC SIDE G RIFLE	N	11 JJ	45 COLT	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	NONE	HENRY REPEATING ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	LEVER	RIFLE	1	500-or-more	0.00	[empty string]	Henry Big Boy Steel 45lc Side G Rifle	<p>-Henry Big Boy Steel Side Gate</p> <p>-Lever Action</p> <p>-.45 Colt</p> <p>-10 Rounds</p> <p>-Barrel Length: 20"</p> <p>-Barrel Type: Round Blued Steel</p> <p>-Receiver Finish: Blued</p> <p>-Stock Material: American Walnut</p>	[empty string]	N	915	915	[empty string]	94117-DEFAULT-s.jpg	[empty string]	1000	H012GC	366396	LEVER ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	henry-repeating-arms/henry-big-boy-steel-45lc-side-g-rifle-366396	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts383 ORDER BY sortposition asc

Firearms

Sort By:

Items per page:

Close

Filter By

Filter

Henry Repeating Arms
Big Boy - 44 Mag/44 Special - Brass
Item # H006 $945.00
Henry Repeating Arms
Henry 45/70 18in Side G Lever Action Rifle
Item # H010G $915.00
Henry Repeating Arms
Henry Big Boy Steel 45lc Side G Rifle
Item # H012GC $915.00