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

ISABELA 2A - REF:405-2A - APARTMENT - ETVPL/13483 - Holiday Rental

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

Top floor apartment with 3 bedrooms, located at the end of the Pine Walk area in Port de Pollença.


  • Air conditioning
  • Sea view
  • Sea front
  • Satellite TV
  • TV
  • DVD
  • Internet acces
  • Walking distance to beach
  • Walking distance to supermarkets
  • Walking distance to city
  • Heating
  • 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

ISABELA WITH PENTHOUSE is located at the very end of the Pinewalk area of Puerto Pollensa and it is one of the best apartments to let along this promenada. The apartment is finished to the highest standard and enjoy a magnificent view of the whole bay of Puerto Pollensa and the Aucanada Peninsula in the distance. This top floor, On the main level there is 3 bedrooms, one full bathroom en suite and a full shared shower room: Airy lounge/diner with a TV satellite wich open out to a spacious terrace with fabulous sea views, a fully fitted kitchen (microwaver & dishwasher) and utility area with washing machine & tumble dryer. An spiral staircase from the balcony is leading up to the roof top terrace. Air conditioned apartment.

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 : 2500.00 €

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

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

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

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