The dot in the “.php” might be throwing it off. You might have to use a regular expression to escape the dot. Try this:
redirectMatch 301 /ActiveListings\.php/Details/96 http://domain.com/featured-listings/
(My regular expression syntax may very well be off…)
If that doesn’t work, try reading through either of these pages for more information:
http://www.squidoo.com/301
http://www.askapache.com/htaccess/301-redirect-with-mod_rewrite-or-redirectmatch.html