I am in my 40s and have chronic lower back and hip pain. Pain shoots down front of leg. Foot gets numb and tingly. Any ideas what it could be?

Possibly a sciatica. A sciatica is caused by an irritation of a nerve in the back that then can cause pain that runs down the leg like you are describing. There are also potentially other causes as well. Usually a detailed history and exam can determine the cause. Thank you for your question.
Spinal problem. With all that put together, my first thought would be an issue with your spine, perhaps a disc herniation or spinal stenosis. You may benefit from an X-ray of the lumbar spine with flexion and extension views along with an MRI of the spine to begin the investigation.