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 SORTPOSITION STYLE STYLE_ID SUBTYP1 SUBTYP2 SUBTYP3 TERMSALE TERMSALELISTPRICE TERMSALEPRICE TYP URL WEBSTYLE WEIGHTED_SEARCH
1 [empty string] BIG SHOT Big Shot SHOOTING Shooting [empty string] 1 199.99 0 199.99 27885-DEFAULT-l.jpg 199.99 27885-DEFAULT-m.jpg BIG SHOT TARGET TITAN 10X N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4545 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 12 150-to-200 0.00 [empty string] Big Shot Target Titan 10x <p>The Titan 10x HD is the first 10-sided target designed for the fastest crossbow in the world. The TENpoint 505. It's amazing Twist and Pull feature offers maximum stopping power and minimum pulling effort. BIGshot's new HS Foam Formula offers maximum value and durability. Designed with 10 purpose driven shooting faces, the BIGshot Titan 10X HD includes over 150 aiming points! The 10X HD's Ample 17 X 17 size offers plenty of shooting surface for those longer test shots for crossbows , Plus the unique tree stand mode allows you to easily practice from an elevated platform to give you that realistic hunting scenario.</p> [empty string] N 199.99 199.99 [empty string] 27885-DEFAULT-s.jpg [empty string] 1000 1000 BH-10X 124593 EMPTY EMPTY EMPTY 0 0 0 EMPTY big-shot/big-shot-target-titan-10x-124593 BH-10X 0
2 [empty string] BIG SHOT Big Shot SHOOTING Shooting [empty string] 1 189.99 0 189.99 27886-DEFAULT-l.jpg 189.99 27886-DEFAULT-m.jpg BIG SHOT TARGET KINETIC 650 N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4545 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 7 150-to-200 0.00 [empty string] Big Shot Target Kinetic 650 - High Energy <p>BIGshot's innovative answer for high-kinetic, high-speed crossbows continues with extreme stopping power! This high strength target utilizes the signature Iron Man stuffing with a 5 stage multi layered aramid core that stops heavy hitting bolts in their tracks. IRON MAN Kinetic 650 is rated at 650 FPS / 250 FP KE.</p><ul><li>High Compression</li><li>Easiest Pulling Target</li><li>High Tech Aramid Core</li><li>Long Lasting</li><li>95 shooting points</li><li>Field Point Only Target</li><li>For Compound or Crossbows</li><li>20H x 20W x 13D</li></ul> [empty string] N 189.99 189.99 [empty string] 27886-DEFAULT-s.jpg [empty string] 1000 1000 IM20X 124598 EMPTY EMPTY EMPTY 0 0 0 EMPTY big-shot/big-shot-target-kinetic-650-high-energy-124598 IM20X 0
3 [empty string] CENTURY ARMS Century Arms SHOOTING Shooting [empty string] 1 169.99 0 169.99 12138-DEFAULT-l.jpg 169.99 12138-DEFAULT-m.jpg MESA TACTICAL 91470 N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2840 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 150-to-200 0.00 [empty string] Mesa Tactical Urbino Tactical 91470 <p>Mesa Tactical Urbino Tactical Stock, Fits Benelli M4, Fixed, Fits with a Tactical Length of Pull, Riser, Limbsaver, Black 91470</p> [empty string] N 169.99 169.99 [empty string] 12138-DEFAULT-s.jpg [empty string] 1000 1000 91470 129322 EMPTY EMPTY EMPTY 0 0 0 EMPTY century-arms/mesa-tactical-urbino-tactical-91470-129322 91470 0
4 [empty string] CENTURY ARMS Century Arms SHOOTING Shooting [empty string] 1 54.99 0 54.99 9549-DEFAULT-l.jpg 54.99 9549-DEFAULT-m.jpg CENTURY INTERNATIONAL ARMS N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2840 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 50-to-100 0.00 [empty string] Century International Arms Magazine Tp9 15rd 9mm Pkg <ul><li>MANUFACTURER: CANIK</li><li>FAMILY: TP9 Series</li><li>MODEL: TP9 Magazine</li><li>TYPE: Accessory-Magazines</li><li>CALIBER/GAUGE: 9mm</li><li>CAPACITY: 15 rd.</li><li>SHIPPING WEIGHT: 0.3 lbs.</li><li>MFG MODEL NO: MA2082</li><li>UPC: 787450716834</li></ul> [empty string] N 54.99 54.99 [empty string] 9549-DEFAULT-s.jpg [empty string] 1000 1000 MA2082 129334 EMPTY EMPTY EMPTY 0 0 0 EMPTY century-arms/century-international-arms-magazine-tp9-15rd-9mm-pkg-129334 MA2082 0
5 [empty string] CROSSFIRE ELITE LLC Crossfire Elite Llc SHOOTING Shooting [empty string] 1 39.99 0 39.99 790-DEFAULT-l.jpg 39.99 790-DEFAULT-m.jpg CROSSFIRE CYCLSA1S2R N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4513 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 25-to-50 0.00 [empty string] Crossfire 2"-2.5" Sub-Compact Black Holster <p>The Cyclone is an extremely stable inside the waist band (IWB) and outside the waist band (OWB) holster. Designed for extreme comfort using dual clips, a comfort panel (removable), and extremely low-profile, you'll almost forget it's there. Padded neck riser keeps your firearm from touching your body.<br></p> [empty string] N 39.99 39.99 [empty string] 790-DEFAULT-s.jpg [empty string] 1000 1000 CYCLSA1S2R 131209 EMPTY EMPTY EMPTY 0 0 0 EMPTY crossfire-elite-llc/crossfire-2-2-5-sub-compact-black-holster-131209 CYCLSA1S2R 0
6 [empty string] CROSSFIRE ELITE LLC Crossfire Elite Llc SHOOTING Shooting [empty string] 1 39.99 0 39.99 598-DEFAULT-l.jpg 39.99 598-DEFAULT-m.jpg CROSSFIRE EDGBSHS2R N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4513 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 25-to-50 0.00 [empty string] Crossfire Crossfire Edge 2"-2.5" Sub-Compact Blush Holster <p>Secure but very fast, very low-profile. The Edge is a very low-profile holster system that will not close on the user due to the new &quot;3D&quot; holster design. It uses our new &quot;Speed-Retainer&quot; system for fast access to the firearm. New shape for a great look and high functionality.<br></p> [empty string] N 39.99 39.99 [empty string] 598-DEFAULT-s.jpg [empty string] 1000 1000 EDGBSHS2R 131210 EMPTY EMPTY EMPTY 0 0 0 EMPTY crossfire-elite-llc/crossfire-crossfire-edge-2-2-5-sub-compact-blush-holster-131210 EDGBSHS2R 0
7 [empty string] CROSSFIRE ELITE LLC Crossfire Elite Llc SHOOTING Shooting [empty string] 1 39.99 0 39.99 599-DEFAULT-l.jpg 39.99 599-DEFAULT-m.jpg CROSSFIRE EDGIRSS2R N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4513 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 25-to-50 0.00 [empty string] Crossfire Edge 2"-2.5" Sub-Compact Iris Holster <p>Secure but very fast, very low-profile. The Edge is a very low-profile holster system that will not close on the user due to the new &quot;3D&quot; holster design. It uses our new &quot;Speed-Retainer&quot; system for fast access to the firearm. New shape for a great look and high functionality.l<br></p> [empty string] N 39.99 39.99 [empty string] 599-DEFAULT-s.jpg [empty string] 1000 1000 EDGIRSS2R 131211 EMPTY EMPTY EMPTY 0 0 0 EMPTY crossfire-elite-llc/crossfire-edge-2-2-5-sub-compact-iris-holster-131211 EDGIRSS2R 0
8 [empty string] CROSSFIRE ELITE LLC Crossfire Elite Llc SHOOTING Shooting [empty string] 1 49.99 0 49.99 791-DEFAULT-l.jpg 49.99 791-DEFAULT-m.jpg CROSSFIRE MAGSA1C1 N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4513 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 3 25-to-50 0.00 [empty string] Crossfire The Mag Semi-Automatic Pistol Series Sub-Compact <p>The Mag, a very low-profile outside the waist band (OWB) holster with integrated magazine pouch. Its forward cant allows for an easier conceal and draw, and uses &quot;Spring-loaded Thumb Break&quot; to keep the firearm retained. This holster flexes but keeps its shape and allows for easy insertion of the pistol back into the holster.</p><ul><li>Fully-ambidextrous design.</li><li>Uses our adjustable &quot;Spring-Loaded Thumb Break.&quot;</li><li>Holster cavity creates compression fit.</li><li>Small, convenient, very low-profile holster.</li><li>Memory-type foam laminate technology.</li><li>1680 denier Ballistic Nylon fabric; durable and retains its shape.</li></ul> [empty string] N 49.99 49.99 [empty string] 791-DEFAULT-s.jpg [empty string] 1000 1000 MAGSA1C1 131219 EMPTY EMPTY EMPTY 0 0 0 EMPTY crossfire-elite-llc/crossfire-the-mag-semi-automatic-pistol-series-sub-compact-131219 MAGSA1C1 0
9 [empty string] CROSSFIRE ELITE LLC Crossfire Elite Llc SHOOTING Shooting [empty string] 1 44.99 0 44.99 597-DEFAULT-l.jpg 44.99 597-DEFAULT-m.jpg CROSSFIRE TRSA1C3R N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4513 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 25-to-50 0.00 [empty string] Crossfire The Rocket Semi-Automatic Pistol Series <p>The Rocket is a true pancake holster, but doesn't collapse like traditional pancake holsters. Using our popular &quot;3-D&quot; technology, the cavity of the holster body stays open when the firearm is drawn, making it very easy to re-holster. It uses wide-offset belt loops to keep the holster stable and also has our new &quot;Spring-Loaded Thumb Break&quot; to hold the firearm securely. Very compact design, wear concealed or non-concealed outside the waist band (OWB). The Rocket sits a little higher to allow the user to sit down comfortably. Fits most semi-auto pistols.</p><ul><li>Uses our adjustable &quot;Spring-Loaded Thumb Break.&quot;</li><li>&quot;3-D&quot; holster design will not collapse when the pistol is removed from the holster.</li><li>Memory-type foam laminate technology.</li><li>1680 denier Ballistic Nylon fabric; durable and retains its shape.</li><li>Barrel ramp system.</li></ul> [empty string] N 44.99 44.99 [empty string] 597-DEFAULT-s.jpg [empty string] 1000 1000 TRSA1C3R 131230 EMPTY EMPTY EMPTY 0 0 0 EMPTY crossfire-elite-llc/crossfire-the-rocket-semi-automatic-pistol-series-131230 TRSA1C3R 0
10 [empty string] CROSSFIRE ELITE LLC Crossfire Elite Llc SHOOTING Shooting [empty string] 1 59.99 0 59.99 792-DEFAULT-l.jpg 59.99 792-DEFAULT-m.jpg CROSSFIRE WRPSA1M1R N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4513 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 50-to-100 0.00 [empty string] Crossfire The Wrap Conceal-Carry Ankle Series 1"-1.5" Micro (Right) [empty string] [empty string] N 59.99 59.99 [empty string] 792-DEFAULT-s.jpg [empty string] 1000 1000 WRPSA1M1R 131234 EMPTY EMPTY EMPTY 0 0 0 EMPTY crossfire-elite-llc/crossfire-the-wrap-conceal-carry-ankle-series-1-1-5-micro-right-131234 WRPSA1M1R 0
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts104 ORDER BY sortposition asc