Find Nannies Near Rochester, MN
WITH NearbyZips AS (
SELECT DISTINCT ZipCode,ACOS(SIN(RADIANS(44.07)) * SIN(RADIANS(`Latitude`)) + COS(RADIANS(44.07)) * COS(RADIANS(`Latitude`)) * COS(RADIANS(-92.51) - RADIANS(`Longitude`))) * 3959 AS distance
FROM loc_data
WHERE `Latitude` BETWEEN 44.07 - 1 AND 44.07 + 1
AND `Longitude` BETWEEN -92.51 - 1 AND -92.51 + 1
AND ACOS(SIN(RADIANS(44.07)) * SIN(RADIANS(`Latitude`)) + COS(RADIANS(44.07)) * COS(RADIANS(`Latitude`)) * COS(RADIANS(-92.51) - 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_sick) AS srv_sick, SUM(srv_housekeeping) AS srv_housekeeping, SUM(srv_travel) AS srv_travel, SUM(srv_carpool) AS srv_carpool, SUM(srv_errands) AS srv_errands, SUM(srv_shopping) AS srv_shopping, SUM(srv_laundry) AS srv_laundry, SUM(qual_car) AS qual_car, SUM(qual_pets) AS qual_pets, SUM(qual_non_smoker) AS qual_non_smoker, SUM(qual_twins) AS qual_twins, SUM(qual_first_aid) AS qual_first_aid, SUM(qual_cpr) AS qual_cpr, SUM(qual_ece) AS qual_ece
FROM `caredotcom_childcare`
INNER JOIN NearbyZips AS dt ON `caredotcom_childcare`.`zip` = `dt`.`ZipCode`
AND (`availabilityFrequency` = 'FULL-TIME') AND `hourlyRateFrom` >= 30 AND `hourlyRateFrom` <= 40 AND `imageUrl` != 'https://www.care.com/img/placeholder_logo_135x135.gif'array(20) {
["total"]=>
string(1) "6"
["yearsOfExperience"]=>
string(2) "40"
["numberOfReviews"]=>
string(1) "0"
["hourlyRateFrom"]=>
string(3) "190"
["spk_english"]=>
string(1) "6"
["spk_spanish"]=>
string(1) "0"
["srv_sick"]=>
string(1) "2"
["srv_housekeeping"]=>
string(1) "5"
["srv_travel"]=>
string(1) "4"
["srv_carpool"]=>
string(1) "3"
["srv_errands"]=>
string(1) "4"
["srv_shopping"]=>
string(1) "5"
["srv_laundry"]=>
string(1) "5"
["qual_car"]=>
string(1) "5"
["qual_pets"]=>
string(1) "5"
["qual_non_smoker"]=>
string(1) "5"
["qual_twins"]=>
string(1) "0"
["qual_first_aid"]=>
string(1) "4"
["qual_cpr"]=>
string(1) "4"
["qual_ece"]=>
string(1) "3"
}
-
Hi,
My name is Chloe and I was born and raised in Rochester, MN.
I've been working with children for almost 8 years now as a babysitter, nanny, therapist, postpartum doula, tutor, and as a lead infant...
-
Hello! My name is Hannah and I am a 28-year-old female living in Rochester, MN with my husband. I have worked in education for the past 10 years and have an teaching degree in ESL. I recently left teaching...
-
Hello! I'm Irene. My background caring for infants, toddlers, and youth started over 10 years ago. I turned to childcare as a profession once my children went off to college and I've never looked back....
-
Gabrielle B.
< 1 Mile Away
I am a bright and outgoing person! I believe in taking everyone as they come! I come from a large family, with many siblings! I've also gained 2+ years of experience in childcare, and one year with an...
-
Hello, My name is Lauren. I am a loving mother of two adult children, and have had years of early childhood and special education experience. Throughout my career I've cared for individuals ages 0-100,...
-
I have 10 years of experience. I can help with Travel and Carpooling, overnights, long weekends, light cleaning, laundry. I love children and I love teaching!!