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 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
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
Open 24/7
Pediatric Emergency Care
Short Wait – under 15 minutes*
On-site Lab, Imaging & Diagnostics
AHN Neighborhood Hospitals have a comprehensive child health care approach, and our team of experienced board-certified emergency medicine physicians are passionate about providing quality care for children. We are open 24/7, on-site laboratory and imaging, and around-the-clock emergency services to provide the specialized care your child needs to get back to health.
*Average door-to-doctor wait of 14 minutes at AHN Neighborhood hospitals Jan – Nov 2022
Your Closest Location
Additional AHN Neighborhood Hospital Locations
Harmar
2501 Freeport Rd
Pittsburgh, PA 15238
412-550-5550
Hempfield
6321 Route 30
Greensburg, PA 15601
878-295-4735
McCandless
8950 Duncan Ave
Pittsburgh, PA 15237
878-999-9035
We offer a variety of pediatric services in a kid friendly, family-centered environment to make sure your child gets diagnosed, treated and back to being a kid as soon as possible.
Services offered:
- Orthopedic care including reductions with sedation and splinting if necessary
- Laceration care including sedation if necessary
- All ED Physicians and RNs are PALS/ENPC certified
- Majority of ER Techs are PALS certified
Some of the conditions treated include:
- Asthma
- Pneumonia
- Dehydration
- Upper Respiratory Infections
- Urinary Tract Infections
- Gastritis
- Cellulitis
- Respiratory Syncytial Virus (RSV) Infections
- Minor Burn/Wound Management