Location courtyard by marriott detroit warren is a family friendly hotel in warren warren sterling heights and area attractions include red oaks waterpark and freedom hill amphitheatre additional regional attractions include detroit zoo and motown historical museum hotel features courtyard by marriott detroit warren has an indoor pool a spa tub and a 24 hour fitness center complimentary wireless internet access is available in public areas this 3 star hotel features business ameniti