HOME
Search Chip Gallery
New Issues Service
Specific Themes
NEVADA AUSTIN Golden Club BAKER Border Inn Great Basin BATTLE MOUNTAIN Battle Mountain Club Commercial Hotel Copper Club Hotel Nevada Owl Club Silver Dollar CARLIN Humboldt Club Nevada Club Overland Bar CARSON CITY Artichoke Joe's Artichoke's Poker Palace Black Gold Broderick's Bar [EB] Cactus Jack's Carson Hot Springs Carson Inn, Zieglers Carson Station Casino Fandango Cave Club Maverick Embers, The Gold Dust West Golden Spike, Chuck's Horseshoe Club, Carson Hunter's Lodge Jackpot Crossing K-Bar, Hal Dorn's Kit Carson Club Lucky Spur Max Casino Mint, The Mother Lode Nugget, Carson Ormsby House PiƱon Plaza Senator Bar Senator Club Silver Spur Travelodge Treasure Chest Victory Club, Carson Victory Club, Tommy's DAYTON Terrible's Casino Dayton ELKO Commercial Hotel Crumley Hotels Gold Country Gold Dust West Horseshoe Club Jackpot Club New Deal Club Ranchinn Red Lion Inn & Casino Red Lion Motor Inn Royal Crest Ranchinn Silver Dollar Club Silver Dollar Saloon, Bill & Dan's Stage-Coach Inn Stockmen's Town House ELY Ace of Clubs Airport Lodge Alpine Club Bank Club Capitol Club Chief, The Collins Court Casino Fireside Inn Hotel Nevada Jailhouse Casino Miners Club Mustang Club Northern Lounge Pit, The Saddle Club Town Club Winners Circle EUREKA Lincoln Hotel Nevada Club Owl Club FALLON Bank Club, Barney's Bird Farm Bonanza Inn Club Horseshoe Corner Bar Depot Esquire Club Frankie's Club Headquarters Keystone Club Lucky Spot Mom's Place Nevada Club Nugget, Fallon Owl Club Palace Club Pastime Club, Jerry's Roadside Inn Sagebrush Club Star Club Stockman's FERNLEY Light House Bar Nugget, Fernley Pioneer Crossing Casino Silverado Sturgeon's Truck Inn GABBS Keystone Club Toiyabe Club GARDNERVILLE Golden Bubble Ritchford Hotel Sharkey's Wa She Shu Casino GERLACH Capooch Club Country Club Desert Club Joe's Miner's Club HAWTHORNE Club Tonga El Capitan Hawthorne Club Joe's Monte Carlo, Hawthorne's Nevada Club JACKPOT Cactus Pete's Casino 93 Diamond Jim's Horse Shu Club Horseshu Hotel & Casino Stardust, Ray & Ruth's LAKE TAHOE (North) Bal Tabarin Cal-Neva Biltmore Cal-Neva Lodge/Resort Cal-Vada Lodge Cal-Vada Lodge, New Crystal Bay Club Hyatt / Grand Lodge Casino Incline Village Kings Castle Monte Carlo Nevada Lodge North Shore Club Nugget, Jim Kelley's Nugget, Tahoe Sierra Lodge Sierra Tahoe Ta-Neva-Ho Tahoe Biltmore Tahoe Colonial LAKE TAHOE (South) Barney's Bill's Bonanza Club Caesars Caesars Tahoe Casino de Paris Circus Room Country Club Dopey Norman's Gary's Casino Gateway Club, George's Glass Crutch Hard Rock Hotel & Casino Harrah's Tahoe Harvey's Harvey's Inn High Sierra Horizon Lakeside Inn Montbleu Nevada Club Nugget, Ed's Tahoe Nugget, John's Tahoe Nugget, South Tahoe Oliver's Club Park Tahoe Riverboat Sahara Tahoe Shack, The Sky Harbor South Shore Club South Tahoe Casino Stardust Tahoe Palace Tahoe Plaza Tahoe Village Tony's Club LAS VEGAS Hard Rock LOVELOCK Bank Club, Felix's Big Meadow Davin's Jax Club Pershing Hotel Sturgeon's MCDERMITT Say When MCGILL Stray Antlers (Elk's Club) MILL CITY Alamo Casino MINA Mina Bar MINDEN Carson Valley Inn Minden Hotel Minden Inn Pony Express MONTGOMERY PASS Montgomery Lodge, Soper's Montgomery Pass Lodge MOUNTAIN CITY Miner's Club RENO Atlantis B & C Bally's Bank Club Bank Palace Club Barn Club Bonanza Casino Bonanza Club Boomtown (Verdi) Bordertown Brand K Bar Carlton Cheers China Mint Christmas Tree Circus Circus Clarion Hotel Casino Club Cal-Neva Club Harlem Colbrandt's Flamingo Club Colonial Casino Colony Casino Colony Club Comstock Confucius Club Corner Bar, Bill's Cosmo Club/Casino Country Club Deerhead Lodge Diamond's Casino Dog House Doll House Eddie's Fabulous 50's Eldorado Elk's Lodge 597 Fan-Tan Fitzgerald's Flamingo Hilton Fortune Club Frisco Club Frontier Gambler, The Gay Ninety's, Steve's Gem Casino Gold Dust Casino Gold Dust West Gold Ranch (Verdi) Golden Golden Bank Golden Hotel Casino Golden Phoenix Grand Sierra Resort Great Provider Greyhound Casino Happy Buddha Club Harold's Club Harold's Gun Club Harrah's Reno Haymarket Club Hilton Hobey's (Sun Valley) Holiday Holiday Lodge Holiday Spa Horseshoe Club Jimmie's Casino Club Jubilee (Pleasant Valley) Kings Inn Lawton's Hot Springs Mac's Mapes Hotel/Casino Mapes-Money Tree MGM Grand Mint Club Money Tree Monte Carlo Mr. C's Nevada Club New China Club New Star Keno Nugget Casino (Verdi) Nugget, Jim Kelley's Nugget, The Oak Room Casino Old Reno Casino Onslow Overland Hotel Pacos Palace Club Peppermill Piccadilly Pioneer Players Ponderosa Poor Pete's Primadonna Prospector (Verdi) Reef, The Regal Service Station Reno Card Room Reno Casino Reno Ramada RenoCasinoChips.com River Palace Riverboat Riverside Riverside, Jessie Beck's Riverside, Pick Hobson's Rocky's Sahara Reno Sands SH Corral Shadows, The Siena Silver Dollar Casino Silver Dollar, Harley's Silver Legacy Silver Spur Speakeasy Sun Valley Casino Sundowner Sunflower Supper Club Swede's Town Club Town House Trocadero United Club Vagabond Val's Verdi Inn Virginian Waldorf Club Willows Zimba's SILVER SPRINGS Red Coach SMOKY VALLEY (Round Mountain) Carvers Country SPARKS Alamo Travel Center Baldini's Bar West Claim Stake Crystal Card Club D&N Bar Gold Club High Sierra Howard Johnson's Kellison & Poncia Cigar Store King of Clubs Mint Nugget (Sparks, Dick Graves') Nugget Casino resort Nugget, John Ascuaga's Plantation Rail City Saddle Club Shy Clown Sierra Sid's Silver Club (also Karl's) Sparks Lodge 2397 (B.P.O.E.) Trader Dick's Treasury Club Victorian Gambling Hall, Giudici's Western Village SPRING CREEK Scoreboard Sports Bar TONOPAH Ace Club Mizpah Pastime Club Rex Silver Strike Casino Station House Tonopah Belle Tonopah Club Tonopah Station TOPAZ LAKE Casey's Greg-Mar Lodge Horizons Librandi's Nugget, Ed's Topaz Pine Nut Casino Topaz Lodge VIRGINIA CITY Bonanza Club Brass Rail Saloon [PH] Bucket of Blood Capitol Bar (JJJ) Crystal Saloon Delta Old Washoe Club Ponderosa Saloon Red Garter Silver Queen WELLS 4-Way Casino Chinatown Casino El Rancho Hotel Lucky J's Old West Inn Pequop Hotel Ranch House Wagon Wheel WENDOVER A-1 Casino Goldrush Hide-Away Club Jim's Casino & Saloon Montego Bay Nevada Crossing Nugget, State Line Nugget, Wendover Peppermill Wendover Rainbow Casino Red Garter Saloon/Casino Silver Smith State Line Casino WINNEMUCCA Arrow Club Atomic Club Bank Club, Felix's Boon Dock’s Cattlemens Ferris Hotel Forty-Niner Truck Plaza Gem Humboldt Casino Ironhorse Casino Legends Casino & Lounge Mint Club Model T Monte's Club Overland Hotel Red Lion Inn Casino Scotty’s Club Sierra Sid's Sonoma Inn Star Sundance Texan Club TJ’s Dirty Bird Casino Vic's Club Winners Hotel & Casino Winners Inn YERINGTON Casino West Eagle Club Kopper Korner Games L & L Bar Lucky Club Lyon Hotel Owl Bar/Club Pioneer Crossing Casino Silver Palace |
SELECT
t_casinos.casino_id as casino_id,
t_casinos.casino_name as casino_name,
t_casinos.casino_web_url as casino_url,
t_casinos.address1 as cas_add_1,
t_casinos.address2 as cas_add_2,
t_casinos.casino_description as casino_description,
cities_nevada.city as city,
cities_nevada.city_id as city_id,
t_states.state as state,
t_states.state_id as state_id,
chip_denom.denom as denom,
chip_molds.mold as mold,
chip_condition.c_condition as c_condition,
t_chips.chip_image_url as chip_url,
t_chips.tcr_number as tcr_no,
t_chips.chip_category as chip_cat,
t_chips.condition_id as condition_id,
t_chips.issue_date as issue_date,
t_chips.date_certain as date_certain,
t_chips.date_entered as date_entered,
t_chips.chip_description as chip_description,
t_chips.traders_avail as traders_avail,
t_chips.trade_value as trade_value
from t_chips, t_casinos, cities_nevada, t_states, chip_denom, chip_molds, chip_condition where
t_chips.casino_id = t_casinos.casino_id and
t_chips.city_id = cities_nevada.city_id and
t_chips.state_id = t_states.state_id and
t_chips.denom_id = chip_denom.denom_id and
t_chips.mold_id = chip_molds.mold_id and
t_chips.condition_id = chip_condition.condition_id and
(t_chips.in_collection REGEXP 'Y|N|D|S' or
(t_chips.in_collection='T' and t_chips.traders_avail > 0)) and
t_chips.chip_description LIKE '%Bowling%'
ORDER BY t_casinos.casino_name, cities_nevada.city, t_chips.group_by, t_chips.present_order_no, chip_denom.denom
Specific Themes - Bowling 18 chips total, 50 max per page. Showing 1-18.
|
Atlantis | RENO, NEVADA |
TCR#: | N9280 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | BJONES |
Issue/Event Date: | 1998 |
Record Entry Date: | 2004-10-27 |
In Stock? | No |
Description: | Bowling 1998: Have a Ball in Reno |
|
| |
Club Cal-Neva | RENO, NEVADA |
TCR#: | N0592 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | CHIPCO |
Issue/Event Date: | 1994 |
Record Entry Date: | 2004-10-27 |
In Stock? | No |
Description: | ABC Bowling 1994 (issued 1995) |
|
| |
Club Cal-Neva | RENO, NEVADA |
TCR#: | N8099 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | CHIPCO |
Issue/Event Date: | 1997 |
Record Entry Date: | 2004-10-27 |
In Stock? | No |
Description: | WIBC Bowling 1997 |
|
| |
Club Cal-Neva | RENO, NEVADA |
TCR#: | N9498 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | CHIPCO |
Issue/Event Date: | 1998 |
Record Entry Date: | 2004-10-27 |
In Stock? | No |
Description: | ABC Bowling 1998 |
|
| |
Eldorado | RENO, NEVADA |
TCR#: | D0124 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | ICON |
Issue/Event Date: | 2011-04-16 |
Record Entry Date: | 2011-04-17 |
In Stock? | No |
Description: | USBC Bowling - lane |
|
| |
Eldorado | RENO, NEVADA |
TCR#: | D0123 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | ICON |
Issue/Event Date: | 2011-04-16 |
Record Entry Date: | 2011-04-17 |
In Stock? | No |
Description: | USBC Bowling - ball |
|
| |
Eldorado | RENO, NEVADA |
TCR#: | D0125 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | ICON |
Issue/Event Date: | 2011-04-16 |
Record Entry Date: | 2011-04-17 |
In Stock? | No |
Description: | USBC Bowling - pins |
|
| |
Fitzgerald's | RENO, NEVADA |
TCR#: | N0649 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | CHIPCO |
Issue/Event Date: | 1995-02 |
Record Entry Date: | 2004-10-27 |
In Stock? | No |
Description: | ABC Bowling 1995 |
|
| |
Flamingo Hilton | RENO, NEVADA |
TCR#: | N0650 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | CHIPCO |
Issue/Event Date: | 1995-02-15 |
Record Entry Date: | 2004-10-27 |
In Stock? | No |
Description: | Bowling 1995 |
|
| |
Harrah's Reno | RENO, NEVADA |
TCR#: | N0594 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | CHIPCO |
Issue/Event Date: | 1995 |
Record Entry Date: | 2004-10-27 |
In Stock? | No |
Description: | ABC Bowling 1995 |
|
| |
Hilton | RENO, NEVADA |
TCR#: | N0593 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | CHIPCO |
Issue/Event Date: | 1995 |
Record Entry Date: | 2004-10-27 |
In Stock? | No |
Description: | ABC Bowling 1995 |
|
| |
Hilton | RENO, NEVADA |
TCR#: | N9004 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | CHIPCO |
Issue/Event Date: | 1997 |
Record Entry Date: | 2004-10-27 |
In Stock? | No |
Description: | WIBC Bowling 1997 |
|
| |
Peppermill | RENO, NEVADA |
TCR#: | V1291 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | H&C(RIM) |
Issue/Event Date: | 1998 |
Record Entry Date: | 2004-11-13 |
In Stock? | No |
Description: | ABC Bowling 1998 |
|
| |
Peppermill | RENO, NEVADA |
TCR#: | V5263 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | H&C(RIM) |
Issue/Event Date: | 2000 |
Record Entry Date: | 2004-11-13 |
In Stock? | No |
Description: | WIBC Bowling 2000 |
|
| |
Peppermill | RENO, NEVADA |
TCR#: | V9495 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | H&C(RIM) |
Issue/Event Date: | 2001 |
Record Entry Date: | 2004-11-13 |
In Stock? | No |
Description: | ABC Bowling 2001 |
|
| |
Peppermill | RENO, NEVADA |
TCR#: | E2117 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | H&C(RIM) |
Issue/Event Date: | 2003 |
Record Entry Date: | 2004-11-13 |
In Stock? | No |
Description: | Women's Bowling 2003 |
|
| |
Silver Legacy | RENO, NEVADA |
TCR#: | E3292 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | SUN |
Issue/Event Date: | 2004-06 |
Record Entry Date: | 2004-11-18 |
In Stock? | No |
Description: | ABC Bowling 2004 |
|
| |
Sundowner | RENO, NEVADA |
TCR#: | V1610 |
Categories: | Commemorative |
Denom: | $5 |
Mold: | H&C(RIM) |
Issue/Event Date: | 1998 |
Record Entry Date: | 2004-11-21 |
In Stock? | No |
Description: | ABC Bowling 1998: Fuzzy Shimada |
|
|
|