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

DEBUGING
Address: New York 10001
Full Address:
Username: NexusRex
Lat: 40.752
Lon: -73.995
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((40.752 - locations.lat) * pi()/180 / 2), 2) + COS(40.752 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-73.995 - 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] => 11205 [location_number] => 3600041 [name] => BEGINNING WITH CHLDRN CHARTER [street_address] => 900 3RD AVE STE 1801 [street_address_line2] => [street_address_line3] => [city] => NEW YORK [state_province] => NY [zip_postal_code] => 10022 [country] => USA [phone] => 2127509320 [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.758377 [lon] => -73.968925 [distance] => 1.4330718314695896 ) [1] => stdClass Object ( [id] => 10691 [location_number] => 3407350 [name] => HOBOKEN CITY [street_address] => 1115 CLINTON STREET [street_address_line2] => [street_address_line3] => [city] => HOBOKEN [state_province] => NJ [zip_postal_code] => 07030 [country] => USA [phone] => 2014202151 [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.750805 [lon] => -74.031616 [distance] => 1.9169928371902847 ) [2] => stdClass Object ( [id] => 11024 [location_number] => 3417310 [name] => WEEHAWKEN TWP [street_address] => 53 LIBERTY PLACE [street_address_line2] => [street_address_line3] => [city] => WEEHAWKEN [state_province] => NJ [zip_postal_code] => 07086 [country] => USA [phone] => 2018672243 [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.774166 [lon] => -74.018044 [distance] => 1.94795891322943 ) [3] => stdClass Object ( [id] => 10430 [location_number] => 3400032 [name] => AGENCY - HOBOKEN CS [street_address] => FOURTH AND GARDEN STREET [street_address_line2] => [street_address_line3] => [city] => HOBOKEN [state_province] => NJ [zip_postal_code] => 07030 [country] => USA [phone] => 2019630222 [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.741562 [lon] => -74.031494 [distance] => 2.040478832486995 ) [4] => stdClass Object ( [id] => 10428 [location_number] => 3400029 [name] => AGENCY - ELYSIAN CS OF HOBOKEN [street_address] => 301 GARDEN STREET [street_address_line2] => [street_address_line3] => [city] => HOBOKEN [state_province] => NJ [zip_postal_code] => 07030 [country] => USA [phone] => 2018760102 [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.740608 [lon] => -74.031441 [distance] => 2.0620852118949795 ) [5] => stdClass Object ( [id] => 11214 [location_number] => 3600050 [name] => INTNTL CHARTER HS AT LAGUARDIA [street_address] => 31-10 THOMPSN AV-MB50 [street_address_line2] => [street_address_line3] => [city] => LONG ISLAND CITY [state_province] => NY [zip_postal_code] => 11101 [country] => USA [phone] => 7184825456 [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.744682 [lon] => -73.948509 [distance] => 2.483751678066476 ) [6] => stdClass Object ( [id] => 11220 [location_number] => 3600056 [name] => MIDDLE COLLEGE CHARTER HS AT L [street_address] => 31-10 THMPSN AV-L101 [street_address_line2] => [street_address_line3] => [city] => LONG ISLAND CITY [state_province] => NY [zip_postal_code] => 11101 [country] => USA [phone] => 7183494000 [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.744682 [lon] => -73.948509 [distance] => 2.483751678066476 ) [7] => stdClass Object ( [id] => 11034 [location_number] => 3417580 [name] => WEST NEW YORK TOWN [street_address] => 6028 BROADWAY [street_address_line2] => [street_address_line3] => [city] => WEST NEW YORK [state_province] => NJ [zip_postal_code] => 07093 [country] => USA [phone] => 2019021123 [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.787388 [lon] => -74.010208 [distance] => 2.5695196620026057 ) [8] => stdClass Object ( [id] => 11222 [location_number] => 3600058 [name] => REACH CHARTER SCHOOL [street_address] => 303 GREENWICH ST [street_address_line2] => [street_address_line3] => [city] => NEW YORK [state_province] => NY [zip_postal_code] => 10013 [country] => USA [phone] => 2123498073 [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.716557 [lon] => -74.010689 [distance] => 2.5811878263625054 ) [9] => stdClass Object ( [id] => 10991 [location_number] => 3416380 [name] => UNION CITY [street_address] => 3912 BERGEN TURNPIKE [street_address_line2] => [street_address_line3] => [city] => UNION CITY [state_province] => NJ [zip_postal_code] => 07087 [country] => USA [phone] => 2013485851 [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.778374 [lon] => -74.031532 [distance] => 2.6392630246712043 ) )