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

DEBUGGING
Address: Glendora
Username: honlphoto
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` = 'honlphoto' 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) )) ) <= '500' ORDER BY distance asc, locations.location_number asc, locations.id asc LIMIT 50
Total Rows: 20
Rows: Array ( [0] => stdClass Object ( [id] => 103516 [location_number] => [name] => Powell Camera Shop [street_address] => 160 West Badillo Street [street_address_line2] => [street_address_line3] => [city] => Covina [state_province] => CA [zip_postal_code] => 91723 [country] => USA [phone] => (626) 332-1253 [toll_free] => [fax] => (626) 915-4004 [email] => info@powellcamera.com [website_url] => www.powellcamera.com [contact_name] => [contact_title] => [additional_info] => Store Hours M-F 9:30am-5:30pm Sat. 9:30am-5pm [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.086262 [lon] => -117.891846 [distance] => 3.92968577232345 ) [1] => stdClass Object ( [id] => 21576 [location_number] => [name] => Samy's Camera [street_address] => 41 E. Walnut St. [street_address_line2] => [street_address_line3] => [city] => Pasadena [state_province] => CA [zip_postal_code] => 91103 [country] => USA [phone] => 626-796-3300 [toll_free] => [fax] => [email] => [website_url] => www.samys.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.149502 [lon] => -118.149551 [distance] => 17.0975762844628 ) [2] => stdClass Object ( [id] => 46074 [location_number] => [name] => Fullerton Cameras [street_address] => 809 N. Habor Blvd. [street_address_line2] => [street_address_line3] => [city] => Fullerton [state_province] => CA [zip_postal_code] => 92832-1534 [country] => USA [phone] => 714-441-2443 [toll_free] => [fax] => 714-441-2445 [email] => info@fullertoncameras.com [website_url] => www.fullertoncameras.com [contact_name] => [contact_title] => [additional_info] => Store Hours M-F 10am-6pm Sat. 10am-4pm [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 33.878323 [lon] => -117.924362 [distance] => 18.0169009223 ) [3] => stdClass Object ( [id] => 42789 [location_number] => [name] => Calumet [street_address] => 1430 S. Village Way [street_address_line2] => [street_address_line3] => [city] => Santa Ana [state_province] => CA [zip_postal_code] => 92705 [country] => USA [phone] => 714-285-0143 [toll_free] => [fax] => [email] => [website_url] => www.calumetphoto.com [contact_name] => [contact_title] => [additional_info] => Store Hours M-F 9 to 6 Sat. 9 to 5:30 [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 33.731243 [lon] => -117.835899 [distance] => 27.6909479689135 ) [4] => stdClass Object ( [id] => 42788 [location_number] => [name] => Calumet [street_address] => 1135 N. Highland Ave. [street_address_line2] => [street_address_line3] => [city] => Los Angeles [state_province] => CA [zip_postal_code] => 90038 [country] => USA [phone] => 323-466-1238 [toll_free] => [fax] => [email] => [website_url] => www.calumetphoto.com [contact_name] => [contact_title] => [additional_info] => Store Hours M-F 9 to 6 Sat. 9 to 5:30 [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.091709 [lon] => -118.338821 [distance] => 28.0199720468926 ) [5] => stdClass Object ( [id] => 255269 [location_number] => [name] => Simon's Camera [street_address] => 1213 N Highland Ave [street_address_line2] => [street_address_line3] => [city] => Los Angeles [state_province] => CA [zip_postal_code] => 90038 [country] => [phone] => (323) 463-8585 [toll_free] => [fax] => [email] => [website_url] => www.simons-camera.in-hollywood-ca.com/ [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.092880 [lon] => -118.339035 [distance] => 28.0240022894428 ) [6] => stdClass Object ( [id] => 21572 [location_number] => [name] => Samy's Camera [street_address] => 431 S. Fairfax Ave. [street_address_line2] => [street_address_line3] => [city] => Los Angeles [state_province] => CA [zip_postal_code] => 90036 [country] => USA [phone] => 323-938-2420 [toll_free] => [fax] => [email] => [website_url] => www.samys.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.069012 [lon] => -118.361435 [distance] => 29.5008273306352 ) [7] => stdClass Object ( [id] => 21574 [location_number] => [name] => Samy's Camera [street_address] => 3309b S. Bristol St. [street_address_line2] => [street_address_line3] => [city] => Santa Ana [state_province] => CA [zip_postal_code] => 92704 [country] => USA [phone] => 714-557-9400 [toll_free] => [fax] => [email] => [website_url] => www.samys.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 33.703045 [lon] => -117.885422 [distance] => 29.6894050184487 ) [8] => stdClass Object ( [id] => 21573 [location_number] => [name] => Samy's Camera [street_address] => 4411 Sepulveda Blvd. [street_address_line2] => [street_address_line3] => [city] => Culver City [state_province] => CA [zip_postal_code] => 90320 [country] => USA [phone] => 310-450-4551 [toll_free] => [fax] => [email] => [website_url] => www.samys.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.003136 [lon] => -118.407288 [distance] => 33.0340818068425 ) [9] => stdClass Object ( [id] => 21577 [location_number] => [name] => Samy's Camera [street_address] => 12636 Beatrice Street [street_address_line2] => [street_address_line3] => [city] => Los Angeles [state_province] => CA [zip_postal_code] => 90066 [country] => USA [phone] => 310-450-4365 [toll_free] => [fax] => [email] => [website_url] => www.samys.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 33.979576 [lon] => -118.416679 [distance] => 34.0238252129145 ) [10] => stdClass Object ( [id] => 96562 [location_number] => [name] => Bel Air Camera [street_address] => 10925 Kinross Ave. [street_address_line2] => [street_address_line3] => [city] => Los Angeles [state_province] => CA [zip_postal_code] => 90024 [country] => USA [phone] => 310-208-5150 [toll_free] => 800-200-4999 [fax] => 310-208-7472 [email] => info@belaircamera.com [website_url] => www.belaircamera.com [contact_name] => [contact_title] => [additional_info] => Store Hours M-F 9am- 7pm Sat. 9:30am- 6pm Sun. Noon- 5pm [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.060429 [lon] => -118.446297 [distance] => 34.388905787783 ) [11] => stdClass Object ( [id] => 21586 [location_number] => [name] => Paul's Photo [street_address] => 23845 S. Hawthorne Blvd. [street_address_line2] => [street_address_line3] => [city] => Torrance [state_province] => CA [zip_postal_code] => 90505 [country] => USA [phone] => (310) 375-7014 [toll_free] => [fax] => [email] => [website_url] => www.paulsphoto.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 33.807659 [lon] => -118.351761 [distance] => 36.3825050229433 ) [12] => stdClass Object ( [id] => 42790 [location_number] => [name] => Calumet [street_address] => 830 W. Valley Parkway [street_address_line2] => Suite 330 [street_address_line3] => [city] => Escondido [state_province] => CA [zip_postal_code] => 92025 [country] => USA [phone] => 760-737-6002 [toll_free] => [fax] => [email] => [website_url] => www.calumetphoto.com [contact_name] => [contact_title] => [additional_info] => Store Hours M-F 9:30 to 6 Sat. 9 to 5:30 [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 33.117580 [lon] => -117.092918 [distance] => 82.502355005844 ) [13] => stdClass Object ( [id] => 21575 [location_number] => [name] => Samy's Camera [street_address] => 614 Chapala St. [street_address_line2] => [street_address_line3] => [city] => Santa Barbara [state_province] => CA [zip_postal_code] => 93101 [country] => USA [phone] => 805-963-7269 [toll_free] => [fax] => [email] => [website_url] => www.samys.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 34.417355 [lon] => -119.698128 [distance] => 107.205734257068 ) [14] => stdClass Object ( [id] => 226091 [location_number] => [name] => Henley's Photo [street_address] => 2000 H Street [street_address_line2] => [street_address_line3] => [city] => Bakersfield [state_province] => CA [zip_postal_code] => 93301 [country] => USA [phone] => 661-324-9484 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 35.377430 [lon] => -119.020836 [distance] => 108.609106271069 ) [15] => stdClass Object ( [id] => 21520 [location_number] => [name] => Casey's Camera [street_address] => 1550 East Tropicana Ave. [street_address_line2] => [street_address_line3] => [city] => Las Vegas [state_province] => NV [zip_postal_code] => 89119 [country] => USA [phone] => 702.736.0890 [toll_free] => [fax] => [email] => [website_url] => www.caseyscamera.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 36.101452 [lon] => -115.130928 [distance] => 205.143057568091 ) [16] => stdClass Object ( [id] => 21519 [location_number] => [name] => Keeble & Shuchat Photography [street_address] => 290 California Ave [street_address_line2] => [street_address_line3] => [city] => Palo Alto [state_province] => CA [zip_postal_code] => 94306 [country] => USA [phone] => 650-327-8996 [toll_free] => [fax] => [email] => [website_url] => www.kspphoto.com [contact_name] => [contact_title] => [additional_info] => Store Hours Mon.-Sat. 9am-5:30pm Sun. 11am-5:30pm [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 37.427681 [lon] => -122.144051 [distance] => 330.983978730564 ) [17] => stdClass Object ( [id] => 21571 [location_number] => [name] => Photomark [street_address] => 2202 East McDowell Rd [street_address_line2] => [street_address_line3] => [city] => Phoenix [state_province] => AZ [zip_postal_code] => 85006 [country] => USA [phone] => 800.777.6627 [toll_free] => [fax] => [email] => [website_url] => www.photomark.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 33.466187 [lon] => -112.034225 [distance] => 336.853295925615 ) [18] => stdClass Object ( [id] => 46075 [location_number] => [name] => Looking Glass Photo [street_address] => 2848 Telegraph Avenue [street_address_line2] => [street_address_line3] => [city] => Berkeley [state_province] => CA [zip_postal_code] => 94705 [country] => USA [phone] => 510-548-6888 [toll_free] => [fax] => [email] => info@lookingglassphoto.com [website_url] => www.lookingglassphoto.com [contact_name] => [contact_title] => [additional_info] => Store Hours M-F 9am-8pm Sat. 10am-6pm Sun. 11am-5pm [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 37.858707 [lon] => -122.259636 [distance] => 356.074099358622 ) [19] => stdClass Object ( [id] => 42791 [location_number] => [name] => Calumet [street_address] => 2001 Bryant Street [street_address_line2] => [street_address_line3] => [city] => San Francisco [state_province] => CA [zip_postal_code] => 94110 [country] => USA [phone] => 415-643-9275 [toll_free] => [fax] => [email] => [website_url] => www.calumetphoto.com [contact_name] => [contact_title] => [additional_info] => Store Hours M-F 8 to 6 Sat. 9 to 5:30 [custom1] => [custom2] => [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [products] => [lat] => 37.761551 [lon] => -122.409790 [distance] => 357.29687822882 ) )