Use this snippet to find the URL alias for a node by looking it up in the url_alias table by its node ID.

$src = 'node/'.$node->nid;
$path = db_result(db_query("SELECT dst FROM url_alias WHERE src = '%s'",$src));