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

DEBUGING
Address: El Monte 91732
Full Address:
Username:
Lat: 34.0734
Lon: -118.0139
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.rank, locations.products, locations.lat, locations.lon, (3956 * 2 * ASIN(SQRT( POWER(SIN((34.0734 - locations.lat) * pi()/180 / 2), 2) + COS(34.0734 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-118.0139 - locations.lon) * pi()/180 / 2), 2) )) ) AS distance FROM (`locations`) LEFT JOIN `accounts` ON `locations`.`account_id` = `accounts`.`id` WHERE `accounts`.`username` = 'seattlebikesupply' AND `locations`.`lat` <> "" AND `locations`.`custom2` != 1 AND `locations`.`custom1` = 'redline' ORDER BY `distance` asc, `locations`.`location_number` asc, `locations`.`id` asc LIMIT 10
Total Rows: 10
Rows: Array ( [0] => stdClass Object ( [id] => 821992 [location_number] => [name] => Bicycle Station [street_address] => 6433 N Figueroa [street_address_line2] => [street_address_line3] => [city] => Los Angeles [state_province] => [zip_postal_code] => 90042 [country] => [phone] => 323-256-0703 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => REDLINE [custom2] => ADULT [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/474/RL-ADULT-ICON.png [rank] => 0 [products] => [lat] => 34.118938 [lon] => -118.183762 [distance] => 10.208318725681362 ) [1] => stdClass Object ( [id] => 5690738 [location_number] => [name] => Buena Park Bicycles [street_address] => 6042 Beach Blvd [street_address_line2] => [street_address_line3] => [city] => Buena Park [state_province] => ca [zip_postal_code] => 90621 [country] => [phone] => 714-521-8120 [toll_free] => [fax] => 714-521-8118 [email] => [email protected] [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => REDLINE [custom2] => ADULT [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => http://www.easylocator.net/_img_cs/474/RL-ADULT-ICON.png [rank] => 0 [products] => [lat] => 33.872810 [lon] => -117.997849 [distance] => 13.880219471268832 ) [2] => stdClass Object ( [id] => 5690723 [location_number] => [name] => Fullerton Bicycles [street_address] => 424 East Commonwealth Ave [street_address_line2] => [street_address_line3] => [city] => Fullerton [state_province] => ca [zip_postal_code] => 92832 [country] => [phone] => 714-879-8310 [toll_free] => [fax] => 714-879-8901 [email] => [email protected] [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => REDLINE [custom2] => ADULT [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => http://www.easylocator.net/_img_cs/474/RL-ADULT-ICON.png [rank] => 0 [products] => [lat] => 33.870106 [lon] => -117.916397 [distance] => 15.106071108743778 ) [3] => stdClass Object ( [id] => 4371611 [location_number] => [name] => La Golden Bicycle Shop [street_address] => 4001 Wilshire Blvd Unit C [street_address_line2] => [street_address_line3] => [city] => Los Angeles [state_province] => ca [zip_postal_code] => 90010 [country] => [phone] => 213-739-9911 [toll_free] => [fax] => [email] => [email protected] [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => REDLINE [custom2] => BMX [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => http://www.easylocator.net/_img_cs/474/RL-ADULT-ICON.png [rank] => 0 [products] => [lat] => 34.061848 [lon] => -118.314453 [distance] => 17.20876820628898 ) [4] => stdClass Object ( [id] => 821944 [location_number] => [name] => Anaheim Hills Bike Shop [street_address] => 5548 East La Palma Avenue [street_address_line2] => [street_address_line3] => [city] => Anaheim Hills [state_province] => ca [zip_postal_code] => 92807 [country] => [phone] => 714.779.7521 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => REDLINE [custom2] => ADULT [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/474/RL-ADULT-ICON.png [rank] => 0 [products] => [lat] => 33.859741 [lon] => -117.793304 [distance] => 19.421492788729218 ) [5] => stdClass Object ( [id] => 7350116 [location_number] => [name] => H20 LOGISTICS [street_address] => 16920 S. MAIN ST. [street_address_line2] => [street_address_line3] => [city] => GARDENA [state_province] => CA [zip_postal_code] => 90248 [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => REDLINE [custom2] => BMX [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [rank] => 0 [products] => [lat] => 33.877750 [lon] => -118.275490 [distance] => 20.16987111853634 ) [6] => stdClass Object ( [id] => 2636065 [location_number] => [name] => Bicycle John's [street_address] => 1038 North Hollywood Way [street_address_line2] => [street_address_line3] => [city] => Burbank [state_province] => CA [zip_postal_code] => 91505 [country] => [phone] => 818.848.8330 [toll_free] => [fax] => 818-848-8361 [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => REDLINE [custom2] => ADULT [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/474/RL-ADULT-ICON.png [rank] => 0 [products] => [lat] => 34.169304 [lon] => -118.347313 [distance] => 20.17520711029536 ) [7] => stdClass Object ( [id] => 13448094 [location_number] => [name] => Burbank Bike Shop [street_address] => 4400 W Victory Blvd [street_address_line2] => [street_address_line3] => [city] => Burbank [state_province] => CA [zip_postal_code] => 91505-1335 [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => REDLINE [custom2] => BMX [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [rank] => 0 [products] => [lat] => 34.184605 [lon] => -118.358734 [distance] => 21.15146218338929 ) [8] => stdClass Object ( [id] => 7350157 [location_number] => [name] => ORANGE CYCLE [street_address] => 210 S GLASSELL ST [street_address_line2] => [street_address_line3] => [city] => ORANGE [state_province] => CA [zip_postal_code] => 92866 [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => REDLINE [custom2] => BMX [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [rank] => 0 [products] => [lat] => 33.785793 [lon] => -117.853561 [distance] => 21.879418572461795 ) [9] => stdClass Object ( [id] => 7350125 [location_number] => [name] => VAN'S CYCLERY [street_address] => 11407 VICTORY BLVD [street_address_line2] => [street_address_line3] => [city] => N HOLLYWOOD [state_province] => CA [zip_postal_code] => 91606 [country] => [phone] => [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => REDLINE [custom2] => BMX [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => [rank] => 0 [products] => [lat] => 34.186703 [lon] => -118.379501 [distance] => 22.31172951070392 ) )