>Hi
>I'm looking to speed up a query that is used for the main search in a program I've written. I've got 3 tables of similar structure and a property(address) level table that I need to query.

It's probably the DISTINCT clause that's slowing things down the most. Try it without that.

Tamar