Find Senior Care Givers Near New Haven, CT

Are You a Caregiver? Register HereAlready Registered?login

WITH NearbyZips AS ( SELECT DISTINCT ZipCode,ACOS(SIN(RADIANS(41.31)) * SIN(RADIANS(`Latitude`)) + COS(RADIANS(41.31)) * COS(RADIANS(`Latitude`)) * COS(RADIANS(-72.92) - RADIANS(`Longitude`))) * 3959 AS distance FROM loc_data WHERE `Latitude` BETWEEN 41.31 - 1 AND 41.31 + 1 AND `Longitude` BETWEEN -72.92 - 1 AND -72.92 + 1 AND ACOS(SIN(RADIANS(41.31)) * SIN(RADIANS(`Latitude`)) + COS(RADIANS(41.31)) * COS(RADIANS(`Latitude`)) * COS(RADIANS(-72.92) - 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 `yearsOfExperience` >= 1 AND `imageUrl` != 'https://www.care.com/img/placeholder_logo_135x135.gif'array(27) { ["total"]=> string(3) "657" ["yearsOfExperience"]=> string(4) "4390" ["numberOfReviews"]=> string(3) "349" ["hourlyRateFrom"]=> string(5) "19931" ["spk_english"]=> string(3) "647" ["spk_spanish"]=> string(3) "100" ["srv_med_trans"]=> string(2) "96" ["srv_pers_care"]=> string(3) "338" ["srv_specneeds"]=> string(3) "107" ["srv_errands"]=> string(3) "388" ["srv_cleaning"]=> string(3) "459" ["srv_meals"]=> string(3) "452" ["srv_trans"]=> string(3) "336" ["srv_respite"]=> string(3) "191" ["srv_hospice"]=> string(3) "260" ["srv_live_in"]=> string(3) "191" ["srv_companion"]=> string(3) "278" ["srv_feeding"]=> string(3) "241" ["srv_active"]=> string(3) "158" ["srv_mobility"]=> string(3) "189" ["srv_spec_care"]=> string(2) "77" ["qual_pets"]=> string(3) "529" ["qual_car"]=> string(3) "316" ["qual_non_smoker"]=> string(3) "604" ["qual_aide"]=> string(3) "206" ["qual_cna"]=> string(3) "234" ["qual_cpr"]=> string(3) "135" }

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