The best options for supportive housing in Amherstburg Ontario

Amherstburg, ON

There are no housing results in Amherstburg, ON related to 'Supportive Housing'

SELECT dID, Link, AdType, AdYouTubeID, LinkText, LinkID, Description, DirectoryCats.CategoryName, AdColor, AdLogo, AdLogoAlt, Phone, AlwaysFirstBooking, AlwaysFirst, DisplayAddress, Email, City, Province, Address 
FROM DirectoryLinks 
LEFT OUTER JOIN DirectoryCats ON dcID = CategoryID
LEFT OUTER JOIN DirectoryLinksSubcategories ON SubCatLinkID = DirectoryLinks.dID
LEFT OUTER JOIN DirectoryCats AS DC2 ON DirectoryLinksSubcategories.SubCatCatID = DC2.dcID
LEFT OUTER JOIN cities ON CityName = City
WHERE (City <> 'Amherstburg' OR Province <> 'ON') AND (Expiry IS NULL OR Expiry > sysdate()) AND (LiveDate IS NULL OR LiveDate < sysdate()) AND Live = 1 AND ForBlog <> 1 
AND City <> '' AND SQRT(POW(((CityLatitude - 42.106998443604)*110),2) + POW(((CityLongitude - -83.102348327637)*110),2)) < 30 AND LinkText NOT IN (SELECT LinkText  FROM DirectoryLinks 
LEFT OUTER JOIN DirectoryCats ON dcID = CategoryID
LEFT OUTER JOIN DirectoryLinksSubcategories ON SubCatLinkID = DirectoryLinks.dID
LEFT OUTER JOIN DirectoryCats AS DC2 ON DirectoryLinksSubcategories.SubCatCatID = DC2.dcID 
WHERE City = 'Amherstburg' AND Province = 'ON' AND (Expiry IS NULL OR Expiry > sysdate()) AND (LiveDate IS NULL OR LiveDate < sysdate()) AND Live = 1 AND ForBlog <> 1 GROUP BY LinkID) GROUP BY LinkID 
ORDER BY   (Max(AlwaysFirst) <> 0) DESC, if(Max(AlwaysFirst) <> 0,Min(AlwaysFirstBooking),''), Abs(City = '' OR City IS NULL) ASC, AdType = 'b', LinkText LIMIT 4

1 services found in nearby cities

Hughes Intelligence - Resident Safety Services

Resident Safety Program

Supportive Housing in Ontario

Housing

What's the Difference Between Retirement Homes, Seniors Buildings and Long-Term Care in Ontario?

Housing

Your name:
Your email:
Contact number:
Message:

Province:
City:

There are no housing results in Amherstburg, ON related to 'Supportive Housing'

1 services found in nearby cities

2 articles found related to 'Supportive Housing'