Find Senior Care Givers Near Alsip, IL

Are You a Caregiver? Register HereAlready Registered?login

WITH NearbyZips AS ( SELECT DISTINCT ZipCode,ACOS(SIN(RADIANS(41.67)) * SIN(RADIANS(`Latitude`)) + COS(RADIANS(41.67)) * COS(RADIANS(`Latitude`)) * COS(RADIANS(-87.73) - RADIANS(`Longitude`))) * 3959 AS distance FROM loc_data WHERE `Latitude` BETWEEN 41.67 - 1 AND 41.67 + 1 AND `Longitude` BETWEEN -87.73 - 1 AND -87.73 + 1 AND ACOS(SIN(RADIANS(41.67)) * SIN(RADIANS(`Latitude`)) + COS(RADIANS(41.67)) * COS(RADIANS(`Latitude`)) * COS(RADIANS(-87.73) - RADIANS(`Longitude`))) * 3959 < 20 )SELECT COUNT(*) AS total, SUM(yearsOfExperience) AS yearsOfExperience, SUM(numberOfReviews) AS numberOfReviews, SUM(hourlyRateFrom) AS hourlyRateFrom, SUM(spk_english) AS spk_english, SUM(spk_spanish) AS spk_spanish, SUM(srv_med_trans) AS srv_med_trans, SUM(srv_pers_care) AS srv_pers_care, SUM(srv_specneeds) AS srv_specneeds, SUM(srv_errands) AS srv_errands, SUM(srv_cleaning) AS srv_cleaning, SUM(srv_meals) AS srv_meals, SUM(srv_trans) AS srv_trans, SUM(srv_respite) AS srv_respite, SUM(srv_hospice) AS srv_hospice, SUM(srv_live_in) AS srv_live_in, SUM(srv_companion) AS srv_companion, SUM(srv_feeding) AS srv_feeding, SUM(srv_active) AS srv_active, SUM(srv_mobility) AS srv_mobility, SUM(srv_spec_care) AS srv_spec_care, SUM(qual_pets) AS qual_pets, SUM(qual_car) AS qual_car, SUM(qual_non_smoker) AS qual_non_smoker, SUM(qual_aide) AS qual_aide, SUM(qual_cna) AS qual_cna, SUM(qual_cpr) AS qual_cpr FROM `caredotcom_seniorcare` INNER JOIN NearbyZips AS dt ON `caredotcom_seniorcare`.`zip` = `dt`.`ZipCode` AND `srv_meals` = '1' AND `imageUrl` != 'https://www.care.com/img/placeholder_logo_135x135.gif'array(27) { ["total"]=> string(3) "915" ["yearsOfExperience"]=> string(4) "4707" ["numberOfReviews"]=> string(3) "353" ["hourlyRateFrom"]=> string(5) "27527" ["spk_english"]=> string(3) "899" ["spk_spanish"]=> string(3) "136" ["srv_med_trans"]=> string(2) "63" ["srv_pers_care"]=> string(3) "384" ["srv_specneeds"]=> string(2) "70" ["srv_errands"]=> string(3) "774" ["srv_cleaning"]=> string(3) "866" ["srv_meals"]=> string(3) "915" ["srv_trans"]=> string(3) "549" ["srv_respite"]=> string(3) "251" ["srv_hospice"]=> string(3) "353" ["srv_live_in"]=> string(3) "233" ["srv_companion"]=> string(3) "376" ["srv_feeding"]=> string(3) "337" ["srv_active"]=> string(3) "221" ["srv_mobility"]=> string(3) "264" ["srv_spec_care"]=> string(2) "98" ["qual_pets"]=> string(3) "769" ["qual_car"]=> string(3) "415" ["qual_non_smoker"]=> string(3) "847" ["qual_aide"]=> string(3) "203" ["qual_cna"]=> string(3) "227" ["qual_cpr"]=> string(3) "199" }

Care - 500+ Senior Care Givers Near 60803 Post a Job Here