6-rooms. apartment for 12 guests, 160 m2

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

On the site since march 2012 Rent

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

The owner

ava

On the site since march 2012 Rent

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

flat description

The main advantage of the hotel - convenient location: right in the heart of the northern capital, at the intersection of 9th Street and the Soviet Greek Avenue. The exact address of the hotel: Greek prospect 29/1. The hotel building is located deep in his own quiet, cozy patio that provides a "retreat" from the busy streets and bustle.

Good transport interchange allows you to quickly get to the desired area of ​​the city. Just 10 minutes away and you have the nearest metro station - "Space Rebellion." The same amount of time you need on the road to the Moscow railway station. Walking the Greek Avenue, you have the unique opportunity to study with many architectural and cultural monuments, walk along the fashionable boutiques and antique shops, stores and salons. Tasty lunch or dinner can be adjacent to the hotel cafe and restaurants. The hotel "The atmosphere of the City" offers accommodation in 7 double comfortable "standard" rooms: 4 Room Twin (twin beds) and 3 DBL rooms with a bed King Size (one big bed). All rooms made qualitative improvements, in accordance with European standards. The interiors are designed in soothing, deep-red colors, which has a good rest. Large windows overlook the hotel courtyard. All rooms have modern technical equipment: telephone with long distance / international calls, LCD TV, satellite TV, free Wi-Fi-Internet access, mini bar and air conditioning. Bathrooms are equipped with imported sanitary ware: shower and toilet. "The atmosphere of the City" - a perfect combination of this St. Petersburg hospitality and home comfort. Parking: in the courtyard there is parking, parking at the Moscow railway station.

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/sankt-peterburg/realt/7675/
Array (2)
time0.3806
count40
1
Array (40)
0SELECT `ws_visits`.* FROM `ws_visits` WHERE (`ws_visits`.`hash_id` = 'a035cac9433fbd576e1771f01e756e11') LIMIT 1;
1SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`seo_link` = 'sankt-peterburg') LIMIT 1;
2SELECT `estate_ad`.* FROM `estate_ad` WHERE (`estate_ad`.`id` = '7675');
3SELECT `streets`.* FROM `streets` WHERE (`streets`.`id` = '134065');
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 = 7675;
8SELECT id FROM estate_ad_visit_days WHERE ad_id = 7675 AND yearmonthday = 20250515;
9INSERT INTO estate_ad_visit_days (visits, roomer, ad_id, yearmonthday, ctime) VALUES (1, 0, 7675, 20250515, "2025-05-15 03:28:20");
10SELECT id FROM estate_ad_visit_month WHERE ad_id = 7675 AND yearmonth = 202505;
11UPDATE estate_ad_visit_month SET visits = (visits + 1), roomer = (roomer + 0) WHERE id = 3403331;
12SELECT `estate_ad_visit`.* FROM `estate_ad_visit` WHERE (`estate_ad_visit`.`session_id` = 'ftincfr7p6btguhepk836l7rvi') AND (`estate_ad_visit`.`roomer` = 0) AND (utime >= "2025-05-15 02:58:20") 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` = 7675, `session_id` = 'ftincfr7p6btguhepk836l7rvi', `ctime` = '2025-05-15 03:28:20', `utime` = '2025-05-15 03:28:20', `referer` = 'https://vlasne.ru/en/city/sankt-peterburg/realt/7675', `paid_ad` = 1, `city_id` = 5973, `country_id` = 75, `ip` = '3.141.164.124', `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` = 220, `owner_id` = 44142;
15SELECT * FROM ws_customers WHERE id = 44142;
16SELECT * FROM estate_media WHERE ad_id = 7675 AND `type` = "image" ORDER BY sequence ASC LIMIT 1;
17SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 7675;
18SELECT `streets`.* FROM `streets` WHERE (`streets`.`id` = '134065') LIMIT 1;
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 countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
31SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
32SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
33SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
34SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
35SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
36SELECT countries.*, ST_AsText(location) as location FROM countries WHERE country_id = 0 order by name asc;
37SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Очистить все даты') LIMIT 1;
38SELECT *, 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 = 7675 AND IF(`type` = "image", IF (small IS NULL OR small = "", false, true), true) ORDER BY ordered ASC, sequence ASC;
39SELECT DISTINCT ad_id FROM n2n_estate_ad_recent WHERE session_id = "ftincfr7p6btguhepk836l7rvi" ORDER BY ctime DESC;
Array (1)
main0.5924
string
Memory: 18.000Mb