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

DEBUGING
Address:
Full Address:
Username:
Lat: 37.751
Lon: -97.822
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((37.751 - locations.lat) * pi()/180 / 2), 2) + COS(37.751 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-97.822 - 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] => 5648641 [location_number] => [name] => Bicycle X-Change [street_address] => 908 W. Douglas [street_address_line2] => [street_address_line3] => [city] => Wichita [state_province] => KS [zip_postal_code] => 67201 [country] => [phone] => (316)262-9878 [toll_free] => [fax] => [email] => [website_url] => http://www.bicyclex-change.com [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] => 37.684284 [lon] => -97.351089 [distance] => 26.12903184636057 ) [1] => stdClass Object ( [id] => 7350225 [location_number] => [name] => BICYCLE EXCHANGE [street_address] => 908 W. DOUGLAS [street_address_line2] => [street_address_line3] => [city] => WICHITA [state_province] => KS [zip_postal_code] => 67203 [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] => 37.684284 [lon] => -97.351089 [distance] => 26.12903184636057 ) [2] => stdClass Object ( [id] => 1361929 [location_number] => [name] => Hub Bicycle Shop (THE) [street_address] => 803 Fort Street [street_address_line2] => [street_address_line3] => [city] => Hays [state_province] => [zip_postal_code] => 67601 [country] => [phone] => 785.625.5685 [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] => 38.871338 [lon] => -99.332954 [distance] => 112.6219267939389 ) [3] => stdClass Object ( [id] => 7350226 [location_number] => [name] => CAPPS BIKE SHOP INC. [street_address] => 2917 B SOUTH TOPEKA BLVD [street_address_line2] => [street_address_line3] => [city] => TOPEKA [state_province] => KS [zip_postal_code] => 66611 [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] => 39.014557 [lon] => -95.687691 [distance] => 144.751396895106 ) [4] => stdClass Object ( [id] => 13938746 [location_number] => [name] => Al's Bicycles Edmond [street_address] => 2624 S Broadway Ct [street_address_line2] => [street_address_line3] => [city] => Edmond [state_province] => OK [zip_postal_code] => 73013-4003 [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] => 35.627781 [lon] => -97.485832 [distance] => 147.77459283207492 ) [5] => stdClass Object ( [id] => 822101 [location_number] => [name] => Celestial Cycles [street_address] => 2929 W Hefner Rd [street_address_line2] => [street_address_line3] => [city] => Oklahoma City [state_province] => [zip_postal_code] => 73120 [country] => [phone] => 405.751.8809 [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] => 35.580559 [lon] => -97.568939 [distance] => 150.51235452642177 ) [6] => stdClass Object ( [id] => 7350295 [location_number] => [name] => CELESTIAL CYCLES LLC. [street_address] => 2929 W HEFNER RD [street_address_line2] => [street_address_line3] => [city] => OKLAHOMA CITY [state_province] => OK [zip_postal_code] => 73120 [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] => 35.580559 [lon] => -97.568939 [distance] => 150.51235452642177 ) [7] => stdClass Object ( [id] => 13938743 [location_number] => [name] => Al's Bicycles Northwest [street_address] => 7930 N Macarthur [street_address_line2] => [street_address_line3] => [city] => Oklahoma City [state_province] => OK [zip_postal_code] => 73132-4711 [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] => 35.552246 [lon] => -97.618408 [distance] => 152.23163522580438 ) [8] => stdClass Object ( [id] => 1431480 [location_number] => [name] => T Town Bicycle [street_address] => 2731 South Harvard Avenue [street_address_line2] => [street_address_line3] => [city] => Tulsa [state_province] => [zip_postal_code] => 74114 [country] => [phone] => 918.749.7563 [toll_free] => [fax] => 918.749.5360 [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => REDLINE [custom2] => BMX [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/474/RL-ADULT-ICON.png [rank] => 0 [products] => [lat] => 36.123348 [lon] => -95.940125 [distance] => 153.01432372655788 ) [9] => stdClass Object ( [id] => 2920904 [location_number] => [name] => Tom's Rivertrail Bicycles [street_address] => 6861 S Peoria Ave [street_address_line2] => [street_address_line3] => [city] => Tulsa [state_province] => ok [zip_postal_code] => 74136 [country] => [phone] => 918-481-1818 [toll_free] => [fax] => 918-481-1838 [email] => [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] => 36.063938 [lon] => -95.975769 [distance] => 154.77567437150793 ) )