WP_Query Object ( [query] => Array ( [pcategory] => propiedades ) [query_vars] => Array ( [pcategory] => propiedades [error] => [m] => [p] => 0 [post_parent] => [subpost] => [subpost_id] => [attachment] => [attachment_id] => 0 [name] => [static] => [pagename] => [page_id] => 0 [second] => [minute] => [hour] => [day] => 0 [monthnum] => 0 [year] => 0 [w] => 0 [category_name] => [tag] => [cat] => [tag_id] => [author] => [author_name] => [feed] => [tb] => [paged] => 0 [comments_popup] => [meta_key] => [meta_value] => [preview] => [s] => [sentence] => [title] => [fields] => [menu_order] => [category__in] => Array ( ) [category__not_in] => Array ( ) [category__and] => Array ( ) [post__in] => Array ( ) [post__not_in] => Array ( ) [post_name__in] => Array ( ) [tag__in] => Array ( ) [tag__not_in] => Array ( ) [tag__and] => Array ( ) [tag_slug__in] => Array ( ) [tag_slug__and] => Array ( ) [post_parent__in] => Array ( ) [post_parent__not_in] => Array ( ) [author__in] => Array ( ) [author__not_in] => Array ( ) [ignore_sticky_posts] => [suppress_filters] => [cache_results] => 1 [update_post_term_cache] => 1 [update_post_meta_cache] => 1 [post_type] => [posts_per_page] => 12 [nopaging] => [comments_per_page] => 50 [no_found_rows] => [taxonomy] => pcategory [term] => propiedades [order] => DESC ) [tax_query] => WP_Tax_Query Object ( [queries] => Array ( [0] => Array ( [taxonomy] => pcategory [terms] => Array ( [0] => propiedades ) [field] => slug [operator] => IN [include_children] => 1 ) ) [relation] => AND [table_aliases:protected] => Array ( [0] => wp_term_relationships ) [queried_terms] => Array ( [pcategory] => Array ( [terms] => Array ( [0] => propiedades ) [field] => slug ) ) [primary_table] => wp_posts [primary_id_column] => ID ) [meta_query] => WP_Meta_Query Object ( [queries] => Array ( ) [relation] => [meta_table] => [meta_id_column] => [primary_table] => [primary_id_column] => [table_aliases:protected] => Array ( ) [clauses:protected] => Array ( ) [has_or_relation:protected] => ) [date_query] => [queried_object] => WP_Term Object ( [term_id] => 33 [name] => Propiedades [slug] => propiedades [term_group] => 0 [term_taxonomy_id] => 33 [taxonomy] => pcategory [description] => [parent] => 0 [count] => 0 [filter] => raw [term_icon] => [term_price] => ) [queried_object_id] => 33 [request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) JOIN wp_icl_translations t ON wp_posts.ID = t.element_id AND t.element_type IN ('post_property') JOIN wp_icl_languages l ON t.language_code=l.code AND l.active=1 WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (17,18,29,33) ) AND wp_posts.post_type = 'property' AND (wp_posts.post_status = 'publish') AND t.language_code='es' GROUP BY wp_posts.ID ORDER BY (select wp_postmeta.meta_value from wp_postmeta where wp_postmeta.post_id=wp_posts.ID and wp_postmeta.meta_key = 'featured_c') ASC,post_date DESC LIMIT 0, 12 [posts] => Array ( [0] => WP_Post Object ( [ID] => 65306 [post_author] => 34376 [post_date] => 2019-05-20 17:39:49 [post_date_gmt] => 2019-05-20 15:39:49 [post_content] => [post_title] => Local en ALFONSO XII, Sevilla [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => local-alfonso-xii-sevilla [to_ping] => [pinged] => [post_modified] => 2019-05-20 17:39:49 [post_modified_gmt] => 2019-05-20 15:39:49 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.tucasasivale.com/property/local-alfonso-xii-sevilla/ [menu_order] => 0 [post_type] => property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 58093 [post_author] => 28743 [post_date] => 2019-02-16 20:00:30 [post_date_gmt] => 2019-02-16 18:00:30 [post_content] =>

 

[post_title] => Casa en CUMBRE DE SAN GERARDO, Valencia [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => casa-cumbre-de-san-gerardo-valencia [to_ping] => [pinged] => [post_modified] => 2019-02-16 20:00:30 [post_modified_gmt] => 2019-02-16 18:00:30 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.tucasasivale.com/property/casa-cumbre-de-san-gerardo-valencia/ [menu_order] => 0 [post_type] => property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 50350 [post_author] => 23139 [post_date] => 2018-09-09 18:04:49 [post_date_gmt] => 2018-09-09 16:04:49 [post_content] =>

Excelente restaurante ubicado en pleno centro de Santa Cruz de Tenerife, con terraza, aforo para 110 personas! Cuenta con todas las licencias y equipamiento para comenzar a trabajar!

[post_title] => Negocio en Plaza Isla de la Madera , Tenerife [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => negocio-plaza-isla-de-la-madera-tenerife [to_ping] => [pinged] => [post_modified] => 2018-09-09 18:04:49 [post_modified_gmt] => 2018-09-09 16:04:49 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.tucasasivale.com/property/negocio-plaza-isla-de-la-madera-tenerife/ [menu_order] => 0 [post_type] => property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 44935 [post_author] => 18972 [post_date] => 2018-04-09 13:53:33 [post_date_gmt] => 2018-04-09 11:53:33 [post_content] =>

bonito local en la avenida de valdemarin. el local tiene 100 metros cuadrados y dispone de salida de humos. cuenta con licencia de restauración. Dispone de terraza

[post_title] => Local en Avenida valdemarin 121, Madrid [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => local-avenida-valdemarin-121-madrid [to_ping] => [pinged] => [post_modified] => 2018-04-09 13:53:33 [post_modified_gmt] => 2018-04-09 11:53:33 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.tucasasivale.com/property/local-avenida-valdemarin-121-madrid/ [menu_order] => 0 [post_type] => property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 43321 [post_author] => 17894 [post_date] => 2018-02-23 22:00:03 [post_date_gmt] => 2018-02-23 20:00:03 [post_content] =>

Magnifico loft en el centro de Barcelona, recien reformado, suelos parket , cocina office totalmente equipada, baño con plato ducha , amueblado, insonorizado , cristaleria climalit, aire ac y calefaccion, listo para entrar a vivir, tambien Se acepta PAGO EN EFECTIVO .

[post_title] => Piso en calle ricart 22, Barcelona [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => piso-calle-ricart-22-barcelona [to_ping] => [pinged] => [post_modified] => 2018-02-23 22:00:03 [post_modified_gmt] => 2018-02-23 20:00:03 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.tucasasivale.com/property/piso-calle-ricart-22-barcelona/ [menu_order] => 0 [post_type] => property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 43312 [post_author] => 17894 [post_date] => 2018-02-23 21:56:50 [post_date_gmt] => 2018-02-23 19:56:50 [post_content] =>

Magnifico duplex en el centro de Barcelona, recien reformado, suelos parket , cocina office totalmente equipada, baño con plato ducha , amueblado, insonorizado , cristaleria climalit, aire ac y calefaccion, listo para entrar a vivir .

[post_title] => Piso en avenida paralelo 141, Barcelona [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => piso-avenida-paralelo-141-barcelona [to_ping] => [pinged] => [post_modified] => 2018-02-23 21:56:50 [post_modified_gmt] => 2018-02-23 19:56:50 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.tucasasivale.com/property/piso-avenida-paralelo-141-barcelona/ [menu_order] => 0 [post_type] => property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [6] => WP_Post Object ( [ID] => 43297 [post_author] => 17894 [post_date] => 2018-02-23 21:33:23 [post_date_gmt] => 0000-00-00 00:00:00 [post_content] =>

Loft Diseño  , 120 metros , situado a escasos metros del centro de Barcelona, junto al Camp Nou , parada metro Colblanc , materiales 1 calidad, totalmente equipado , cocina alta gama, isla( vitroceramica Teka inducción , extractora suspendida filtro carbono, horno, microondas, frigorífico lavadora integral)Televisión 65 pulgadas , baño completo spa gres, madera olivo, recién acabada la obra, parket AC5 , 2x aire acondicionado Lg , salida humo industrial, amueblado, 2x Sofa, cama colchón + canapé 190x200 , iluminación Led diseñador Paul Mann , puerta blindada , local acceso calle , posibilidad acceso por portal, grandes ventanas cristal térmicos y de seguridad con motorización , 3 plantas , Microcemento , techo de 5, 90 metro altura, se puede ampliar una planta lo que haria un total de 220 metros , suministros al día. Listo para entrar PARTICULAR , Negociable , nada de inmobiliaria , se acepta PAGO EN EFECTIVO

[post_title] => Piso en plaza de la senia , Barcelona [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => piso-plaza-de-la-senia-barcelona [to_ping] => [pinged] => [post_modified] => 2018-02-23 21:33:23 [post_modified_gmt] => 0000-00-00 00:00:00 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.tucasasivale.com/?post_type=property&p=43297 [menu_order] => 0 [post_type] => property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [7] => WP_Post Object ( [ID] => 37721 [post_author] => 12730 [post_date] => 2017-10-16 10:47:37 [post_date_gmt] => 2017-10-16 08:47:37 [post_content] =>

¡¡¡VENTA DE PISO EN TORREMOLINOS POR CAMBIO DE RESIDENCIA, OPORTUNIDAD UNICA !!!

115 000 €      

Zona Centro Malaga

 

¡¡¡VENTA DE PISO EN TORREMOLINOS POR CAMBIO DE RESIDENCIA, OPORTUNIDAD UNICA !!!
115 000 €
Zona Centro Malaga
Piso de 3 dormitorios, 1 baño con ventana exterior, cocina, terraza con vistas a la bahía de Málaga, aparcamiento privado para propietarios, agua incluida en recibo de comunidad y múltiples servicios cercanos al inmueble como farmacia 24h, colegios, supermercados, etc. A 5 minutos del centro de Torremolinos, 10 minutos al aeropuerto y con acceso a autovía. Precio negociable. Playa a un kilómetro. 3ª Planta. Ascensor. Amueblado. Terraza. Piscina. Jardín-contacto  pronijnahoo.es -  tlno. 687375904-    C.P 29620.

[post_title] => Piso en c/guadalope, Málaga [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => piso-cguadalope-malaga [to_ping] => [pinged] => [post_modified] => 2017-10-16 10:47:37 [post_modified_gmt] => 2017-10-16 08:47:37 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.tucasasivale.com/property/piso-cguadalope-malaga/ [menu_order] => 0 [post_type] => property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [8] => WP_Post Object ( [ID] => 37576 [post_author] => 12628 [post_date] => 2017-10-10 13:19:15 [post_date_gmt] => 2017-10-10 11:19:15 [post_content] =>

ID-100 Gran Oportunidad Casa Independiente espectacular en Puntallana   

 

·         5 Habitacion

·         3 baños

·        Estudio/Loft Completamente equipado

·        Completamente Amueblado

·         292/272 m²

·         3000 m² de terreno (aproximadamente)

·        Zona de Barbacoa

·        Terazza

·        Garaje

·        Jardin con Frutales

 

 

Casa situada en la población de Puntallana, Isla de La Palma, provincia de Tenerife, a unos 15km de la capital, y cerca del núcleo urbano de Puntallana, en C/ Los Perdomos 10 (nueva C/ Aguanea). Gran casa a cuatro vientos de 292 m2, en finca plana en terreno rustico de mas o menos  3.000m2 bien delimitado y conservado, con inmejorables vistas al mar y montaña, así como a la capital, desde donde se puede ver Tenerife y la Gomera, la construcción dispone de : Planta baja con garaje de 2 plazas y un anexo separado con baño con ducha y salón con cocina y salida al exterior, donde hay una barbacoa techada de 20m2 con mesa y bancos de obra, y jardín con frutales. En planta principal 4 habitaciones dobles, 2 baños y cocina “office” con un gran salón-comedor, todo exterior con vistas al mar, y salida a la terraza principal, todo amueblado y electrodomésticos básicos. En planta alta gran terraza con un estudio de unos 42m2, que dispone de baño y cocina y individual del resto. Todas las ventanas son de madera de estilo isleño y con rejas de hierro macizo por el exterior, construcción con materiales de primera calidad y acabados excelentes, Todo recién pintado y acondicionado para entrar a vivir desde el primer día, no puedes perderte esta oportunidad de visitarla, avisa con antelación a Lapalmacompraventa para generarle una visita.  Puntallana limita con Santa Cruz de La Palma por el Barranco Seco al sur, y con San Andrés y Sauces por el Barranco de La Galga al norte.

 

 

·        Amueblado

·        Armarios

·        Cocina Equipada

·        Cocina Office

·        Electrodomésticos

·        Garaje Privado

·        Gres Cerámica

·        Horno

·        Jardín Privado

·        Lavadero

·        Lavadora

·        Microondas

·        Nevera

·        Patio

·        Terraza

·        TV

·        Vistas a la montaña

 

LapalmaCompraVenta quiere brindarle una incomparable variedad de propiedades en las dos Provincias de las Islas Canarias España.  

      

Las ofertas incluyen hoteles, casas rurales, terrenos y solares para uso personal y uso turístico , villas, apartamentos, viviendas, casas con terreno, locales comerciales, fincas y solares edificables.

 

En nuestras islas tenemos el privilegio de tener  un excelente  clima durante todo el año y los precios en el mercado inmobiliario relativamente más económicos hacen la compra de una propiedad inmobiliaria en las Islas Canarias una gran oportunidad.

 

Ofrecemos alquileres de larga temporada, así como la venta de propiedades inmobiliarias directa de particulares, promotoras, con los mejores servicios para su asesoramiento y su tranquilidad.

 

Contáctenos para concertar una cita en una de nuestra oficina. Le espera un servicio inmobiliario profesional y una atención personalizada."

 

 

 

 

[post_title] => Casa en Camino Los Perdomos 10, Santa Lucia, Puntallana C.P. 38715 Isla La Palma Canarias España, Tenerife [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => casa-camino-los-perdomos-10-santa-lucia-puntallana-c-p-38715-isla-la-palma-canarias-espana-tenerife [to_ping] => [pinged] => [post_modified] => 2017-10-10 13:19:15 [post_modified_gmt] => 2017-10-10 11:19:15 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.tucasasivale.com/property/casa-camino-los-perdomos-10-santa-lucia-puntallana-c-p-38715-isla-la-palma-canarias-espana-tenerife/ [menu_order] => 0 [post_type] => property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [9] => WP_Post Object ( [ID] => 37237 [post_author] => 12320 [post_date] => 2017-09-22 14:15:41 [post_date_gmt] => 2017-09-22 12:15:41 [post_content] =>

Nice apartament, just in front of Atlantic Ocean; its in the 7th floor of a building with 8 floors. In less level you have a natural pool, with restaurants and services and a big public parking. In 7th floor you have the private parking, and a social and sport club, with tenis, squash, fronton, padel, big pool, bar, mini golf, a big gym with sauna, and a lot of activityes, like tenis classes, .... A nice place for living, and less than 5 minutes to the city. Temps between 15ºC and 35ºC over the year. Im selling it for buying another bigger one, in the same building, cause my family has grown.

[post_title] => Piso en Avenida marítima, edif jardin del mar, Tenerife [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => piso-avenida-maritima-edif-jardin-del-mar-tenerife [to_ping] => [pinged] => [post_modified] => 2017-09-22 14:15:41 [post_modified_gmt] => 2017-09-22 12:15:41 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.tucasasivale.com/property/piso-avenida-maritima-edif-jardin-del-mar-tenerife/ [menu_order] => 0 [post_type] => property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [10] => WP_Post Object ( [ID] => 34823 [post_author] => 10012 [post_date] => 2017-05-11 12:02:18 [post_date_gmt] => 2017-05-11 10:02:18 [post_content] =>

Magnifico chalet independiente de 240m2 construidos, 700m2 de parcela, 4 habitaciones, 3 cuartos de baño, gran piscina, zona ajardinada con estanque, calefacción por inducción, AA en todas las habitaciones, cochera techada para 2 coches, alarma perimetral, buhardilla, zona tranquila y bien comunicada, amueblada y con electrodomésticos para entrar a vivir

[post_title] => Casa en Monte real, Valencia [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => casa-monte-real-valencia [to_ping] => [pinged] => [post_modified] => 2017-05-11 12:02:18 [post_modified_gmt] => 2017-05-11 10:02:18 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.tucasasivale.com/property/casa-monte-real-valencia/ [menu_order] => 0 [post_type] => property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [11] => WP_Post Object ( [ID] => 28161 [post_author] => 13 [post_date] => 2017-01-04 18:48:47 [post_date_gmt] => 2017-01-04 16:48:47 [post_content] => [post_title] => Piso en avenida de moscú 1, Tenerife [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => piso-avenida-de-moscu-1-tenerife [to_ping] => [pinged] => [post_modified] => 2017-01-04 18:48:47 [post_modified_gmt] => 2017-01-04 16:48:47 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.tucasasivale.com/property/piso-avenida-de-moscu-1-tenerife/ [menu_order] => 0 [post_type] => property [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 12 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 65306 [post_author] => 34376 [post_date] => 2019-05-20 17:39:49 [post_date_gmt] => 2019-05-20 15:39:49 [post_content] => [post_title] => Local en ALFONSO XII, Sevilla [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => local-alfonso-xii-sevilla [to_ping] => [pinged] => [post_modified] => 2019-05-20 17:39:49 [post_modified_gmt] => 2019-05-20 15:39:49 [post_content_filtered] => [post_parent] => 0 [guid] => http://www.tucasasivale.com/property/local-alfonso-xii-sevilla/ [menu_order] => 0 [post_type] => property [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 1536 [max_num_pages] => 128 [max_num_comment_pages] => 0 [is_single] => [is_preview] => [is_page] => [is_archive] => 1 [is_date] => [is_year] => [is_month] => [is_day] => [is_time] => [is_author] => [is_category] => [is_tag] => [is_tax] => 1 [is_search] => [is_feed] => [is_comment_feed] => [is_trackback] => [is_home] => [is_404] => [is_embed] => [is_comments_popup] => [is_paged] => [is_admin] => [is_attachment] => [is_singular] => [is_robots] => [is_posts_page] => [is_post_type_archive] => [query_vars_hash:WP_Query:private] => bdadb5b8daf0eb346d485088e6b09486 [query_vars_changed:WP_Query:private] => [thumbnails_cached] => [updated_term_meta_cache] => [updated_comment_meta_cache] => [stopwords:WP_Query:private] => [compat_fields:WP_Query:private] => Array ( [0] => query_vars_hash [1] => query_vars_changed ) [compat_methods:WP_Query:private] => Array ( [0] => init_query_flags [1] => parse_tax_query ) )