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

DEBUGING
Address: Ashburn 20149
Full Address:
Username: Body_Wrappers
Lat: 39.0481
Lon: -77.4728
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((39.0481 - locations.lat) * pi()/180 / 2), 2) + COS(39.0481 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-77.4728 - locations.lon) * pi()/180 / 2), 2) )) ) AS distance FROM (`locations`) LEFT JOIN `accounts` ON `locations`.`account_id` = `accounts`.`id` WHERE `accounts`.`username` = 'Body_Wrappers' AND `locations`.`custom5` != '' AND (3956 * 2 * ASIN(SQRT( POWER(SIN((39.0481 - locations.lat) * pi()/180 / 2),2) + COS(39.0481 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-77.4728 - locations.lon) * pi()/180 / 2),2) )) ) <= '100' ORDER BY `distance` asc, `locations`.`location_number` asc, `locations`.`id` asc LIMIT 1000
Total Rows: 9
Rows: Array ( [0] => stdClass Object ( [id] => 18020626 [location_number] => 111101 [name] => Dance Shoppe Of Centreville [street_address] => 14215G Centreville Sq [street_address_line2] => [street_address_line3] => [city] => Centreville [state_province] => VA [zip_postal_code] => 20121 [country] => United States [phone] => (703) 815-3205 [toll_free] => [fax] => (703) 815-2381 [email] => office@danceshoppe.com [website_url] => http://www.mydanceshoppe.com [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => [custom4] => [custom5] => Y [custom6] => [image] => [lat] => 38.837376 [lon] => -77.437363 [distance] => 14.673439329800441 ) [1] => stdClass Object ( [id] => 18020610 [location_number] => 43682 [name] => Heather's Dance Boutique [street_address] => 8759 Mathis Ave [street_address_line2] => [street_address_line3] => [city] => Manassas [state_province] => VA [zip_postal_code] => 20110 [country] => United States [phone] => (703) 331-5964 [toll_free] => [fax] => (703) 335-7405 [email] => [website_url] => http://www.heathersdancewear.com [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => [custom4] => [custom5] => Y [custom6] => [image] => [lat] => 38.764668 [lon] => -77.458656 [distance] => 19.584409141197533 ) [2] => stdClass Object ( [id] => 18019892 [location_number] => 54421 [name] => Les Gals [street_address] => 2337 Distribution Cir [street_address_line2] => [street_address_line3] => [city] => Silver Spring [state_province] => MD [zip_postal_code] => 20910 [country] => United States [phone] => (301) 608-3237 [toll_free] => [fax] => [email] => asharris3@verizon.net [website_url] => www.lesgalsactivewear.com [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => [custom3] => [custom4] => [custom5] => Y [custom6] => [image] => [lat] => 39.007202 [lon] => -77.050262 [distance] => 22.838966076320613 ) [3] => stdClass Object ( [id] => 18019917 [location_number] => 112032 [name] => Footlights [street_address] => 938 Wayne Ave. [street_address_line2] => [street_address_line3] => [city] => Silver Spring [state_province] => MD [zip_postal_code] => 20910 [country] => United States [phone] => (301) 696-1558 [toll_free] => [fax] => [email] => info2dancefootlights.com [website_url] => www.dancefootlights,.com [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => Y [custom4] => Y [custom5] => Y [custom6] => Y [image] => [lat] => 38.994480 [lon] => -77.025513 [distance] => 24.277334919484122 ) [4] => stdClass Object ( [id] => 18019916 [location_number] => 112031 [name] => Footlights [street_address] => 306 E Church St [street_address_line2] => [street_address_line3] => [city] => Frederick [state_province] => MD [zip_postal_code] => 21701 [country] => United States [phone] => (301) 696-1558 [toll_free] => [fax] => [email] => info2dancefootlights.com [website_url] => http://www.dancefootlights.com [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => Y [custom4] => Y [custom5] => Y [custom6] => Y [image] => [lat] => 39.415100 [lon] => -77.404839 [distance] => 25.59895754629078 ) [5] => stdClass Object ( [id] => 18019914 [location_number] => 111051 [name] => Dancer The Unusual Store [street_address] => 8010 Old Branch Ave [street_address_line2] => [street_address_line3] => [city] => Clinton [state_province] => MD [zip_postal_code] => 20735 [country] => United States [phone] => (301) 856-2144 [toll_free] => [fax] => (301) 856-2149 [email] => dancercfo@gmail.com [website_url] => http://www.dancermd.com [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => [custom4] => [custom5] => Y [custom6] => Y [image] => [lat] => 38.779404 [lon] => -76.899025 [distance] => 35.9773708791543 ) [6] => stdClass Object ( [id] => 18019876 [location_number] => 2191 [name] => Artisitic Costumes and Dance Fashions [street_address] => 1304 Goucher Blvd [street_address_line2] => [street_address_line3] => [city] => Towson [state_province] => MD [zip_postal_code] => 21286 [country] => United States [phone] => (410) 321-1121 [toll_free] => [fax] => (410) 321-0223 [email] => [website_url] => http://www.artisitccostumes.com [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => [custom4] => [custom5] => Y [custom6] => [image] => [lat] => 39.384838 [lon] => -76.579193 [distance] => 53.15630471590627 ) [7] => stdClass Object ( [id] => 18019905 [location_number] => 98611 [name] => County Ballet Shop [street_address] => 2232 Old Emmorton Rd [street_address_line2] => [street_address_line3] => [city] => Bel Air [state_province] => MD [zip_postal_code] => 21015 [country] => United States [phone] => (410) 569-0316 [toll_free] => [fax] => [email] => countyballetdanceshop@gmail.com [website_url] => http://countyballet.com [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => [custom4] => [custom5] => Y [custom6] => [image] => [lat] => 39.494118 [lon] => -76.322762 [distance] => 68.7534694812049 ) [8] => stdClass Object ( [id] => 18019901 [location_number] => 98043 [name] => The Dancer Pointe [street_address] => 201 W Main St [street_address_line2] => [street_address_line3] => [city] => Hummelstown [state_province] => PA [zip_postal_code] => 17036 [country] => United States [phone] => (717) 583-1820 [toll_free] => [fax] => (717) 256-0041 [email] => dancerspointepa@verizon.net [website_url] => http://www.thedancerspointepa.com [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => [custom4] => Y [custom5] => Y [custom6] => [image] => [lat] => 40.265003 [lon] => -76.711037 [distance] => 93.26877484917293 ) )