Powered by Easy Locator - fast results (0.1627 seconds).

DEBUGING
Address: Columbus 43215
Full Address:
Username: NexusRex
Lat: 39.9653
Lon: -83.0235
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((39.9653 - locations.lat) * pi()/180 / 2), 2) + COS(39.9653 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-83.0235 - locations.lon) * pi()/180 / 2), 2) )) ) AS distance FROM (`locations`) LEFT JOIN `accounts` ON `locations`.`account_id` = `accounts`.`id` WHERE `accounts`.`username` = 'NexusRex' AND `locations`.`lat` <> "" ORDER BY `rank` desc, `distance` asc, `locations`.`location_number` asc, `locations`.`id` asc LIMIT 10
Total Rows: 10
Rows: Array ( [0] => stdClass Object ( [id] => 12653 [location_number] => 3900237 [name] => DEPARTMENT OF YOUTH SERVICES [street_address] => 51 N HIGH ST FL 4TH [street_address_line2] => [street_address_line3] => [city] => COLUMBUS [state_province] => OH [zip_postal_code] => 43215 [country] => USA [phone] => 6147282489 [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.965046 [lon] => -83.003906 [distance] => 1.037023737970234 ) [1] => stdClass Object ( [id] => 12666 [location_number] => 3900250 [name] => OHIO CONNECTIONS ACADEMY, INC [street_address] => 375 N FRONT ST [street_address_line2] => [street_address_line3] => [city] => COLUMBUS [state_province] => OH [zip_postal_code] => 43215 [country] => USA [phone] => M [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.969669 [lon] => -83.003922 [distance] => 1.0790626514850787 ) [2] => stdClass Object ( [id] => 13320 [location_number] => 3905076 [name] => DEPT OF EDUCATION [street_address] => 65 S FRONT ST [street_address_line2] => [street_address_line3] => [city] => COLUMBUS [state_province] => OH [zip_postal_code] => 43215 [country] => USA [phone] => 6144663304 [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.960304 [lon] => -83.002258 [distance] => 1.1758518182121038 ) [3] => stdClass Object ( [id] => 12498 [location_number] => 3900081 [name] => CORNERSTONE ACADEMY COMMUNITY [street_address] => 61 E MOUND ST [street_address_line2] => [street_address_line3] => [city] => COLUMBUS [state_province] => OH [zip_postal_code] => 43215 [country] => USA [phone] => 6142258924 [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.954830 [lon] => -82.997330 [distance] => 1.5623056559205584 ) [4] => stdClass Object ( [id] => 12729 [location_number] => 3904380 [name] => COLUMBUS CITY SD [street_address] => 270 E STATE ST [street_address_line2] => [street_address_line3] => [city] => COLUMBUS [state_province] => OH [zip_postal_code] => 43215 [country] => USA [phone] => 6143655000 [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.961025 [lon] => -82.993004 [distance] => 1.6406311389936596 ) [5] => stdClass Object ( [id] => 12755 [location_number] => 3904407 [name] => GRANDVIEW HEIGHTS CITY SD [street_address] => 1587 W 3RD AVE [street_address_line2] => [street_address_line3] => [city] => COLUMBUS [state_province] => OH [zip_postal_code] => 43212 [country] => USA [phone] => 6144813600 [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.985275 [lon] => -83.048431 [distance] => 1.908485772131717 ) [6] => stdClass Object ( [id] => 12621 [location_number] => 3900205 [name] => CRITTENTON COMMUNITY SCHOOL [street_address] => 1515 INDIANOLA AVE [street_address_line2] => [street_address_line3] => [city] => COLUMBUS [state_province] => OH [zip_postal_code] => 43201 [country] => USA [phone] => 6142942661 [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.993652 [lon] => -83.003258 [distance] => 2.2314005504863816 ) [7] => stdClass Object ( [id] => 12520 [location_number] => 3900104 [name] => YOUTHBUILD COLUMBUS COMMUNITY [street_address] => 1183 ESSEX AVE [street_address_line2] => [street_address_line3] => [city] => COLUMBUS [state_province] => OH [zip_postal_code] => 43201 [country] => USA [phone] => 6142910805 [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.988625 [lon] => -82.987816 [distance] => 2.4815751298523145 ) [8] => stdClass Object ( [id] => 12526 [location_number] => 3900110 [name] => MONTESSORI RENAISSANCE EXP [street_address] => 1895 SUMMIT ST [street_address_line2] => [street_address_line3] => [city] => COLUMBUS [state_province] => OH [zip_postal_code] => 43201 [country] => USA [phone] => 6142991126 [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.001419 [lon] => -83.001244 [distance] => 2.7578452530868813 ) [9] => stdClass Object ( [id] => 12833 [location_number] => 3904493 [name] => UPPER ARLINGTON CITY SD [street_address] => 1950 N MALLWAY DR [street_address_line2] => [street_address_line3] => [city] => UPPER ARLINGTON [state_province] => OH [zip_postal_code] => 43221 [country] => USA [phone] => 6144875000 [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.999550 [lon] => -83.061172 [distance] => 3.0926651504202285 ) )