Can you advise on where is the metaphysis of a long bone located?

Towards the end but: Not the end itself, eg: the part of the thigh just above the knee joint, like the 2 inches of the bone above the lower end of the thigh bone.

Near end of bone: The metaphysics is the region of a long bone towards the end where the cortical /tubular bone fans out and transitions to the cancellous bone that supports the joint. It id where the bone starts to flare out at the end9s) of a long bone.