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	195	0	255	66311-DEFAULT-l.jpg	195	66311-DEFAULT-m.jpg	1851 COLT NAVY REVOLVER .44 CAL 7.5IN BA	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	ONLINE	[empty string]	[empty string]	3	250-to-300	0.00	[empty string]	1851 Navy Revolver - .44 Cal - 7.5in Barrel	Traditions 44 Cal Blackpowder w/Brass Frame/7.5` Steel Barrel & Walnut Grips The authenticity is precise, from the walnut tone grips to the color case hardened loading lever. The six shot cylinder has the same engraved scene that Sam Colt used. This brass framed revolver is available in .44 caliber. Western expansion of this country in the mid eighteen hundreds dictated that the U.S. Army carry sidearms designed for the time.	[empty string]	N	255	255	[empty string]	66311-DEFAULT-s.jpg	[empty string]	1000	FR18511	72521	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	traditions-inc/1851-colt-navy-revolver-44-cal-7-5in-ba-72521	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]	9	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]	0	145	0	170	[empty string]	145	[empty string]	KENTUCKY 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]	SO	[empty string]	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	Kentucky Pistol Kit .50 Cal Percussion	[empty string]	[empty string]	N	170	170	[empty string]	[empty string]	[empty string]	1000	KP50602	82439	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	traditions-inc/kentucky-pistol-kit-50-cal-percussion-82439	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]	5	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]	6	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]	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]	8	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
7	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	1	250	0	305	64625-DEFAULT-l.jpg	250	64625-DEFAULT-m.jpg	1851 COLT REB ENG 44 CAL BA	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]	3	300-to-350	0.00	[empty string]	1851 Colt Reb Eng 44 Cal Ba	The Traditions 1851 Navy Engraved Nickel is distinguished by its octagonal barrel and lever style loader, the lever style loader. This revolver features intricate engraving and a 7.375" octagonal barrel, brass frame, brass guard.	[empty string]	N	305	305	[empty string]	64625-DEFAULT-s.jpg	[empty string]	1000	FR185118	270035	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	traditions-inc/1851-colt-reb-eng-44-cal-ba-270035	1
8	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	1	340	0	430	64624-DEFAULT-l.jpg	340	64624-DEFAULT-m.jpg	1851 COLT REB ENG DELUX NICKEL 44 CAL BA	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	400-to-450	0.00	[empty string]	1851 Colt Reb Eng Delux Nickel 44 Cal Ba	The Traditions 1851 Navy Engraved Nickel is distinguished by its octagonal barrel and lever style loader, the lever style loader. This revolver features intricate engraving and a 7.375" octagonal barrel, nickel frame, nickel guard,and a simulated available in .44 caliber, weighs 2.7lbs and is 13.5" in length.	[empty string]	N	430	430	[empty string]	64624-DEFAULT-s.jpg	[empty string]	1000	FR185117	270036	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	traditions-inc/1851-colt-reb-eng-delux-nickel-44-cal-ba-270036	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts367 ORDER BY sortposition asc

Firearms

Sort By:

Items per page:

Filter