SQLSTATE[42S22]: Column not found: 1054 Unknown column '3073B' 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=3073B order by DataInici

CATALINA 3B - REF:3073B - APARTMENT - ETVPL/15602 - Holiday Rental

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

Exclusive sea front apartment on the Pine Walk 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
Sited at 89, Voramar street, in a prime position directly at the waters edge along the pine walk area, Catalina 3B apartmetn is on the second floor, facing south-west and it consist of 3 bedrooms sleeping six people and 2 full bathrooms (one en suite), fully fitted kitchen and utility area with washing machine and tumble dryer, spacious lounge area with TV satellite. The two fully furnished terraces are facing the sea and the beach is adjacent to the apartment, Shops and restaurants both within an easy 500 metres stroll. A lift serves all the floors. Air conditioned apartment. Safe is provided. Wifi.
To view and enlarge the image gallery, click on a photo
CATALINA 3B - 2 foto 2 CATALINA 3B - 3 foto 3 CATALINA 3B - 4 foto 4 CATALINA 3B - 5 foto 5 CATALINA 3B - 6 foto 6 CATALINA 3B - 7 foto 7 CATALINA 3B - 8 foto 8 CATALINA 3B - 9 foto 9 CATALINA 3B - 10 foto 10 CATALINA 3B - 11 foto 11 CATALINA 3B - 12 foto 12 CATALINA 3B - 13 foto 13 CATALINA 3B - 14 foto 14 CATALINA 3B - 15 foto 15 CATALINA 3B - 16 foto 16 CATALINA 3B - 17 foto 17 CATALINA 3B - 18 foto 18 CATALINA 3B - 19 foto 19 CATALINA 3B - 20 foto 20
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 20/08/2023 : 3000.00 €

From 20/08/2023 to 01/09/2023 : 2900.00 €

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

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