As per my knowledge you need tenancy contract for both the cases (visit & Residence visa). For visit visa no need to attested but for for residence visa you need to attested tenancy contract.