• 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 != 3270 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 != 3270 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 Two Piece Rocks Glass Set – Primary Logo

  1. 23 of 23 people found the following review helpful
    2.0 out of 5 stars
    A thin glass with a poorly applied team logo stuck to the surface of the glass, December 7, 2013
    By 
    MTM

    Verified Purchase(What’s this?)
    These glasses are certainly a disappointment. The glasses themselves have thin sides with a surprisingly thick (1/8″) logo glued to the surface of the glass. In our case the team logo didn’t even wrap flush all the way around the glass so part of the logo sticks out from the glass on each end. The protrusion and non-uniform adhesion not only looks cheap but makes handling of the glass awkward.

    Overall a low quality item that may serve fine if just used for display, but not friendly for actual usage as a glass.

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

  2. 22 of 22 people found the following review helpful
    2.0 out of 5 stars
    Looks cheap and the logo is 50% thicker than the glass, February 3, 2014
    By 
    outdoortechie (Southern USA) –

    Verified Purchase(What’s this?)

    Customer Video Review Length:: 1:54 Mins

    It appears the logo was meant for Great American Product’s travel mug, as it’s too wide for the glass and out of proportion. And, the logo, which is about 3/32″, is 50% thicker than the glass, which is about 1/16″ thick. Further, the logo was just cheaply glued on, so not nearly as nice as the manufacturer photos.

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

  3. 28 of 31 people found the following review helpful
    3.0 out of 5 stars
    Nice look, not practical, February 11, 2011
    By 

    Verified Purchase(What’s this?)
    These are nice rocks glasses and the team logo looks great. however, i found out that these are NOT dishwasher safe when they arrived. I probably wouldn’t have gotten them knowing this in advance…but my hubby who these were for, doesn’t want to return them… so i stuck hand-washing…

    0

    Help other customers find the most helpful reviews 

    Was this review helpful to you? Yes
    No

  4. Pingback: NFL San Francisco 49ers Two Piece Rocks Glass Set – Primary Logo | 49ers.xyz

Share your experience about this product