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

DEBUGING
Address: Washington 20007
Username: grabgreenhome
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` = 'grabgreenhome' 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 100
Total Rows: 14
Rows: Array ( [0] => stdClass Object ( [id] => 150554 [location_number] => [name] => Mom's Organic Market [street_address] => 3831 Mount Vernon Avenue [street_address_line2] => [street_address_line3] => [city] => Arlington [state_province] => VA [zip_postal_code] => 22305 [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 38.840351 [lon] => -77.062912 [distance] => 5.16311785871203 ) [1] => stdClass Object ( [id] => 150772 [location_number] => [name] => The Laundry Bag [street_address] => 11005 Rosemont Drive [street_address_line2] => [street_address_line3] => [city] => Rockville [state_province] => MD [zip_postal_code] => 20852 [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 39.035667 [lon] => -77.126656 [distance] => 8.79840660683869 ) [2] => stdClass Object ( [id] => 150553 [location_number] => [name] => Mom's Organic Market [street_address] => 11711 B Parklawn Drive [street_address_line2] => [street_address_line3] => [city] => Rockville [state_province] => MD [zip_postal_code] => 20852 [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 39.047649 [lon] => -77.101128 [distance] => 9.29623701296316 ) [3] => stdClass Object ( [id] => 150556 [location_number] => [name] => Mom's Organic Market - Rockville [street_address] => 11711 B Parklawn Drive [street_address_line2] => [street_address_line3] => [city] => Rockville [state_province] => MD [zip_postal_code] => 20852 [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 39.047649 [lon] => -77.101128 [distance] => 9.29623701296316 ) [4] => stdClass Object ( [id] => 96686 [location_number] => [name] => Smile Herb Shop [street_address] => 4908 Berwyn Road [street_address_line2] => [street_address_line3] => [city] => College Park [state_province] => MD [zip_postal_code] => 20740 [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 38.995216 [lon] => -76.927002 [distance] => 9.7670540624065 ) [5] => stdClass Object ( [id] => 150663 [location_number] => [name] => Smile Herb Shop [street_address] => 4908 Berwyn Road [street_address_line2] => [street_address_line3] => [city] => College Park [state_province] => MD [zip_postal_code] => 20740 [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 38.995216 [lon] => -76.927002 [distance] => 9.7670540624065 ) [6] => stdClass Object ( [id] => 42374 [location_number] => [name] => The Laundry Bag [street_address] => 2220 Veirs Mill Road [street_address_line2] => [street_address_line3] => [city] => Rockville [state_province] => MD [zip_postal_code] => 20851 [country] => United States [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 39.074673 [lon] => -77.114403 [distance] => 11.2533778412706 ) [7] => stdClass Object ( [id] => 150555 [location_number] => [name] => Mom's Organic Market - Bowie [street_address] => 6824 Race Track Road [street_address_line2] => [street_address_line3] => [city] => Bowie [state_province] => MD [zip_postal_code] => 20715 [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 38.983696 [lon] => -76.729164 [distance] => 19.2443424855214 ) [8] => stdClass Object ( [id] => 96678 [location_number] => [name] => Roots Market [street_address] => 5805 Clarksville Square Dr. [street_address_line2] => [street_address_line3] => [city] => Clarksville [state_province] => MD [zip_postal_code] => 21029 [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 39.213154 [lon] => -76.939575 [distance] => 21.8911011597036 ) [9] => stdClass Object ( [id] => 150654 [location_number] => [name] => Roots Market [street_address] => 5805 Clarksville Square Dr. [street_address_line2] => [street_address_line3] => [city] => Clarksville [state_province] => MD [zip_postal_code] => 21029 [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 39.213154 [lon] => -76.939575 [distance] => 21.8911011597036 ) [10] => stdClass Object ( [id] => 150552 [location_number] => [name] => Mom's -Columbia East [street_address] => 7351 Assateague Dr #190 [street_address_line2] => [street_address_line3] => [city] => Jessup [state_province] => MD [zip_postal_code] => 20794 [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 39.169739 [lon] => -76.785484 [distance] => 23.5378059611739 ) [11] => stdClass Object ( [id] => 150726 [location_number] => [name] => The Fresh Market [street_address] => 2504 Solomons Island Road [street_address_line2] => [street_address_line3] => [city] => Annapolis [state_province] => MD [zip_postal_code] => 21401 [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 38.971611 [lon] => -76.542801 [distance] => 28.9206486591297 ) [12] => stdClass Object ( [id] => 150727 [location_number] => [name] => The Fresh Market [street_address] => 2510 Quarry Lake Dr. [street_address_line2] => [street_address_line3] => [city] => Baltimore [state_province] => MD [zip_postal_code] => 21209 [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 39.385017 [lon] => -76.688217 [distance] => 38.5699439582174 ) [13] => stdClass Object ( [id] => 96695 [location_number] => [name] => The Natural Marketplace [street_address] => 5 Diagonal Street [street_address_line2] => [street_address_line3] => [city] => Warrenton [state_province] => VA [zip_postal_code] => 20186 [country] => USA [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [lat] => 38.714287 [lon] => -77.796921 [distance] => 41.1568799326003 ) )