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 group_slug,' 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 ORDER BY distance

Now Open


Brentwood

3290 Saw Mill Run Blvd  
Brentwood, PA 15227

 

Get Directions


McCandless

8950 Duncan Ave  
Pittsburgh, PA 15237

 

Get Directions


Hempfield

6321 Route 30  
Greensburg, PA 15601

 

Get Directions

 

Opening Soon


Harmar

2501 Freeport Rd  
Pittsburgh, PA 15238