• VENTA DEPARTAMENTO 2 DORMITORIOS TOLOSA CON COCHERA


    Moderno edificio, ubicado en la localidad de Tolosa, calle 115 y esquina 531,. La zona conserva su clima histórico con sus fachadas de época, sus calles empedradas y la histórica iglesia Del Carmen que sobresale por su altura y belleza. El edificio , con departamentos a estrenar

    Ver Más
  • CAMPOS DE ROCA CASA VENTA


    La CASA posee más de 10 AMBIENTES DE CATEGORÍA desarrollados sobre un lote de 6.251 m2 + 685 m2 CUBIERTOS y se encuentra TOTALMENTE EQUIPADA.

    Ver Más
  • VENTA DEPARTAMENTO MODERNO


    Ubicado en la calle 65 entre 6 y 7, en un cuarto piso contra frente, a estrenar, con un desarrollo en dos plantas y una superficie de 75m2 para obtener un dormitorio divisible.

    Ver Más
  • ALQUILER TEMPORADA CAMPOS DE ROCA


    Sobre una parcela de 13.500, con pequeña laguna privada y rodeada de un entorno natural maravilloso con todo el confort para una temporada.

    Ver Más
  • VENTA DEPARTAMENTO LA PLATA


    DEPARTAMENTO de un dormitorio con cochera ubicado la calle 38 entre 2 y 3. Posee una superficie de 52 m2, con ambientes luminosos, amplios y cómodos en su distribución.

    Ver Más
  • CASA EN CAMPOS DE ROCA


    Importante propiedad en CAMPOS DE ROCA, casa de estilo campo con acentos coloniales.

    Ver Más
  • ALQUILER CASA CAMPOS DE ROCA


    Construida sobre un lote de 6.400 m2, desarrollada en dos plantas con una superficie cubierta de 410 m2 y semicubierta de 64 m2, la casa posee con 4 dormitorios y 5 baños. Un proyecto arquitectónico exquisito de ambientes amplios, cómodos y bien distribuidos.

    Ver Más

¿Qué estás buscando?

ModelEmptyResultException Object
(
    [message:protected] => SELECT p.id_propiedad
    		FROM propiedades p
            INNER JOIN propiedad_operacion po USING (id_propiedad)
    		INNER JOIN operaciones o USING(id_operacion)
    		WHERE p.home
                AND p.activo=1
                AND o.nombre = 'Venta'
                AND p.orden>(SELECT orden FROM propiedades WHERE marker='VENTA')
                AND p.orden<=(SELECT orden FROM propiedades WHERE marker='BARRIOS CERRADOS Y COUNTRIES')
                AND marker IS NULL
    		ORDER BY orden asc, id_propiedad desc
    		LIMIT 0, 9
    [string:Exception:private] => 
    [code:protected] => 0
    [file:protected] => /home5/falco/public_html/vadmin/vork/classes/Model/Model.php
    [line:protected] => 379
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home5/falco/public_html/includes/models/propiedades_home_venta.php
                    [line] => 22
                    [function] => query
                    [class] => Model
                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT p.id_propiedad
    		FROM propiedades p
            INNER JOIN propiedad_operacion po USING (id_propiedad)
    		INNER JOIN operaciones o USING(id_operacion)
    		WHERE p.home
                AND p.activo=1
                AND o.nombre = 'Venta'
                AND p.orden>(SELECT orden FROM propiedades WHERE marker='VENTA')
                AND p.orden<=(SELECT orden FROM propiedades WHERE marker='BARRIOS CERRADOS Y COUNTRIES')
                AND marker IS NULL
    		ORDER BY orden asc, id_propiedad desc
    		LIMIT 0, 9
                        )

                )

            [1] => Array
                (
                    [file] => /home5/falco/public_html/vadmin/vork/functions.php
                    [line] => 126
                    [args] => Array
                        (
                            [0] => /home5/falco/public_html/includes/models/propiedades_home_venta.php
                        )

                    [function] => include
                )

            [2] => Array
                (
                    [file] => /home5/falco/public_html/includes/functions.php
                    [line] => 333
                    [function] => get_var
                    [args] => Array
                        (
                            [0] => /home5/falco/public_html/includes/models/propiedades_home_venta.php
                            [1] => query
                            [2] => Array
                                (
                                )

                        )

                )

            [3] => Array
                (
                    [file] => /home5/falco/public_html/includes/plugins/home/destacadas.php
                    [line] => 7
                    [function] => fetch
                    [args] => Array
                        (
                            [0] => propiedades_home_venta
                        )

                )

            [4] => Array
                (
                    [file] => /home5/falco/public_html/vadmin/vork/functions.php
                    [line] => 88
                    [args] => Array
                        (
                            [0] => /home5/falco/public_html/includes/plugins/home/destacadas.php
                        )

                    [function] => include
                )

            [5] => Array
                (
                    [file] => /home5/falco/public_html/vadmin/vork/functions.php
                    [line] => 106
                    [function] => include_component
                    [args] => Array
                        (
                            [0] => /home5/falco/public_html/includes/plugins/home/destacadas.php
                            [1] => Array
                                (
                                )

                        )

                )

            [6] => Array
                (
                    [file] => /home5/falco/public_html/includes/functions.php
                    [line] => 361
                    [function] => component
                    [args] => Array
                        (
                            [0] => /home5/falco/public_html/includes/plugins/home/destacadas.php
                            [1] => Array
                                (
                                )

                        )

                )

            [7] => Array
                (
                    [file] => /home5/falco/public_html/home.php
                    [line] => 6
                    [function] => plugin
                    [args] => Array
                        (
                            [0] => home/destacadas
                        )

                )

            [8] => Array
                (
                    [file] => /home5/falco/public_html/includes/functions.php
                    [line] => 463
                    [args] => Array
                        (
                            [0] => /home5/falco/public_html/home.php
                        )

                    [function] => include
                )

            [9] => Array
                (
                    [file] => /home5/falco/public_html/includes/functions.php
                    [line] => 438
                    [function] => build_page
                    [args] => Array
                        (
                            [0] => home
                        )

                )

            [10] => Array
                (
                    [file] => /home5/falco/public_html/index.php
                    [line] => 101
                    [function] => show_page
                    [args] => Array
                        (
                            [0] => home
                        )

                )

        )

    [previous:Exception:private] => 
)

