SELECT a.ID,Pic0,ShortDesc,b.City,Year,Qty,Price . FROM products as a, candc as b . WHERE a.city=b.id AND Type = 3 AND Status = "active" AND Qty>0 ORDER BY ID DESC LIMIT 0,20
HARD ROCK CAFE PIN
BLUE ICON MINI GUITAR
Mint ondition
No Location
2007
2 available
$9.00
|
HARD ROCK CAFE PIN
4TH YEAR COMPASS "STAFF"
Back No Text
Some Slight Wear
Near Mint ondition
No Location
1 available
$20.00
|
HARD ROCK CAFE PIN
KNIVES (FRIES) "STAFF"
Mint ondition
No Location
1 available
$17.00
|
HARD ROCK CAFE PIN
KNIVES (BROILER) "STAFF"
Mint ondition
No Location
1 available
$17.00
|
HARD ROCK CAFE PIN
1 YEAR TCB "STAFF"
Mint Condition
No Location
1 available
$25.00
|
HARD ROCK CAFE PIN
ROCK STAR "STAFF" 3LC
Pre 1996 USA Cafes
Mint or Near Mint Condition
No Location
1 available
$20.00
|
HARD ROCK CAFE PIN
BIKE WEEK
No City Name On Pin
Mint Condition
No Location
1 available
$15.00
|
HARD ROCK CAFE PIN
ST PATRICKS DAY SURFBOARD
Limited Edition 300
Mint Condition
Surfers Paradise
200
1 available
$15.00
|
HARD ROCK CAFE PIN
LOGO (BROWN & YELLOW)
Near Mint Condition
New York
1 available
$7.00
|
HARD ROCK CAFE PIN
ROCK GUITAR SERIES
Limited Edition 500
Mint Condition
Key West
2006
1 available
$10.00
|
HARD ROCK CAFE PIN
DOLPHIN GUITAR
Mint Condition
Guam
2007
1 available
$15.00
|
HARD ROCK CAFE PIN
UNCLE DAN GUITAR
Mint Condition
Guangzhou
2000
1 available
$7.00
|
HARD ROCK CAFE PIN
WINTERFEST DRAGON #1
Limited Edition 300
Mint Condition
Chicago
2008
1 available
$15.00
|
HARD ROCK CAFE PIN
CHARITY EVENT
Mint Condition
Bangkok
2003
1 available
$10.00
|
HARD ROCK CAFE PIN
VALENTINES DAY
Has some wear
Good To Near Mint Condition
Bangkok
1997
1 available
$5.00
|
HARD ROCK CAFE PIN
LOGO (BROWN & YELLOW)
Mint Condition
Berlin
1 available
$8.00
|
HARD ROCK CAFE PIN
MERMAID SERIES
Limited Edition 300
Mint Condition
Yokohama
2004
1 available
$20.00
|
HARD ROCK CAFE PIN
MERMAID SERIES
Limited Edition 300
Mint Condition
Uyeno-Eki
2004
1 available
$20.00
|
HARD ROCK CAFE PIN
MERMAID SERIES
Limited Edition 300
Mint Condition
Tokyo
2004
1 available
$20.00
|
HARD ROCK CAFE PIN
MERMAID SERIES
Limited Edition 300
Mint Condition
Osaka Universal City
2004
1 available
$20.00
|
