bool(false) string(12) "can-picafort" bool(false) string(791) "SELECT anuncios.*, tipos.en as type, poblaciones.en as poblaciones, poblaciones.en_url as poblacion_url, tipos.en_url as tipos_url, provincias.en_url as provincia, provincias.en FROM anuncios left join tipos on tipos.id = anuncios.tipo left join poblaciones on poblaciones.id = anuncios.pueblo left join provincias on provincias.id = anuncios.provincia WHERE precioventa between 0 AND 50000000 AND poblaciones.en_url = 'can-picafort' AND provincias.en_url = 'majorca' ORDER BY fechaactualizado DESC, id DESC LIMIT 0,30" Property For Sale in can picafort

0 Eur

First line, Can Picafort, 140 m2 flat

First line, Can Picafort, 140 m2 flat

0 Eur

Dormitorios: 4 Baños: 2 M2 Viv.: 140

1 1 1 1

Dormitorios: 4 Baños: 2 M2 Viv.: 140

Majorca Majorca Majorca Majorca

First line, Rent a spacious 4 bedroom apartment in Can Picafort, with large terrace with magnificent views of the Nautical Club. Housing distributed in 4 bedrooms, 2 bathrooms, large living room and dining room with access to large terrace with wonde...

Hace 2 meses

Hace 2 meses

89.500 Eur

1 bedroom Apartment, Can Picafort

1 bedroom Apartment, Can Picafort

89.500 Eur

Dormitorios: 1 Baños: 1 M2 Viv.: 40

1 1 1 1

Dormitorios: 1 Baños: 1 M2 Viv.: 40

Majorca Majorca Majorca Majorca

For sale 1 bedroom ground floor apartment in Can Picafort, 50 meters from the sea, spacious living room with fully fitted and equipped kitchen. 1 double bedroom and bathroom.

Hace mas de 6 meses

Hace mas de 6 meses