Do rental agreements need to be notarized?

No. The landlord / manager should only rent to someone that has seen the apartment in person. The landlord / manager needs to see proof of your ID and SSN which eliminates the need for a notary. Although, in some States you may need a Witness.