• Organization Directory

    220118229img1.jpg

    Tucson Rodeo Parade Museum

    Museum inventory includes 150 vehicles, ranging from small Buggies, Wagons, Surries, Coaches and Historic artifacts from pioneer days and a re-created Western Main Street representing what early Wild West Tucson would have looked like and what it offered in terms of businesses and services.


    Featured Organizations

    More Organizations

    A |B |C |D |E |F |G |H |I |J |K |L |M |N |O |P |Q |R |S |T |U |V |W |X |Y |Z
    Page:  1 2 3 4 5 6 7 Next page of listings  8

    Organization Type City  
    9 Queens  , , , Classes, Festivals, Free Events, Kids & Families, Special Events, Special Events, Special Events, Special Events, Special Events  Tucson   
    91.3 KXCI Community Radio  Special Events, Special Events  Tucson   
    A.C.M.E. Studio  , , , Visual Art, Visual Art, Visual Art, Visual Art, Visual Art  Marana   
    Accordion Club of Tucson  , , , Music, Music, Music, Music, Music, Music  Tucson   
    Act One Theatre Corporation  , , , Theatre, Theatre, Theatre, Theatre, Theatre  Tucson   
    Alliance Francaise Tucson  , , , Special Events, Special Events, Special Events, Special Events, Special Events, Special Events  Tucson   
    American Pen Women  , , , Visual Art, Visual Art, Visual Art, Visual Art, Visual Art  Tucson   
    American Society of Interior Designers - Arizona South Chapter  Special Events  Tucson   
    Anselmo Valencia Amphitheatre  , , , Music, Music, Theatre, Theatre, Theatre  Tucson   
    Arid Rose Theater  , , , Theatre, Theatre, Theatre, Theatre, Theatre, Theatre  Tucson   
    Arirang Dance Studio  , , , Dance, Dance, Dance, Dance, Dance  Tucson   
    Arizona Balalaika Orchestra  , , , Music, Music, Music, Music, Music  Tucson   
    Arizona Designer Craftsmen  , , , Visual Art, Visual Art, Visual Art, Visual Art, Visual Art  Tucson   
    Arizona Early Music Society  , , , Music, Music, Music, Music, Music, Music  Tucson   
    Arizona Falun Dafa Association  ,   Tucson   
    Arizona Friends of Chamber Music  , , , Music, Music, Music, Music, Music, Music, Music  Tucson   
    Arizona Historical Society  , , , Museums, Museums, Museums, Museums, Museums, Museums, Museums  Tucson   
    Arizona Jazz Academy  , , , Music, Music, Music, Music, Music  Tucson   
    Arizona Media Arts Center  , , , Visual Art, Visual Art, Visual Art, Visual Art, Visual Art  Tucson   
    Arizona Music Educators Association  , , , Music, Music, Music, Music, Music  Tucson   
    Arizona National  , , , Kids & Families, Kids & Families  Tucson   
    Arizona National  Kids & Families, Kids & Families, Kids & Families  Tucson   
    Arizona Onstage Productions  , , , Theatre, Theatre, Theatre, Theatre, Theatre, Theatre, Theatre  Tucson   
    Arizona Press Women  , , , , Poetry & Literature, Poetry & Literature, Poetry & Literature  Tucson   
    Arizona Repertory Singers  , , , Music, Music, Music, Music, Music, Music  Tucson   
    Arizona Repertory Theatre  , , , Theatre, Theatre, Theatre, Theatre, Theatre, Theatre, Theatre  Tucson   
    Arizona Rose Theatre  , , , Theatre, Theatre, Theatre, Theatre, Theatre, Theatre, Theatre  Tucson   
    Arizona State Museum  , , , Museums, Museums, Museums, Museums, Museums, Museums, Museums, Museums, Museums, Museums, Museums  Tucson   
    Arizona Symphonic Winds  , , , Music, Music, Music, Music, Music, Music, Music  Tucson   
    Arizona Tapestry Association  , , , Visual Art, Visual Art, Visual Art, Visual Art, Visual Art  Tucson   
    Arizona-Sonora Desert Museum  , , , Museums, Museums, Museums, Museums, Museums, Museums, Museums, Museums, Museums  Tucson   
    Arizona-Sonora Desert Museum - Art Institute  , , , Special Events, Special Events, Special Events, Special Events, Special Events, Special Events, Special Events, Special Events, Special Events  Tucson   
    Arnold/Klingernfus Ensemble  , , , Music, Music, Music, Music, Music  Tucson   
    Art in Reality  , , , Special Events, Special Events, Special Events, Special Events, Special Events  Tucson   
    Art Institute of Tucson  ,   Tucson   
    ArtNet  , , , Special Events, Special Events, Special Events, Special Events, Special Events  Tucson   
    Arts Express  , , , Special Events, Special Events, Special Events, Special Events, Special Events, Special Events  Tucson   
    Arts for All Inc  , , , Visual Art, Visual Art, Visual Art, Visual Art, Visual Art  Tucson   
    ArtsReach  , , , Poetry & Literature, Poetry & Literature, Poetry & Literature, Poetry & Literature, Poetry & Literature  Tucson   
    ArtWorks Academy  , , , Poetry & Literature, Poetry & Literature, Poetry & Literature, Poetry & Literature, Poetry & Literature  Tucson   

    A |B |C |D |E |F |G |H |I |J |K |L |M |N |O |P |Q |R |S |T |U |V |W |X |Y |Z
    Page:  1 2 3 4 5 6 7 Next page of listings  8

  • Services

       

       

    • Chase Ticket Marketplace
      Find discount tickets & special offers   
    • Subscribe to You've Got Shows!
      Weekly e-mail & Win Tickets contests  
    • Tucson Passport
      Southern Arizona Attractions Alliance   
    • ShowUpdotcom on Twitter
      Join the conversation   
    • ShowUp.com on Facebook
      Be a friend and stay in touch   
    • Straight from the Art
      A StarNet Art & Theater Blog   
    • Top 10 Events
      The best events from your reviews   
    • Rave Reviews
      What audiences are saying! 
    • Donate Now!
      Support ShowUp.com/Alliance for Audience 

  • Featured Sponsors


     

    Metropolitan Tucson Convention & Visitors Bureau

  • Featured Video

    ATC 2009-2010 'THE KITE RUNNER'

  URI STRING  
