JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
Startseite - stay4business
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)

Serviced apartments in Mannheim, Heidelberg and surroundings

INNER JOIN r2b5Y_postmeta ON ( r2b5Y_posts.ID = r2b5Y_postmeta.post_id ) INNER JOIN r2b5Y_postmeta AS mt1 ON ( r2b5Y_posts.ID = mt1.post_id ) INNER JOIN r2b5Y_postmeta AS mt2 ON ( r2b5Y_posts.ID = mt2.post_id ) JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)
Nice & bright family apartment
(88 sqm, no. 305)

U6, 68161 Mannheim, Deutschland

Stylish and bright 2 bedroom apartment on the 3rd floor. Completely renovated. Centrally located and still very quiet.

Special equipment

Daily price

from 80,85€ (incl. 5% VAT)

Cosy & nice 1 bedroom apartment
(44 sqm, no. 205)

Liebigstraße, 69226 Nußloch, Deutschland

Cosy fully equipped 1 bedroom apartment with balcony. Very quiet area. Shops for daily needs within walking distance.

Special equipment

Daily price

from 63,00€ (incl. 5% VAT)

Cosy 3 bedroom family apartment
(90 sqm, no. 203)

Liebigstraße, 69226 Nußloch, Deutschland

Modern and bright 3 bedoom apartment on the first floor. It is a duplex apartment. Apartment is fully furnished and equipped.

Special equipment

Daily price

from 84,39€ (incl. 5% VAT)

Nice & bright 1 bedroom apartment
(48 sqm, no. 302)

U6, 68161 Mannheim, Deutschland

Stylish and bright 1 bedroom apartment on the 1st floor. Completely renovated. Centrally located and still very quiet.

Special equipment

Daily price

from 68,25€ (incl. 5% VAT)

Nice & bright 2 bedroom apartment
(77 sqm, no. 124)

Konrad-Adenauer-Straße, St. Ilgen 69181 Leimen, Deutschland

Very nice, modern and bright 2 bedroom apartment on the top floor. The apartment is very spacious with own balcony.

Special equipment

Daily price

from 68,25€ (incl. 5% VAT)

Nice & bright! 1 bedroom apartment
(48 sqm, no. 406)

Julius-Becker-Straße 68181, St. Ilgen Leimen, Deutschland

Modern and bright business apartment in a new building (2019). Quiet location, local public transport 5 min away.

Special equipment

Daily price

from 68,25€ (incl. 5% VAT)

Very nice 1 bedroom business apartment
(48 sqm, no. 403)

Julius-Becker-Straße 68181, St. Ilgen Leimen, Deutschland

Modern and bright business apartment in a new building (2019). Quiet location, local public transport 5 min away.

Special equipment

Daily price

from 68,25€ (incl. 5% VAT)

Apartment in the heart of Mannheim
(78 sqm, no. 301)

U6, 68161 Mannheim, Deutschland

Stylish and bright 2 bedroom apartment on the 1st floor. Completely renovated. Centrally located and still very quiet.

Special equipment

Daily price

from 80,85€ (incl. 5% VAT)

JOIN r2b5Y_icl_translations wpml_translations ON r2b5Y_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', r2b5Y_posts.post_type)