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	270	0	270	66311-DEFAULT-l.jpg	270	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]	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	270	270	[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	299	0	299	85258-DEFAULT-l.jpg	299	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	299	299	[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	310	0	310	66312-DEFAULT-l.jpg	310	66312-DEFAULT-m.jpg	1858 REM NEW ARMY BRASS REVOLVER .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]	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	310	310	[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	380	0	380	88384-DEFAULT-l.jpg	380	88384-DEFAULT-m.jpg	1858 REM NEW ARMY REVOLVER STEEL .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]	ACTIVE	[empty string]	[empty string]	[empty string]	3	350-to-400	0.00	[empty string]	1858 Rem New Army Revolver Steel .44 Cal 8in Barrel	[empty string]	[empty string]	N	380	380	[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	315	0	315	66315-DEFAULT-l.jpg	315	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]	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	315	315	[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	345	0	345	85259-DEFAULT-l.jpg	345	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]	6	300-to-350	0.00	[empty string]	1860 Army Revolver .44 Cal 8in Barrel Blued	[empty string]	[empty string]	N	345	345	[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	445	0	445	[empty string]	445	[empty string]	UBERTI 1847 WALKER 44 REVOLVER	N	11 JJ	44MAG	[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]	DOUBLE ACTION	REVOLVER	1	400-to-450	0.00	[empty string]	Uberti 1847 Walker 44 Revolver	[empty string]	[empty string]	N	445	445	[empty string]	[empty string]	[empty string]	1000	340200	86947	REVOLVERS	EMPTY	EMPTY	0	0	0	BLACK POWDER	[empty string]	uberti/uberti-1847-walker-44-revolver-86947	1
8	[empty string]	TRADITIONS INC	Traditions Inc	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	0	370	0	370	[empty string]	370	[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]	4	350-to-400	0.00	[empty string]	1858 Rem New Army Brass Revolver .44 Cal 8in Barrel	[empty string]	[empty string]	N	370	370	[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	330	0	330	72279-DEFAULT-l.jpg	330	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]	2	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	330	330	[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	235	0	235	[empty string]	235	[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]	ACTIVE	[empty string]	[empty string]	[empty string]	3	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	235	235	[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	335	0	335	[empty string]	335	[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]	2	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	335	335	[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]	UBERTI	Uberti	FIREARMS	Firearms>Black Powder>Revolvers	[empty string]	0	365	0	365	[empty string]	365	[empty string]	UBERTI 1860 ARMY BRASS 44 CAL 8IN	N	11 JJ	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[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	3	350-to-400	0.00	[empty string]	Uberti 1860 Army Brass 44 Cal 8in	[empty string]	[empty string]	N	365	365	[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