Find Senior Care Givers Near Waterloo, IA

Are You a Caregiver? Register HereAlready Registered?login

WITH NearbyZips AS ( SELECT DISTINCT ZipCode,ACOS(SIN(RADIANS(42.49)) * SIN(RADIANS(`Latitude`)) + COS(RADIANS(42.49)) * COS(RADIANS(`Latitude`)) * COS(RADIANS(-92.35) - RADIANS(`Longitude`))) * 3959 AS distance FROM loc_data WHERE `Latitude` BETWEEN 42.49 - 1 AND 42.49 + 1 AND `Longitude` BETWEEN -92.35 - 1 AND -92.35 + 1 AND ACOS(SIN(RADIANS(42.49)) * SIN(RADIANS(`Latitude`)) + COS(RADIANS(42.49)) * COS(RADIANS(`Latitude`)) * COS(RADIANS(-92.35) - 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 `qual_non_smoker` = '1' AND `imageUrl` != 'https://www.care.com/img/placeholder_logo_135x135.gif'array(27) { ["total"]=> string(2) "25" ["yearsOfExperience"]=> string(2) "91" ["numberOfReviews"]=> string(1) "8" ["hourlyRateFrom"]=> string(3) "509" ["spk_english"]=> string(2) "24" ["spk_spanish"]=> string(1) "1" ["srv_med_trans"]=> string(1) "4" ["srv_pers_care"]=> string(1) "9" ["srv_specneeds"]=> string(1) "6" ["srv_errands"]=> string(2) "15" ["srv_cleaning"]=> string(2) "15" ["srv_meals"]=> string(2) "15" ["srv_trans"]=> string(2) "18" ["srv_respite"]=> string(2) "11" ["srv_hospice"]=> string(1) "8" ["srv_live_in"]=> string(1) "5" ["srv_companion"]=> string(1) "4" ["srv_feeding"]=> string(1) "3" ["srv_active"]=> string(1) "2" ["srv_mobility"]=> string(1) "3" ["srv_spec_care"]=> string(1) "2" ["qual_pets"]=> string(2) "22" ["qual_car"]=> string(2) "14" ["qual_non_smoker"]=> string(2) "25" ["qual_aide"]=> string(1) "4" ["qual_cna"]=> string(1) "6" ["qual_cpr"]=> string(1) "3" }

Care - 25 Senior Care Givers Near 50701 Post a Job Here