Thanks, I have solved it now.

I used and modified the code from this post and it works a treat.

....AND

WHERE (NOT EXISTS

...

This example is exactly what I'm working with for apartment availabilty search.

So, basically I just need to extend the code so that it returns all the properties that are available...