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

DEBUGING
Address: Cambridge 02139
Full Address:
Username: NexusRex
Lat: 42.3646
Lon: -71.1028
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((42.3646 - locations.lat) * pi()/180 / 2), 2) + COS(42.3646 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-71.1028 - 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] => 6566 [location_number] => 2503270 [name] => CAMBRIDGE [street_address] => 159 THORNDIKE STREET [street_address_line2] => [street_address_line3] => [city] => CAMBRIDGE [state_province] => MA [zip_postal_code] => 02141 [country] => USA [phone] => 6173496494 [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.370327 [lon] => -71.085403 [distance] => 0.9715629000832459 ) [1] => stdClass Object ( [id] => 6478 [location_number] => 2500046 [name] => PROSPECT HILL ACADEMY CHARTER [street_address] => 15 WEBSTER AVENUE [street_address_line2] => [street_address_line3] => [city] => SOMERVILLE [state_province] => MA [zip_postal_code] => 02143 [country] => USA [phone] => 6172847800 [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.378773 [lon] => -71.096428 [distance] => 1.0311301177565741 ) [2] => stdClass Object ( [id] => 6831 [location_number] => 2510890 [name] => SOMERVILLE [street_address] => 181 WASHINGTON STREET [street_address_line2] => [street_address_line3] => [city] => SOMERVILLE [state_province] => MA [zip_postal_code] => 02143 [country] => USA [phone] => 6176256600 [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.380085 [lon] => -71.091064 [distance] => 1.2253412980050167 ) [3] => stdClass Object ( [id] => 6497 [location_number] => 2500066 [name] => MEDIA AND TECHNOLOGY CHARTER [street_address] => 1001 COMMONWEALTH AVENUE [street_address_line2] => [street_address_line3] => [city] => BOSTON [state_province] => MA [zip_postal_code] => 02215 [country] => USA [phone] => 6172320300 [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.352211 [lon] => -71.120964 [distance] => 1.26117404200998 ) [4] => stdClass Object ( [id] => 6460 [location_number] => 2500026 [name] => CITY ON A HILL CHARTER [street_address] => 320 HUNTINGTON AVENUE [street_address_line2] => [street_address_line3] => [city] => BOSTON [state_province] => MA [zip_postal_code] => 02115 [country] => USA [phone] => 6172629838 [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.340824 [lon] => -71.087524 [distance] => 1.8172539645077268 ) [5] => stdClass Object ( [id] => 6485 [location_number] => 2500054 [name] => HEALTH CAREERS ACADEMY HMCS [street_address] => 360 HUNTINGTON AVENUE [street_address_line2] => [street_address_line3] => [city] => BOSTON [state_province] => MA [zip_postal_code] => 02115 [country] => USA [phone] => 6173738576 [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.340202 [lon] => -71.089012 [distance] => 1.8255520959482392 ) [6] => stdClass Object ( [id] => 6472 [location_number] => 2500039 [name] => BOSTON RENAISSANCE CHARTER [street_address] => 250 STUART STREET [street_address_line2] => [street_address_line3] => [city] => BOSTON [state_province] => MA [zip_postal_code] => 02116 [country] => USA [phone] => 6173570900 [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.350323 [lon] => -71.069214 [distance] => 1.9769214449810937 ) [7] => stdClass Object ( [id] => 6502 [location_number] => 2500071 [name] => EDWARD BROOKE CHARTER [street_address] => 617 CAMBRIDGE STREET [street_address_line2] => [street_address_line3] => [city] => BRIGHTON [state_province] => MA [zip_postal_code] => 02134 [country] => USA [phone] => 6172547757 [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.351639 [lon] => -71.143044 [distance] => 2.2398058682062216 ) [8] => stdClass Object ( [id] => 6549 [location_number] => 2502790 [name] => BOSTON [street_address] => 26 COURT STREET [street_address_line2] => [street_address_line3] => [city] => BOSTON [state_province] => MA [zip_postal_code] => 02108 [country] => USA [phone] => 6176359050 [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.359051 [lon] => -71.058678 [distance] => 2.2834003407332717 ) [9] => stdClass Object ( [id] => 6563 [location_number] => 2503150 [name] => BROOKLINE [street_address] => 333 WASHINGTON STREET [street_address_line2] => [street_address_line3] => [city] => BROOKLINE [state_province] => MA [zip_postal_code] => 02445 [country] => USA [phone] => 6177302403 [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.333912 [lon] => -71.120544 [distance] => 2.3042269158043385 ) )