Properties For Sale

Property-Database
 E-mail
Home   Ski Resorts-Borovets, Bansko, | Search


ID> vt2 ::: Veliko Tarnovo - Agatovo 4 bedroom property


Property Data
Rooms9Bedrooms4
WC/Bathrooms1Floor(s) / Location2
TerraceYesGardenYes
GarageYes 

Description

The house is lived in and in very good condition for a rural property of this kind.
 The garden is also well loved and there are mature vines, vegetable patches,
 fruit trees and lovely flower beds. The property is a very good size and could be renovated into a lovely big country retreat or small holding. It has 5 rooms on the ground floorand 4 on the first floor. There is water and electric installed. There is also a large old barn in the grounds.

 

Location / Vicinity
The village of Agatovo is very quiet and rural. The house is positioned between Sevlievo (15km) and the beautiful old town of Lovech.Sofia is the nearest airport (1h 50min).The popular town of Veliko Turnovo is only a 45 minute drive.

Financial Information
Price20.000 € 

Contact Address
Property Location
Agatovo
sevlievo
veliko Tarnovo
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 < '1268213726' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268213726' )
 AND guest = 1
 AND userid = 0
 )
4
SELECT *
 FROM jos_session
 WHERE session_id = '9dfc8e60586db1483558b7f7cbbfa114'
5
SELECT session_id
 FROM jos_session
 WHERE session_id = 'a8c0334c8ad209526e13559902fe92e5'
6
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'a8c0334c8ad209526e13559902fe92e5','1268214626','','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 = '10'
15
UPDATE jos_estateagent SET hits=(hits+1) WHERE id=10
16
SELECT * FROM jos_contact_details WHERE user_id = 63 AND published = 1 AND access <= 0
17
SELECT * FROM jos_estateagent_images WHERE objid = 10 AND (type = '.jpg' OR type = '.gif' OR type = '.png') ORDER BY ordering ASC
18
SELECT * FROM jos_estateagent_images WHERE objid = 10 AND type = '.pdf' ORDER BY ordering ASC
19
SELECT * FROM jos_estateagent_images WHERE objid = 10 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 = 10 AND (type = '.doc' OR type = '.xls' OR type = '.ppt') ORDER BY ordering ASC
21
SELECT * FROM jos_estateagent_images WHERE objid = 10 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-10') AND publish_down >= '2010-03-10')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-10' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-10'))
 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