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 BLACK_WHITE J+S CATTLE J+s Cattle UNCATEGORIZED Uncategorized BLACK_WHITE|NULL|NULL 0 19.99 0 19.99 [empty string] 19.99 [empty string] J S CATTLE CO TRUCKER MESH CAP N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4971 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 28 15-to-20 0.00 [empty string] J S Cattle Co Trucker Mesh Cap [empty string] [empty string] N 19.99 19.99 OS [empty string] [empty string] 1000 1000 FRONT 131607 EMPTY EMPTY EMPTY 0 0 0 EMPTY j-s-cattle/j-s-cattle-co-trucker-mesh-cap-131607 FRONT 0
2 BLUE_RASPBERRY GENESIS Genesis ARCHERY Archery>Compound Bow BLUE_RASPBERRY|NULL|NULL 1 159.99 0 159.99 29119-DEFAULT-l.jpg 159.99 29119-DEFAULT-m.jpg MATHEWS GENESIS BOW N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 586 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 150-to-200 0.00 [empty string] Mathews Genesis Bow - Youth Left Hand <p>The Genesis System eliminates let-off on light draw weight bows (where its unnecessary) so there are no specific draw length requirements. The result is a bow that fits virtually everyone (15 to 30) and that a young person cant outgrow. A Genesis bow, set at 20lbs. (it's adjustable from 10 to 20 lbs), stores and releases energy comparable to that of a 35lb. recurve! Plus, with zero let-off, it has the 'holding weight' necessary to 'pull the string from your finger,' making it easy to shoot.</p><ul><li>Color: Blue</li><li>Weight (pounds): 2.95</li><li>Dexterity: Left Hand</li><li>IBO Speed (FPS): 137-170</li><li>Brace Height (inches): 7.625</li><li>Axle to Axle or Overall Length (inches): 35.5</li><li>Peak Draw Weight (lbs): 20</li><li>Draw Length Range (inches): Up to 30</li><li>Preset Draw Length (inches): No Specific</li><li>Let Off (percent): 0</li></ul> [empty string] N 159.99 159.99 LH 29119-DEFAULT-s.jpg [empty string] 1000 1000 10471 182383 EMPTY EMPTY EMPTY 0 0 0 EMPTY genesis/mathews-genesis-bow-youth-left-hand-182383 10471 0
3 BLUE GENESIS Genesis ARCHERY Archery>Compound Bow BLUE|NULL|NULL 1 219.99 0 219.99 9473-DEFAULT-l.jpg 219.99 9473-DEFAULT-m.jpg MATHEWS GENESIS KIT N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 586 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 200-to-250 0.00 [empty string] Mathews Genesis Bow Kit <p>The original Genesis , the official bow of NASP , has been utilized to establish more archers across the world than any other bow model in history. This is largely due to its simplicity, durability, universal draw length, and &quot;zero let-off&quot; design. These innovations eliminate most of the major barriers for anyone to enter into the sweet sport of archery. Available in right or left hand draw as a stand-alone bow or as a kit. Kit includes tube quiver, arm guard and 5 XX75 arrows*.</p><p><em>*Please note, kit arrows will be identical but are random colors and may not match bow color.</em></p> [empty string] N 219.99 219.99 LH 9473-DEFAULT-s.jpg [empty string] 1000 1000 10925 182386 EMPTY EMPTY EMPTY 0 0 0 EMPTY genesis/mathews-genesis-bow-kit-182386 10925 0
4 RED GENESIS Genesis ARCHERY Archery>Compound Bow RED|NULL|NULL 1 219.99 0 219.99 9472-DEFAULT-l.jpg 219.99 9472-DEFAULT-m.jpg MATHEWS GENESIS KIT N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 586 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 200-to-250 0.00 [empty string] Mathews Genesis Bow Kit <p>The original Genesis , the official bow of NASP , has been utilized to establish more archers across the world than any other bow model in history. This is largely due to its simplicity, durability, universal draw length, and &quot;zero let-off&quot; design. These innovations eliminate most of the major barriers for anyone to enter into the sweet sport of archery. Available in right or left hand draw as a stand-alone bow or as a kit. Kit includes tube quiver, arm guard and 5 XX75 arrows*.</p><p><em>*Please note, kit arrows will be identical but are random colors and may not match bow color.</em></p> [empty string] N 219.99 219.99 LH 9472-DEFAULT-s.jpg [empty string] 1000 1000 10929 182388 EMPTY EMPTY EMPTY 0 0 0 EMPTY genesis/mathews-genesis-bow-kit-182388 10929 0
5 RED GENESIS Genesis ARCHERY Archery>Compound Bow RED|NULL|NULL 1 219.99 0 219.99 8907-DEFAULT-l.jpg 219.99 8907-DEFAULT-m.jpg MATHEWS GENESIS KIT N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 586 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 200-to-250 0.00 [empty string] Mathews Genesis Bow Kit <p>The original Genesis , the official bow of NASP , has been utilized to establish more archers across the world than any other bow model in history. This is largely due to its simplicity, durability, universal draw length, and &quot;zero let-off&quot; design. These innovations eliminate most of the major barriers for anyone to enter into the sweet sport of archery. Available in right or left hand draw as a stand-alone bow or as a kit. Kit includes tube quiver, arm guard and 5 XX75 arrows*.</p><p><em>*Please note, kit arrows will be identical but are random colors and may not match bow color.</em></p> [empty string] N 219.99 219.99 RH 8907-DEFAULT-s.jpg [empty string] 1000 1000 10930 182389 EMPTY EMPTY EMPTY 0 0 0 EMPTY genesis/mathews-genesis-bow-kit-182389 10930 0
6 PURPLE GENESIS Genesis ARCHERY Archery>Compound Bow PURPLE|NULL|NULL 1 219.99 0 219.99 20455-DEFAULT-l.jpg 219.99 20455-DEFAULT-m.jpg MATHEWS GENESIS KIT N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 586 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 200-to-250 0.00 [empty string] Mathews Genesis Bow Kit <p>The original Genesis , the official bow of NASP , has been utilized to establish more archers across the world than any other bow model in history. This is largely due to its simplicity, durability, universal draw length, and &quot;zero let-off&quot; design. These innovations eliminate most of the major barriers for anyone to enter into the sweet sport of archery. Available in right or left hand draw as a stand-alone bow or as a kit. Kit includes tube quiver, arm guard and 5 XX75 arrows*.</p><p><em>*Please note, kit arrows will be identical but are random colors and may not match bow color.</em></p> [empty string] N 219.99 219.99 RH 20455-DEFAULT-s.jpg [empty string] 1000 1000 10932 182390 EMPTY EMPTY EMPTY 0 0 0 EMPTY genesis/mathews-genesis-bow-kit-182390 10932 0
7 ORANGE GENESIS Genesis ARCHERY Archery>Compound Bow ORANGE|NULL|NULL 1 219.99 0 219.99 8910-DEFAULT-l.jpg 219.99 8910-DEFAULT-m.jpg MATHEWS GENESIS KIT N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 586 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 200-to-250 0.00 [empty string] Mathews Genesis Bow Kit <p>The original Genesis , the official bow of NASP , has been utilized to establish more archers across the world than any other bow model in history. This is largely due to its simplicity, durability, universal draw length, and &quot;zero let-off&quot; design. These innovations eliminate most of the major barriers for anyone to enter into the sweet sport of archery. Available in right or left hand draw as a stand-alone bow or as a kit. Kit includes tube quiver, arm guard and 5 XX75 arrows*.</p><p><em>*Please note, kit arrows will be identical but are random colors and may not match bow color.</em></p> [empty string] N 219.99 219.99 RH 8910-DEFAULT-s.jpg [empty string] 1000 1000 11419 182392 EMPTY EMPTY EMPTY 0 0 0 EMPTY genesis/mathews-genesis-bow-kit-182392 11419 0
8 BLACK GENESIS Genesis ARCHERY Archery>Compound Bow BLACK|NULL|NULL 1 219.99 0 219.99 8909-DEFAULT-l.jpg 219.99 8909-DEFAULT-m.jpg MATHEWS GENESIS KIT N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 586 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 2 200-to-250 0.00 [empty string] Mathews Genesis Bow Kit <p>The original Genesis , the official bow of NASP , has been utilized to establish more archers across the world than any other bow model in history. This is largely due to its simplicity, durability, universal draw length, and &quot;zero let-off&quot; design. These innovations eliminate most of the major barriers for anyone to enter into the sweet sport of archery. Available in right or left hand draw as a stand-alone bow or as a kit. Kit includes tube quiver, arm guard and 5 XX75 arrows*.</p><p><em>*Please note, kit arrows will be identical but are random colors and may not match bow color.</em></p> [empty string] N 219.99 219.99 RH 8909-DEFAULT-s.jpg [empty string] 1000 1000 12240 182401 EMPTY EMPTY EMPTY 0 0 0 EMPTY genesis/mathews-genesis-bow-kit-182401 12240 0
9 AMBUSH GENESIS Genesis ARCHERY Archery>Compound Bow AMBUSH|NULL|NULL 1 219.99 0 219.99 20444-DEFAULT-l.jpg 219.99 20444-DEFAULT-m.jpg MATHEWS GENESIS KIT N AMAZON,EBAY [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 586 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 200-to-250 0.00 [empty string] Mathews Genesis Bow Kit <p>The original Genesis , the official bow of NASP , has been utilized to establish more archers across the world than any other bow model in history. This is largely due to its simplicity, durability, universal draw length, and &quot;zero let-off&quot; design. These innovations eliminate most of the major barriers for anyone to enter into the sweet sport of archery. Available in right or left hand draw as a stand-alone bow or as a kit. Kit includes tube quiver, arm guard and 5 XX75 arrows*.</p><p><em>*Please note, kit arrows will be identical but are random colors and may not match bow color.</em></p> [empty string] N 219.99 219.99 LH 20444-DEFAULT-s.jpg [empty string] 1000 1000 12295 182403 EMPTY EMPTY EMPTY 0 0 0 EMPTY genesis/mathews-genesis-bow-kit-182403 12295 0
10 [empty string] TECHNA CLIP Techna Clip SHOOTING Shooting>Accessories>Holsters [empty string] 1 29.99 0 29.99 761-DEFAULT-l.jpg 29.99 761-DEFAULT-m.jpg TECHNA CLIP 238BR N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4635 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 25-to-50 0.00 [empty string] Techna Clip for Sig Sauer P238 <p>The Techna Clip comes with screws and an Allen key that secures the Techna Clip to right side of the gun. Extra screws are included. The high quality Teflon coating prevents abrasion to the gun by providing a thin but highly durable cushion between the Techna Clip and the slide. The Techna Clip comes in Nickel plated and fits all Sig Sauer P238 models. We do NOT use double-sided sticky tape like our competitors.</p><ul><li>Included: (Black) High Carbon Spring Steel belt clip, plated with Teflon Stone Coat 5100 and grip plate replacement screws.</li><li>Quick 5-minute install with NO modification required. (Installs on the Right Side of the gun)</li><li>Techna Clip is a Minimalist Holster solution for those who Conceal Carry.</li></ul> [empty string] N 29.99 29.99 [empty string] 761-DEFAULT-s.jpg [empty string] 1000 1000 238BR 208918 HOLSTERS EMPTY EMPTY 0 0 0 EMPTY techna-clip/techna-clip-for-sig-sauer-p238-208918 238BR 0
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts ORDER BY sortposition asc