Romantic Room at the Lion Bridge

3-rooms. Mini-hotel for 10 guests, 100 m2

1725
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 10 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 10 guests (not counting infants)
View similar object
You won’t be charged yet
1725
rub
per day
ava

On the site since may 2013 Rent

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

The owner

ava

On the site since may 2013 Rent

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

flat description

If you like romance, like the old days with a modern twist, this number is created for you, all new furniture and is made in the same old style. The room is located in a house renovated, the house is a good insulation, wall thickness of 30 cm, a quiet street, the length of the street, just 100 m. 1-minute walk shops and supermarket 24 hours, 7 minutes to walk to the underground, the entire historic city within walking distance, to the Hermitage 15 minutes, 10 minutes wharf, where the canal tours.

Opposite the house is a house where there lived an old woman pawnbroker who killed Raskolnikov. The atmosphere of mystery and enigma will wait for guests in this room. In the room of 100 m2 for rent 3 rooms, shower room and toilet general, the maximum number of persons not more than 8, kitchen 10 m2 furnished and equipped with everything necessary to cook and live a long time. Each room has an electric kettle, crockery for 2-4 persons, microwave oven, to the minimum contact with the guests. WC and bathroom are clean, the water pressure is chic, after a bath you cheerful and fun, the atmosphere has room to communicate, you can only smoke in the kitchen area, in the same room and talk ... made in an elegant antique style with wrought-iron bed with mattress average rigidity and a chest of drawers, which can hold a lot of things, home theater allows you to watch any movies previously downloaded on your USB flash drive, in-room sound system worth 5.1 (after 22:00 prohibits loud music include) microwave, kettle, TV, fast WIFI 50 m / bit, set of dishes for two people, provided a good clean bed linen and towels. Who are interested in this accommodation to any person who wants to live in the center with the best possible conditions, while not paying a lot of money. For students who come learn, for lovers romantics ...

Show full description

Amenities

Rent terms and conditions

Check-in
after 13:00
Check out
up to 12: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/29147/
Array (2)
time0.5845
count27
1
Array (27)
0SELECT `ws_visits`.* FROM `ws_visits` WHERE (`ws_visits`.`hash_id` = '7d0a6b8306f0e4c68f1f4daf2001fa32') 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` = '29147');
3SELECT `streets`.* FROM `streets` WHERE (`streets`.`id` = '138565');
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 = 29147;
8SELECT id FROM estate_ad_visit_days WHERE ad_id = 29147 AND yearmonthday = 20250515;
9INSERT INTO estate_ad_visit_days (visits, roomer, ad_id, yearmonthday, ctime) VALUES (1, 0, 29147, 20250515, "2025-05-15 06:58:52");
10SELECT id FROM estate_ad_visit_month WHERE ad_id = 29147 AND yearmonth = 202505;
11UPDATE estate_ad_visit_month SET visits = (visits + 1), roomer = (roomer + 0) WHERE id = 3396883;
12SELECT `estate_ad_visit`.* FROM `estate_ad_visit` WHERE (`estate_ad_visit`.`session_id` = 'emltg8bhiqgbtpodv1hsjpt6hp') AND (`estate_ad_visit`.`roomer` = 0) AND (utime >= "2025-05-15 06:28:52") 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` = 29147, `session_id` = 'emltg8bhiqgbtpodv1hsjpt6hp', `ctime` = '2025-05-15 06:58:52', `utime` = '2025-05-15 06:58:52', `referer` = 'https://vlasne.ru/en/city/sankt-peterburg/realt/29147', `paid_ad` = 1, `city_id` = 5973, `country_id` = 75, `ip` = '3.129.10.46', `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` = 65620;
15SELECT * FROM estate_media WHERE ad_id = 29147 AND `type` = "image" ORDER BY sequence ASC LIMIT 1;
16SELECT * FROM estate_ad_calendar WHERE actual = 1 AND ad_id = 29147;
17SELECT `streets`.* FROM `streets` WHERE (`streets`.`id` = '138565') 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 `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Очистить все даты') LIMIT 1;
25SELECT *, 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 = 29147 AND IF(`type` = "image", IF (small IS NULL OR small = "", false, true), true) ORDER BY ordered ASC, sequence ASC;
26SELECT DISTINCT ad_id FROM n2n_estate_ad_recent WHERE session_id = "emltg8bhiqgbtpodv1hsjpt6hp" ORDER BY ctime DESC;
Array (1)
main0.8416
string
Memory: 18.000Mb