• Other Recommendations
  • Best Selling Products
  • Product Reviews
  • Feedback

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND p.ID != 3342 AND p.post_status = 'publish' AND p.post_date_gmt <' at line 2]
SELECT p.*, count(tr.object_id) as count FROM wp_term_taxonomy AS tt, wp_term_relationships AS tr, wp_posts AS p WHERE tt.taxonomy ='post_tag' AND tt.term_taxonomy_id = tr.term_taxonomy_id AND tr.object_id = p.ID AND tt.term_id IN () AND p.ID != 3342 AND p.post_status = 'publish' AND p.post_date_gmt < NOW() GROUP BY tr.object_id ORDER BY count DESC, p.post_date_gmt DESC LIMIT 8;

4 thoughts on “NFL San Francisco 49ers ’47 Frost MVP Camo Adjustable Hat, One Size Fits Most, Realtree Camouflage

  1. Pingback: NFL San Francisco 49ers ’47 Frost MVP Camo Adjustable Hat, One Size Fits Most, Realtree Camouflage | 49ers.xyz

  2. 2 of 2 people found the following review helpful
    3.0 out of 5 stars
    Update: not bad, not exactly as described on amazon and photographed here though. cap lining color on front is gray, December 10, 2014
    By 
    R. McGinness (WA) –
    (REAL NAME)
      

    Verified Purchase(What’s this?)
    Sure would be nice if AMAZON stocked up better on stuff like this! Geez. Way to go there Amazon!

    Update 8-5-15: I did get the hat, it’s not terrible. I think they should change the description however as the hat I got is not the blue “Frosted” cap with blue cap lining and lettering on front pictured here. Instead the caps brim lining and text is gray- which is not entirely that bad, it’s just not what was described in what I purchased. Aside from that, the hat is alright, got the camo realtree design and seahawks logo on front. So can’t give it 5 stars for that.

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

  3. 1 of 1 people found the following review helpful
    5.0 out of 5 stars
    Just like the picture!, August 21, 2015
    By 
    B.Smith

    Verified Purchase(What’s this?)
    One nice thing about this hat… more specifically its listing on Amazon, is the high quality pictures. There are great pictures of both the front, and the back. It leaves very little doubt to the smart shopper that it is camouflage, and that it has a Velcro adjustment strap on the back. I can’t imagine any scenario where someone could not know exactly what they may be getting before purchasing.

    Upon receipt of the hat I discovered that is is EXACTLY like the one in the pictures. Right down to the velcro closure. I saw in the photos a “REALTREE” logo stamped in the camo pattern. Lo and behold, right there on my actual hat that I received is the SAME LOGO. I’m sure someone will be disappointed that the product is not “Mossy Oak” instead, but sure enough… right there in the description is the word “Realtree”. So I wanted a Realtree hat, and GOT a Realtree hat. Amazing how that works.

    The hat is constructed very solid. The bill is well formed to the curl as shown in the pictures and very rigid to hold that shape. The fabric is very tough and although I just received it, have little doubt that it will be durable and last a long time. The embroidered logo is sharp and is raised above the fabric to stand out nicely. All the embroidery of the “REDSKINS” name and logo is VERY well done. The colors of the logo are bold and pop out from the camo nicely.

    If you are looking for a Redskins hat that is camo, preferably Realtree camo, and if you like a velcro closure, this is your hat!

    HOWEVER… if you do NOT want a Redskins hat that is camo with a velcro closure, Amazon is kind enough to have a solution for you. Near the top of the page is a big, white box that spans the length of the screen almost. In that box type the words “Redskins hat”. In the background, a small army of Amazon employees frantically gather all types of styles of Redskins hats and present them to you nearly instantly. From there you can choose one of the many alternatives. They have burgundy hats, gold hats, black hats, leather hats, fabric hats, curled brim hats, flat brim hats, even a few floppy hats! Get the right one for YOU.

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

  4. 1 of 1 people found the following review helpful
    2.0 out of 5 stars
    Disappointing., October 1, 2015
    By 
    L. A. Kane (Seattle, WA USA) –
    (VINE VOICE)
      
    (TOP 1000 REVIEWER)
      

    Verified Purchase(What’s this?)
    Not what I expected… First off, it doesn’t look like the photo. The brim is a washed out light gray, not a dark blue. Second, the material is extremely thin, thinner than any other hat of this style that I own. Third, the sizing is very small, so it fit’s oddly. I had to let the back tab out nearly 2/3 of the way whereas with most it overlaps that much. On the good side the logo is true to form and nice embroidery. Just wish the hat lived up to it… sigh.

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

Share your experience about this product