Apartments for rent Truskavets

Rooms and Guests
Type
Price
Location
Other filters
Instant
Truskavets, Ukraine

Apartments for rent Truskavets

Your payments are protected

Vlasne guarantees security online booking:

  • contract offer
  • secure payments
  • money back guarantee

All this works only on condition online booking through the website.

Nothing
didn't fit?

Fill in search request.
We will send it to all property owners in the city.

Array (1)
адрес страницы/en/city/truskavets/
Array (2)
time0.2044
count7
1
Array (7)
0SELECT `ws_visits`.* FROM `ws_visits` WHERE (`ws_visits`.`hash_id` = '89a0fa8349465ec5088d5b935137613f') LIMIT 1;
1SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`seo_link` = 'truskavets') LIMIT 1;
2SELECT DISTINCT ad_id FROM n2n_estate_ad_recent WHERE session_id = "065jharl6rtu159tvbi1s1lhr8" ORDER BY ctime DESC;
3SELECT estate_ad.score_info, estate_ad.name_en, estate_ad.description_en, estate_ad.id, estate_ad.adress_en, 2 as currency, ((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.5886 WHEN 2 THEN estate_ad.price_usd * 41.5376 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.38 WHEN 5 THEN estate_ad.price_chf * 49.6357 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.081743 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4296 END) / 41.5376) as price_usd, estate_ad.no_reservation, estate_ad.city_public_paused, estate_ad.lat, estate_ad.lng, estate_ad.city_id, estate_ad.country_id, estate_ad.rooms, estate_ad.images, estate_ad.type_id, estate_ad.qty_comments, estate_ad.comments_score, estate_ad.can_low_price, estate_ad.sleeping, estate_ad.city_hot_paused, estate_ad.city_hot_main_paused, estate_ad.end_hot_2, estate_ad.end_hot_main, estate_ad.end_public, estate_ad.end_hot, estate_ad.daily_fee_paid, estate_ad.recommend, estate_ad.reserv, estate_ad.partner_id, estate_ad.customer_id FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9920 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-16" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870) ORDER BY IF (estate_ad.end_hot_main >= "2025-05-16", IF (estate_ad.reserv = 1, 2.5, 2), IF (estate_ad.end_hot_2 >= "2025-05-16", IF (estate_ad.reserv = 1, 1.5, 1), IF (estate_ad.end_public >= "2025-05-16", IF (estate_ad.reserv = 1, 0.5, 0), -0.5))) DESC, estate_ad.score DESC, estate_ad.id ASC LIMIT 0,26;
4SELECT `city_info`.* FROM `city_info` WHERE ((city_id = 9920 OR city_id = 0 OR city_id IS NULL)) AND (`city_info`.`site_id` = '2') AND ((country_id = 92 OR country_id = 0 OR country_id IS NULL)) AND (`city_info`.`site_id` IS NULL OR `city_info`.`site_id` = '2') ORDER BY IFNULL(country_id, 0) DESC, IFNULL(city_id, 0) DESC;
5SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'предложений') LIMIT 1;
6SELECT `comments`.* FROM `comments` WHERE (`comments`.`public` = 1) AND (`comments`.`type` = 1) AND (`comments`.`site_id` IS NULL OR `comments`.`site_id` = '2') ORDER BY `ctime` DESC LIMIT 5;
Array (1)
main0.4271
string
Memory: 4.000Mb