Powered by Easy Locator - fast results (0.0624 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: 20
Rows: Array ( [0] => stdClass Object ( [id] => 16835173 [location_number] => [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] => 16728447 [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 ) [2] => stdClass Object ( [id] => 16835161 [location_number] => [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 ) [3] => stdClass Object ( [id] => 16728435 [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 ) [4] => stdClass Object ( [id] => 16834710 [location_number] => [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 ) [5] => stdClass Object ( [id] => 16727983 [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 ) [6] => stdClass Object ( [id] => 16834734 [location_number] => [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] => [custom4] => Y [custom5] => Y [custom6] => [image] => [lat] => 39.415100 [lon] => -77.404839 [distance] => 25.59895754629078 ) [7] => stdClass Object ( [id] => 16728007 [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] => [custom4] => Y [custom5] => Y [custom6] => [image] => [lat] => 39.415100 [lon] => -77.404839 [distance] => 25.59895754629078 ) [8] => stdClass Object ( [id] => 16835130 [location_number] => [name] => Essential Dance Supply [street_address] => 14510 Smoketown Rd [street_address_line2] => [street_address_line3] => [city] => Woodbridge [state_province] => VA [zip_postal_code] => 22192 [country] => United States [phone] => (703) 492-2722 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => [custom4] => [custom5] => Y [custom6] => [image] => [lat] => 38.644554 [lon] => -77.301651 [distance] => 29.343563271945683 ) [9] => stdClass Object ( [id] => 16728404 [location_number] => 12732 [name] => Essential Dance Supply [street_address] => 14510 Smoketown Rd [street_address_line2] => [street_address_line3] => [city] => Woodbridge [state_province] => VA [zip_postal_code] => 22192 [country] => United States [phone] => (703) 492-2722 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => [custom4] => [custom5] => Y [custom6] => [image] => [lat] => 38.644554 [lon] => -77.301651 [distance] => 29.343563271945683 ) [10] => stdClass Object ( [id] => 16834757 [location_number] => [name] => Washington Dancewear [street_address] => 43 Yost Place [street_address_line2] => [street_address_line3] => [city] => Capitol Heights [state_province] => MD [zip_postal_code] => 20743 [country] => United States [phone] => (240) 485-8744 [toll_free] => [fax] => [email] => service@washingtondancewear.com [website_url] => www.washingtondancewear.com [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => Y [custom4] => Y [custom5] => Y [custom6] => Y [image] => [lat] => 38.888393 [lon] => -76.903542 [distance] => 32.487656202069566 ) [11] => stdClass Object ( [id] => 16728030 [location_number] => 118841 [name] => Washington Dancewear [street_address] => 43 Yost Place [street_address_line2] => [street_address_line3] => [city] => Capitol Heights [state_province] => MD [zip_postal_code] => 20743 [country] => United States [phone] => (240) 485-8744 [toll_free] => [fax] => [email] => service@washingtondancewear.com [website_url] => www.washingtondancewear.com [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => Y [custom4] => Y [custom5] => Y [custom6] => Y [image] => [lat] => 38.888393 [lon] => -76.903542 [distance] => 32.487656202069566 ) [12] => stdClass Object ( [id] => 16834702 [location_number] => [name] => Dance Supp;ies [street_address] => 556D Ritchie Highway [street_address_line2] => [street_address_line3] => [city] => Severna Park [state_province] => MD [zip_postal_code] => 21146 [country] => United States [phone] => (410) 647-8727 [toll_free] => [fax] => [email] => julia@dancesuppliesetc.com [website_url] => http://www.dancesuppliesetc.com [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => [custom4] => [custom5] => Y [custom6] => [image] => [lat] => 39.077038 [lon] => -76.547447 [distance] => 49.64884755395542 ) [13] => stdClass Object ( [id] => 16727975 [location_number] => 27812 [name] => Dance Supp;ies [street_address] => 556D Ritchie Highway [street_address_line2] => [street_address_line3] => [city] => Severna Park [state_province] => MD [zip_postal_code] => 21146 [country] => United States [phone] => (410) 647-8727 [toll_free] => [fax] => [email] => julia@dancesuppliesetc.com [website_url] => http://www.dancesuppliesetc.com [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => [custom4] => [custom5] => Y [custom6] => [image] => [lat] => 39.077038 [lon] => -76.547447 [distance] => 49.64884755395542 ) [14] => stdClass Object ( [id] => 16834690 [location_number] => [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.384537 [lon] => -76.579735 [distance] => 53.12123895272327 ) [15] => stdClass Object ( [id] => 16727963 [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.384537 [lon] => -76.579735 [distance] => 53.12123895272327 ) [16] => stdClass Object ( [id] => 16834723 [location_number] => [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 ) [17] => stdClass Object ( [id] => 16727996 [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] => plauer2@verizon.net [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 ) [18] => stdClass Object ( [id] => 16834719 [location_number] => [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 ) [19] => stdClass Object ( [id] => 16727992 [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 ) )