/org/listing
  CLASS/METHOD  
org/listing
  MEMORY USAGE  
2,740,664 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Org / Listing )  0.0571
Total Execution Time  0.0584
  GET DATA  
No GET data exists
  POST DATA  
No POST data exists
  DATABASE:  showup   QUERIES: 24   
0.0004   SELECT *
FROM (`lookup`)
ORDER BY `lookupType`, `lookupText` 
0.0003   SELECT *
FROM (`ci_sessions`)
WHERE `session_id` = 'd8f056f2fae93c50311fc6781365c3a8'
AND `last_activity` > 1258767224 
0.0002   SELECT `locationID`
FROM (`location`)
WHERE `subdomain_name` = 'tucson'
AND `use_as_subdomain` = 1 
0.0002   SELECT *
FROM (`location`)
WHERE `locationId` = '19'
ORDER BY `location` asc 
0.0002   SELECT *
FROM (`location_city`)
WHERE `locationID` IN (19)
ORDER BY `city` asc 
0.0002   SELECT *
FROM (`location_zip`)
WHERE `locationID` IN (19)
ORDER BY `zip` asc 
0.0003   SELECT *
FROM (`org`)
JOIN `org_template` ON `org`.`orgID` = `org_template`.`orgID`
WHERE `org_template`.`locationID` = '19'
ORDER BY `org_template`.`position` 
0.0055  
                SELECT *
                FROM org o
                WHERE o.display > 0
            AND o.orgID NOT IN (220118229,220111119,220120466,220117224,220117177,19255)
 AND (o.city IN ('Green Valley', 'Marana', 'Oro Valley', 'Sahuarita', 'South Tucson', 'Tucson', 'Vail'))
 ORDER BY name ASC
 
0.0068  
                SELECT *
                FROM org o
                WHERE o.display > 0
            AND o.orgID NOT IN (220118229,220111119,220120466,220117224,220117177,19255)
 AND (o.city IN ('Green Valley', 'Marana', 'Oro Valley', 'Sahuarita', 'South Tucson', 'Tucson', 'Vail'))
 ORDER BY name ASC
limit 40
offset 0
 
0.0050   SELECT `t`.`orgID`, `t`.`orgTypesID`, `l`.`lookupCode`, `l`.`lookupText`
FROM (`orgtypes_to_orgs` t)
LEFT JOIN `lookup` l ON `l`.`lookupID` = `t`.`orgType`
WHERE `t`.`orgID` in (220123011,220119212,220115096,220115203,220115214,220128230,220115275,220129267,21928,220127933,220115283,220115298,220115312,220115326,220131772,220110889,220115353,220115339,220115358,220115482,19260,220000885,220126036,41047,220115515,220128524,220115877,220118073,220115884,220115898,220031641,220116009,220115903,220115995,220131688,220116089,220124649,220116118,220116225,220116237)

ORDER BY `l`.`lookupText` 
0.0002   SELECT *
FROM (`meta_tags`)
WHERE `hash` = '11dc450a2a7c29ddc1252b55e75ded82' 
0.0002   SELECT *
FROM (`meta_tags`)
WHERE `hash` = '5a445d710ae24cd276062b0c84850838' 
0.0003   SELECT *
FROM (`page`)
WHERE `url` = '/org/listing'
AND `location_id` = '19' 
0.0002   SELECT *
FROM (`page`)
WHERE `url` = ''
AND `location_id` = '19' 
0.0002   SELECT *
FROM (`location`)
WHERE `hide_from_listings` = 0
ORDER BY `location` asc 
0.0002   SELECT *
FROM (`location`)
WHERE `use_as_subdomain` = 1
ORDER BY `location` ASC 
0.0002   SELECT *
FROM (`page_item`)
WHERE `page_id` = '123'
ORDER BY `blockorder` 
0.0003   SELECT *
FROM (`content`)
WHERE `id` = 'tucson_services_right' 
0.0002   SELECT *
FROM (`content`)
WHERE `id` = 'tucson_featured_sponsor' 
0.0002   SELECT *
FROM (`content`)
WHERE `id` = 'tucson_featured_video' 
0.0002   SELECT *
FROM (`content`)
WHERE `id` = 'sponsors_footer' 
0.0002   SELECT *
FROM (`content`)
WHERE `id` = 'partners_footer' 
0.0002   SELECT *
FROM (`content`)
WHERE `id` = 'site_credits' 
0.0002   SELECT *
FROM (`content`)
WHERE `id` = 'network'