WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', , lat, lng) distance, wp_emeruslocationgroup.slug as g' at line 2]
SELECT wp_emeruslocation.*, emerus_haversine_distance_sp(, , lat, lng) distance, wp_emeruslocationgroup.slug as group_slug, wp_emeruslocationgroup.icon as group_icon, wp_emeruslocationgroup.drop_pin as group_drop_pin FROM wp_emeruslocation LEFT OUTER JOIN wp_emeruslocationgroup ON wp_emeruslocationgroup.id = wp_emeruslocation.group_id WHERE wp_emeruslocationgroup.slug = 'open' ORDER BY distance LIMIT 1 /* From [ahnneighborhood.org/locations/?%20utm_source=YouthSnap&utm_medium=ProgrammaticDisplay&utm_campaign=AllStar&utm_id=0724&ut%20m_content=AHNRegional] in [/nas/content/live/ahnnh/wp-content/plugins/emerus-locations/emerus-location.php:1415] */

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', , lat, lng) distance, wp_emeruslocationgroup.slug as g' at line 2]
SELECT wp_emeruslocation.*, emerus_haversine_distance_sp(, , lat, lng) distance, wp_emeruslocationgroup.slug as group_slug, wp_emeruslocationgroup.icon as group_icon, wp_emeruslocationgroup.drop_pin as group_drop_pin FROM wp_emeruslocation LEFT OUTER JOIN wp_emeruslocationgroup ON wp_emeruslocationgroup.id = wp_emeruslocation.group_id WHERE wp_emeruslocationgroup.slug = 'open' ORDER BY distance LIMIT 1024 OFFSET 1 /* From [ahnneighborhood.org/locations/?%20utm_source=YouthSnap&utm_medium=ProgrammaticDisplay&utm_campaign=AllStar&utm_id=0724&ut%20m_content=AHNRegional] in [/nas/content/live/ahnnh/wp-content/plugins/emerus-locations/emerus-location.php:1415] */

Your Closest Location


Brentwood

3290 Saw Mill Run Blvd  
Brentwood, Pennsylvania 15227

 

Get Directions

Average wait time of 18 minutes at AHN Neighborhood Hospital (January – August 2024)

Additional Pittsburgh Area Locations


Harmar

2501 Freeport Rd  
Pittsburgh, PA 15238

 

Hempfield

6321 Route 30  
Greensburg, PA 15601

 

McCandless

8950 Duncan Ave  
Pittsburgh, PA 15237