Tu espacio servicios inmobiliarios manizales arrienda casas

sábado, 22 de noviembre de 2008

Menú principal

Buscar Inmueble

Quienes Somos

Ultimos Inmuebles

APARTAMENTO CON EXCELENTE UBICACION

CASA PARA ESTRENAR EN VILLAMARIA

CASA AMPLIA EN LA ENEA

EXCELENTE CASA AMPLIA

APARTAMENTO AMPLIO Y BIN UBICADO

Categorias

Apartamentos (30)

Casas (71)

Fincas (13)

Lotes (6)

Locales (4)

Otros (2)

Ultimos Agregados

	APARTAMENTO CON EXCELE...
	CASA PARA ESTRENAR EN ...
	CASA AMPLIA EN LA ENEA
	EXCELENTE CASA AMPLIA
	APARTAMENTO AMPLIO Y B...

Mas Vistos

	(215)	CASA EN COLINAS DEL VI...
	(160)	CASA EN LOS ROSALES
	(147)	CASA EN CHIPRE
	(138)	SAN PEREGRINO
	(131)	CASA EN MONTANA /FRANC...
	(129)	LOCALES CENTRALES FREN...
	(111)	APARTAMENTO PALERMO
	(106)	CASA CON BODEGA EN CEN...
	(105)	MAGNIFICA CASA EN CONJ...
	(103)	EXCELENTES CASAS EN PA...

Inicio

Una Buena Opcion

UBICACION ESTRATEGICA PARA PROYECTO DE APARTAESTUDIOS

Busqueda Rapida

Ultimo inmueble

APARTAMENTO CON EXCELENTE UBICACION

CASA PARA ESTRENAR EN VILLAMARIA

CASA AMPLIA EN LA ENEA

EXCELENTE CASA AMPLIA

APARTAMENTO AMPLIO Y BIN UBICADO

tu espacio inmobiliaria Manizales

TU ESPACIO SERVICIOS INMOBILIARIOS

CALLE 22 N° 23-23 EDIFICIO CONCHA LOPEZ OFICINA 804

TELEFONOS: 8826525 8824925 CELULAR 312-8534102

VENTA Y ALQUILER:

OFREZCA SU INMUEBLE HAGA CLICK AQUI

Casas		Fincas
Apartamentos		Apartaestudio
Lotes		Locales
Oficinas		Otros

Joomla! es Software Libre distribuido bajo licencia GNU/GPL.

crado por Diseño de páginas Web creamostupagina.com

1 SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 AND folder = 'system' ORDER BY ordering

2 SELECT id, link FROM jos_menu WHERE menutype = 'mainmenu' AND published = 1 ORDER BY parent, ordering LIMIT 1

3 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 1 ) ORDER BY menuid DESC LIMIT 1

4 DELETE FROM jos_session WHERE ( ( time < '1227314315' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1227314315' ) AND guest = 1 AND userid = 0 )

5 SELECT * FROM jos_menu WHERE id = 1

6 SELECT COUNT(a.id) FROM jos_content AS a INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-11-21 17:53' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-11-21 17:53' ) AND s.published = 1 AND cc.published = 1 AND a.access <= 0 AND s.access <= 0 AND cc.access <= 0

7 SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits, CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups , s.id AS sec_id, cc.id as cat_id FROM jos_content AS a INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-11-21 17:53' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-11-21 17:53' ) AND s.published = 1 AND cc.published = 1 AND a.access <= 0 AND s.access <= 0 AND cc.access <= 0 ORDER BY f.ordering LIMIT 4

8 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 1 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

9 SELECT id FROM jos_menu WHERE type = 'content_blog_section' AND published = 1 AND componentid = 0

10 SELECT folder, element, published, params FROM jos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering

11 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'

12 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 = 1 ) ORDER BY ordering

13 SELECT m.* FROM jos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering

14 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_item_link' AND published = 1

15 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=2'

16 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=3'

17 SELECT id, cat, title, publish, publish_up, publish_down FROM jos_estateagent WHERE ( ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22') AND publish_down >= '2008-11-22') OR ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2008-11-22')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND publish=1 ORDER BY id DESC LIMIT 5

18 SELECT id, path, fname, type, ordering, publish FROM jos_estateagent_images WHERE objid='132' AND ordering=1

19 SELECT id, path, fname, type, ordering, publish FROM jos_estateagent_images WHERE objid='131' AND ordering=1

20 SELECT id, path, fname, type, ordering, publish FROM jos_estateagent_images WHERE objid='130' AND ordering=1

21 SELECT id, path, fname, type, ordering, publish FROM jos_estateagent_images WHERE objid='129' AND ordering=1

22 SELECT id, path, fname, type, ordering, publish FROM jos_estateagent_images WHERE objid='128' AND ordering=1

23 SELECT * FROM jos_estateagent_categories WHERE parent=0 ORDER BY ordering ASC

24 SELECT count(*) FROM jos_estateagent WHERE cat = 3 AND publish=1 AND verified=1

25 SELECT * FROM jos_estateagent_categories WHERE parent = 3

26 SELECT count(*) FROM jos_estateagent WHERE cat = 2 AND publish=1 AND verified=1

27 SELECT * FROM jos_estateagent_categories WHERE parent = 2

28 SELECT * FROM jos_estateagent_categories WHERE parent=2 ORDER BY ordering ASC

29 SELECT count(*) FROM jos_estateagent WHERE cat = 1 AND publish=1 AND verified=1

30 SELECT * FROM jos_estateagent_categories WHERE parent = 1

