rooms for rent in midstream