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
SUMMER SURFER GIRL
Limited Edition 500
Mint Condition
San Francisco
2004
1 available
$15.00
|
HARD ROCK CAFE PIN
SUMMER SURFER GIRL
Limited Edition 500
Mint Condition
Atlantic City
2004
1 available
$15.00
|
HARD ROCK CAFE PIN
SUMMER SURFER GIRL
Limited Edition 500
Mint Condition
Las Vegas
2004
1 available
$15.00
|
HARD ROCK CAFE PIN
SUMMER SURFER GIRL
Limited Edition 500
Mint Condition
Baltimore
2004
1 available
$15.00
|
HARD ROCK CAFE PIN
SUMMER SURFER GIRL
Limited Edition 500
Mint Condition
Hollywood FL
2004
1 available
$15.00
|
HARD ROCK CAFE PIN
SUMMER SURFER GIRL
Limited Edition 500
Mint Condition
San Diego
2003
1 available
$15.00
|
HARD ROCK CAFE PIN
SUMMER SURFER GIRL
Limited Edition 1000
Mint Condition
Las Vegas
2003
1 available
$15.00
|
HARD ROCK CAFE PIN
SUMMER SURFER GIRL
Limited Edition 500
Mint Condition
Baltimore
2003
1 available
$15.00
|
HARD ROCK CAFE PIN
SUMMER SURFER GIRL
Limited Edition 500
Mint Condition
Myrtle Beach
2003
1 available
$15.00
|
HARD ROCK CAFE PIN
SUMMER SURFER GIRL
Limited Edition 500
Mint Condition
Miami
2003
1 available
$15.00
|
HARD ROCK CAFE PIN
SUMMER SURFER GIRL
Limited Edition 1000
Mint Condition
San Francisco
2003
1 available
$15.00
|
HARD ROCK CAFE PIN
MOTORCYCLE
Wheels Move Around
Limited Edition 300
Mint Condition
Kobe
2003
1 available
$20.00
|
HARD ROCK CAFE PIN
8TH ANNIVERSARY GIRL
Limited Edition 200
Mint Condition
Fukuoka
2008
2 available
$18.00
|
HARD ROCK CAFE PIN
CHERRY BLOSSOM GIRL
Limited Edition 200
Mint Condition
Fukuoka
2008
1 available
$17.00
|
HARD ROCK CAFE PIN
SPORTS PANDA SERIES #1
Limited Edition 300
Mint Condition
Uyeno-Eki
2008
2 available
$17.00
|
HARD ROCK CAFE PIN
MUSICIAN BEAR SERIES #1
Limited Edition 300
Mint Condition
Tokyo
2008
2 available
$17.00
|
HARD ROCK CAFE PIN
CHERRY BLOSSOM PANDA
Limited Edition 300
Mint Condition
Uyeno-Eki
2008
2 available
$18.00
|
HARD ROCK CAFE PIN
GRAND OPENING LUGGAGE RACK
Limited Edition 1000
Mint Condition
San Diego Hotel
2008
1 available
$25.00
|
HARD ROCK CAFE PIN
KOI FISH SERIES "HAPPY"
Limited Edition 200
Mint Condition
Fukuoka
2008
1 available
$18.00
|
HARD ROCK CAFE PIN
THANKSGIVING PANDA
Limited Edition 300
Mint Condition
Washington D.C.
2007
1 available
$16.00
|
