WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', , lat, lng) distance, wp_emeruslocationgroup.slug as g' at line 2]
SELECT wp_emeruslocation.*, emerus_haversine_distance_sp(, , lat, lng) distance, wp_emeruslocationgroup.slug as group_slug, wp_emeruslocationgroup.icon as group_icon, wp_emeruslocationgroup.drop_pin as group_drop_pin FROM wp_emeruslocation LEFT OUTER JOIN wp_emeruslocationgroup ON wp_emeruslocationgroup.id = wp_emeruslocation.group_id WHERE wp_emeruslocationgroup.slug = 'open' ORDER BY distance LIMIT 1 /* From [strosenh.org/locations/] in [/nas/content/live/strosenhorg/wp-content/plugins/emerus-locations/emerus-location.php:1415] */

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', , lat, lng) distance, wp_emeruslocationgroup.slug as g' at line 2]
SELECT wp_emeruslocation.*, emerus_haversine_distance_sp(, , lat, lng) distance, wp_emeruslocationgroup.slug as group_slug, wp_emeruslocationgroup.icon as group_icon, wp_emeruslocationgroup.drop_pin as group_drop_pin FROM wp_emeruslocation LEFT OUTER JOIN wp_emeruslocationgroup ON wp_emeruslocationgroup.id = wp_emeruslocation.group_id WHERE wp_emeruslocationgroup.slug = 'open' ORDER BY distance LIMIT 1024 OFFSET 1 /* From [strosenh.org/locations/] in [/nas/content/live/strosenhorg/wp-content/plugins/emerus-locations/emerus-location.php:1415] */

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', , lat, lng) distance, wp_emeruslocationgroup.slug as group_slug, ' at line 2]
SELECT wp_emeruslocation.*, emerus_haversine_distance_sp(, , lat, lng) distance, wp_emeruslocationgroup.slug as group_slug, wp_emeruslocationgroup.icon as group_icon, wp_emeruslocationgroup.drop_pin as group_drop_pin FROM wp_emeruslocation LEFT OUTER JOIN wp_emeruslocationgroup ON wp_emeruslocationgroup.id = wp_emeruslocation.group_id ORDER BY distance /* From [strosenh.org/locations/] in [/nas/content/live/strosenhorg/wp-content/plugins/emerus-locations/emerus-location.php:1768] */

YOUR CLOSEST LOCATION


Blue Diamond Campus

4855 Blue Diamond Rd. 
Las Vegas, Nevada 89139

Get Directions

Neighborhood Hospitals



North Las Vegas Campus

1550 W. Craig Rd. 
North Las Vegas, Nevada 89032

Sahara Campus

4980 W. Sahara Ave. 
Las Vegas, Nevada 89146

West Flamingo Campus

9880 W. Flamingo Rd. 
Las Vegas, Nevada 89147

ST. ROSE CAMPUSES


Rose de Lima Campus

102 E. Lake Mead Pkwy. 
Henderson, Nevada 89015 

San Martín Campus

8280 W. Warm Springs Rd. 
Las Vegas, Nevada 89113 

Siena Campus

3001 St. Rose Pkwy. 
Henderson, Nevada 89052