The 156-room Scottsdale Courtyard hotel set to open in 2012 will be on Pima road between Camelback Road and McDonald Drive on the Salt River Pima Maricopa Indian Community side of Pima Road.