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

DEBUGING
Address: Washington 20007
Username: rnouvel
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` = 'rnouvel' 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) )) ) <= '50' ORDER BY distance asc, locations.location_number asc, locations.id asc LIMIT 5
Total Rows: 5
Rows: Array ( [0] => stdClass Object ( [id] => 46847 [location_number] => 27 [name] => Bellini - Rockville [street_address] => 12113 Rockville Pike [street_address_line2] => [street_address_line3] => [city] => Rockville [state_province] => MD [zip_postal_code] => 20852 [country] => USA [phone] => 301-770-3944 [toll_free] => [fax] => [email] => [website_url] => www.bellini.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 39.058800 [lon] => -77.121475 [distance] => 10.2606650598731 ) [1] => stdClass Object ( [id] => 46868 [location_number] => 48 [name] => Endeavors [street_address] => 313 Mill St. [street_address_line2] => [street_address_line3] => [city] => Occoquan [state_province] => VA [zip_postal_code] => 22125 [country] => USA [phone] => 703-494-0079 [toll_free] => [fax] => [email] => [website_url] => www.endeavorsonmill.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 38.684788 [lon] => -77.260880 [distance] => 18.7079059904573 ) [2] => stdClass Object ( [id] => 46829 [location_number] => 9 [name] => Baby2Teen Furniture & Accessories [street_address] => 8612 Phoenix Dirve [street_address_line2] => [street_address_line3] => [city] => Manassas [state_province] => VA [zip_postal_code] => 20110 [country] => USA [phone] => 703-369-0299 [toll_free] => [fax] => [email] => [website_url] => www.baby2teenfurniture.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 38.764790 [lon] => -77.457596 [distance] => 22.9608256273464 ) [3] => stdClass Object ( [id] => 46882 [location_number] => 62 [name] => La Couture Babe [street_address] => 23160 Robin Song Drive [street_address_line2] => [street_address_line3] => [city] => Clarksburg [state_province] => MD [zip_postal_code] => 20871 [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 39.241238 [lon] => -77.263229 [distance] => 24.690789914857 ) [4] => stdClass Object ( [id] => 46891 [location_number] => 71 [name] => Lullaby Baby [street_address] => 9130T Red Branch Road [street_address_line2] => [street_address_line3] => [city] => Columbia [state_province] => MD [zip_postal_code] => 21045 [country] => USA [phone] => 410-997-8090 [toll_free] => [fax] => [email] => [website_url] => www.lullaby-baby.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 39.231655 [lon] => -76.818398 [distance] => 25.9024397193922 ) )