Bulgarian Property Services Contact Us Bulgarian Property For Sale   Properties For Sale Our Services Property Services Property Management Property For Sale Rivendell Personnel Buying & Renovating Ski Properties Ski Borovets Contact Us Roperty for Rent Other Services Welcome Services Rental Services Cleaning Services Useful Links Affiliate Links Property-Database   Home   Land | Search Sort By Rent Price Town District Ascending Descending 5 10 15 20 25 30 50 Our Current Offers     Borovets - Mala Tserkva, Land   ... [More] 80 € / Mala Tserkva / Samokov   Borovets - Madjare village land   ... [More] 65 € / Madjare / Borovets ski area   Alino village land   ... [More] 8 € / Alino village / Borovets area   Borovets Area - Regulated Land on Lake Iskar 110 Euros p/m2   ... [More] 8 € / Lake Iskar, Samokov / Borovets   Borovets - 10000M2 Regulated Development Land   ... [More] 2.450.000 € / Borovets / Samokov   1140 M2 Regulated Land in Reylovo Village - 25 Euros per sq. m   ... [More] 2.450.000 € / Reylovo Village / Samokov   Regulated land in Govedartsi village   ... [More] 100 € / Govedartsi / Borovets   2 Plots of unregulated land in Mechkata   ... [More] 25 € / Mechkata / Samokov   10,300 M2 of unregulated land near Belchin Bania.   ... [More] 8 € / Belchin Bania / Samokov   2591 sq m Regulated Land Borovets   ... [More] 30 € / Madjare / Govedartsi   Borovets Regulated Land 26 Euro p/m2   ... [More] 34.970 € / Metchkata / Samokov Buying and Renovation

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 < '1268314950' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268314950' )
 AND guest = 1
 AND userid = 0
 )
4
SELECT *
 FROM jos_session
 WHERE session_id = '28e3b6a2c47f170f1b1eafb67ba5d441'
5
SELECT session_id
 FROM jos_session
 WHERE session_id = 'b1dc0bede3b4dc8622f687755a5c34e0'
6
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'b1dc0bede3b4dc8622f687755a5c34e0','1268315850','','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=showCE%'
14
SELECT *
 FROM jos_estateagent_categories
 WHERE id = '4'
15
SELECT * FROM jos_estateagent_categories WHERE (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11') AND publish_down >= '2010-03-11')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-11'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND parent = 4 AND access <= 0 AND publish='1' ORDER BY ordering
16
SELECT count(id) FROM jos_estateagent WHERE cat=4 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11') AND publish_down >= '2010-03-11') OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-11')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access<=0 AND verified=1 AND publish=1
17
SELECT id, obj_id, type, title, description, rent, price, country, state, town, district, hot FROM jos_estateagent WHERE cat=4 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11') AND publish_down >= '2010-03-11') OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-11')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') )  AND access<=0 AND verified=1 AND publish=1 ORDER BY id ASC LIMIT 0,25
18
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 8 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
19
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 15 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
20
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 18 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
21
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 34 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
22
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 35 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
23
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 43 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
24
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 44 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
25
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 45 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
26
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 46 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
27
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 53 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
28
SELECT title,fname,type,path FROM jos_estateagent_images WHERE objid = 63 AND (type = '.jpg' OR type = '.gif' OR type = '.png') AND ordering = 1 AND publish = 1
29
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'
30
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
31
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
32
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
33
SELECT id, cat, title, publish, publish_up, publish_down
					FROM jos_estateagent 
					WHERE 
 (
 ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11') AND publish_down >= '2010-03-11')
 OR ((publish_up >= '0000-00-00' AND publish_up <= '2010-03-11' ) AND (publish_down = '0000-00-00' OR publish_down >= '2010-03-11'))
 OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')
 ) AND publish=1 ORDER BY id DESC LIMIT 5
34
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='72' AND ordering=1
35
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='71' AND ordering=1
36
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='70' AND ordering=1
37
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='69' AND ordering=1
38
SELECT id, path, fname, type, ordering, publish
		FROM jos_estateagent_images
		WHERE objid='68' AND ordering=1
39
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
40
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
41
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
42
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=20'
43
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=21'
44
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=26'
45
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Other Services'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
46
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=15'
47
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=14'
48
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
49
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
50
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=25'
51
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering