Select all objects available for a given date range, etc

1)

SELECT

HousingFacility.HousingFacilityId

FROM

HousingFacility H LEFT OUTER JOIN

Reservation R ON H.HousingFacilityId=R.HousingFacilityId

WHERE

R.HousingFacilityId Is Null