SQLSTATE[42S22]: Column not found: 1054 Unknown column '3072A' in 'where clause'

SELECT CodProp, DataInici, DataFi, Titol_en Titol, Texte_en Texte , PreuEstada, PreuOferta, NitSemPer FROM oferta where Activa = 1 and DataInici >= current_date() and CodProp=3072A order by DataInici

CATALINA 2A - REF:3072A - APARTMENT - ETVPL/15415 - Holiday Rental

CATALINA 2A
  • Bedrooms: 3
  • Persons: 6
  • Bathrooms: 2

Pine Walk apartment on the beachfront in the most exclusive location of Port de Pollensa and within a walking distance to the centre.


  • Air conditioning
  • Sea view
  • Sea front
  • Satellite TV
  • TV
  • DVD
  • Internet acces
  • Walking distance to beach
  • Walking distance to supermarkets
  • Walking distance to city
  • Wifi
  • Bed linen and towels
  • Oven / hob
  • Fridge / freezer
  • Microwave
  • Dishwasher
  • Washing machine
  • Tumble dryer
  • Kettle
  • Coffe maker
  • Iron / ironing board
  • Toaster
  • Pots and pans
  • Cutlery
  • Glassware
  • Crockery
  • Bath tube
  • Shower
  • Elevator
  • Safe

CATALINA 2A apartment is located at 89, Voramar street (Puerto POllensa)directly at the waters edge along the pine walk and the beach is adjacent to the apartment. CATALINA 2A apartment is on the first floor of the building and facing East. A lift serves all the floors. It consists of 3 bedrooms and two full bathrooms, fully fitted kitchen utility area with washing machine & tumble-dryer, spacious lounge area with TV satellite. Two terraces facing the sea fully furnished. Air conditioning in all the rooms.

To view and enlarge the image gallery, click on a photo

June - 2023
MoTuWeThFrSaSu
   1234
567891011
12131415161718
19202122232425
2627282930
July - 2023
MoTuWeThFrSaSu
     12
3456789
10111213141516
17181920212223
24252627282930
31
August - 2023
MoTuWeThFrSaSu
 123456
78910111213
14151617181920
21222324252627
28293031
September - 2023
MoTuWeThFrSaSu
    123
45678910
11121314151617
18192021222324
252627282930
October - 2023
MoTuWeThFrSaSu
      1
2345678
9101112131415
16171819202122
23242526272829
3031
November - 2023
MoTuWeThFrSaSu
  12345
6789101112
13141516171819
20212223242526
27282930
December - 2023
MoTuWeThFrSaSu
    123
45678910
11121314151617
18192021222324
25262728293031
January - 2024
MoTuWeThFrSaSu
1234567
891011121314
15161718192021
22232425262728
293031
February - 2024
MoTuWeThFrSaSu
   1234
567891011
12131415161718
19202122232425
26272829
March - 2024
MoTuWeThFrSaSu
    123
45678910
11121314151617
18192021222324
25262728293031
April - 2024
MoTuWeThFrSaSu
1234567
891011121314
15161718192021
22232425262728
2930
May - 2024
MoTuWeThFrSaSu
  12345
6789101112
13141516171819
20212223242526
2728293031
June - 2024
MoTuWeThFrSaSu
     12
3456789
10111213141516
17181920212223
24252627282930
July - 2024
MoTuWeThFrSaSu
1234567
891011121314
15161718192021
22232425262728
293031
August - 2024
MoTuWeThFrSaSu
   1234
567891011
12131415161718
19202122232425
262728293031
September - 2024
MoTuWeThFrSaSu
      1
2345678
9101112131415
16171819202122
23242526272829
30
October - 2024
MoTuWeThFrSaSu
 123456
78910111213
14151617181920
21222324252627
28293031
November - 2024
MoTuWeThFrSaSu
    123
45678910
11121314151617
18192021222324
252627282930
  • Legend:
  • Available
  • Booked

Send Enquiry for this Property:

PRICES PER WEEK

From 01/06/2023 to 01/07/2023 : 2200.00 €

From 01/07/2023 to 01/08/2023 : 2750.00 €

From 01/08/2023 to 01/09/2023 : 3000.00 €

From 01/09/2023 to 01/10/2023 : 2200.00 €

From 01/10/2023 to 01/11/2023 : 1550.00 €