Pensiunea Grandor Paltinis
Paltinis, DJ 106APensiunea Grandor*** este situata in Platoul Valari, la o distanta de 3 kilometri de statiunea de schi Paltinis.
SELECT wpbf_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpbf_postmeta price_meta2 WHERE price_meta2.post_id=wpbf_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-11-21:2026-11-21' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpbf_postmeta price_meta3 WHERE price_meta3.post_id=wpbf_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpbf_posts INNER JOIN wpbf_postmeta ON ( wpbf_posts.ID = wpbf_postmeta.post_id )
WHERE 1=1 AND (
( wpbf_postmeta.meta_key = 'accommodation_location_post_id' AND wpbf_postmeta.meta_value IN ('2119') )
) AND wpbf_posts.post_type = 'accommodation' AND ((wpbf_posts.post_status = 'publish'))
GROUP BY wpbf_posts.ID HAVING 1=1
ORDER BY wpbf_posts.post_title ASC
Pensiunea Victoria Paltinis
Str. Zona Platos, nr. 1
From
$
Pensiunea Victoria*** este situata in Paltinis, la 1 kilometru distanta de Manastirea Paltinis si la 300 metri de complexul de schi Arena Platos.
Vila Romana Paltinis
DN 106A, Paltinis
From
$
Vila Romana*** este situata in Paltinis, la o distanta de 450 metri fata de statia autobuzului ce circula catre Sibiu.
Vila Stefana Paltinis
Str. Prinicipala nr. 10
From
$
Vila Stefana*** este situata la o distanta de 5 kilometri de centrul statiunii montane Paltinis si la 300 metri de partiile de schi.
Păltiniș
Unfortunately no tours were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.