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, tebyn_emeruslocationgroup.slug as' at line 2]
SELECT tebyn_emeruslocation.*, emerus_haversine_distance_sp(, , lat, lng) distance, tebyn_emeruslocationgroup.slug as group_slug, tebyn_emeruslocationgroup.icon as group_icon, tebyn_emeruslocationgroup.drop_pin as group_drop_pin FROM tebyn_emeruslocation LEFT OUTER JOIN tebyn_emeruslocationgroup ON tebyn_emeruslocationgroup.id = tebyn_emeruslocation.group_id WHERE tebyn_emeruslocationgroup.slug = 'open' ORDER BY distance LIMIT 1

Dignity Health – St. Rose Dominican Neighborhood Hospitals are in-network with most major insurance providers.

 

See a full list and more information about accepted insurance plans.



  • 24/7
    Emergency Care

  • Inpatient
    Care

  • On-site Labs
    & Imaging

  • Online Waiting
    Service

  • In Network
    Coverage

YOUR CLOSEST LOCATION


Blue Diamond Campus

4855 Blue Diamond Rd. 
Las Vegas, Nevada 89139