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)
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)
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)
Home - 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 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.

Daily price

from 69,55€ (incl. 7% 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.

Daily price

from 86,00€ (incl. 7% VAT)

Modern, 3 bedroom family apartment
(99 sqm, no. 122)

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

A fully equipped apartment with 2 bedrooms,. It is very well connected to public transport and shops for daily needs.

Daily price

from 85,60€ (incl. 7% VAT)

Nice & bright 2 bedroom maisonette-apartment in Walldorf (70 sqm, no. 135)

Erich-Kästner-Straße, 69190 Walldorf, Deutschland

Modern and bright 3-room flat over 2 floors with balcony. Maisonette, the children's room is accessible via stairs. Conveniently located for public transport, shops for daily needs within walking distance.

Daily price

from 73,83€ (incl. 7% 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.

Daily price

from 69,55€ (incl. 7% 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.

Daily price

from 69,55€ (incl. 7% 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.

Daily price

from 64,20€ (incl. 7% VAT)

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.

Daily price

from 82,39€ (incl. 7% 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)