Properties For Sale

Property-Database
 E-mail
Home   Rental Property | Search


ID> KORH ::: Renaissance style house in Kotel


Property Data
Rooms7WC/Bathrooms1
Living-/Useable Space220.00 m²Floor(s) / Location2

Description

We are pleased to offer this unique Renaissance style house located in the historical town of Kotel. Built in the late revival period it features paintings by Italian artists.

It is a two storey town house in need of renovation, close to all amenities, comprising of 7 rooms with approximately 220 sq. m. of floor area and 300 sq. m. yard. On the first floor there are two large rooms and a bathroom with another 4 large rooms on the second floor. The ceilings and walls in the second floor rooms are covered with unique paintings, work of Italian artist who decorated the local church around the 1850's.

The property has electric and water connection.

Location / Vicinity
Located in this historical town, Kotel is 28km from the so called Pentacle major crossroad on the Sofia - Bourgas motorway. Kotel is only 120km from Bourgas International airport, 100km from Veliko Turnovo and only 78km from Sliven.

Condition
The property is in need of major renovation work. However 3 years ago the roof was renovated and a plastic membrane was sunk around the house to protect against damp.

Financial Information
Price40.000 € 

Contact Address
Property Location
Kotel
Sliven
Bourgas
Bulgaria




Contact
Name *
Phone  
Fax  
E-Mail *
Subject *
Inspection Date Desired  
Message *
(* Obligate Fields)

Buying and Renovation

© 2010 Bulgarian Property Sales and Management Services
44 queries executed
1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 99999999 )
 ORDER BY menuid DESC
LIMIT 1
3
DELETE FROM jos_session
 WHERE (
 ( time < '1268405250' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268405250' )
 AND guest = 1
 AND userid = 0
 )
4
SELECT *
 FROM jos_session
 WHERE session_id = '26bd3f29491eefcccd30fa01e23b27d6'
5
SELECT session_id
 FROM jos_session
 WHERE session_id = 'bcad759cdba059de75377fac1b6562ef'
6
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'bcad759cdba059de75377fac1b6562ef','1268406150','','0','1' )
7
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
8
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
9
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
10
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
11
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
12
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
13
SELECT *
 FROM jos_menu
 WHERE published = 1 AND
 link LIKE 'index.php?option=com_estateagent&task=showEO%'
14
SELECT *
 FROM jos_estateagent
 WHERE id = '58'
15
UPDATE jos_estateagent SET hits=(hits+1) WHERE id=58
16
SELECT * FROM jos_contact_details WHERE user_id = 63 AND published = 1 AND access <= 0
17
SELECT * FROM jos_estateagent_images WHERE objid = 58 AND (type = '.jpg' OR type = '.gif' OR type = '.png') ORDER BY ordering ASC
18
SELECT * FROM jos_estateagent_images WHERE objid = 58 AND type = '.pdf' ORDER BY ordering ASC
19
SELECT * FROM jos_estateagent_images WHERE objid = 58 AND (type = '.avi' OR type = '.mov' OR type = '.swf' OR type = '.mpg' OR type = '.mp4' OR type = '.mpeg') ORDER BY ordering ASC
20
SELECT * FROM jos_estateagent_images WHERE objid = 58 AND (type = '.doc' OR type = '.xls' OR type = '.ppt') ORDER BY ordering ASC
21
SELECT * FROM jos_estateagent_images WHERE objid = 58 AND (type = '.odt' OR type = '.odp' OR type = '.ods') ORDER BY ordering ASC
22
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
23
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 99999999 )
 ORDER BY ordering
24
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
25
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
26
SELECT id, cat, title, publish, publish_up, publish_down
					FROM jos_estateagent 
					WHERE 
 (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-12') AND publish_down >= '2010-03-12')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-12' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-12'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND publish=1 ORDER BY id DESC LIMIT 5
27
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='72' AND ordering=1
28
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='71' AND ordering=1
29
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='70' AND ordering=1
30
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='69' AND ordering=1
31
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='68' AND ordering=1
32
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
33
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
34
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
35
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=20'
36
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=21'
37
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=26'
38
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Other Services'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
39
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=15'
40
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=14'
41
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
42
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
43
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=25'
44
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering