Waterpark Apartments!

3-rooms. apartment for 6 guests, 100 m2,
4 floor 10 -storey building

2875
rub
per day
Dates
Check in
Check out
Select a check-in time
Check in time
Close
Number of guests
Adults
Children Age 2 — 12
Maximum 6 guests (not counting infants)
Close
Message
Departure date must be later than the arrival date.
Please fill in the fields "Check in" and "Check out."
Unfortunately, the object is not available for the chosen dates.
You can choose other dates or other objects.
You have already sent a request for these dates.
Wait for a response from the owner, or send a request to other dates.
Minimum stay period for this ad — 1 day
Booking for one day is possible one day prior to arrival or on the day of arrival
Minimum stay for this period —
Please select guests
Maximum 6 guests (not counting infants)
View similar object
You won’t be charged yet
2875
rub
per day
ava

On the site since january 2016 Rent

Languages: Русский
Contact the owner
Communicate only through Vlasne. For security reasons, never transfer money and do not communicate outside the site
Request booking
2875 per day
Request booking

The owner

ava

On the site since january 2016 Rent

Languages: Русский
Contact the owner
Communicate only through Vlasne. For security reasons, never transfer money and do not communicate outside the site

flat description

Cozy, large and comfortable 3-room studio in the most prestigious area of ​​the city. In the immediate vicinity of one of the largest water parks in the world "Riviera" beach with 80-meter swimming pool and cascading the VIP-basins, as well as 5D and 3D movie theaters, a bowling alley, located in the same place: the city's best restaurants, a petting zoo, a fitness club premium class "Planet Fitness", a nightclub «Cinema».

Very close by are Ice Palace "Tatneft Arena", the new football stadium c largest external screen in Europe "Arena", the Palace of water sports, cinema with the largest screen in Kazan «3D Port Cinema», shopping and entertainment centers "Tandem" , «Park House», «Bahetle". The apartment offers a beautiful view of the city of Kazan! Bus stop near the house, the ability to go to any area of ​​the city! The apartment is equipped with all necessary appliances and utensils for cooking. In the kitchen there is a comfortable kitchen, dining table, chairs, refrigerator, microwave oven, electric kettle and tableware is included. For a pleasant stay you expect 2 double beds, fold-out sofa, entertainment of a high-speed Wi-fi, a large, modern TV and digital HD TV !! Also for convenience there is a washing machine, iron, hair dryer, electric kettle, microwave oven, clean bed linen and all necessary for the life of the little things (slippers and personal care products, soaps, shampoos, shoe care products, tea, sugar, etc. .) The real owner of the apartment! We made sure that the guests of the capital, stopping us feel at home, to unwind, relax, prepare their favorite food if you wish. We always clean and comfortable. Cleaning and linen change not less than once every five days, disinfection of apartments is carried out after every guest. The apartment is not designed for noisy parties and company !!! On arrival a deposit. The deposit is refunded upon departure and is used in case of damage to property in the apartment. You should have your passport for registration of contract. Provides reporting documents.

Show full description

Amenities

Rent terms and conditions

Check-in
after 12:00
Check out
up to 11:00
Pledge
No
Children
Conditions of cancellation
Animals
Smoking
Parties
Documents
Check-in/out terms

Reviews (0)

No reviews have been submitted so far.

Location

Array (1)
адрес страницы/en/city/kazan/realt/45403/
Array (2)
time0.3465
count34
1
Array (34)
0SELECT `ws_visits`.* FROM `ws_visits` WHERE (`ws_visits`.`hash_id` = 'bf682e8c27c2f78bc138a725831a8819') LIMIT 1;
1SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`seo_link` = 'kazan') LIMIT 1;
2SELECT `estate_ad`.* FROM `estate_ad` WHERE (`estate_ad`.`id` = '45403');
3SELECT `streets`.* FROM `streets` WHERE (`streets`.`id` = '168771');
4SELECT country_id FROM country_polygons WHERE St_Contains(polygon, POINT(-83.0061, 39.9625)) LIMIT 1;
5SELECT city_id FROM city_polygons WHERE St_Contains(polygon, POINT(-83.0061, 39.9625)) LIMIT 1;
6SELECT city_id FROM cities WHERE country_id = 75 AND ( name = "Колумбус" OR name_en = "Columbus");
7UPDATE estate_ad SET visits = (visits + 1) WHERE id = 45403;
8SELECT id FROM estate_ad_visit_days WHERE ad_id = 45403 AND yearmonthday = 20250515;
9UPDATE estate_ad_visit_days SET visits = (visits + 1), roomer = (roomer + 0) WHERE id = 62142952;
10SELECT id FROM estate_ad_visit_month WHERE ad_id = 45403 AND yearmonth = 202505;
11UPDATE estate_ad_visit_month SET visits = (visits + 1), roomer = (roomer + 0) WHERE id = 3404365;
12SELECT `estate_ad_visit`.* FROM `estate_ad_visit` WHERE (`estate_ad_visit`.`session_id` = '4fljat4dm5rotc64evq79mtepq') AND (`estate_ad_visit`.`roomer` = 0) AND (utime >= "2025-05-15 22:38:38") ORDER BY `utime` DESC LIMIT 1;
13SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`pay` = 1) ORDER BY `sequence` DESC, `name` ASC;
14INSERT INTO `estate_ad_visit` SET `ad_id` = 45403, `session_id` = '4fljat4dm5rotc64evq79mtepq', `first_id` = 206686337, `ctime` = '2025-05-15 23:08:38', `utime` = '2025-05-15 23:08:38', `referer` = 'https://vlasne.ru/en/city/kazan/realt/45403', `paid_ad` = 1, `city_id` = 5973, `country_id` = 75, `ip` = '18.117.153.108', `user_agent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])', `c` = 1, `year` = 2025, `yearmonth` = 202505, `yearmonthday` = 20250515, `ad_city_id` = 2095, `owner_id` = 106736;
15SELECT * FROM estate_media WHERE ad_id = 45403 AND `type` = "image" ORDER BY sequence ASC LIMIT 1;
16SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 45403;
17SELECT `streets`.* FROM `streets` WHERE (`streets`.`id` = '168771') LIMIT 1;
18SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
19SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
20SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
21SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
22SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
23SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
24SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
25SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
26SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
27SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
28SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
29SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
30SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = '-ти') LIMIT 1;
31SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Очистить все даты') LIMIT 1;
32SELECT *, CASE WHEN `type` = "image" THEN 1 WHEN `type` = "video" THEN 2 WHEN vcode IS NOT NULL AND vcode <> "" then 3 END as ordered FROM estate_media WHERE ad_id = 45403 AND IF(`type` = "image", IF (small IS NULL OR small = "", false, true), true) ORDER BY ordered ASC, sequence ASC;
33SELECT DISTINCT ad_id FROM n2n_estate_ad_recent WHERE session_id = "4fljat4dm5rotc64evq79mtepq" ORDER BY ctime DESC;
Array (1)
main0.7475
string
Memory: 18.000Mb