WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' , lat, lng) distance, dlxbi_emeruslocationgroup.slug as' at line 2]
SELECT dlxbi_emeruslocation.*, emerus_haversine_distance_sp(, , lat, lng) distance, dlxbi_emeruslocationgroup.slug as group_slug, dlxbi_emeruslocationgroup.icon as group_icon, dlxbi_emeruslocationgroup.drop_pin as group_drop_pin FROM dlxbi_emeruslocation LEFT OUTER JOIN dlxbi_emeruslocationgroup ON dlxbi_emeruslocationgroup.id = dlxbi_emeruslocation.group_id WHERE dlxbi_emeruslocationgroup.slug = 'open' ORDER BY distance LIMIT 1

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' , lat, lng) distance, dlxbi_emeruslocationgroup.slug as' at line 2]
SELECT dlxbi_emeruslocation.*, emerus_haversine_distance_sp(, , lat, lng) distance, dlxbi_emeruslocationgroup.slug as group_slug, dlxbi_emeruslocationgroup.icon as group_icon, dlxbi_emeruslocationgroup.drop_pin as group_drop_pin FROM dlxbi_emeruslocation LEFT OUTER JOIN dlxbi_emeruslocationgroup ON dlxbi_emeruslocationgroup.id = dlxbi_emeruslocation.group_id WHERE dlxbi_emeruslocationgroup.slug = 'open' ORDER BY distance LIMIT 1024 OFFSET 1

Your Closest Location


Brentwood

3290 Saw Mill Run Blvd  
Brentwood, Pennsylvania 15227

 

Get Directions

AHN Harmar Neighborhood Hospital is NOW OPEN


2501 Freeport Rd | Pittsburgh, PA 15238

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