2-rooms. apartment for 4 guests, 77 m2,
12 floor 22--storey building

1610
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 4 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 4 guests (not counting infants)
You won’t be charged yet
1610
rub
per day
ava

On the site since october 2016 Rent

Contact the owner
Communicate only through Vlasne. For security reasons, never transfer money and do not communicate outside the site
Request booking
1610 per day

The owner

ava

On the site since october 2016 Rent

Contact the owner
Communicate only through Vlasne. For security reasons, never transfer money and do not communicate outside the site

flat description

A cool Apartment for modern people, new-fangled modern design. Cool colors, lots of light, from the design of chandeliers and lamps. Wood and glass base of Scandinavian design and good quality furniture in modern colors are not pitted, adds sophistication apartment! Good bed, with a mattress made of coconut fibers, anatomical pillows.

sleep here this morning that the body is fully rested and the soul sings. kitchen coffee machine will return to the earthly world, and the morning scrambled eggs, cooked in the kitchen of quality, the charge strength for the coming day. Always qualitatively to clean, with good linen. there is not a shame to spend time with the girl, to discuss business ideas, play mafia.

Show full description

Amenities

Rent terms and conditions

Check-in
after 11:00
Check out
up to 10: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/stavropol/realt/45517/
Array (2)
time0.8174
count30
1
Array (30)
0SELECT `ws_visits`.* FROM `ws_visits` WHERE (`ws_visits`.`hash_id` = '77affb806aceed9395bd7d8efa6b6ec9') LIMIT 1;
1SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`seo_link` = 'stavropol') LIMIT 1;
2SELECT `estate_ad`.* FROM `estate_ad` WHERE (`estate_ad`.`id` = '45517');
3SELECT `streets`.* FROM `streets` WHERE (`streets`.`id` = '293314');
4SELECT country_id FROM country_polygons WHERE St_Contains(polygon, POINT(-97.822, 37.751)) LIMIT 1;
5SELECT city_id FROM city_polygons WHERE St_Contains(polygon, POINT(-97.822, 37.751)) LIMIT 1;
6UPDATE estate_ad SET visits = (visits + 1) WHERE id = 45517;
7SELECT id FROM estate_ad_visit_days WHERE ad_id = 45517 AND yearmonthday = 20250516;
8UPDATE estate_ad_visit_days SET visits = (visits + 1), roomer = (roomer + 0) WHERE id = 62145288;
9SELECT id FROM estate_ad_visit_month WHERE ad_id = 45517 AND yearmonth = 202505;
10UPDATE estate_ad_visit_month SET visits = (visits + 1), roomer = (roomer + 0) WHERE id = 3390934;
11SELECT `estate_ad_visit`.* FROM `estate_ad_visit` WHERE (`estate_ad_visit`.`session_id` = '2sjb74av730j3qvnft0p66bmn0') AND (`estate_ad_visit`.`roomer` = 0) AND (utime >= "2025-05-16 00:27:11") ORDER BY `utime` DESC LIMIT 1;
12SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`pay` = 1) ORDER BY `sequence` DESC, `name` ASC;
13INSERT INTO `estate_ad_visit` SET `ad_id` = 45517, `session_id` = '2sjb74av730j3qvnft0p66bmn0', `first_id` = 206696187, `ctime` = '2025-05-16 00:57:11', `utime` = '2025-05-16 00:57:11', `referer` = 'https://vlasne.ru/ru/user/changelang/lang/en/currency/2/?uri=%2Fcity%2Fstavropol%2Frealt%2F45517%2F', `paid_ad` = 1, `country_id` = 75, `ip` = '216.73.216.87', `user_agent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])', `c` = 1, `year` = 2025, `yearmonth` = 202505, `yearmonthday` = 20250516, `ad_city_id` = 2045, `owner_id` = 160252;
14SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 45517;
15SELECT `streets`.* FROM `streets` WHERE (`streets`.`id` = '293314') LIMIT 1;
16SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
17SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
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 `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Очистить все даты') LIMIT 1;
28SELECT *, 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 = 45517 AND IF(`type` = "image", IF (small IS NULL OR small = "", false, true), true) ORDER BY ordered ASC, sequence ASC;
29SELECT DISTINCT ad_id FROM n2n_estate_ad_recent WHERE session_id = "2sjb74av730j3qvnft0p66bmn0" ORDER BY ctime DESC;
Array (1)
main1.2154
string
Memory: 16.000Mb