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

Additional Pittsburgh Area Locations


Hempfield

6321 Route 30  
Greensburg, PA 15601

 

McCandless

8950 Duncan Ave  
Pittsburgh, PA 15237

 

AHN Harmar Neighborhood Hospital is OPENING SOON


2501 Freeport Rd | Pittsburgh, PA 15238