1 miles
CAMBRIDGE
159 THORNDIKE STREET
CAMBRIDGE, MA 02141
USA
1 miles
PROSPECT HILL ACADEMY CHARTER
15 WEBSTER AVENUE
SOMERVILLE, MA 02143
USA
1.2 miles
SOMERVILLE
181 WASHINGTON STREET
SOMERVILLE, MA 02143
USA
1.3 miles
MEDIA AND TECHNOLOGY CHARTER
1001 COMMONWEALTH AVENUE
BOSTON, MA 02215
USA
1.8 miles
CITY ON A HILL CHARTER
320 HUNTINGTON AVENUE
BOSTON, MA 02115
USA
1.8 miles
HEALTH CAREERS ACADEMY HMCS
360 HUNTINGTON AVENUE
BOSTON, MA 02115
USA
2 miles
BOSTON RENAISSANCE CHARTER
250 STUART STREET
BOSTON, MA 02116
USA
2.2 miles
EDWARD BROOKE CHARTER
617 CAMBRIDGE STREET
BRIGHTON, MA 02134
USA
2.3 miles
BOSTON
26 COURT STREET
BOSTON, MA 02108
USA
2.3 miles
BROOKLINE
333 WASHINGTON STREET
BROOKLINE, MA 02445
USA
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
)
)