The best options for supportive housing in Beamsville Ontario

Beamsville, ON

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

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

Niagara Supportive Living - Chetwood Hills

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

Supportive Housing

118 Chetwood St, St. Catharines, ON L2S 2P3

Full Details

Radiant Care Tabor Manor - Mapleview Apartments

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

1 Tabor Drive, St. Catharines, ON L2N1V9

Full Details

United Mennonite Home - Orchard View Apartments

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

4020 Twenty-Third Street, Vineland, ON L0R 2C0

Full Details

Queenchester Terrace

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

Supportive Housing

211 Queenston St, St. Catharines, ON L2R 3A5

Full Details

Scott Manor Residence

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

Supportive Housing

54 Scott St W, St. Catharines, ON L2R 1C9

Full Details

Radiant Care Tabor Manor - Evergreen Apartments

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

1 Tabor Drive, St. Catharines, ON L2N 1V9

Full Details

Radiant Care Tabor Manor - Spruce Lane Wellness Suites

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

Assisted Living Supportive Housing

1 Tabor Drive, St. Catharines, ON L2N1V9

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 <> 'Beamsville' 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.16773223877)*110),2) + POW(((CityLongitude - -79.477012634277)*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 = 'Beamsville' 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