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 RT_EXCAPE SCENT LOK Scent Lok CLOTHING Clothing>Hunting>Outerwear>Men RT_EXCAPE|NULL|NULL 1 139.99 1 129.99 9993-DEFAULT-l.jpg 139.99 9993-DEFAULT-m.jpg SCENT LOK MNS SAVANNA AERO JAC N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1471 .SCENTLOKSAVANNAAEROJACKET [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 28 100-to-150 0.00 [empty string] Scent Lok Savanna Aero Jacket <p>We tailored the Savanna Aero Crosshair system with all the features a warm weather hunter would need, and stripped away everything they don't.</p><p><strong>FEATURES:</strong></p><ul><li>Carbon Alloy technology</li><li>For maximum odor adsorption</li><li>Moisture Wicking</li><li>Keeps you cool &amp; dry</li><li>Antimicrobial treatment</li><li>For maximum odor prevention</li><li>No sheen fabric</li><li>Helps reduce visibility in the field</li><li>Spandex Cuff</li><li>Keeps sleeves secure and in place</li><li>Safety Harness opening</li><li>Allows Carbon Alloy to control odors on harness</li><li>Three pockets</li><li>For added storage &amp; accessibility</li></ul> [empty string] N 129.99 139.99 L,2X,3X,M,S,XL 9993-DEFAULT-s.jpg [empty string] 1000 1000 1016110 77562 OUTERWEAR MEN EMPTY 0 0 0 HUNTING scent-lok/scent-lok-savanna-aero-jacket-77562 1016110 0
2 RT_EXCAPE SCENT LOK Scent Lok CLOTHING Clothing>Hunting>Outerwear>Men RT_EXCAPE|NULL|NULL 1 129.99 1 119.99 16421-DEFAULT-l.jpg 129.99 16421-DEFAULT-m.jpg SCENT LOK MNS SAVANNA AERO HOO N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1471 .SCENTLOKSAVANNAAEROHOODIE [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 9 100-to-150 0.00 [empty string] Scent Lok Savanna Aero Hoodie [empty string] [empty string] N 119.99 129.99 M,XL,3X,L,S 16421-DEFAULT-s.jpg [empty string] 1000 1000 1016117 77563 OUTERWEAR MEN EMPTY 0 0 0 HUNTING scent-lok/scent-lok-savanna-aero-hoodie-77563 1016117 0
3 RT_EXCAPE SCENT LOK Scent Lok UNCATEGORIZED Uncategorized RT_EXCAPE|NULL|NULL 1 99.99 1 89.99 10003-DEFAULT-l.jpg 99.99 10003-DEFAULT-m.jpg SCENT LOK MNS SAVANNA AERO 1/4 N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1471 .SCENTLOKSAVANNAAERO1-4ZIP [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 4 50-to-100 0.00 [empty string] Scent Lok Savanna Aero 1/4 Zip <p>A tailored quarter-zip shirt constructed from ultra-lightweight Savanna Aero fabric perfect for beating the heat in the early season.</p><p><strong>FEATURES:</strong></p><ul><li>Carbon Alloy technology</li><li>For maximum odor adsorption</li><li>Antimicrobial Treatment</li><li>For maximum odor prevention</li><li>Moisture Wicking</li><li>Keeps you cool &amp; dry</li><li>Smooth polyester fabric</li><li>For maximum comfort in the field</li><li>Quarter-zip design</li><li>For easy dressing &amp; increased ventilation</li><li>Zipper cover</li><li>For protection against neck abrasion</li><li>Raglan sleeves</li><li>For increased mobility</li></ul> [empty string] N 89.99 99.99 S,M,3X 10003-DEFAULT-s.jpg [empty string] 1000 1000 1016119 77564 OUTERWEAR MEN EMPTY 0 0 0 HUNTING scent-lok/scent-lok-savanna-aero-1-4-zip-77564 1016119 0
4 RT_EXCAPE SCENT LOK Scent Lok CLOTHING Clothing>Hunting>Bottoms>Men RT_EXCAPE|NULL|NULL 1 139.99 1 129.99 9997-DEFAULT-l.jpg 139.99 9997-DEFAULT-m.jpg SCENT LOK MNS SAVANNA AERO PAN N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1471 .SCENTLOKSAVANNAAEROPANT [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 9 100-to-150 0.00 [empty string] Scent Lok Savanna Aero Pant <p>We tailored the Savanna Aero Crosshair system with all the features a warm weather hunter would need, and stripped away everything they don't.</p><p><strong>FEATURES:</strong></p><ul><li>Carbon Alloy technology</li><li>For maximum odor adsorption</li><li>Moisture Wicking</li><li>Keeps you cool &amp; dry</li><li>Antimicrobial treatment</li><li>For maximum odor prevention</li><li>No sheen fabric</li><li>Helps reduce visibility in the field</li><li>Six pocket design</li><li>To keep essentials close</li><li>Side waist adjusters</li><li>Ensures a custom fit</li><li>Inner thigh gusset &amp; articulated knees</li><li>Allows ultimate mobility in the field</li></ul> [empty string] N 129.99 139.99 M,S,2X,L,3X 9997-DEFAULT-s.jpg [empty string] 1000 1000 1016120 77565 EMPTY MEN EMPTY 0 0 0 HUNTING scent-lok/scent-lok-savanna-aero-pant-77565 1016120 0
5 RT_EXCAPE SCENT LOK Scent Lok CLOTHING Clothing>Hunting>Outerwear>Men RT_EXCAPE|NULL|NULL 1 179.99 1 169.99 16416-DEFAULT-l.jpg 179.99 16416-DEFAULT-m.jpg SCENT LOK MNS FOREFRONT JACKET N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1471 .SCENTLOKFOREFRONTJACKET [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 6 150-to-200 0.00 [empty string] Scent Lok Forefront Jacket [empty string] [empty string] N 169.99 179.99 L,2X,M,3X 16416-DEFAULT-s.jpg [empty string] 1000 1000 1021010 77566 OUTERWEAR MEN EMPTY 0 0 0 HUNTING scent-lok/scent-lok-forefront-jacket-77566 1021010 0
6 RT_EXCAPE SCENT LOK Scent Lok CLOTHING Clothing>Hunting>Bottoms>Men RT_EXCAPE|NULL|NULL 1 179.99 1 169.99 16417-DEFAULT-l.jpg 179.99 16417-DEFAULT-m.jpg SCENT LOK MNS FOREFRONT PANT N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1471 .SCENTLOKFOREFRONTPANT [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 13 150-to-200 0.00 [empty string] Scent Lok Forefront Pant [empty string] [empty string] N 169.99 179.99 XL,L,M,2X 16417-DEFAULT-s.jpg [empty string] 1000 1000 1021020 77567 EMPTY MEN EMPTY 0 0 0 HUNTING scent-lok/scent-lok-forefront-pant-77567 1021020 0
7 RT_EXCAPE SCENT LOK Scent Lok CLOTHING Clothing>Hunting>Outerwear>Men RT_EXCAPE|NULL|NULL 1 179.99 1 99.99 9983-DEFAULT-l.jpg 179.99 9983-DEFAULT-m.jpg SCENT LOK MNS REACTOR JACKET N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1471 .SCENTLOKREACTORJACKET [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 6 50-to-100 0.00 [empty string] Scent Lok Reactor Jacket <p>The BE:1 Reactor is the bowhunter's solution to on-demand insulation, without the noise of traditional puff jackets. An optimum choice for warmth, the hybrid design provides low-bulk insulation in the core areas of the body and stretch fabrics in areas of high activity. The Reactor series can be worn as a stand-alone shell piece or a layering piece for additional warmth.</p><p> </p><p><strong>FEATURES:</strong></p><ul><li>Carbon Alloy technology</li><li> For maximum odor adsorption</li><li>Thermal mapped Thinsulate insulation</li><li> Offers the perfect warmth</li><li>Premium body &amp; upper arm fabric</li><li> Provides crucial quietness</li><li>Stretch cuff and waist</li><li>For great range-of-motion</li><li>Three pocket design</li><li> To keep your essential gear secure</li><li>Thumbholes on sleeves</li><li> For added warmth and easy layering </li></ul> [empty string] Y 99.99 99.99 M,L,3X 9983-DEFAULT-s.jpg [empty string] 1000 1000 1030810 77568 OUTERWEAR MEN EMPTY 0 0 0 HUNTING scent-lok/scent-lok-reactor-jacket-77568 1030810 0
8 RT_EXCAPE SCENT LOK Scent Lok CLOTHING Clothing>Hunting>Bottoms>Men RT_EXCAPE|NULL|NULL 1 179.99 1 99.99 9988-DEFAULT-l.jpg 179.99 9988-DEFAULT-m.jpg SCENT LOK MNS REACTOR PANT N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1471 .SCENTLOKREACTORPANT [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 4 50-to-100 0.00 [empty string] Scent Lok Reactor Pant <p>The BE:1 Reactor is the bowhunter's solution to on-demand insulation, without the noise of traditional puff jackets. An optimum choice for warmth, the hybrid design provides low-bulk insulation in the core areas of the body and stretch fabrics in areas of high activity. The Reactor series can be worn as a stand-alone shell piece or a layering piece for additional warmth.</p><p> </p><p><strong>FEATURES:</strong></p><ul><li>Carbon Alloy technology</li><li> For maximum odor adsorption</li><li>Thermal mapped Thinsulate insulation</li><li> Offers the perfect warmth</li><li>Premium body &amp; lower leg fabric</li><li> Provides crucial quietness</li><li>Stretch cuff and waist</li><li> For great range-of-motion</li><li>Drawstring waist adjusters</li><li> Ensure a secure fit</li><li>Zip fly</li><li> For ease-of-use</li><li>Tapered legs</li><li> Great for easy layering</li></ul> [empty string] Y 99.99 99.99 2X,L,3X 9988-DEFAULT-s.jpg [empty string] 1000 1000 1030820 77569 EMPTY MEN EMPTY 0 0 0 HUNTING scent-lok/scent-lok-reactor-pant-77569 1030820 0
9 RT_EDGE SCENT LOK Scent Lok UNCATEGORIZED Uncategorized RT_EDGE|NULL|NULL 0 269.99 1 259.99 [empty string] 269.99 [empty string] SCENT LOK MNS MORPHIC V2 JACKE N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1471 .SCENTLOKMORPHICV2JACKET [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 6 250-to-300 0.00 [empty string] Scent Lok Mns Morphic V2 Jacke [empty string] [empty string] N 259.99 269.99 XL,M,2X,L [empty string] [empty string] 1000 1000 1035310 77572 EMPTY EMPTY EMPTY 0 0 0 EMPTY scent-lok/scent-lok-mns-morphic-v2-jacke-77572 1035310 0
10 RT_EDGE SCENT LOK Scent Lok UNCATEGORIZED Uncategorized RT_EDGE|NULL|NULL 0 219.99 0 219.99 [empty string] 219.99 [empty string] SCENT LOK MNS MORPHIC V2 PANT N [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1471 .SCENTLOKMORPHICV2PANT [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 1 4 200-to-250 0.00 [empty string] Scent Lok Mns Morphic V2 Pant [empty string] [empty string] N 219.99 219.99 L,XL [empty string] [empty string] 1000 1000 1035320 77573 EMPTY EMPTY EMPTY 0 0 0 EMPTY scent-lok/scent-lok-mns-morphic-v2-pant-77573 1035320 0
CACHED false
EXECUTIONTIME 0
SQL SELECT * FROM GetALLProducts ORDER BY sortposition asc