DB 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 'AND areas.stateID =
AND areas.areaID = 152' at line 10
Marbella, Spain Our 4 star hotel is on the beach front and in the heart of Marbella. We have 263 rooms renovated in 2006 equipped with air conditioning, LCD TV (20'' double room, 26'' Suites and Semisuites), telephone, minibar, safety box (extra), music channel, hairdryer, satellite TV and Internet connection, cot (free of charge). Hotel facilities include restaurant with terrace, TV room, piano bar with terrace (daily live music), outdoor heated pool, indoor heated pool (seasonal), sunbeds by the pool and on the beach (extra), miniclub (July-August), Beach Restaurant (closed in January), lounges, shop, cyber room (extra), WIFI (extra), garage (extra) and limited free parking space. Fully equipped sport centre with sauna and Turkish bath. Miramar SPA & Beauty Centre. Discounted rates at most of the golf courses in the area.