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

DEBUGGING
Address: Glendora
Username: nikawater
Waldo: GeoIP_Location Object ( [countryCode] => US [countryName] => United States [region] => CA [city] => Glendora [postalCode] => [latitude] => 34.1321 [longitude] => -117.8511 [areaCode] => 626 [dmaCode] => 803 [countryCode3] => USA )
Geocode:
Lat: 34.1321
Lon: -117.8511
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.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` = 'nikawater' 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) )) ) <= '2000' ORDER BY distance asc, locations.location_number asc, locations.id asc LIMIT 15
Total Rows: 15
Rows: Array ( [0] => stdClass Object ( [id] => 504932 [location_number] => [name] => BevMo! [street_address] => 1397 E. Gladstone Street [street_address_line2] => [street_address_line3] => [city] => Glendora [state_province] => CA [zip_postal_code] => 91740 [country] => [phone] => 909.592.1583 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.114784 [lon] => -117.834854 [distance] => 1.51381827490151 ) [1] => stdClass Object ( [id] => 222032 [location_number] => [name] => Henry's-Monrovia [street_address] => 432 Huntington Drive [street_address_line2] => [street_address_line3] => [city] => Monrovia [state_province] => CA [zip_postal_code] => 91016 [country] => [phone] => (626)358-6845 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.140415 [lon] => -117.994301 [distance] => 8.20391304744057 ) [2] => stdClass Object ( [id] => 157055 [location_number] => [name] => Pomona College Coop Store [street_address] => 333 North College Way [street_address_line2] => Pomona College - Smith Campus Center [street_address_line3] => [city] => Claremont [state_province] => CA [zip_postal_code] => 91711 [country] => USA [phone] => (909) 607-2264 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.096931 [lon] => -117.712746 [distance] => 8.27322810795438 ) [3] => stdClass Object ( [id] => 185036 [location_number] => [name] => Sagehen Caf [street_address] => 170 East Sixth Street [street_address_line2] => [street_address_line3] => [city] => Claremont [state_province] => CA [zip_postal_code] => 91711 [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.099724 [lon] => -117.709709 [distance] => 8.38574598443135 ) [4] => stdClass Object ( [id] => 107309 [location_number] => [name] => Henry's Farmers Market [street_address] => 400 West Huntington Dr. [street_address_line2] => [street_address_line3] => [city] => Monrovia [state_province] => CA [zip_postal_code] => 91016 [country] => [phone] => (626) 358-6845 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.139778 [lon] => -118.008606 [distance] => 9.01695534293906 ) [5] => stdClass Object ( [id] => 504923 [location_number] => [name] => BevMo! [street_address] => 12945 Peyton Drive [street_address_line2] => [street_address_line3] => [city] => Chino Hills [state_province] => CA [zip_postal_code] => 91709 [country] => [phone] => 909.627.4999 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.018181 [lon] => -117.744598 [distance] => 9.94816125442904 ) [6] => stdClass Object ( [id] => 107294 [location_number] => [name] => Henry's Farmers Market [street_address] => 3630 Grand Ave. [street_address_line2] => [street_address_line3] => [city] => Chino Hills [state_province] => CA [zip_postal_code] => 91709 [country] => [phone] => 909-548-0440 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.003262 [lon] => -117.727249 [distance] => 11.3715392060749 ) [7] => stdClass Object ( [id] => 222031 [location_number] => [name] => Henry's-Chino Hills [street_address] => 3630 Grand Ave. [street_address_line2] => [street_address_line3] => [city] => Chino Hills [state_province] => CA [zip_postal_code] => 91709 [country] => [phone] => (909) 548-0440 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.003235 [lon] => -117.727272 [distance] => 11.3721669144304 ) [8] => stdClass Object ( [id] => 222007 [location_number] => [name] => Whole Foods-Pasadena [street_address] => 3751 E. Foothill Blvd. [street_address_line2] => [street_address_line3] => [city] => Pasadena [state_province] => CA [zip_postal_code] => 91107 [country] => [phone] => (626) 351-5994 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.150997 [lon] => -118.072212 [distance] => 12.702758202095 ) [9] => stdClass Object ( [id] => 194701 [location_number] => [name] => Novel Caf [street_address] => 1713 E. Colorado Blvd. [street_address_line2] => [street_address_line3] => [city] => Pasadena [state_province] => CA [zip_postal_code] => 91106 [country] => [phone] => (626) 683-3309 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.146416 [lon] => -118.115143 [distance] => 15.1216101604418 ) [10] => stdClass Object ( [id] => 192759 [location_number] => [name] => Sabor 2 [street_address] => 716 E Colorado Blvd. [street_address_line2] => [street_address_line3] => [city] => Pasadena [state_province] => CA [zip_postal_code] => 91101 [country] => [phone] => (626) 793-0251 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.145821 [lon] => -118.135468 [distance] => 16.2784139826599 ) [11] => stdClass Object ( [id] => 266414 [location_number] => [name] => Gelson's The Super Market [street_address] => 245 East Green Street [street_address_line2] => [street_address_line3] => [city] => Pasedena [state_province] => CA [zip_postal_code] => 91101 [country] => [phone] => (626) 535-0190 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.144558 [lon] => -118.145042 [distance] => 16.8201367894086 ) [12] => stdClass Object ( [id] => 222042 [location_number] => [name] => Henry's- Yorba Linda [street_address] => 17482 Yorba Linda Blvd. [street_address_line2] => [street_address_line3] => [city] => Yorba Linda [state_province] => CA [zip_postal_code] => 92886 [country] => [phone] => (714) 572-3535 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 33.887741 [lon] => -117.829163 [distance] => 16.9184703036905 ) [13] => stdClass Object ( [id] => 107323 [location_number] => [name] => Henry's Farmers Market [street_address] => 17482 Yorba Linda Blvd. [street_address_line2] => [street_address_line3] => [city] => Yorba Linda [state_province] => CA [zip_postal_code] => 92886 [country] => [phone] => 714-572-3535 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 33.887722 [lon] => -117.829185 [distance] => 16.9196864556352 ) [14] => stdClass Object ( [id] => 504925 [location_number] => [name] => BevMo! [street_address] => 885 S. Arroyo Parkway [street_address_line2] => [street_address_line3] => [city] => Pasadena [state_province] => CA [zip_postal_code] => 91105 [country] => [phone] => 626.356.9462 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.130493 [lon] => -118.147385 [distance] => 16.9337536081901 ) )