Pensiunea Antique Targu Jiu
Bdul Ctin Brancusi, nr.33Pensiunea Antique**** este situata in centrul orasului Targu Jiu, vis-a-vis de intrarea principala in Parcul Constantin Brancusi.
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-24:2026-11-24' 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 ('2183') )
) 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 Casa Vera Targu Jiu
Str. Vasile Alecsandri, nr.51-53
From
$
Pensiunea Casa Vera*** este situata in centrul orasului Targu Jiu, aproape de principalele puncte de interes ale orasului.
Târgu Jiu
Unfortunately no tours were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.