Penn State Clothing and Nittany Lions Merchandise Shipped from State College, PA 1-800-462-0068

Welcome, Guest

Wish List


Featured Penn State Gear



query
RESULTSET
query
  ALTERNATETEAM ATTR1LIST BRAND BRANDDISPLAY DEPT DEPTTREE INTERNALLISTPRICE INTERNALMARKDOWN INTERNALPRICE ISFEATUREDITEM LARGEPICTURE LEAGUE LISTPRICE MEDIUMPICTURE NAME NEW OVERALLQOH PRICERANGE PRODREVIEWSAVERAGE PRODUCTAGE RANKING REALNAME ROMANTICCOPYLONG ROMANTICCOPYSHORT SALE SALEPRICERANGEBOTTOM SALEPRICERANGETOP SIZELIST SMALLPICTURE SORTPOSITION STYLE STYLE_ID SUBTYP1 SUBTYP2 SUBTYP3 TEAM TERMSALE TERMSALELISTPRICE TERMSALEPRICE TYP URL WEIGHT
1 [empty string] Navy/White,DUMMYCOLOR LEGACY Legacy HATS HATS &GT; ADULT &GT; ADJUSTABLE 26 0 26 YES 14483-DEFAULT-l.jpg [empty string] 26 14483-DEFAULT-m.jpg Wool Flannel Trucker Hat N 31 25-to-50 0.00 0 [empty string] Wool Flannel Trucker Hat <p><strong><span style="font-size: larger;">Wool Flannel Trucker Hat</span></strong></p> <ul> <li>Classic fall fabrics meet Legacy&rsquo;s Supersoft mesh to create our most distinctive trucker. </li> <li>Featuring a soft foam liner behind the front crown panels, the Prep Trucker was recently voted our most comfortable cap!</li> <li>Full crown top stitching and a premium hi-density visor board</li> <li>Old-school kelly green undervisor</li> <li>Snap back closure</li> </ul> [empty string] N 26 26 ADJ,DUMMYSIZE 14483-DEFAULT-s.jpg 1000 450760 4423 ADJUSTABLE EMPTY EMPTY [empty string] 0 0 0 ADULT legacy/wool-flannel-trucker-hat-4423 1
2 [empty string] NAVY,DUMMYCOLOR JVP JVP SPORTSWEAR SPORTSWEAR &GT; T-SHIRTS &GT; LONG SLEEVE &GT; SCREEN PRINTED 22 0 22 YES 14426-DEFAULT-l.jpg [empty string] 22 14426-DEFAULT-m.jpg Joe Paterno 409 Long Sleeve T N 41 20-to-25 0.00 0 [empty string] Joe Paterno 409 Long Sleeve T <p>&nbsp;</p> <p><strong><span style="font-size: larger;">Joe Paterno 409 Long Sleeve Tee<br /> </span></strong></p> <ul> <li>Joe Paterno's 409 wins have been restored!</li> <li>Celebrate the Winningest Coach of All Time with this shirt</li> <li>The lettering within the numbers 409 reflects each of Joe's accomplishments as a coach and philanthropist</li> </ul> <p>&nbsp;</p> [empty string] N 22 22 L,XL,S,XXL,DUMMYSIZE 14426-DEFAULT-s.jpg 1000 3755 4333 LONG SLEEVE SCREEN PRINTED EMPTY [empty string] 0 0 0 T-SHIRTS jvp/joe-paterno-409-long-sleeve-t-4333 2
3 [empty string] GRAY,DUMMYCOLOR LEAGUE League LADIES LADIES &GT; CREW SWEATSHIRTS &GT; QUARTER ZIP CREWS 60 0 60 YES 14511-DEFAULT-l.jpg [empty string] 60 14511-DEFAULT-m.jpg League Fashion 1/4 Zip N 59 50-to-100 0.00 1 [empty string] League Fashion 1/4 Zip <p><strong><span style="font-size: larger;">League Fashion 1/4 Zip</span></strong></p> <ul> <li>94% cotton/ 6% polyester body</li> <li>100% polyester yoke</li> <li>Lightweight and luxurious brushed terry fleece</li> </ul> [empty string] N 60 60 L,M,XL,S,DUMMYSIZE 14511-DEFAULT-s.jpg 1000 TF100GRY 4331 QUARTER ZIP CREWS EMPTY EMPTY [empty string] 0 0 0 LEAGUE league/league-fashion-1-4-zip-4331 2
4 [empty string] NAVY,DUMMYCOLOR LEAGUE League LADIES LADIES &GT; T-SHIRTS &GT; LONG SLEEVE 28 0 28 YES 14463-DEFAULT-l.jpg [empty string] 28 14463-DEFAULT-m.jpg League Ladies Long Sleeve Tee N 70 25-to-50 0.00 0 [empty string] League Ladies Long Sleeve Tee <p><strong><span style="font-size: larger;">League Ladies Long Sleeve Tee</span></strong></p> <ul> <li>100% cotton jersey long sleeve tee</li> <li>Individually garment washed for extraordinary softness</li> <li>'Fitted&nbsp; ladies cut</li> <li>Waterbase imprint for vintage hand feel</li> </ul> [empty string] N 28 28 L,M,XL,S,DUMMYSIZE 14463-DEFAULT-s.jpg 1000 SP660NVY 4326 LONG SLEEVE EMPTY EMPTY [empty string] 0 0 0 T-SHIRTS league/league-ladies-long-sleeve-tee-4326 1
5 [empty string] PACIFIC,DUMMYCOLOR LEAGUE League LADIES LADIES &GT; T-SHIRTS &GT; LONG SLEEVE 48 0 48 YES 14430-DEFAULT-l.jpg [empty string] 48 14430-DEFAULT-m.jpg League Color Block Ra Ra Lst N 41 25-to-50 0.00 0 [empty string] League Color Block Ra Ra <p><strong><span style="font-size: large;">League Color Block Ra Ra Jersey Long Sleeve T-Shirt</span></strong></p> <ul> <li><span style="font-size: small;">Oversized heavy weight long sleeve tee</span></li> <li><span style="font-size: small;">100% cotton</span></li> <li><span style="font-size: small;">Screen printed Penn State logos on front and back</span></li> <li><span style="font-size: small;">Laid back, slouchy fit that looks good with everything</span></li> </ul> <p>&nbsp;</p [empty string] N 48 48 L,M,XL,S,DUMMYSIZE 14430-DEFAULT-s.jpg 1000 MF620BLU 4308 LONG SLEEVE EMPTY EMPTY [empty string] 0 0 0 T-SHIRTS league/league-color-block-ra-ra-lst-4308 1
6 [empty string] NAVY,DUMMYCOLOR LEAGUE League SPORTSWEAR SPORTSWEAR &GT; JACKETS &GT; LIGHT WEIGHT 55 0 55 YES 14422-DEFAULT-l.jpg [empty string] 55 14422-DEFAULT-m.jpg League Embroider Full Zip Hood N 20 50-to-100 0.00 0 [empty string] League Embroidered Full Zip Hood <p><span style="font-size: large;"><strong>League Embroidered Full Zip Hood</strong></span></p> <ul> <li>Tri Blend full zip up hood</li> <li>60% cotton / 30% polyester /10% rayon</li> <li>Embroidered PENN STATE&nbsp;letters</li> <li>Sporty vintage look with a preppy attitude</li> <li>Sure to become your favorite hoodie</li> <li>Modern fit</li> </ul> [empty string] N 55 55 L,M,XL,DUMMYSIZE 14422-DEFAULT-s.jpg 1000 ML485NVY 4304 ZIPPER EMPTY EMPTY [empty string] 0 0 0 LEAGUE league/league-embroider-full-zip-hood-4304 3
7 [empty string] NAVY,DUMMYCOLOR SPIRIT Spirit LADIES LADIES &GT; T-SHIRTS &GT; LONG SLEEVE 50 0 50 YES 14391-DEFAULT-l.jpg [empty string] 50 14391-DEFAULT-m.jpg Spirit Brand Spirit Jersey Lc N 75 25-to-50 5.00 1 [empty string] Spirit Brand Spirit Jersey <p id="description"><span style="font-size: large;"><strong>Spirit Football Jersey - Penn State</strong></span><strong><span style="font-size: larger;"><br /> </span></strong></p> <ul class="infoTXT"> <li><span style="font-size: small;">Authentic. Famous. Original. Spirit Football Jersey. Made in the USA</span></li> <li><span style="font-size: small;">Spirit Jerseys have become the de facto way to show your spirit and solidarity with your school in style and comfort</span></li> <li><span style="font-size: small;">Features unmistakable bold back print in their famous puff ink and unique drop shoulder design</span></li> <li><span style="font-size: small;">Screen printed front logo</span></li> <li><span style="font-size: small;">Designed to fit oversized</span></li> </ul> [empty string] N 50 50 S,XS,M,L,DUMMYSIZE 14391-DEFAULT-s.jpg 1000 J470NVY15 4290 LONG SLEEVE EMPTY EMPTY [empty string] 0 0 0 T-SHIRTS spirit/spirit-brand-spirit-jersey-lc-4290 2
8 [empty string] Navy/Gray/White,DUMMYCOLOR UNDER ARMOUR Under Armour SPORTSWEAR SPORTSWEAR &GT; POLO SHIRTS &GT; SHORT SLEEVE &GT; PERFORMANCE 75 0 75 YES 14375-DEFAULT-l.jpg [empty string] 75 14375-DEFAULT-m.jpg Under Armour Links Stripe Polo N 8 50-to-100 0.00 0 [empty string] Under Armour Links Stripe Polo <p><strong><span style="font-size: larger;">Under Armour Links Stripe Polo</span></strong></p> <ul> <li>96% polyester/ 4% elastane</li> <li>30+ UPF protects your skin from the sun's harmful rays</li> <li>Anti-odor technology prevents the growth of odor causing microbes</li> <li>Moisture transport system wicks sweat away from the body</li> <li>Stretchy, light and breathable</li> <li>Multi-color yarn dye stripe with all over emboss pater</li> <li>UA logo on left sleeve</li> <li>Rib knit collar</li> <li>Penn State logo embroidered on left chest</li> </ul> [empty string] N 75 75 L,M,XL,XXL,DUMMYSIZE 14375-DEFAULT-s.jpg 1000 UM0491NVY 4236 SHORT SLEEVE PERFORMANCE EMPTY [empty string] 0 0 0 POLO SHIRTS under-armour/under-armour-links-stripe-polo-4236 1
9 [empty string] WHITE,DUMMYCOLOR NIKE Nike SPORTSWEAR SPORTSWEAR &GT; T-SHIRTS &GT; LONG SLEEVE &GT; SCREEN PRINTED 32 0 32 YES 14264-DEFAULT-l.jpg [empty string] 32 14264-DEFAULT-m.jpg Nike Unrivaled Psfb Lng Slv T N 135 25-to-50 0.00 0 [empty string] Nike Unrivaled PSFB Lng Slv T <p>&nbsp;</p> <p><strong><span style="font-size: larger;">Nike Unrivaled PS Football&nbsp; Long Sleeve Tee</span></strong></p> <ul> <li><span style="font-size: small;">100% cotton long sleeve t-shirt</span><span style="font-size: larger;"><br /> </span></li> <li>Cotton crew neck t-shirt with Nike Unrivaled design</li> <li>Swoosh design trademark at left shoulder</li> </ul> <p>&nbsp;</p> [empty string] N 32 32 L,M,XL,S,XXL,DUMMYSIZE 14264-DEFAULT-s.jpg 1000 33292WHT 4169 LONG SLEEVE SCREEN PRINTED EMPTY [empty string] 0 0 0 WHITE OUT nike/nike-unrivaled-psfb-lng-slv-t-4169 2
10 [empty string] BLUE,DUMMYCOLOR CUTTER & BUCK Cutter & Buck LADIES LADIES &GT; SHIRTS 65 0 65 YES 14036-DEFAULT-l.jpg [empty string] 65 14036-DEFAULT-m.jpg Cb Ladies Micro Print Oxford N 9 50-to-100 0.00 0 [empty string] CB Ladies Micro Print Oxford <p><strong><span style="font-size: larger;">Cutter &amp; Buck Ladies Micro Print Oxford</span></strong></p> <ul> <li>100% cotton plain weave</li> <li>Self fabric banded collar</li> <li>Button front Y-neck</li> <li>Grosgrain ribbon trim at inside sleeve placket</li> <li>Forward shoulders</li> <li>Front darts</li> <li>Curved hem</li> <li>Drop tail</li> <li>Cutter &amp; Buck pennant on teh inside placket</li> <li>Micro geo all over pattern</li> <li>Embroidered Penn State logo</li> </ul> [empty string] N 65 65 L,XL,XS,DUMMYSIZE 14036-DEFAULT-s.jpg 1000 04147 3963 EMPTY EMPTY EMPTY [empty string] 0 0 0 SHIRTS cutter-buck/cb-ladies-micro-print-oxford-3963 1
11 [empty string] NAVY,DUMMYCOLOR BOXERCRAFT Boxercraft SPORTSWEAR SPORTSWEAR &GT; PANTS &GT; SWEATPANTS 25 0 25 YES 14392-DEFAULT-l.jpg [empty string] 25 14392-DEFAULT-m.jpg Nittany Lion Flannel Pant N 207 20-to-25 0.00 0 [empty string] Boxercraft Flannel NIttany Lion Pant <p>&nbsp;</p> <p><font size="+1"><b>Boxercraft Flannel NIttany Lion Pant</b></font></p> <ul> <li>Custom lion head design is unique to Lions Pride</li> <li>Features a covered elastic waistband with taping, no fly, no pockets</li> <li>Constructed from super-soft, 4 oz 100% cotton flannel</li> <li>Longer length and roomy cut</li> <li>Unisex Fit</li> </ul> <p>&nbsp;</p> [empty string] N 25 25 L,M,XL,S,XXL,DUMMYSIZE 14392-DEFAULT-s.jpg 1000 F19 3935 SWEATPANTS EMPTY EMPTY [empty string] 0 0 0 PANTS boxercraft/nittany-lion-flannel-pant-3935 1
12 [empty string] NAVY,DUMMYCOLOR UNDER ARMOUR Under Armour LADIES LADIES &GT; CREW SWEATSHIRTS &GT; QUARTER ZIP CREWS 65 0 65 YES 14053-DEFAULT-l.jpg [empty string] 65 14053-DEFAULT-m.jpg Ua Ladies Verve 1/2 Zip Crew N 40 50-to-100 0.00 0 [empty string] UA Ladies Verve 1/2 Zip Crew <p>&nbsp;</p> <p><strong><span style="font-size: larger;">UA Ladies Verve 1/2 Zip Crew</span></strong></p> <ul> <li>94% polyester/ 6%spandex</li> <li>Super soft fabric delivers stretch and incredible next to skin comfort</li> <li>Comfortable 1/2 zip front for extra coverage and on demand ventilation</li> <li>Thumb holes keep sleeves secure and help seal in your body heat</li> <li>Drop tail enures extra coverage</li> </ul> <p>&nbsp;</p> [empty string] N 65 65 L,M,XL,S,DUMMYSIZE 14053-DEFAULT-s.jpg 1000 UW1291NVY 3528 QUARTER ZIP CREWS EMPTY EMPTY [empty string] 0 0 0 CREW SWEATSHIRTS under-armour/ua-ladies-verve-1-2-zip-crew-3528 2
13 [empty string] WHITE,DUMMYCOLOR UNDER ARMOUR Under Armour LADIES LADIES &GT; HOODED SWEATSHIRTS &GT; HOODS 65 0 65 YES 13937-DEFAULT-l.jpg [empty string] 65 13937-DEFAULT-m.jpg Ua Ladies French Terry Hood N 34 50-to-100 0.00 0 [empty string] UA Ladies French Terry Hood <FONT SIZE="+1"><B>UA Ladies French Terry Hood</B></FONT><UL><LI>93% polyester/ 7% spandex</LI><LI>Soft & super lightweight french terry fabric gives you warmth without weight</LI><LI>Two piece hood with cross over neck for enhanced comfort</LI><LI>Rib on cuffs, waistband and pockets</LI><LI>Thumbhole construction at cuff</LI></UL> [empty string] N 65 65 L,M,XL,S,DUMMYSIZE 13937-DEFAULT-s.jpg 1000 UW1578WHT 3518 HOODS EMPTY EMPTY [empty string] 0 0 0 HOODED SWEATSHIRTS under-armour/ua-ladies-french-terry-hood-3518 3
14 [empty string] As Shown,DUMMYCOLOR BLAKEWAY Blakeway GIFTS GIFTS &GT; OFFICE / EXECUTIVE &GT; WALL HANGINGS &GT; PRINTS 30 0 30 YES 13514-DEFAULT-l.jpg [empty string] 30 13514-DEFAULT-m.jpg 2013 Homecoming Rolled Poster N 19 25-to-50 0.00 0 [empty string] 2013 Homecoming Rolled Poster <FONT SIZE="+1"><B>2013 Homecoming Rolled Poster</B></FONT><UL><LI>Print measures 40 x 13.5 inches</LI><LI>This panorama, taken by Christopher Gjevre, captures the excitement of the Penn State Nittany Lion fans as their team scores a touchdown during a sell-out homecoming game that ultimately resulted in a stunning win over Michigan at Beaver Stadium</LI><LI> Nittany Lion fans showed their Penn State pride and wore white at the game for the all-stadium white out, cheering their team to victory in the fourth overtime</LI></UL> [empty string] N 30 30 1 Size,DUMMYSIZE 13514-DEFAULT-s.jpg 1000 PSU4T 3245 WALL HANGINGS PRINTS EMPTY [empty string] 0 0 0 OFFICE / EXECUTIVE blakeway/2013-homecoming-rolled-poster-3245 1
15 [empty string] GRAY,DUMMYCOLOR RFSJ RFSJ GIFTS GIFTS &GT; HOME &GT; DRINKWARE &GT; COFFEE MUGS 12 0 12 YES 13124-DEFAULT-l.jpg [empty string] 12 13124-DEFAULT-m.jpg 16oz.Mk Matte Gray Logo Mug N 61 10-to-15 0.00 1 [empty string] 16oz. MK Matte Gray Logo Mug <p><font size="+1"><b>16 oz. MK Matte Finish Gray Logo Mug</b></font></p> <ul> <li>16 oz gray matte finish diner mug with Penn State Nittany Lion logo in white imprint.</li> <li>It makes for a great big cup of coffee and has a unique hour glass style shape.</li> <li>Makes a great gift for coffee/tea drinkers, or makes a great mug for pens on your desk.</li> </ul> [empty string] N 12 12 1 Size,DUMMYSIZE 13124-DEFAULT-s.jpg 1000 TMF4545SG 2948 EMPTY EMPTY EMPTY [empty string] 0 0 0 HOME rfsj/16oz-mk-matte-gray-logo-mug-2948 1
16 [empty string] NAVY/WHITE,DUMMYCOLOR TEAM EFFORT Team Effort GIFTS GIFTS &GT; SPORTS &GT; GOLF ACCESSORIES &GT; BAGS 199.95 0 199.95 YES 12738-DEFAULT-l.jpg [empty string] 199.95 12738-DEFAULT-m.jpg Team Effort Cooler Cart Bag N 9999 150-to-200 0.00 30 [empty string] Team Effort Cooler Cart Bag <FONT SIZE="+1"><B>Team Effort Cooler Cart Bag</B></FONT><UL><LI>The Bucket cooler cart bag features the latest innovations for the practical minded golfer</LI><LI>Insulated thermal-lined beverage pocket with integrated drainage port keeps beverages and snacks coold through the 18th hole and beyond</LI><LI>14 way top organizer with front putter well features 2 sturdy tactile molded rubber handles for easy maneuvering</LI><LI>Rubber non-skid feet offer added stablility and prevent twisting when bag is riding in your cart</LI><LI>Padded shoulder strap with retainer sleeve and removable rain hood</LI><LI>First rait organization and functionality</LI></UL> [empty string] N 199.95 199.95 1 Size,DUMMYSIZE 12738-DEFAULT-s.jpg 1000 27BKB 2524 GOLF ACCESSORIES BAGS EMPTY [empty string] 0 0 0 SPORTS team-effort/team-effort-cooler-cart-bag-2524 15
17 [empty string] WHITE/NAVY,DUMMYCOLOR STOUS STOUS GIFTS GIFTS &GT; AUTO &GT; MAGNETS 3 0 3 YES 12283-DEFAULT-l.jpg [empty string] 3 12283-DEFAULT-m.jpg 409 Magnet N 15 5-and-under 0.00 0 [empty string] 5 3/4 x 3 3/8 inch 409 Magnet <p><font size="+1"><b>5 3/4 x 3 3/8 inch 409 Magnet</b></font></p> <ul> <li>Perfect for just about anywhere. Car, office, tailgate grill or refrigerator.</li> </ul> [empty string] N 3 3 1 Size,DUMMYSIZE 12283-DEFAULT-s.jpg 1000 409-2997 1976 MAGNETS EMPTY EMPTY [empty string] 0 0 0 PATERNO stous/409-magnet-1976 1
18 [empty string] As Shown,DUMMYCOLOR CHURCH HILL Church Hill GIFTS GIFTS &GT; OFFICE / EXECUTIVE &GT; DIPLOMA FRAMES 199 0 199 YES 11311-DEFAULT-l.jpg [empty string] 199 11311-DEFAULT-m.jpg Church Hill Photo Diploma Frame N 9999 150-to-200 0.00 5 [empty string] Church Hill Photo Diploma Frame <p><font size="+1"><b>Church Hill Photo Diploma Frame</b></font></p> <ul> <li><b>Best Seller!</b> Year in and year out the wide view collection continues to sell very well.</li> <li>Our Panoramic Photo Edition features a beautiful panoramic image of the Nittany Lion Statue mounted above your diploma, with Penn State's name and seal gold embossed on navy museum-quality matting.</li> <li>It is framed in our Galleria moulding, a solid hardwood with a high-gloss cherry lacquer finish and an inner gold lip.</li> <li>This moulding is a narrower version of our Gallery frame.</li> <li>Finished size measures 16&quot; x 20&quot;.</li> <li>Fits an 8.5&quot; x 11&quot; diploma.</li> <br /> <font color="red"><b>NOTE</b> </font> <li>If this item is &quot;In Stock&quot; it will ship from Lions Pride in 1-2 business days</li> <li>If this item is listed as &quot;Drop Ship&quot; it means that the item will ship from the manufacturer</li> <li>You will need to allow 2-3 weeks for &quot;Drop Ship&quot; delivery.</li> <li>Drop shipped items will <u><b>only</b></u> be shipped via ground delivery.</li> </ul> [empty string] N 199 199 1 Size,DUMMYSIZE 11311-DEFAULT-s.jpg 1000 132744 539 EMPTY EMPTY EMPTY [empty string] 0 0 0 OFFICE / EXECUTIVE church-hill/church-hill-photo-diploma-frame-539 25
19 [empty string] NAVY/WHITE,DUMMYCOLOR BARBARIAN Barbarian SPORTSWEAR SPORTSWEAR &GT; DRESS SHIRTS &GT; RUGBY 79 0 79 YES 12894-DEFAULT-l.jpg [empty string] 79 12894-DEFAULT-m.jpg Authentic Heavy- Weight Rugby N 46 50-to-100 0.00 1 [empty string] Authentic Heavy-weight Rugby <p><font size="+1"><b>Authentic Heavy-weight Rugby</b></font></p> <ul> <li>Barbarian brand&nbsp; preshrunk authentic cotton rugby shirt</li> <li>Embroidered lion head on front</li> <li>Concealed rubber buttons</li> </ul> [empty string] N 79 79 L,XL,XXS,XS,XXL,DUMMYSIZE 12894-DEFAULT-s.jpg 1000 STK 424 RUGBY EMPTY EMPTY [empty string] 0 0 0 DRESS SHIRTS barbarian/authentic-heavyweight-rugby-424 3
CACHED true
EXECUTIONTIME 0
SQL SELECT distinct style_id , max(url) as url , max(realName) as realName , max(style) as style , max(overallqoh) as overallqoh , max(sale) as sale , max(new) as new , max(SmallPicture) as SmallPicture , max(MediumPicture) as MediumPicture , max(LargePicture) as LargePicture , max(sortposition) as sortposition , max(dept) as dept , max(typ) as typ , max(subtyp1) as subtyp1 , max(subtyp2) as subtyp2 , max(subtyp3) as subtyp3 , max(brand) as brand , max(branddisplay) as branddisplay , max(team) as team , max(league) as league , max(priceRange) as priceRange , min(salePriceRangeBottom) as salePriceRangeBottom , max(salePriceRangeTop) as salePriceRangeTop , max(ListPrice) as ListPrice , max(ranking) as ranking , max(alternateteam) as alternateteam , max(romanticcopylong) as romanticcopylong , max(romanticcopyshort) as romanticcopyshort , max(depttree) as depttree , max(weight) as weight , max(attr1list) as attr1list , max(sizelist) as sizelist , max(name) as name , max(isFeaturedItem) as isFeaturedItem , max(prodreviewsaverage) as prodreviewsaverage , max(INTERNALLISTPRICE) as INTERNALLISTPRICE , max(INTERNALMARKDOWN) as INTERNALMARKDOWN , max(INTERNALPRICE) as INTERNALPRICE , max(TERMSALELISTPRICE) as TERMSALELISTPRICE , max(TERMSALEPRICE) as TERMSALEPRICE , max(TERMSALE) as TERMSALE , max(PRODUCTAGE) as PRODUCTAGE FROM [dbo].[web_all_products] WHERE pictureid is not null and HPFEATURED='1' GROUP BY STYLE_ID ORDER BY style_id desc

Our Penn State Sports Blog

A Couple Falls and a Finalist After a sweep of the first round, a few Nittany Lions met their match in the second round of wrestling on Friday.  Senior 174 lbs. Matt Brown remains the only Penn State wrestler... View Full Article »
Matt Brown Makes the History Books

National Championship Saturday was a bit different than usual for the Penn State wrestling team. With only one wrestler in the finals and no chance of a team title... View Full Article »