Easy and simplified access to a residence
that meets your needs.

Whether you’re looking for a retirement residence for independent or assisted living, a private or public long-term care facility (CHSLD), a facility offering palliative or progressive care, or a facility specializing in Parkinson’s or Alzheimer’s care, with or without dementia, Accès Résidences is at the heart of your needs. Our free support service helps you make the right choice for your new living environment. Accès Résidences is compensated by the network of private retirement residences in Quebec.

SELECT SQL_CALC_FOUND_ROWS  Car16Wp_posts.ID
					 FROM Car16Wp_posts  JOIN Car16Wp_icl_translations wpml_translations
							ON Car16Wp_posts.ID = wpml_translations.element_id
								AND wpml_translations.element_type = CONCAT('post_', Car16Wp_posts.post_type) 
					 WHERE 1=1  AND ((Car16Wp_posts.post_type = 'residence' AND (Car16Wp_posts.post_status = 'publish' OR Car16Wp_posts.post_status = 'acf-disabled'))) AND ( ( ( wpml_translations.language_code = 'en' OR (
					wpml_translations.language_code = 'fr'
					AND Car16Wp_posts.post_type IN ( 'e-floating-buttons','elementor_library' )
					AND ( ( 
			( SELECT COUNT(element_id)
			  FROM Car16Wp_icl_translations
			  WHERE trid = wpml_translations.trid
			  AND language_code = 'en'
			) = 0
			 ) OR ( 
			( SELECT COUNT(element_id)
				FROM Car16Wp_icl_translations t2
				JOIN Car16Wp_posts p ON p.id = t2.element_id
				WHERE t2.trid = wpml_translations.trid
				AND t2.language_code = 'en'
                AND (
                    p.post_status = 'publish' OR p.post_status = 'private' OR 
                    ( p.post_type='attachment' AND p.post_status = 'inherit' )
                )
			) = 0 ) ) 
				) ) AND Car16Wp_posts.post_type  IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-floating-buttons','elementor_library','acf-field-group','lien-seo','equipe','residence','commentaire' )  ) OR Car16Wp_posts.post_type  NOT  IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-floating-buttons','elementor_library','acf-field-group','lien-seo','equipe','residence','commentaire' )  )
					 
					 ORDER BY Car16Wp_posts.menu_order, Car16Wp_posts.post_date DESC
					 LIMIT 0, 20