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

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 1024 OFFSET 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, tebyn_emeruslocationgroup.slug as group_slug,' 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 ORDER BY distance

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