DEBUGING
Address: Washington 20007
Username: grabgreenhome
Lat: 38.9144
Lon: -77.0763
Geo Source:
A PHP Error was encountered
Severity: Notice
Message: Undefined variable: geo_source
Filename: search/template_0004.php
Line Number: 167
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.lat, locations.lon, (3956 * 2 * ASIN(SQRT( POWER(SIN((38.9144 - locations.lat) * pi()/180 / 2), 2) + COS(38.9144 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-77.0763 - locations.lon) * pi()/180 / 2), 2) )) ) AS distance
FROM (locations)
LEFT JOIN accounts ON locations.account_id = accounts.id
WHERE `accounts`.`username` = 'grabgreenhome'
AND (3956 * 2 * ASIN(SQRT( POWER(SIN((38.9144 - locations.lat) * pi()/180 / 2),2) + COS(38.9144 * pi()/180) * COS(locations.lat * pi()/180) * POWER(SIN((-77.0763 - locations.lon) * pi()/180 / 2),2) )) ) <= '50'
ORDER BY distance asc, locations.location_number asc, locations.id asc
LIMIT 100
Total Rows: 14
Rows: Array
(
[0] => stdClass Object
(
[id] => 150554
[location_number] =>
[name] => Mom's Organic Market
[street_address] => 3831 Mount Vernon Avenue
[street_address_line2] =>
[street_address_line3] =>
[city] => Arlington
[state_province] => VA
[zip_postal_code] => 22305
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 38.840351
[lon] => -77.062912
[distance] => 5.16311785871203
)
[1] => stdClass Object
(
[id] => 150772
[location_number] =>
[name] => The Laundry Bag
[street_address] => 11005 Rosemont Drive
[street_address_line2] =>
[street_address_line3] =>
[city] => Rockville
[state_province] => MD
[zip_postal_code] => 20852
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 39.035667
[lon] => -77.126656
[distance] => 8.79840660683869
)
[2] => stdClass Object
(
[id] => 150553
[location_number] =>
[name] => Mom's Organic Market
[street_address] => 11711 B Parklawn Drive
[street_address_line2] =>
[street_address_line3] =>
[city] => Rockville
[state_province] => MD
[zip_postal_code] => 20852
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 39.047649
[lon] => -77.101128
[distance] => 9.29623701296316
)
[3] => stdClass Object
(
[id] => 150556
[location_number] =>
[name] => Mom's Organic Market - Rockville
[street_address] => 11711 B Parklawn Drive
[street_address_line2] =>
[street_address_line3] =>
[city] => Rockville
[state_province] => MD
[zip_postal_code] => 20852
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 39.047649
[lon] => -77.101128
[distance] => 9.29623701296316
)
[4] => stdClass Object
(
[id] => 96686
[location_number] =>
[name] => Smile Herb Shop
[street_address] => 4908 Berwyn Road
[street_address_line2] =>
[street_address_line3] =>
[city] => College Park
[state_province] => MD
[zip_postal_code] => 20740
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 38.995216
[lon] => -76.927002
[distance] => 9.7670540624065
)
[5] => stdClass Object
(
[id] => 150663
[location_number] =>
[name] => Smile Herb Shop
[street_address] => 4908 Berwyn Road
[street_address_line2] =>
[street_address_line3] =>
[city] => College Park
[state_province] => MD
[zip_postal_code] => 20740
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 38.995216
[lon] => -76.927002
[distance] => 9.7670540624065
)
[6] => stdClass Object
(
[id] => 42374
[location_number] =>
[name] => The Laundry Bag
[street_address] => 2220 Veirs Mill Road
[street_address_line2] =>
[street_address_line3] =>
[city] => Rockville
[state_province] => MD
[zip_postal_code] => 20851
[country] => United States
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 39.074673
[lon] => -77.114403
[distance] => 11.2533778412706
)
[7] => stdClass Object
(
[id] => 150555
[location_number] =>
[name] => Mom's Organic Market - Bowie
[street_address] => 6824 Race Track Road
[street_address_line2] =>
[street_address_line3] =>
[city] => Bowie
[state_province] => MD
[zip_postal_code] => 20715
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 38.983696
[lon] => -76.729164
[distance] => 19.2443424855214
)
[8] => stdClass Object
(
[id] => 96678
[location_number] =>
[name] => Roots Market
[street_address] => 5805 Clarksville Square Dr.
[street_address_line2] =>
[street_address_line3] =>
[city] => Clarksville
[state_province] => MD
[zip_postal_code] => 21029
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 39.213154
[lon] => -76.939575
[distance] => 21.8911011597036
)
[9] => stdClass Object
(
[id] => 150654
[location_number] =>
[name] => Roots Market
[street_address] => 5805 Clarksville Square Dr.
[street_address_line2] =>
[street_address_line3] =>
[city] => Clarksville
[state_province] => MD
[zip_postal_code] => 21029
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 39.213154
[lon] => -76.939575
[distance] => 21.8911011597036
)
[10] => stdClass Object
(
[id] => 150552
[location_number] =>
[name] => Mom's -Columbia East
[street_address] => 7351 Assateague Dr #190
[street_address_line2] =>
[street_address_line3] =>
[city] => Jessup
[state_province] => MD
[zip_postal_code] => 20794
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 39.169739
[lon] => -76.785484
[distance] => 23.5378059611739
)
[11] => stdClass Object
(
[id] => 150726
[location_number] =>
[name] => The Fresh Market
[street_address] => 2504 Solomons Island Road
[street_address_line2] =>
[street_address_line3] =>
[city] => Annapolis
[state_province] => MD
[zip_postal_code] => 21401
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 38.971611
[lon] => -76.542801
[distance] => 28.9206486591297
)
[12] => stdClass Object
(
[id] => 150727
[location_number] =>
[name] => The Fresh Market
[street_address] => 2510 Quarry Lake Dr.
[street_address_line2] =>
[street_address_line3] =>
[city] => Baltimore
[state_province] => MD
[zip_postal_code] => 21209
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 39.385017
[lon] => -76.688217
[distance] => 38.5699439582174
)
[13] => stdClass Object
(
[id] => 96695
[location_number] =>
[name] => The Natural Marketplace
[street_address] => 5 Diagonal Street
[street_address_line2] =>
[street_address_line3] =>
[city] => Warrenton
[state_province] => VA
[zip_postal_code] => 20186
[country] => USA
[phone] =>
[toll_free] =>
[fax] =>
[email] =>
[website_url] =>
[contact_name] =>
[contact_title] =>
[additional_info] =>
[custom1] =>
[custom2] =>
[custom3] =>
[custom4] =>
[custom5] =>
[custom6] =>
[image] =>
[lat] => 38.714287
[lon] => -77.796921
[distance] => 41.1568799326003
)
)