The best options for supportive housing in Belwood Ontario

Belwood, ON

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

2 residences found in nearby cities related to 'Supportive Housing'

Community Living Dufferin

Please use the Email link to send a message directly to this home and request more information.

065371 County Rd 3, East Garafraxa, ON L9W 7J8

Full Details

40 Lawrence Ave - Seniors Apartments - Orangeville

Please use the Email link to send a message directly to this home and request more information.

Independent Living for Rent Seniors Building (no care) Supportive Housing

40 Lawrence Ave, Orangeville, ON L9W 0C1

Full Details

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 <> 'Belwood' OR Province <> 'ON') AND (Expiry IS NULL OR Expiry > sysdate()) AND (LiveDate IS NULL OR LiveDate < sysdate()) AND Live = 1 AND ForBlog <> 1 AND adType != 'u'
AND City <> '' AND SQRT(POW(((CityLatitude - 43.788440704346)*110),2) + POW(((CityLongitude - -80.311363220215)*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 = 'Belwood' AND Province = 'ON' AND (Expiry IS NULL OR Expiry > sysdate()) AND (LiveDate IS NULL OR LiveDate < sysdate()) AND Live = 1 AND ForBlog <> 1 AND adType != 'u' 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