31 SELECT * FROM jos_estateagent_categories WHERE parent=1 ORDER BY ordering ASC

32 SELECT count(*) FROM jos_estateagent WHERE cat = 4 AND publish=1 AND verified=1

33 SELECT * FROM jos_estateagent_categories WHERE parent = 4

34 SELECT * FROM jos_estateagent_categories WHERE parent=4 ORDER BY ordering ASC

35 SELECT count(*) FROM jos_estateagent WHERE cat = 5 AND publish=1 AND verified=1

36 SELECT * FROM jos_estateagent_categories WHERE parent = 5

37 SELECT * FROM jos_estateagent_categories WHERE parent=5 ORDER BY ordering ASC

38 SELECT count(*) FROM jos_estateagent WHERE cat = 6 AND publish=1 AND verified=1

39 SELECT * FROM jos_estateagent_categories WHERE parent = 6

40 SELECT * FROM jos_estateagent_categories WHERE parent=6 ORDER BY ordering ASC

41 SELECT count(*) FROM jos_estateagent WHERE cat = 7 AND publish=1 AND verified=1

42 SELECT * FROM jos_estateagent_categories WHERE parent = 7

43 SELECT count(*) FROM jos_estateagent WHERE cat = 8 AND publish=1 AND verified=1

44 SELECT * FROM jos_estateagent_categories WHERE parent = 8

45 SELECT * FROM jos_estateagent_categories WHERE parent=8 ORDER BY ordering ASC

46 SELECT id, cat, title, publish, publish_up, publish_down FROM jos_estateagent WHERE ( ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22') AND publish_down >= '2008-11-22') OR ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2008-11-22')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND publish=1 ORDER BY id DESC LIMIT 5

47 SELECT id, cat, title, publish, publish_up, publish_down, hits FROM jos_estateagent WHERE ( ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22') AND publish_down >= '2008-11-22') OR ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2008-11-22')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND publish=1 ORDER BY hits DESC LIMIT 10

48 SELECT id, name, link, parent, type, menutype, access FROM jos_menu WHERE published = 1 AND access <= 0 ORDER BY menutype, parent, ordering

49 SELECT id, cat, title, publish, publish_up, publish_down FROM jos_estateagent WHERE ( ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22') AND publish_down >= '2008-11-22') OR ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2008-11-22')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND publish=1 ORDER BY RAND() LIMIT 1

50 SELECT id, path, fname, type, ordering, publish FROM jos_estateagent_images WHERE objid='8' AND ordering=1

51 SELECT * FROM jos_estateagent_categories WHERE parent = 0 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22') AND publish_down >= '2008-11-22') OR ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2008-11-22')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access<=0 AND publish='1' ORDER BY ordering

52 SELECT * FROM jos_estateagent_categories WHERE parent = 3 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22') AND publish_down >= '2008-11-22') OR ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2008-11-22')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access<=0 AND publish='1' ORDER BY ordering

53 SELECT * FROM jos_estateagent_categories WHERE parent = 2 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22') AND publish_down >= '2008-11-22') OR ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2008-11-22')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access<=0 AND publish='1' ORDER BY ordering

54 SELECT * FROM jos_estateagent_categories WHERE parent = 1 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22') AND publish_down >= '2008-11-22') OR ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2008-11-22')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access<=0 AND publish='1' ORDER BY ordering

55 SELECT * FROM jos_estateagent_categories WHERE parent = 4 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22') AND publish_down >= '2008-11-22') OR ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2008-11-22')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access<=0 AND publish='1' ORDER BY ordering

56 SELECT * FROM jos_estateagent_categories WHERE parent = 5 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22') AND publish_down >= '2008-11-22') OR ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2008-11-22')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access<=0 AND publish='1' ORDER BY ordering

57 SELECT * FROM jos_estateagent_categories WHERE parent = 6 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22') AND publish_down >= '2008-11-22') OR ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2008-11-22')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access<=0 AND publish='1' ORDER BY ordering

58 SELECT * FROM jos_estateagent_categories WHERE parent = 7 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22') AND publish_down >= '2008-11-22') OR ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2008-11-22')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access<=0 AND publish='1' ORDER BY ordering

59 SELECT * FROM jos_estateagent_categories WHERE parent = 8 AND ( ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22') AND publish_down >= '2008-11-22') OR ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2008-11-22')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND access<=0 AND publish='1' ORDER BY ordering

60 SELECT id, cat, title, publish, publish_up, publish_down FROM jos_estateagent WHERE ( ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22') AND publish_down >= '2008-11-22') OR ((publish_up >= '0000-00-00' AND publish_up <= '2008-11-22' ) AND (publish_down = '0000-00-00' OR publish_down >= '2008-11-22')) OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00') ) AND publish=1 ORDER BY id DESC LIMIT 5

61 SELECT id, path, fname, type, ordering, publish FROM jos_estateagent_images WHERE objid='132' AND ordering=1

62 SELECT id, path, fname, type, ordering, publish FROM jos_estateagent_images WHERE objid='131' AND ordering=1

63 SELECT id, path, fname, type, ordering, publish FROM jos_estateagent_images WHERE objid='130' AND ordering=1

64 SELECT id, path, fname, type, ordering, publish FROM jos_estateagent_images WHERE objid='129' AND ordering=1

65 SELECT id, path, fname, type, ordering, publish FROM jos_estateagent_images WHERE objid='128' AND ordering=1

66 SELECT * FROM jos_banner WHERE showBanner=1