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]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	1	220	0	285	85258-DEFAULT-l.jpg	220	85258-DEFAULT-m.jpg	TRADITIONS 1851 COLT NAVY REVOLVER	N	11 JJ	[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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	250-to-300	0.00	[empty string]	Traditions 1851 Colt Navy Revolver	[empty string]	[empty string]	N	285	285	[empty string]	85258-DEFAULT-s.jpg	[empty string]	1000	FR18512	72522	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	traditions-inc/traditions-1851-colt-navy-revolver-72522	1
2	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	1	215	0	295	66315-DEFAULT-l.jpg	215	66315-DEFAULT-m.jpg	TRADITIONS 1860 COLT ARMY REVOLVER	N	11 JJ	[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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	250-to-300	0.00	[empty string]	Traditions 1860 Colt Army Revolver	Recognized as the mainstay of the Union Army, the 1860 was ordered to fill the ranks. The .44 caliber revolver was as powerful as it was popular. After the Civil War, 1860 could long be found in Army posts and across the frontier. This revolver has an 8" round blued barrel, steel frame, brass guard, and a walnut grip.	[empty string]	N	295	295	[empty string]	66315-DEFAULT-s.jpg	[empty string]	1000	FR18601	72526	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	traditions-inc/traditions-1860-colt-army-revolver-72526	1
3	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	1	260	0	330	85259-DEFAULT-l.jpg	260	85259-DEFAULT-m.jpg	1860 ARMY REVOLVER .44 CAL 8IN BARREL	N	11 JJ	[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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	300-to-350	0.00	[empty string]	1860 Army Revolver .44 Cal 8in Barrel Blued	[empty string]	[empty string]	N	330	330	[empty string]	85259-DEFAULT-s.jpg	[empty string]	1000	FR18602	72527	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	traditions-inc/1860-army-revolver-44-cal-8in-barrel-72527	1
4	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	0	260	0	345	[empty string]	260	[empty string]	1858 REM NEW ARMY BRASS .44 CAL REDI PAK	N	11 JJ	[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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	300-to-350	0.00	[empty string]	1858 Rem New Army Brass Revolver .44 Cal 8in Barrel	[empty string]	[empty string]	N	345	345	[empty string]	[empty string]	[empty string]	1000	FRS18581	95217	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	traditions-inc/1858-rem-new-army-brass-44-cal-redi-pak-95217	1
5	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	1	190	0	305	72279-DEFAULT-l.jpg	190	72279-DEFAULT-m.jpg	1851 COLT NAVY BRASS REVOLVER REDI PAK	N	11 JJ	[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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	300-to-350	0.00	[empty string]	1851 Colt Navy Brass Revolver Redi Pak	Union Army soldiers relied on many different types of sidearms for short range and close quarters combat. The revolver was unique in that it had the ability to fire several rounds per minute before having to reload. Revolvers were typically issued to officers and mounted soldiers, however some were purchased privately or found on the battlefield by infantrymen. Distinguished by its octagon barrel and lever style loader, the 1851 helped to begin both the expansion of the West and the Civil War. The 1851 Navy is commonly considered to be one of gunfighter `Wild Bill` Hickok`s favorite handguns. The British government licensed the manufacturing rights and produced what is commonly known as the London Model. This revolver features an 7.375` octagonal barrel, brass frame, brass guard, and walnut grip. It is available in .44 caliber, weighs 2.5 lbs., and is 13.5` in length.	[empty string]	N	305	305	[empty string]	72279-DEFAULT-s.jpg	[empty string]	1000	FRS18511	129800	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	traditions-inc/1851-colt-navy-brass-revolver-redi-pak-129800	1
6	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	1	250	0	340	85249-DEFAULT-l.jpg	250	85249-DEFAULT-m.jpg	1858 REM NEW ARMY BISON 12IN .44 CAL	N	11 JJ	[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]	[empty string]	SO	[empty string]	[empty string]	[empty string]	2	300-to-350	0.00	[empty string]	1858 Rem New Army Bison 12in .44 Cal	[empty string]	[empty string]	N	340	340	[empty string]	85249-DEFAULT-s.jpg	[empty string]	1000	FR185812	153529	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	traditions-inc/1858-rem-new-army-bison-12in-44-cal-153529	1
7	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	0	245	0	310	[empty string]	245	[empty string]	TRAPPER PISTOL KIT .50 CAL PERCUSSION	N	11 JJ	[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]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	300-to-350	0.00	[empty string]	Trapper Pistol Kit .50 Cal Percussion	One of the best ways possible to get a real hands-on muzzleloading experience is to build it yourself. Traditions offers a complete line of muzzleloader rifle and pistol kits that are pre-assembled at the factory to ensure proper fit and ease of assembly. These kits are the perfect project for families to build together or to help pass those long winter nights. Easy to read instructions guide you through the building process to a finished product. There is no greater feeling of accomplishment than knowing you built the rifle or pistol you enjoy shooting so much. This kit contains 50 caliber percussion pistol with a 9.75" octagonal barrel, hooked breech, 1:20" twist, double set trigger, prim/blade sights.	[empty string]	N	310	310	[empty string]	[empty string]	[empty string]	1000	KPC51002	170944	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	traditions-inc/trapper-pistol-kit-50-cal-percussion-170944	1
8	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	0	315	0	330	[empty string]	315	[empty string]	VORTEK PISTOL CERAKOTE 50CAL 13IN 209	N	11 JJ	[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]	[empty string]	SO	NOT ONLINE	[empty string]	[empty string]	1	300-to-350	0.00	[empty string]	Vortek Pistol Cerakote 50cal 13in 209	[empty string]	[empty string]	N	330	330	[empty string]	[empty string]	[empty string]	1000	P151178	188546	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	traditions-inc/vortek-pistol-cerakote-50cal-13in-209-188546	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts367 ORDER BY sortposition asc

Firearms

Sort By:

Items per page:

Close

Filter By

Filter