To get mod_rewrite working in your localhost/~<username> folder you need to add +FollowSymLinks to Options in your /etc/apache2/users/<yourusername>.conf file (looks something like: Options Indexes MultiViews +FollowSymLinks afterwards)
mod_rewrite and OSX 10.5
17th Jan 2008