Hosted Store Locator Service

Using our ATA School Locator is easy...
*Enter the address, city, state or zip code to locate an ATA School in your area.
*The 'A' on map is starting point (where YOU are, based on your internet service provider or entered search).
*The distance under school name reflects the number of miles from point 'A'.

DEBUGING
Address: city, state, address, or zip/post code
Username: planbman
Lat: 34.1321
Lon: -117.8511
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.marker_url, locations.products, locations.lat, locations.lon, (3956 * 2 * ASIN(SQRT( POWER(SIN((34.1321 - locations.lat) * pi()/180 / 2), 2) + COS(34.1321 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-117.8511 - locations.lon) * pi()/180 / 2), 2) )) ) AS distance FROM (locations) LEFT JOIN accounts ON locations.account_id = accounts.id WHERE `accounts`.`username` = 'planbman' AND (3956 * 2 * ASIN(SQRT( POWER(SIN((34.1321 - locations.lat) * pi()/180 / 2),2) + COS(34.1321 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-117.8511 - locations.lon) * pi()/180 / 2),2) )) ) <= '25' ORDER BY distance asc, locations.location_number asc, locations.id asc LIMIT 100
Total Rows: 8
Rows: Array ( [0] => stdClass Object ( [id] => 1178190 [location_number] => 2834 [name] => LEADERSHIP MARTIAL ARTS [street_address] => 8045 ARCHIBALD AVE #120 [street_address_line2] => [street_address_line3] => [city] => RANCHO CUCAMONGA [state_province] => CA [zip_postal_code] => 91730 [country] => [phone] => 9099454999 [toll_free] => [fax] => [email] => hnbtkd@yahoo.com [website_url] => [contact_name] => H. NEIL BEISEL III [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.107815 [lon] => -117.593254 [distance] => 14.8335760648383 ) [1] => stdClass Object ( [id] => 1178391 [location_number] => 3008 [name] => ATA BLACK BELT ACADEMY [street_address] => 1921 W IMPERIAL HWY #A [street_address_line2] => [street_address_line3] => [city] => LA HABRA [state_province] => CA [zip_postal_code] => 90631 [country] => [phone] => 5626976201 [toll_free] => [fax] => [email] => kunwoodad@gmail.com [website_url] => [contact_name] => ANDY YI [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 33.917423 [lon] => -117.966866 [distance] => 16.2354257782333 ) [2] => stdClass Object ( [id] => 1178276 [location_number] => 2653 [name] => JANKOVIAK ATA MARTIAL ARTS [street_address] => 7437 CORONA VALLEY [street_address_line2] => BARTON ELEMENTARY SCHOOL [street_address_line3] => [city] => CORONA [state_province] => CA [zip_postal_code] => 92880 [country] => [phone] => 9515155017 [toll_free] => [fax] => [email] => JankoviakATA@Yahoo.com [website_url] => [contact_name] => TODD JANKOVIAK [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 33.951729 [lon] => -117.587326 [distance] => 19.5663410760469 ) [3] => stdClass Object ( [id] => 1178086 [location_number] => 2992 [name] => ATA BLACK BELT ACADEMY [street_address] => 5567 E. SANTA ANA CANYON RD. [street_address_line2] => [street_address_line3] => [city] => ANAHEIM [state_province] => CA [zip_postal_code] => 92807 [country] => [phone] => 7142825425 [toll_free] => [fax] => [email] => HWANGSATA@YAHOO.COM [website_url] => KICKATA.COM [contact_name] => KWANG MYUNG HWANG [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 33.851501 [lon] => -117.792114 [distance] => 19.6660552439243 ) [4] => stdClass Object ( [id] => 1177875 [location_number] => 1728 [name] => ATA FAMILY TRAINING CENTER [street_address] => 7370 W LIBERTY PARKWAY [street_address_line2] => [street_address_line3] => [city] => FONTANA [state_province] => CA [zip_postal_code] => 92336 [country] => [phone] => 9098543330 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => BEN SANTOS [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.120506 [lon] => -117.504120 [distance] => 19.8480783139953 ) [5] => stdClass Object ( [id] => 1178462 [location_number] => 2756 [name] => ROCK SOLID ATA MARTIAL ARTS [street_address] => 430 S ANAHEIM HILLS ROAD [street_address_line2] => SUITE D [street_address_line3] => [city] => ANAHEIM [state_province] => CA [zip_postal_code] => 92807 [country] => [phone] => 7149981126 [toll_free] => [fax] => [email] => rocksolidata@yahoo.com [website_url] => www.rocksolidata.com [contact_name] => STEPHEN WOODY [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 33.845654 [lon] => -117.775948 [distance] => 20.2403091706015 ) [6] => stdClass Object ( [id] => 1177860 [location_number] => 1543 [name] => HJ PARK TAEKWONDO USA [street_address] => 2143 N. TUSTIN ST. #2-3 [street_address_line2] => [street_address_line3] => [city] => ORANGE [state_province] => CA [zip_postal_code] => 92865 [country] => [phone] => 7149987667 [toll_free] => [fax] => [email] => hjparkwmacs@yahoo.com [website_url] => www.orangeparkstaekwondo.com [contact_name] => HENRY PARK [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 33.823627 [lon] => -117.834229 [distance] => 21.3204500626668 ) [7] => stdClass Object ( [id] => 1177847 [location_number] => 1530 [name] => BRENT ELLISON TKD USA [street_address] => 9952 GRAHAM ST. [street_address_line2] => [street_address_line3] => [city] => CYPRESS [state_province] => CA [zip_postal_code] => 90630 [country] => [phone] => 7148991000 [toll_free] => [fax] => [email] => betusa@netzero.com [website_url] => www.betusa.org [contact_name] => BRENT ELLISON [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 33.817265 [lon] => -118.034561 [distance] => 24.1429592497356 ) )