Agency Results Mapped Go back to list
Warning: Undefined array key "sortby" in /server/www/first4adoption/staging/wp-content/themes/first4adoption/includes/agency_results.php on line 152
Warning: Undefined array key "agency_name" in /server/www/first4adoption/staging/wp-content/themes/first4adoption/includes/agency_results.php on line 194
WordPress database error: [Unknown column 'distance' in 'order clause']
SELECT wppost.id,keyagencytype.meta_value AS agency_type,keylatitude.meta_value AS latitude,
keylongitude.meta_value AS longitude
FROM wp_posts wppost
INNER JOIN wp_postmeta keyagencytype
ON keyagencytype.post_id = wppost.id
AND keyagencytype.meta_key = 'la_or_vaa'
INNER JOIN wp_postmeta keylatitude
ON keylatitude.post_id = wppost.id
AND keylatitude.meta_key = 'latitude' INNER JOIN wp_postmeta keylongitude
ON keylongitude.post_id = wppost.id
AND keylongitude.meta_key = 'longitude'
WHERE wppost.post_type = 'agency'
AND wppost.post_status != 'trash'
ORDER BY distance ASC
Click on a Local Adoption Agency or Voluntary Adoption Agency on the map to view more information below.
Local Authority Agency
Voluntary Adoption Agency
Regional Adoption Agency