Barrios Cerrados y Countries

ModelEmptyResultException Object
(
    [message:protected] => SELECT p.id_propiedad
    		FROM propiedades p
    		WHERE p.home
                AND p.activo=1
                AND p.orden>(SELECT orden FROM propiedades WHERE marker='BARRIOS CERRADOS Y COUNTRIES')
                AND p.orden<=(SELECT orden FROM propiedades WHERE marker='ALQUILERES')
                AND marker IS NULL
    		ORDER BY orden asc, id_propiedad desc
    		LIMIT 0, 4
    [string:Exception:private] => 
    [code:protected] => 0
    [file:protected] => /home5/falco/public_html/vadmin/vork/classes/Model/Model.php
    [line:protected] => 379
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home5/falco/public_html/includes/models/propiedades_home_barrios_cerrados_y_countries.php
                    [line] => 17
                    [function] => query
                    [class] => Model
                    [type] => ->
                    [args] => Array
                        (
                            [0] => SELECT p.id_propiedad
    		FROM propiedades p
    		WHERE p.home
                AND p.activo=1
                AND p.orden>(SELECT orden FROM propiedades WHERE marker='BARRIOS CERRADOS Y COUNTRIES')
                AND p.orden<=(SELECT orden FROM propiedades WHERE marker='ALQUILERES')
                AND marker IS NULL
    		ORDER BY orden asc, id_propiedad desc
    		LIMIT 0, 4
                        )

                )

            [1] => Array
                (
                    [file] => /home5/falco/public_html/vadmin/vork/functions.php
                    [line] => 126
                    [args] => Array
                        (
                            [0] => /home5/falco/public_html/includes/models/propiedades_home_barrios_cerrados_y_countries.php
                        )

                    [function] => include
                )

            [2] => Array
                (
                    [file] => /home5/falco/public_html/includes/functions.php
                    [line] => 333
                    [function] => get_var
                    [args] => Array
                        (
                            [0] => /home5/falco/public_html/includes/models/propiedades_home_barrios_cerrados_y_countries.php
                            [1] => query
                            [2] => Array
                                (
                                )

                        )

                )

            [3] => Array
                (
                    [file] => /home5/falco/public_html/includes/plugins/home/cerrados-y-countries.php
                    [line] => 7
                    [function] => fetch
                    [args] => Array
                        (
                            [0] => propiedades_home_barrios_cerrados_y_countries
                        )

                )

            [4] => Array
                (
                    [file] => /home5/falco/public_html/vadmin/vork/functions.php
                    [line] => 88
                    [args] => Array
                        (
                            [0] => /home5/falco/public_html/includes/plugins/home/cerrados-y-countries.php
                        )

                    [function] => include
                )

            [5] => Array
                (
                    [file] => /home5/falco/public_html/vadmin/vork/functions.php
                    [line] => 106
                    [function] => include_component
                    [args] => Array
                        (
                            [0] => /home5/falco/public_html/includes/plugins/home/cerrados-y-countries.php
                            [1] => Array
                                (
                                )

                        )

                )

            [6] => Array
                (
                    [file] => /home5/falco/public_html/includes/functions.php
                    [line] => 361
                    [function] => component
                    [args] => Array
                        (
                            [0] => /home5/falco/public_html/includes/plugins/home/cerrados-y-countries.php
                            [1] => Array
                                (
                                )

                        )

                )

            [7] => Array
                (
                    [file] => /home5/falco/public_html/home.php
                    [line] => 12
                    [function] => plugin
                    [args] => Array
                        (
                            [0] => home/cerrados-y-countries
                        )

                )

            [8] => Array
                (
                    [file] => /home5/falco/public_html/includes/functions.php
                    [line] => 463
                    [args] => Array
                        (
                            [0] => /home5/falco/public_html/home.php
                        )

                    [function] => include
                )

            [9] => Array
                (
                    [file] => /home5/falco/public_html/includes/functions.php
                    [line] => 438
                    [function] => build_page
                    [args] => Array
                        (
                            [0] => home
                        )

                )

            [10] => Array
                (
                    [file] => /home5/falco/public_html/index.php
                    [line] => 101
                    [function] => show_page
                    [args] => Array
                        (
                            [0] => home
                        )

                )

        )

    [previous:Exception:private] => 
)

Somos una inmobiliaria moderna, trabajamos con profesionalismo, honestidad y ética en los negocios. Ventas, alquileres y asesoramiento.