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

DEBUGGING
Address: El Monte 91732
Full Address:
Username: daveadams
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.featured, 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` = 'daveadams' AND (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) )) ) <= '50' ORDER BY `rank` desc, `distance` asc, `locations`.`location_number` asc, `locations`.`id` asc LIMIT 25
Total Rows: 19
Rows: Array ( [0] => stdClass Object ( [id] => 14354447 [location_number] => [name] => Magnolia Design Center [street_address] => 3415 E Foothill Blvd [street_address_line2] => inside Best Buy [street_address_line3] => [city] => Pasadena [state_province] => CA [zip_postal_code] => 91107 [country] => US [phone] => 626-351-6921 [toll_free] => [fax] => [email] => [website_url] => http://www.magnoliaav.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => Media Furniture [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 34.151173 [lon] => -118.080315 [distance] => 6.576422538045106 ) [1] => stdClass Object ( [id] => 14354238 [location_number] => [name] => City Life [street_address] => 720 E. Imperial Highway [street_address_line2] => [street_address_line3] => [city] => Brea [state_province] => CA [zip_postal_code] => 92821 [country] => US [phone] => 714-255-9696 [toll_free] => [fax] => [email] => [website_url] => http://www.citylifehome.com/ [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => Media Furniture [custom3] => Office / Home Furnishings [custom4] => [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 33.913074 [lon] => -117.893677 [distance] => 13.034718058517429 ) [2] => stdClass Object ( [id] => 14354224 [location_number] => [name] => Cantoni [street_address] => 420 N. La Brea [street_address_line2] => [street_address_line3] => [city] => Los Angeles [state_province] => CA [zip_postal_code] => 90036 [country] => US [phone] => 323-634-0909 [toll_free] => [fax] => [email] => [website_url] => http://cantoni.com/ [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => Media Furniture [custom3] => Office / Home Furnishings [custom4] => Semblance Modular System [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 34.078846 [lon] => -118.343933 [distance] => 18.8782440525821 ) [3] => stdClass Object ( [id] => 14354548 [location_number] => [name] => Rapport International Furniture [street_address] => 401-445 N. La Brea Ave. [street_address_line2] => [street_address_line3] => [city] => Los Angeles [state_province] => CA [zip_postal_code] => 90036 [country] => US [phone] => 323-930-1500 [toll_free] => [fax] => [email] => [website_url] => http://rapportusa.com/ [contact_name] => [contact_title] => [additional_info] => [custom1] => A BDI Premier Dealer [custom2] => Media Furniture [custom3] => Office / Home Furnishings [custom4] => Semblance Modular System [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_preferred.gif [featured] => 0 [rank] => 0 [products] => [lat] => 34.079609 [lon] => -118.344055 [distance] => 18.886261086855132 ) [4] => stdClass Object ( [id] => 14354367 [location_number] => [name] => House to Home [street_address] => 2198 Lakewood Blvd. [street_address_line2] => [street_address_line3] => [city] => Long Beach [state_province] => CA [zip_postal_code] => 90815 [country] => US [phone] => 562-597-3225 [toll_free] => [fax] => [email] => [website_url] => [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => Media Furniture [custom3] => Office / Home Furnishings [custom4] => [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 33.795940 [lon] => -118.142586 [distance] => 20.526651217237077 ) [5] => stdClass Object ( [id] => 14354200 [location_number] => [name] => Blueprint [street_address] => 8600 W. Pico Blvd. [street_address_line2] => [street_address_line3] => [city] => Los Angeles [state_province] => CA [zip_postal_code] => 90035 [country] => US [phone] => 310-647-4315 [toll_free] => [fax] => [email] => [website_url] => http://www.blueprintfurniture.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => Media Furniture [custom3] => Office / Home Furnishings [custom4] => Semblance Modular System [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 34.053524 [lon] => -118.378754 [distance] => 20.914066613439033 ) [6] => stdClass Object ( [id] => 14354193 [location_number] => [name] => Bedfellows [street_address] => 12250 Ventura Blvd. [street_address_line2] => [street_address_line3] => [city] => Studio City [state_province] => CA [zip_postal_code] => 91604 [country] => US [phone] => 818-985-0500 [toll_free] => [fax] => [email] => [website_url] => http://www.bedfellowsfurniture.com/ [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => Media Furniture [custom3] => Office / Home Furnishings [custom4] => Semblance Modular System [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 34.142899 [lon] => -118.400307 [distance] => 22.605299185353772 ) [7] => stdClass Object ( [id] => 14354250 [location_number] => [name] => Contemporary Lifestyles [street_address] => 18406 Hawthorne Blvd. [street_address_line2] => [street_address_line3] => [city] => Torrance [state_province] => CA [zip_postal_code] => 90504 [country] => US [phone] => 310-214-2655 [toll_free] => [fax] => 310-214-2622 [email] => [website_url] => http://contemporarylifestyles.com/ [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => Media Furniture [custom3] => Office / Home Furnishings [custom4] => Semblance Modular System [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 33.864098 [lon] => -118.352356 [distance] => 24.175434357025757 ) [8] => stdClass Object ( [id] => 14354161 [location_number] => [name] => Atmosphere Interiors [street_address] => 2221 S. Sepulveda Blvd. [street_address_line2] => [street_address_line3] => [city] => Los Angeles [state_province] => CA [zip_postal_code] => 90064 [country] => US [phone] => 310-473-9322 [toll_free] => [fax] => [email] => [website_url] => http://www.atmosphereinteriors.com/ [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => Media Furniture [custom3] => Office / Home Furnishings [custom4] => Semblance Modular System [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 34.039444 [lon] => -118.437531 [distance] => 24.346083615243533 ) [9] => stdClass Object ( [id] => 14354490 [location_number] => [name] => Magnolia Design Center [street_address] => 11301 W Pico Blvd [street_address_line2] => inside Best Buy [street_address_line3] => [city] => Los Angeles [state_province] => CA [zip_postal_code] => 90064 [country] => US [phone] => 310-500-4681 [toll_free] => [fax] => [email] => [website_url] => http://www.magnoliaav.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => Media Furniture [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 34.035652 [lon] => -118.439758 [distance] => 24.49993873243959 ) [10] => stdClass Object ( [id] => 14354564 [location_number] => [name] => Robert Westley [street_address] => 3323 Hyland Ave #J [street_address_line2] => [street_address_line3] => [city] => Costa Mesa [state_province] => CA [zip_postal_code] => 92626 [country] => US [phone] => 714-546-7100 [toll_free] => [fax] => [email] => [website_url] => http://robertwestleydesigns.com/ [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => Media Furniture [custom3] => Office /Home Furnishings [custom4] => Semblance Modular System [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 33.694012 [lon] => -117.925438 [distance] => 26.681193968051076 ) [11] => stdClass Object ( [id] => 14354552 [location_number] => [name] => Recliners LA [street_address] => 2316 Lincoln Blvd [street_address_line2] => [street_address_line3] => [city] => Santa Monica [state_province] => CA [zip_postal_code] => 90405 [country] => US [phone] => 888-404-7632 [toll_free] => [fax] => [email] => [website_url] => www.recliners.la [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => Media Furniture [custom3] => Office / Home Furnishings [custom4] => Semblance Modular System [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 34.009251 [lon] => -118.479691 [distance] => 27.0149193386315 ) [12] => stdClass Object ( [id] => 14354441 [location_number] => [name] => Magnolia Design Center [street_address] => 901 South Coast Drive [street_address_line2] => inside Best Buy [street_address_line3] => [city] => Costa Mesa [state_province] => CA [zip_postal_code] => 92626 [country] => US [phone] => 714-913-8021 [toll_free] => [fax] => [email] => [website_url] => http://www.magnoliaav.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => Media Furniture [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 33.689953 [lon] => -117.892906 [distance] => 27.36852159495403 ) [13] => stdClass Object ( [id] => 14354222 [location_number] => [name] => Cantoni [street_address] => 8650 Research Drive [street_address_line2] => [street_address_line3] => [city] => Irvine [state_province] => CA [zip_postal_code] => 92618 [country] => US [phone] => 949-585-9191 [toll_free] => [fax] => [email] => [website_url] => http://cantoni.com/ [contact_name] => [contact_title] => [additional_info] => [custom1] => A BDI Premier Dealer [custom2] => Media Furniture [custom3] => Office / Home Furnishings [custom4] => Semblance Modular System [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_preferred.gif [featured] => 0 [rank] => 0 [products] => [lat] => 33.644176 [lon] => -117.741959 [distance] => 33.487189916500036 ) [14] => stdClass Object ( [id] => 14354437 [location_number] => [name] => Magnolia Design Center [street_address] => 21601 Victory Blvd [street_address_line2] => inside Best Buy [street_address_line3] => [city] => Canoga Park [state_province] => CA [zip_postal_code] => 91303 [country] => US [phone] => 818-251-3540 [toll_free] => [fax] => [email] => [website_url] => http://www.magnoliaav.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => Media Furniture [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 34.187988 [lon] => -118.600288 [distance] => 34.4349456198577 ) [15] => stdClass Object ( [id] => 14354489 [location_number] => [name] => Magnolia Design Center [street_address] => 25422 El Paseo [street_address_line2] => inside Best Buy [street_address_line3] => [city] => Mission Viejo [state_province] => CA [zip_postal_code] => 92691 [country] => US [phone] => 949-616-1221 [toll_free] => [fax] => [email] => [website_url] => http://www.magnoliaav.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => Media Furniture [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 33.591248 [lon] => -117.673019 [distance] => 38.60665894825477 ) [16] => stdClass Object ( [id] => 16484760 [location_number] => [name] => Modern Studio [street_address] => 290 Broadway [street_address_line2] => [street_address_line3] => [city] => Laguna Beach [state_province] => CA [zip_postal_code] => 92651 [country] => US [phone] => 949-376-0103 [toll_free] => [fax] => [email] => [website_url] => http://modernfurnishings.com [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => [custom3] => Office / Home Furnishings [custom4] => [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 33.544243 [lon] => -117.784225 [distance] => 38.839099167852105 ) [17] => stdClass Object ( [id] => 14354543 [location_number] => [name] => PTS Furniture [street_address] => 250 Conejo Ridge Ave [street_address_line2] => [street_address_line3] => [city] => Thousand Oaks [state_province] => CA [zip_postal_code] => 91361 [country] => US [phone] => 805-496-4804 [toll_free] => [fax] => [email] => [website_url] => http://ptsfurniture.com/ [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => Media Furniture [custom3] => Office / Home Furnishings [custom4] => [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 34.169704 [lon] => -118.845985 [distance] => 48.02362841701213 ) [18] => stdClass Object ( [id] => 14354710 [location_number] => [name] => Wilshire Home Entertainment [street_address] => 1412 North Moorpark Rd. [street_address_line2] => [street_address_line3] => [city] => Thousand Oaks [state_province] => CA [zip_postal_code] => 91360 [country] => US [phone] => 805-497-7536 [toll_free] => [fax] => [email] => [website_url] => http://www.wilshirehe.com/ [contact_name] => [contact_title] => [additional_info] => [custom1] => [custom2] => Media Furniture [custom3] => [custom4] => [custom5] => [custom6] => [image] => [marker_url] => /_img_cs/850/BDI_pointer_standard.gif [featured] => 0 [rank] => 0 [products] => [lat] => 34.198498 [lon] => -118.869156 [distance] => 49.63444050580097 ) )