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

DEBUGING
Address: Washington 20007
Username: nikawater
Lat: 38.9144
Lon: -77.0763
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.lat, locations.lon, (3956 * 2 * ASIN(SQRT( POWER(SIN((38.9144 - locations.lat) * pi()/180 / 2), 2) + COS(38.9144 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-77.0763 - locations.lon) * pi()/180 / 2), 2) )) ) AS distance FROM (locations) LEFT JOIN accounts ON locations.account_id = accounts.id WHERE `accounts`.`username` = 'nikawater' AND (3956 * 2 * ASIN(SQRT( POWER(SIN((38.9144 - locations.lat) * pi()/180 / 2),2) + COS(38.9144 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-77.0763 - locations.lon) * pi()/180 / 2),2) )) ) <= '2000' ORDER BY distance asc, locations.location_number asc, locations.id asc LIMIT 15
Total Rows: 14
Rows: Array ( [0] => stdClass Object ( [id] => 157050 [location_number] => [name] => Crema Cafe [street_address] => 27 Brattle Street [street_address_line2] => [street_address_line3] => [city] => Cambridge [state_province] => MA [zip_postal_code] => 02138 [country] => USA [phone] => (617) 876-2700 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 42.373234 [lon] => -71.120743 [distance] => 392.747998883637 ) [1] => stdClass Object ( [id] => 157052 [location_number] => [name] => Flat Patties [street_address] => 33 Brattle Street [street_address_line2] => [street_address_line3] => [city] => Cambridge [state_province] => MA [zip_postal_code] => 02138 [country] => USA [phone] => (617) 871-6871 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 42.373535 [lon] => -71.120956 [distance] => 392.751195399662 ) [2] => stdClass Object ( [id] => 157053 [location_number] => [name] => Felipes Taqueria [street_address] => 83 Mt. Auburn Street [street_address_line2] => [street_address_line3] => [city] => Cambridge [state_province] => MA [zip_postal_code] => 02138 [country] => USA [phone] => (617) 354-9944 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 42.372429 [lon] => -71.119743 [distance] => 392.757290305084 ) [3] => stdClass Object ( [id] => 150265 [location_number] => [name] => Dado Tea and Coffee [street_address] => 50 Church Street [street_address_line2] => [street_address_line3] => [city] => Cambridge [state_province] => MA [zip_postal_code] => 02138 [country] => USA [phone] => (617) 497-9061 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 42.374191 [lon] => -71.120636 [distance] => 392.790792797635 ) [4] => stdClass Object ( [id] => 157051 [location_number] => [name] => Craig Fascino [street_address] => 4 Brattle Street, Suite 211 [street_address_line2] => [street_address_line3] => [city] => Cambridge [state_province] => MA [zip_postal_code] => 02138 [country] => USA [phone] => (617) 868-8530 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 42.373383 [lon] => -71.119698 [distance] => 392.797385293137 ) [5] => stdClass Object ( [id] => 157060 [location_number] => [name] => Petsi Pies [street_address] => 31 Putnam Ave. [street_address_line2] => [street_address_line3] => [city] => Cambridge [state_province] => MA [zip_postal_code] => 02139 [country] => USA [phone] => (617) 499-0801 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 42.368999 [lon] => -71.113701 [distance] => 392.87124515928 ) [6] => stdClass Object ( [id] => 157054 [location_number] => [name] => Cafe Pamplona [street_address] => 12 Bow Street [street_address_line2] => [street_address_line3] => [city] => Cambridge [state_province] => MA [zip_postal_code] => 02138 [country] => USA [phone] => (617) 492-0352 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 42.371704 [lon] => -71.115601 [distance] => 392.90045301069 ) [7] => stdClass Object ( [id] => 157058 [location_number] => [name] => C'est Bon [street_address] => 1436 Massachusetts Avenue [street_address_line2] => [street_address_line3] => [city] => Cambridge [state_province] => MA [zip_postal_code] => 02138 [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 42.372501 [lon] => -71.115913 [distance] => 392.919359740964 ) [8] => stdClass Object ( [id] => 150266 [location_number] => [name] => Dado Tea and Coffee [street_address] => 955 Massachusetts Avenue [street_address_line2] => [street_address_line3] => [city] => Cambridge [state_province] => MA [zip_postal_code] => 02138 [country] => USA [phone] => (617) 497-9061 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 42.369202 [lon] => -71.109802 [distance] => 393.041474086499 ) [9] => stdClass Object ( [id] => 157061 [location_number] => [name] => Evergood Market [street_address] => 1674 Massachusetts Avenue [street_address_line2] => [street_address_line3] => [city] => Cambridge [state_province] => MA [zip_postal_code] => 02138 [country] => USA [phone] => (617) 354-8331 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 42.382195 [lon] => -71.119766 [distance] => 393.147781824784 ) [10] => stdClass Object ( [id] => 150288 [location_number] => [name] => Oxford Spa [street_address] => 102 Oxford Street [street_address_line2] => [street_address_line3] => [city] => Cambridge [state_province] => MA [zip_postal_code] => 02138 [country] => USA [phone] => (617) 661-6988 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 42.383091 [lon] => -71.116127 [distance] => 393.334804436432 ) [11] => stdClass Object ( [id] => 150287 [location_number] => [name] => Cambridge Naturals [street_address] => 23 White Street [street_address_line2] => [street_address_line3] => [city] => Cambridge [state_province] => MA [zip_postal_code] => 02140 [country] => USA [phone] => (617) 492-4452 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 42.389599 [lon] => -71.118401 [distance] => 393.501720146004 ) [12] => stdClass Object ( [id] => 157056 [location_number] => [name] => The Biscuit [street_address] => 406 Washington Street [street_address_line2] => [street_address_line3] => [city] => Somerville [state_province] => MA [zip_postal_code] => 02143 [country] => USA [phone] => (617) 666-2770 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 42.378281 [lon] => -71.106316 [distance] => 393.549579968587 ) [13] => stdClass Object ( [id] => 157059 [location_number] => [name] => Petsi Pies [street_address] => 5 Beacon Street [street_address_line2] => [street_address_line3] => [city] => Somerville [state_province] => MA [zip_postal_code] => 02143 [country] => USA [phone] => (617) 661-7437 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 42.374496 [lon] => -71.101723 [distance] => 393.589163719249 ) )