Rattling noise front end

Wheel bearing? If you turn left and it gets louder. It is the right wheel bearing. And vice versa.

Wheel bearing. Does it make a noise when turning?

Sounds like you have a wheel bearing problem. Jack up the front end so wheels are off the ground. put your hand on the spring on the strut then turn the wheel with the other hand. If the bearing is bad you will feel the vibration/rough spot in the spring. Noise will get louder or diminish when you peed up or slow down.

With the Engine cool, locate the catalytic converters, one on the front of the engine and one on the back, start the engine and listen for exhaust, if you can hear the exhaust place your hand near the converter shield ends and see if you feel air movement, the catalytic converter may have a circumferential crack and has broken open. Replace the converter.

probly heat shild on the exhaust

I have the same car and when she got around 200,000 i had to start running a heavier grade of motor oil. If you have high mileage then the cam support bearings, crankshaft support bearings have excessive oil clearance. Listen to the knock with the hood open. If the sound is a deep low tone knock then it is the lower end of the engine. If the knock is high pitched like a tic tic sound it is usually in the top end. Lower end is where the crankshaft and pistion are located and the top end is where the valves and camshafts are located in that engine. You can take a broom stick and probe around the engine (careful not to touch moving parts) and put it to youe ear with a little presure and you can hear different sections of the engine to see where the knock is the loudest. Kinda like a doctors stefascope. If it is more like a grinding noise it could be a tensioner pulley, idler pulley, alternator bearing, a/c compressor clutch.

a whirring noise is most likley a wheel bearing. The fact that you can make it louder by placing more weight on the that side by turning confirms this. Not sure what you mean by having the front end replaced since this term doesnt apply to this condition.

bal joints and tie rod ends

It's a loose steering column. Remove the black plastic shield under the steering wheel. Lossen the bolt that holds the two shafts together, slide them together as far as they'll go, and re-tighten the bolt. It's that simple... to stop that annoying rattle.

It sounds like you have a bad c v or constant velocity joint. Look under the car next to the wheel look for a rubber accordian type unit, if the rubber is torn or lose the grease has escaped and damaged the joint. You can replace it yourself, but if your not mechanically inclined would say take it to a shop.