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	285	0	285	66311-DEFAULT-l.jpg	285	66311-DEFAULT-m.jpg	1851 COLT NAVY REVOLVER .44 CAL 7.5IN BA	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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]	4	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	285	285	[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	320	0	320	85258-DEFAULT-l.jpg	320	85258-DEFAULT-m.jpg	TRADITIONS 1851 COLT NAVY REVOLVER	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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]	Traditions 1851 Colt Navy Revolver	[empty string]	[empty string]	N	320	320	[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
3	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	1	325	0	325	66312-DEFAULT-l.jpg	325	66312-DEFAULT-m.jpg	1858 REM NEW ARMY BRASS REVOLVER .44 CAL	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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]	1858 Rem New Army Brass Revolver .44 Cal 8in Barrel	Complete with authentic 8" barrel, brass trigger guard and fixed sights. The 1858 Remington Army is both a beautiful collectors piece and a rugged side arm. Perfect for display and target shooting.	[empty string]	N	325	325	[empty string]	66312-DEFAULT-s.jpg	[empty string]	1000	FR18581	72523	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	traditions-inc/1858-rem-new-army-brass-revolver-44-cal-72523	1
4	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	1	395	0	395	88384-DEFAULT-l.jpg	395	88384-DEFAULT-m.jpg	1858 REM NEW ARMY REVOLVER STEEL .44 CAL	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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	350-to-400	0.00	[empty string]	1858 Rem New Army Revolver Steel .44 Cal 8in Barrel	[empty string]	[empty string]	N	395	395	[empty string]	88384-DEFAULT-s.jpg	[empty string]	1000	FR18582	72524	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	traditions-inc/1858-rem-new-army-revolver-steel-44-cal-72524	1
5	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	1	335	0	335	66315-DEFAULT-l.jpg	335	66315-DEFAULT-m.jpg	TRADITIONS 1860 COLT ARMY REVOLVER	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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]	4	300-to-350	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	335	335	[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
6	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	1	370	0	370	85259-DEFAULT-l.jpg	370	85259-DEFAULT-m.jpg	1860 ARMY REVOLVER .44 CAL 8IN BARREL	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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]	4	350-to-400	0.00	[empty string]	1860 Army Revolver .44 Cal 8in Barrel Blued	[empty string]	[empty string]	N	370	370	[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
7	[empty string]	UBERTI	Uberti	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	0	510	0	510	[empty string]	510	[empty string]	UBERTI 1858 NEW ARMY SS 44 CAL 8IN	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	STOEGER	UBERTI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SINGLE ACTION	REVOLVER	3	500-or-more	0.00	[empty string]	Uberti 1858 New Army Ss 44 Cal 8in	[empty string]	[empty string]	N	510	510	[empty string]	[empty string]	[empty string]	1000	341020	90402	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	uberti/uberti-1858-new-army-ss-44-cal-8in-90402	1
8	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	0	395	0	395	[empty string]	395	[empty string]	1858 REM NEW ARMY BRASS .44 CAL REDI PAK	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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]	7	350-to-400	0.00	[empty string]	1858 Rem New Army Brass Revolver .44 Cal 8in Barrel	[empty string]	[empty string]	N	395	395	[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
9	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	1	350	0	350	72279-DEFAULT-l.jpg	350	72279-DEFAULT-m.jpg	1851 COLT NAVY BRASS REVOLVER REDI PAK	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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]	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	350	350	[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
10	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	0	250	0	250	[empty string]	250	[empty string]	KENTUCKY PISTOL KIT .50 CAL PERCUSSION	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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	200-to-250	0.00	[empty string]	Kentucky Pistol Kit .50 Cal Percussion	Muzzleloading is a hands on sport for many shooters and one of the best ways possible to get real hands on experience is to build to 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. Easy to read instructions.	[empty string]	N	250	250	[empty string]	[empty string]	[empty string]	1000	KPC50602	170942	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	traditions-inc/kentucky-pistol-kit-50-cal-percussion-170942	1
11	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	0	355	0	355	[empty string]	355	[empty string]	TRAPPER PISTOL KIT .50 CAL PERCUSSION	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[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]	4	350-to-400	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	355	355	[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
12	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	1	345	0	345	64625-DEFAULT-l.jpg	345	64625-DEFAULT-m.jpg	1851 COLT REB ENG 44 CAL BA	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	[empty string]	STACCATO	[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]	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	345	345	[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
13	[empty string]	UBERTI	Uberti	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	0	399	0	399	[empty string]	399	[empty string]	UBERTI 1858 NEW ARMY BLUE 44 CAL 8IN	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	STOEGER	UBERTI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SINGLE ACTION	REVOLVER	1	350-to-400	0.00	[empty string]	Uberti 1858 New Army Blue 44 Cal 8in	[empty string]	[empty string]	N	399	399	[empty string]	[empty string]	[empty string]	1000	341000	303101	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	uberti/uberti-1858-new-army-blue-44-cal-8in-303101	1
14	[empty string]	UBERTI	Uberti	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	0	390	0	390	[empty string]	390	[empty string]	UBERTI 1860 ARMY BRASS 44 CAL 8IN	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	FIREARM SHIP CHARGE FOR WEB	[empty string]	STOEGER INC	UBERTI	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	SINGLE ACTION	REVOLVER	2	350-to-400	0.00	[empty string]	Uberti 1860 Army Brass 44 Cal 8in	[empty string]	[empty string]	N	390	390	[empty string]	[empty string]	[empty string]	1000	340480	346951	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	uberti/uberti-1860-army-brass-44-cal-8in-346951	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts367 ORDER BY sortposition asc

Firearms

Sort By:

Items per page:

Filter