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, hvuah_emeruslocationgroup.slug a' at line 2]
SELECT hvuah_emeruslocation.*, emerus_haversine_distance_sp(, , lat, lng) distance, hvuah_emeruslocationgroup.slug as group_slug, hvuah_emeruslocationgroup.icon as group_icon, hvuah_emeruslocationgroup.drop_pin as group_drop_pin FROM hvuah_emeruslocation LEFT OUTER JOIN hvuah_emeruslocationgroup ON hvuah_emeruslocationgroup.id = hvuah_emeruslocation.group_id WHERE hvuah_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, hvuah_emeruslocationgroup.slug a' at line 2]
SELECT hvuah_emeruslocation.*, emerus_haversine_distance_sp(, , lat, lng) distance, hvuah_emeruslocationgroup.slug as group_slug, hvuah_emeruslocationgroup.icon as group_icon, hvuah_emeruslocationgroup.drop_pin as group_drop_pin FROM hvuah_emeruslocation LEFT OUTER JOIN hvuah_emeruslocationgroup ON hvuah_emeruslocationgroup.id = hvuah_emeruslocation.group_id WHERE hvuah_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] */

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