Problem with SQL query - TRUNCATE ToList - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (1, "COUNTRY_194", "Spain", 0) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (1, "REGION_1", " -> Costa Brava", 1) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (1, "AIRPORT_3", " ---> Barcelona (BCN)", 2) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (1, "AIRPORT_2", " ---> Gerona (GRO)", 3) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (1, "AIRPORT_57", " -> Reus, REU - Costa Dorada (REU)", 4) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (7, "COUNTRY_194", "Spain", 0) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (7, "REGION_1", " -> Costa Brava", 1) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (7, "AIRPORT_3", " ---> Barcelona (BCN)", 2) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (7, "AIRPORT_2", " ---> Gerona (GRO)", 3) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (7, "AIRPORT_57", " -> Reus, REU - Costa Dorada (REU)", 4) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (8, "COUNTRY_194", "Spain", 0) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (8, "REGION_1", " -> Costa Brava", 1) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (8, "AIRPORT_3", " ---> Barcelona (BCN)", 2) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (8, "AIRPORT_2", " ---> Gerona (GRO)", 3) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (8, "AIRPORT_13", " -> Barcelona-Salou (BCN)", 4) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (8, "AIRPORT_57", " -> Reus, REU - Costa Dorada (REU)", 5) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (10, "COUNTRY_194", "Spain", 0) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (10, "REGION_1", " -> Costa Brava", 1) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (10, "AIRPORT_3", " ---> Barcelona (BCN)", 2) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (10, "AIRPORT_2", " ---> Gerona (GRO)", 3) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (10, "AIRPORT_57", " -> Reus, REU - Costa Dorada (REU)", 4) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (11, "COUNTRY_194", "Spain", 0) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (11, "REGION_1", " -> Costa Brava", 1) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (11, "AIRPORT_3", " ---> Barcelona (BCN)", 2) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (11, "AIRPORT_2", " ---> Gerona (GRO)", 3) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (11, "AIRPORT_57", " -> Reus, REU - Costa Dorada (REU)", 4) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (18, "COUNTRY_194", "Spain", 0) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (18, "REGION_1", " -> Costa Brava", 1) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (18, "AIRPORT_3", " ---> Barcelona (BCN)", 2) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (18, "AIRPORT_2", " ---> Gerona (GRO)", 3) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (18, "AIRPORT_57", " -> Reus, REU - Costa Dorada (REU)", 4) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (21, "COUNTRY_194", "Spain", 0) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (21, "REGION_1", " -> Costa Brava", 1) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (21, "AIRPORT_3", " ---> Barcelona (BCN)", 2) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (21, "AIRPORT_2", " ---> Gerona (GRO)", 3) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (21, "AIRPORT_57", " -> Reus, REU - Costa Dorada (REU)", 4) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (24, "COUNTRY_194", "Spain", 0) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (24, "REGION_1", " -> Costa Brava", 1) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (24, "AIRPORT_2", " ---> Gerona (GRO)", 2) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (24, "AIRPORT_57", " -> Reus, REU - Costa Dorada (REU)", 3) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (34, "COUNTRY_194", "Spain", 0) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (34, "REGION_1", " -> Costa Brava", 1) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (34, "AIRPORT_3", " ---> Barcelona (BCN)", 2) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (34, "AIRPORT_2", " ---> Gerona (GRO)", 3) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (34, "AIRPORT_57", " -> Reus, REU - Costa Dorada (REU)", 4) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (35, "COUNTRY_194", "Spain", 0) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (35, "REGION_1", " -> Costa Brava", 1) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (35, "AIRPORT_3", " ---> Barcelona (BCN)", 2) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (40, "COUNTRY_194", "Spain", 0) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (40, "REGION_1", " -> Costa Brava", 1) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (40, "AIRPORT_3", " ---> Barcelona (BCN)", 2) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (42, "COUNTRY_194", "Spain", 0) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (42, "REGION_1", " -> Costa Brava", 1) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (42, "AIRPORT_3", " ---> Barcelona (BCN)", 2) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (44, "COUNTRY_194", "Spain", 0) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (44, "REGION_1", " -> Costa Brava", 1) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (44, "AIRPORT_3", " ---> Barcelona (BCN)", 2) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (44, "AIRPORT_2", " ---> Gerona (GRO)", 3) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (44, "AIRPORT_57", " -> Reus, REU - Costa Dorada (REU)", 4) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (47, "COUNTRY_194", "Spain", 0) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (47, "REGION_1", " -> Costa Brava", 1) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (47, "AIRPORT_2", " ---> Gerona (GRO)", 2) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (49, "COUNTRY_194", "Spain", 0) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (49, "REGION_1", " -> Costa Brava", 1) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (49, "AIRPORT_3", " ---> Barcelona (BCN)", 2) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (49, "AIRPORT_2", " ---> Gerona (GRO)", 3) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (49, "AIRPORT_57", " -> Reus, REU - Costa Dorada (REU)", 4) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (50, "COUNTRY_194", "Spain", 0) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (50, "REGION_1", " -> Costa Brava", 1) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (50, "AIRPORT_3", " ---> Barcelona (BCN)", 2) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (50, "AIRPORT_2", " ---> Gerona (GRO)", 3) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - INSERT INTO ToList (FromAirportID, Code, Description, OrderReference) VALUES (50, "AIRPORT_57", " -> Reus, REU - Costa Dorada (REU)", 4) - Table 'SunwaysBookingSystem.ToList' doesn't existProblem with SQL query - SELECT * FROM ToList ORDER BY FromAirportID, OrderReference - Table 'SunwaysBookingSystem.ToList' doesn't exist Hotel Pimar, Blanes | Blanes Holidays, Costa Brava | Sunways Holidays
ATOL Protected Logo ABTA Logo

0161 654 0055

Hotel Pimar

Hotel Pimar ***

 

The Hotel Pinar is situated right on the Sânt Abanell beach, the longest beach along the Costa Brava, just a 5 minute walk from the town centre of Blanes and within close proximity to the tourist areas.

 

It is a fantastic destination for a family holiday, where you can combine the sun and the beaches with a warm friendly welcome and good quality service.

 

 

Rooms Description

The rooms have a complete bathroom, telephone, satellite TV, air conditioned, and safety deposit box (at a charge). Guestrooms are bright and simply decorated with tiled floors and some of them have balconies. Rooms with sea view and baby cots are available on request.

 

 

 

Hotel Facilities

Pimar hotel facilities include internet connection, lifts, TV room with satellite, night security guard, air-conditioning/heating in public spaces, indoor parking and luggage room.

 

Food & Beverage
Guests can taste traditional food and beverages in the hotel restaurant where breakfast, lunch and dinner are served in a buffet style. The hotel also provides a bar.

 

Sports & Leisure
Pimar hotel has swimming pool, billiards and video-games. An entertainment programme provides 3 shows per week in the premises with live music and disco.

Holidays

Flights

Hotels

Download & Request Brochure

H.TOP Hotels