715.3 miles
ACASA - St. George, UT
Coming Soon!
St. George, Utah
884.3 miles
ACASA - Henderson, NV
871 Coronado Center Dr
Suite #200
Henderson, Nevada 89052
USA
982 miles
ACASA - Anaheim, CA
Coming Soon!
Anaheim, California
USA
995.1 miles
ACASA - Newport Beach, CA
Coming Soon!
Newport Beach, California
USA
1029 miles
ACASA - Denver, CO
Coming Soon!
Denver, Colorado
USA
1708.9 miles
ACASA - North Chicago
Coming Soon!
Chicago, Illinois
2157.4 miles
ACASA - North Atlanta, GA
125 Town Park Drive
Suite #300
Kennesaw, Georgia 30144
USA
2537.4 miles
ACASA - Tampa Bay, FL
13134 Vail Ridge Drive
Riverview, Florida 33579
USA
2587.8 miles
ACASA - Fort Myers, FL
17000 Alico Commerce Court
Suite #103
Fort Myers, Florida 33967
USA
DEBUGING
Address: Seattle 98109
Full Address:
Username: DanOen
Lat: 47.6344
Lon: -122.3422
Geo Source:
Query: SELECT DISTINCT locations.id, locations.location_number, locations.name, locations.street_address, locations.street_address_line2, locations.street_address_line3, locations.city, locations.state_province, locations.zip_postal_code, locations.country, locations.phone, locations.toll_free, locations.fax, locations.email, locations.website_url, locations.contact_name, locations.contact_title, locations.additional_info, locations.custom1, locations.custom2, locations.custom3, locations.custom4, locations.custom5, locations.custom6, locations.image, locations.marker_url, locations.featured, locations.rank, locations.products, locations.lat, locations.lon, (3956 * 2 * ASIN(SQRT( POWER(SIN((47.6344 - locations.lat) * pi()/180 / 2), 2) + COS(47.6344 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-122.3422 - locations.lon) * pi()/180 / 2), 2) )) ) AS distance
FROM (`locations`)
LEFT JOIN `accounts` ON `locations`.`account_id` = `accounts`.`id`
WHERE `accounts`.`username` = 'DanOen'
AND `locations`.`lat` <> ""
ORDER BY `rank` desc, `distance` asc, `locations`.`location_number` asc, `locations`.`id` asc
LIMIT 10
Total Rows: 9
Rows: Array
(
[0] => stdClass Object
(
[id] => 20756706
[location_number] =>
[name] => ACASA - St. George, UT
[street_address] => Coming Soon!
[street_address_line2] =>
[street_address_line3] =>
[city] => St. George
[state_province] => Utah
[zip_postal_code] =>
[country] =>
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 40.477852
[lon] => -111.886169
[distance] => 715.2948874389198
)
[1] => stdClass Object
(
[id] => 20756622
[location_number] =>
[name] => ACASA - Henderson, NV
[street_address] => 871 Coronado Center Dr
[street_address_line2] => Suite #200
[street_address_line3] =>
[city] => Henderson
[state_province] => Nevada
[zip_postal_code] => 89052
[country] => USA
[phone] => 702-718-2288
[toll_free] =>
[fax] =>
[email] =>
[website_url] => https://henderson.acasaseniorcare.com
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 36.000084
[lon] => -115.110374
[distance] => 884.3415141598837
)
[2] => stdClass Object
(
[id] => 20756343
[location_number] =>
[name] => ACASA - Anaheim, CA
[street_address] => Coming Soon!
[street_address_line2] =>
[street_address_line3] =>
[city] => Anaheim
[state_province] => California
[zip_postal_code] =>
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 33.806877
[lon] => -117.917793
[distance] => 981.9624534936854
)
[3] => stdClass Object
(
[id] => 20756402
[location_number] =>
[name] => ACASA - Newport Beach, CA
[street_address] => Coming Soon!
[street_address_line2] =>
[street_address_line3] =>
[city] => Newport Beach
[state_province] => California
[zip_postal_code] =>
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 33.626057
[lon] => -117.839989
[distance] => 995.1108687356865
)
[4] => stdClass Object
(
[id] => 20756441
[location_number] =>
[name] => ACASA - Denver, CO
[street_address] => Coming Soon!
[street_address_line2] =>
[street_address_line3] =>
[city] => Denver
[state_province] => Colorado
[zip_postal_code] =>
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 39.622532
[lon] => -104.896721
[distance] => 1028.953815424372
)
[5] => stdClass Object
(
[id] => 20756601
[location_number] =>
[name] => ACASA - North Chicago
[street_address] => Coming Soon!
[street_address_line2] =>
[street_address_line3] =>
[city] => Chicago
[state_province] => Illinois
[zip_postal_code] =>
[country] =>
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 42.347183
[lon] => -87.838760
[distance] => 1708.9246181748888
)
[6] => stdClass Object
(
[id] => 20756542
[location_number] =>
[name] => ACASA - North Atlanta, GA
[street_address] => 125 Town Park Drive
[street_address_line2] => Suite #300
[street_address_line3] =>
[city] => Kennesaw
[state_province] => Georgia
[zip_postal_code] => 30144
[country] => USA
[phone] => 470-450-2288
[toll_free] =>
[fax] =>
[email] =>
[website_url] => https://northatlanta.acasaseniorcare.com
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 34.038551
[lon] => -84.566536
[distance] => 2157.4047052644337
)
[7] => stdClass Object
(
[id] => 20756505
[location_number] =>
[name] => ACASA - Tampa Bay, FL
[street_address] => 13134 Vail Ridge Drive
[street_address_line2] =>
[street_address_line3] =>
[city] => Riverview
[state_province] => Florida
[zip_postal_code] => 33579
[country] => USA
[phone] => 888-914-2288
[toll_free] =>
[fax] =>
[email] =>
[website_url] => https://tampabay.acasaseniorcare.com
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 27.914015
[lon] => -82.224876
[distance] => 2537.4005033535223
)
[8] => stdClass Object
(
[id] => 20756461
[location_number] =>
[name] => ACASA - Fort Myers, FL
[street_address] => 17000 Alico Commerce Court
[street_address_line2] => Suite #103
[street_address_line3] =>
[city] => Fort Myers
[state_province] => Florida
[zip_postal_code] => 33967
[country] => USA
[phone] => 239-266-2288
[toll_free] =>
[fax] =>
[email] =>
[website_url] => www.acasaswfl.com
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[marker_url] =>
[featured] => 0
[rank] => 0
[products] => Array
(
[0] =>
)
[lat] => 26.877794
[lon] => -82.209068
[distance] => 2587.767113368031
)
)