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

Welcome, Guest

Wish List

Featured Penn State Gear

1 [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 44 20-to-25 0.00 1 [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
2 [empty string] SAPPHIRE,DUMMYCOLOR THON THON SPORTSWEAR SPORTSWEAR &GT; T-SHIRTS &GT; SHORT SLEEVE &GT; SCREEN PRINTED 15 0 15 YES 14423-DEFAULT-l.jpg [empty string] 15 14423-DEFAULT-m.jpg 4 Weeks 4 Thon Promotional Tee N 32 5-and-under 0.00 3 [empty string] 4 Weeks 4 Thon T-Shirt <p><font size="+1"><b>4 Weeks 4 Thon T-Shirt</b></font></p> <ul> <li>Gildan 100% cotton uni-sex&nbsp; men's cut tee</li> <li>Screen printed logo on the front and the back</li> </ul> [empty string] Y 5 5 L,XL,S,XXL,DUMMYSIZE 14423-DEFAULT-s.jpg 1000 3751 4328 SHORT SLEEVE SCREEN PRINTED EMPTY [empty string] 0 0 0 THON thon/4-weeks-4-thon-promotional-tee-4328 1
3 [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 47 25-to-50 0.00 1 [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
4 [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 23 50-to-100 0.00 0 [empty string] League Embroider 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
5 [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 79 25-to-50 5.00 2 [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
6 [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 138 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
7 [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 11 50-to-100 0.00 2 [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
8 [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 209 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
9 [empty string] NAVY,DUMMYCOLOR BOXERCRAFT Boxercraft LADIES LADIES &GT; PANTS &GT; SLEEPWEAR 29 0 29 YES 14394-DEFAULT-l.jpg [empty string] 29 14394-DEFAULT-m.jpg Ladies Lion Flannel Pant N 220 25-to-50 0.00 0 [empty string] Ladies Lion Flannel Pant <p>&nbsp;<font size="+1"><b>BoxerCraft Ladies Lion Flannel Pant</b></font></p> <ul> <li>Custom Lion logo design is unique to Lions Pride</li> <li>Front accent pocket</li> <li>Stylish cuff</li> <li>2-button false fly</li> <li>Constructed from super-soft, 4 oz 100% cotton flannel</li> <li>Satin tie</li> </ul> <p>&nbsp;</p> [empty string] N 29 29 L,M,XL,S,DUMMYSIZE 14394-DEFAULT-s.jpg 1000 F16 3934 SLEEPWEAR EMPTY EMPTY [empty string] 0 0 0 PANTS boxercraft/ladies-lion-flannel-pant-3934 1
10 [empty string] NAVY,DUMMYCOLOR PING Ping SPORTSWEAR SPORTSWEAR &GT; POLO SHIRTS &GT; SHORT SLEEVE &GT; PERFORMANCE 65 0 65 YES 13913-DEFAULT-l.jpg [empty string] 65 13913-DEFAULT-m.jpg Ping Hoizon Perf Stripe Polo N 10 50-to-100 0.00 1 [empty string] Ping Horizon Polo Shirt <p><strong><span style="font-size: large;">Ping Horizon Stripe Polo Shirt</span></strong></p> <ul> <li><span style="font-size: small;">100% polyester</span></li> <li><span style="font-size: small;">Classic fit</span></li> <li><span style="font-size: small;">Sensor Cool technology</span></li> <li><span style="font-size: small;">Yarn dye fabric with gradient graphite stripe<br /> </span></li> <li><span style="font-size: small;">Self fabric collar</span></li> <li><span style="font-size: small;">Embroidered Penn State logo</span></li> </ul> [empty string] N 65 65 L,M,DUMMYSIZE 13913-DEFAULT-s.jpg 1000 14S1137NVY 3738 SHORT SLEEVE PERFORMANCE EMPTY [empty string] 0 0 0 POLO SHIRTS ping/ping-hoizon-perf-stripe-polo-3738 2
11 [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 41 50-to-100 0.00 1 [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
12 [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 37 50-to-100 0.00 1 [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
13 [empty string] NAVY,DUMMYCOLOR NIKE Nike HATS HATS &GT; ADULT &GT; ADJUSTABLE 28 0 28 YES 13747-DEFAULT-l.jpg [empty string] 28 13747-DEFAULT-m.jpg Nike Performance Coaches Hat N 37 10-to-15 0.00 0 [empty string] Nike Performance Coaches Cap <p><font size="+1"><b>Nike Performance Coaches Hat</b></font></p> <ul> <li>This is Simply the most comfortable hat you'll ever wear</li> <li>100% Dri-FIT polyester</li> <li>Pinnacle performance in Nike's wearable Legacy91 silhouette</li> <li>Features patented comfortbill construction that reduces weith and improves moisture management without looking too technical</li> <li>High density embroidery center front</li> <li>Swoosh design trademark embroidered on the bill</li> <li>Contrast binding and pop eyelets</li> <li>Hook and loop closure with a silicone grommet at back for a clean finish</li> </ul> [empty string] Y 14 14 ADJ,DUMMYSIZE 13747-DEFAULT-s.jpg 1000 29566NVY 3418 ADJUSTABLE EMPTY EMPTY [empty string] 0 0 0 ADULT nike/nike-performance-coaches-hat-3418 2
14 [empty string] GRAY,DUMMYCOLOR CHAMPION Champion SPORTSWEAR SPORTSWEAR &GT; HOODED SWEATSHIRTS &GT; EMBROIDERED 65 0 65 YES 14200-DEFAULT-l.jpg [empty string] 65 14200-DEFAULT-m.jpg Champion Heritage Hood N 2 25-to-50 0.00 0 [empty string] Champion Heritage Hood <FONT SIZE="+1"><B>Champion Heritage Hood</B></FONT><UL><LI>60% cotton/ 40% polyester heavyweight french terry with light brushing</LI><LI>Secondary pop of team color in jersey lined hood and draw cords</LI><LI>Rib side panels</LI></UL> [empty string] Y 32.5 32.5 M,DUMMYSIZE 14200-DEFAULT-s.jpg 1000 CS1946GRY 3258 EMPTY EMPTY EMPTY [empty string] 0 0 0 STAFF PICKS champion/champion-heritage-hood-3258 1
15 [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 9 25-to-50 0.00 5 [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
16 [empty string] NAVY,DUMMYCOLOR LEAGUE League LADIES LADIES &GT; HOODED SWEATSHIRTS &GT; HOODS 49 0 49 YES 12951-DEFAULT-l.jpg [empty string] 49 12951-DEFAULT-m.jpg League Ladies Vs Hoody N 17 25-to-50 0.00 0 [empty string] League Ladies VS Hoody <p><font size="+1"><b>League Ladies Victory Springs Hoody</b></font></p> <ul> <li>Tri Blend Fleece - 60% cotton/ 30% polyester/10% rayon</li> <li>A trendy new take on the 1/4 zip fleece</li> <li>Preppy with a vintage feel</li> <li>Screen printed logo</li> </ul> [empty string] N 49 49 L,XL,DUMMYSIZE 12951-DEFAULT-s.jpg 1000 TR100NVY 2559 HOODS EMPTY EMPTY [empty string] 0 0 0 LEAGUE league/league-ladies-vs-hoody-2559 3
17 [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 12 [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
18 [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 28 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
19 [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 12 [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 DIPLOMA FRAMES EMPTY EMPTY [empty string] 0 0 0 OFFICE / EXECUTIVE church-hill/church-hill-photo-diploma-frame-539 25
20 [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 50 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
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 »