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	380	0	380	38822-DEFAULT-l.jpg	380	38822-DEFAULT-m.jpg	HENRY H001Y 22LR LEVER RIFLE	N	11 JJ	22 LR	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	HENRY REPEATING ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	LEVER	RIFLE	2	350-to-400	0.00	[empty string]	LEVER ACTION 22 YOUTH - 22 LR - ROUND BLUED 16 INCH BBL - AMERICAN WALNUT	<ul> <li>Item: Henry Lever Action 22 Youth Rifle</li> <li>Item Number: H001Y</li> <li>Caliber: 22 S/L/LR</li> <li>Action: Lever</li> <li>Barrel Length: 16.125"</li> <li>OAL: 33"</li> <li>Barrel: round Blued Steel</li> <li>Weight: 4.50 lbs</li> <li>Receiver Finish: Black</li> <li>Stock Material: American Walnut</li> <li>LOP: 13"</li> </ul> <p> </p> <p> </p>	[empty string]	N	380	380	[empty string]	38822-DEFAULT-s.jpg	[empty string]	1000	H001Y	29767	LEVER ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	henry-repeating-arms/lever-action-22-youth-22-lr-round-blued-16-inch-bbl-american-walnut-29767	1
2	[empty string]	HENRY REPEATING ARMS	Henry Repeating Arms	FIREARMS	Firearms>Rifles>Lever Action	[empty string]	1	620	0	620	40852-DEFAULT-l.jpg	620	40852-DEFAULT-m.jpg	HENRY H004M 22 MAG LEVER ACTION RIFLE	N	11 JJ	22 MAGNUM	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	HENRY REPEATING ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	LEVER	RIFLE	4	500-or-more	0.00	[empty string]	GOLDEN BOY - 22 MAG - BLUED OCTAGON - AMERICAN WALNUT	<ul> <li>Item: Henry Golden Boy</li> <li>Item Number: H004M</li> <li>Caliber: 22 Mag</li> <li>Action: Lever</li> <li>Rounds: 12</li> <li>Barrel Length: 20.5"</li> <li>Barrel Type: Octagon Blued Steel</li> <li>OAL: 39"</li> <li>Receiver Finish: Brasslite</li> <li>Stock Material: American Walnut</li> </ul>	[empty string]	N	620	620	[empty string]	40852-DEFAULT-s.jpg	[empty string]	1000	H004M	29775	LEVER ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	henry-repeating-arms/golden-boy-22-mag-blued-octagon-american-walnut-29775	1
3	[empty string]	HENRY REPEATING ARMS	Henry Repeating Arms	FIREARMS	Firearms>Rifles>Lever Action	[empty string]	1	955	0	955	40863-DEFAULT-l.jpg	955	40863-DEFAULT-m.jpg	HENRY BIGBOY 357MAG/38SPL LEVER RIFLE	N	11 JJ	357MAG / 38SPL	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	NONE	HENRY REPEATING ARMS	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	LEVER	RIFLE	1	500-or-more	0.00	[empty string]	Big Boy - 357 Mag/38 Special - Brass	<p>-Big Boy Classic Lever Action</p> <p>-.357 Magnum/.38 Spl</p> <p>-10 Rounds</p> <p>-Barrel Length: 20"</p> <p>-Octagon Blued Steel</p> <p>-Receiver Finish: Polished Hardened Brass</p> <p>-Drilled and Tapped</p> <p>-American Walnut</p>	[empty string]	N	955	955	[empty string]	40863-DEFAULT-s.jpg	[empty string]	1000	H006M	29781	LEVER ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	henry-repeating-arms/henry-bigboy-357mag-38spl-lever-rifle-29781	1
4	[empty string]	HENRY REPEATING ARMS	Henry Repeating Arms	FIREARMS	Firearms>Rifles>Lever Action	[empty string]	1	590	0	590	94122-DEFAULT-l.jpg	590	94122-DEFAULT-m.jpg	HENRY MAGNUM EXPRESS 22WMR LEVER RIFLE	N	11 JJ	22 MAGNUM	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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	3	500-or-more	0.00	[empty string]	LEVER ACTION MAGNUM EXPRESS - 22 WMR - ROUND BLUED STEEL - AMERICAN WALNUT	<ul> <li>Henry Lever action Magnum Express</li> <li>.22 wmr</li> <li>11 rounds</li> <li>Barrel Length: 19.25"</li> <li>Round Blued Steel</li> <li>Receiver Finish: Black</li> <li>Picatinny Rail</li> <li>American walnut</li> </ul>	[empty string]	N	590	590	[empty string]	94122-DEFAULT-s.jpg	[empty string]	1000	H001ME	349974	LEVER ACTION	EMPTY	EMPTY	0	0	0	RIFLES	[empty string]	henry-repeating-arms/lever-action-magnum-express-22-wmr-round-blued-steel-american-walnut-349974	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
Lever Action 22 Youth - 22 Lr - Round Blued 16 Inch Bbl - American Walnut
Item # H001Y $380.00
Henry Repeating Arms
Golden Boy - 22 Mag - Blued Octagon - American Walnut
Item # H004M $620.00
Henry Repeating Arms
Big Boy - 357 Mag/38 Special - Brass
Item # H006M $955.00
Henry Repeating Arms
Lever Action Magnum Express - 22 Wmr - Round Blued Steel - American Walnut
Item # H001ME $590.00