Powered by Easy Locator - fast results (0.0500 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] => 18866600 [location_number] => 109621 [name] => Dancers Paradise [street_address] => 1239 Masten Drive [street_address_line2] => [street_address_line3] => [city] => Kernersville [state_province] => NC [zip_postal_code] => 27285 [country] => United States [phone] => (336) 992-9111 [toll_free] => [fax] => (336) 499-6393 [email] => info@dancersparadiseonline.com [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => [custom3] => [custom4] => [custom5] => Y [custom6] => [image] => [lat] => 38.837532 [lon] => -77.437660 [distance] => 14.660666208776451 ) [1] => stdClass Object ( [id] => 18866264 [location_number] => 19591 [name] => Carolina Dancewear [street_address] => 1627 New Garden Rd [street_address_line2] => [street_address_line3] => [city] => Greensboro [state_province] => NC [zip_postal_code] => 27410 [country] => United States [phone] => (336) 856-9983 [toll_free] => [fax] => (919) 273-0429 [email] => info@carolinadancewear.com [website_url] => [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] => 18866350 [location_number] => 41041 [name] => Gigi's Dance & Activewear [street_address] => 375 Jaques Ave [street_address_line2] => [street_address_line3] => [city] => Rahway [state_province] => NJ [zip_postal_code] => 07065 [country] => United States [phone] => (732) 340-9301 [toll_free] => [fax] => [email] => dan@gigisdancwear.com [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => [custom4] => [custom5] => Y [custom6] => [image] => [lat] => 39.007141 [lon] => -77.049652 [distance] => 22.871983132023637 ) [3] => stdClass Object ( [id] => 18866243 [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.644501 [lon] => -77.301888 [distance] => 29.343079703822063 ) [4] => stdClass Object ( [id] => 18866670 [location_number] => 115341 [name] => Ms. Ros Dance Closet [street_address] => 3761 Main St [street_address_line2] => [street_address_line3] => N Motion Productions [city] => College Park [state_province] => GA [zip_postal_code] => 30337 [country] => United States [phone] => (404) 565-0487 [toll_free] => [fax] => [email] => msrosdancecloset@gmail.com [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => [custom4] => [custom5] => Y [custom6] => [image] => [lat] => 38.621655 [lon] => -77.369476 [distance] => 29.963833499882117 ) [5] => stdClass Object ( [id] => 18866725 [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] => [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => Y [custom4] => Y [custom5] => Y [custom6] => Y [image] => [lat] => 38.888683 [lon] => -76.902405 [distance] => 32.53822889386755 ) [6] => stdClass Object ( [id] => 18866274 [location_number] => 21411 [name] => Capezio Dance Theatre Shop [street_address] => 318 Sunrise Hwy [street_address_line2] => [street_address_line3] => [city] => Rockville Centre [state_province] => NY [zip_postal_code] => 11570 [country] => United States [phone] => (516) 764-1199 [toll_free] => [fax] => [email] => capezio@pagelinx.com [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => [custom4] => Y [custom5] => Y [custom6] => [image] => [lat] => 39.077038 [lon] => -76.547447 [distance] => 49.64884755395542 ) [7] => stdClass Object ( [id] => 18866312 [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] => [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 ) [8] => stdClass Object ( [id] => 18866516 [location_number] => 98452 [name] => Dancin On The Moon [street_address] => 405 Rte 18 S [street_address_line2] => Village Green Shopping Mall [street_address_line3] => [city] => East Brunswick [state_province] => NJ [zip_postal_code] => 08816 [country] => United States [phone] => (732) 238-8854 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => Y [custom2] => Y [custom3] => [custom4] => [custom5] => Y [custom6] => [image] => [lat] => 39.494102 [lon] => -76.322594 [distance] => 68.76102499906517 ) )