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 = 222' at line 10
El Rompido, Spain A unique ecological four star hotel in a unique location: spectacular views to a natural area, golf, next to the picturesque village of El Rompido offering boat access to a 12 km long wild beach (boat transfer to this beach, free of charge / once a day*). 300 twin and family rooms equipped with air conditioning, telephone, minibar, safety box (extra), music channel, hairdryer, satellite TV, Internet connection, baby carriage, cot and baby bath free (depending on availability). Hotel facilities: thematic restaurants, grill restaurant by the pool, show bar (performances 7 times a week), lounges, shop, mini club Forti*, entertainment programme (aerobic, archery, beach volleyball, darts, billiards, ping-pong, etc..), adult manual craft, game room, outdoor pool, heated outdoor pool, outdoor Jacuzzi, children's pool, indoor heated pool, sunbeds (also available on the beach, only summer / extra), TV room, gym, tennis courts (extra), paddle tennis courts (extra), multi purpose sport ground (extra), football pitch (grass, extra),hairdresser (extra), ciber room (extra), garage (extra), bicycle rent (extra). Fully equipped Hydrotherapy - SPA centre with sauna, turkish bath, dynamic pool, hydro-massage bath, massages, beauty treatments. Golf course el Rompido next to the hotel. Additional activities: Sailing, horse riding, trekking, beach trekking, karting, water park, etc. Discounted rates at most of the golf courses in the area.