Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the joli-table-of-contents domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/thevivestia.com/staging.thevivestia.com/wp-includes/functions.php on line 6121

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the wp-last-modified-info domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/thevivestia.com/staging.thevivestia.com/wp-includes/functions.php on line 6121

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the fast-indexing-api domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/thevivestia.com/staging.thevivestia.com/wp-includes/functions.php on line 6121

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the rank-math domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/thevivestia.com/staging.thevivestia.com/wp-includes/functions.php on line 6121

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the traveler domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/vhosts/thevivestia.com/staging.thevivestia.com/wp-includes/functions.php on line 6121
Rental Search Halfmap - Vivestia | Risk-Free Villas, Hotels and Cruises in VR
Deprecated: preg_split(): Passing null to parameter #2 ($subject) of type string is deprecated in /var/www/vhosts/thevivestia.com/staging.thevivestia.com/wp-includes/formatting.php on line 3493

Deprecated: preg_split(): Passing null to parameter #2 ($subject) of type string is deprecated in /var/www/vhosts/thevivestia.com/staging.thevivestia.com/wp-includes/formatting.php on line 3493
Clear filter

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?type=villa GROUP BY yTgq7VE_posts.ID ORDER BY tb.is_featured des...' at line 47]
SELECT SQL_CALC_FOUND_ROWS yTgq7VE_posts.*, st_rental_price FROM yTgq7VE_posts INNER JOIN yTgq7VE_st_rental as tb ON yTgq7VE_posts.ID = tb.post_id INNER JOIN ( SELECT tb3.number , tb3.number_booked , tb3.post_id, SUM( CASE WHEN tb.is_sale_schedule != 'on' THEN CASE WHEN tb.discount_type = 'percent' THEN CAST(tb3.price AS DECIMAL) -(CAST(tb3.price AS DECIMAL) / 100) * CAST(tb.discount_rate AS DECIMAL) ELSE CAST(tb3.price AS DECIMAL) - CAST(tb.discount_rate AS DECIMAL) END WHEN tb.is_sale_schedule = 'on'THEN CASE WHEN(UNIX_TIMESTAMP(DATE(tb.sale_price_from)) <= 1759622400 AND UNIX_TIMESTAMP(DATE(tb.sale_price_to)) >= 1759708800) THEN CASE WHEN tb.discount_type = 'percent' THEN CAST(tb3.price AS DECIMAL) - (CAST(tb3.price AS DECIMAL) / 100) * CAST(tb.discount_rate AS DECIMAL) ELSE CAST(tb3.price AS DECIMAL) - CAST(tb.discount_rate AS DECIMAL) END ELSE tb3.price END ELSE tb3.price END ) as st_rental_price FROM yTgq7VE_st_rental_availability AS tb3 LEFT JOIN yTgq7VE_st_rental AS tb ON tb.post_id = tb3.post_id WHERE ( tb3.check_in >= 1759622400 AND tb3.check_out < 1759708800 AND( CAST(tb3.number AS DECIMAL) - CAST(tb3.number_booked AS DECIMAL) > 0 ) ) OR ( tb3.check_in >= 1759622400 AND tb3.check_out <= 1759708800 AND( CAST(tb3.number AS DECIMAL) - CAST(tb3.number_booked AS DECIMAL) > 0 ) AND tb3.groupday = 1 ) GROUP BY tb3.post_id ) AS tb2 ON yTgq7VE_posts.ID = tb2.post_id WHERE 1=1 AND yTgq7VE_posts.post_type = 'st_rental' AND ((yTgq7VE_posts.post_status = 'publish')) AND yTgq7VE_posts.ID NOT IN (15622,15631,15641,15651,15662,15672,15710,15718,15726,15737,15745,15753,15755,15882,15889,15896,15901,15908,15925,15930,15955,15969,15977,16029,16042,16049,16055,16062,16068,16177,16179,16181,16183,16185,16203,16250,16270,16279,16307,16323,16345,16357,16372,16393,16411,16429,16442,16448,16458,16633,16648,16719,16732,16744,16762,16767,16778,16815,16822,16832,16835,16846,16857,16869,17113,17136,17199,17315,17316,17317,18605,18609,18612,18614,21528,21685,22232,22247,22558,26260,28077,28093,28094,28096,28097) AND CAST(tb.rentals_booking_period AS UNSIGNED) <= 0 AND (CAST(tb2.number AS DECIMAL) - CAST(tb2.number_booked AS DECIMAL) > 0) AND tb.rental_max_adult>= 1 AND tb.rental_max_children>= 0?type=villa GROUP BY yTgq7VE_posts.ID ORDER BY tb.is_featured desc, yTgq7VE_posts.post_date desc LIMIT 0, 50

No rental found for 1 adult

No rentals found.
Map

Let's Keep in Touch

Get a Quote

Leave your details and we will take care of the rest.