House and Credit

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY weight, e.nid, delta' at line 7 query: SELECT filepath, t.name, t.tid, e.nid, fid, weight, delta FROM `content_type_el_comun` e inner join content_field_estancia_imagenes i using(nid) inner join files f on fid=field_estancia_imagenes_fid inner join term_data t on tid=field_el_comun_denominacion_value WHERE field_el_comun_inm_nid= ORDER BY weight, e.nid, delta in /home/housecredi/domains/houseandcredit.es/public_html/sites/all/modules/inmueble/inmueble_functions_2.php on line 177.
warning: implode(): Invalid arguments passed in /home/housecredi/domains/houseandcredit.es/public_html/modules/node/node.module on line 728.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /home/housecredi/domains/houseandcredit.es/public_html/modules/node/node.module on line 755.
warning: implode(): Invalid arguments passed in /home/housecredi/domains/houseandcredit.es/public_html/modules/node/node.module on line 728.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /home/housecredi/domains/houseandcredit.es/public_html/modules/node/node.module on line 755.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND v.nid!= 26449 AND v.nid IN(768918, 774928, 775383, 775457, 939949, 943145, ' at line 10 query: SELECT DISTINCT v.`nid` , title, IF(`field_inm_barrio_nid` = 9,1,0) barrio FROM `content_type_inmueble` f INNER JOIN content_type_via via ON f.field_inm_via_nid=via.nid INNER JOIN content_type_inmueble1 i ON field_inm1_finca_nid=f.nid INNER JOIN content_type_venta v ON field_venta_inmueble1_nid=i.nid INNER JOIN node n ON n.nid=f.nid WHERE field_via_muni_nid = AND v.nid!= 26449 AND v.nid IN(768918, 774928, 775383, 775457, 939949, 943145, 998334, 1074883, 1123379, 1123380, 1123381, 1123382, 1123383, 1123384, 1123385, 1123386, 1123387, 1123388, 1123389, 1154700, 1738396, 1743317, 1781656, 1788537, 1790580, 1791131, 1795506) AND field_inm1_tipo_inmueble_value NOT IN (6,7) AND field_venta_pr_estimado_value BETWEEN '157250' AND '212750' ORDER BY barrio DESC in /home/housecredi/domains/houseandcredit.es/public_html/sites/all/modules/inmueble/inmueble_functions_2.php on line 146.
warning: Missing argument 1 for plano_inmueble(), called in /home/housecredi/domains/houseandcredit.es/public_html/includes/common.inc(1696) : eval()'d code on line 2 and defined in /home/housecredi/domains/houseandcredit.es/public_html/sites/all/modules/inmueble/inmueble_functions_2.php on line 906.
warning: implode(): Invalid arguments passed in /home/housecredi/domains/houseandcredit.es/public_html/modules/node/node.module on line 728.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /home/housecredi/domains/houseandcredit.es/public_html/modules/node/node.module on line 755.
warning: implode(): Invalid arguments passed in /home/housecredi/domains/houseandcredit.es/public_html/modules/node/node.module on line 728.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /home/housecredi/domains/houseandcredit.es/public_html/modules/node/node.module on line 755.
warning: implode(): Invalid arguments passed in /home/housecredi/domains/houseandcredit.es/public_html/modules/node/node.module on line 728.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /home/housecredi/domains/houseandcredit.es/public_html/modules/node/node.module on line 755.
warning: implode(): Invalid arguments passed in /home/housecredi/domains/houseandcredit.es/public_html/modules/node/node.module on line 728.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /home/housecredi/domains/houseandcredit.es/public_html/modules/node/node.module on line 755.
warning: implode(): Invalid arguments passed in /home/housecredi/domains/houseandcredit.es/public_html/modules/node/node.module on line 728.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /home/housecredi/domains/houseandcredit.es/public_html/modules/node/node.module on line 755.
warning: implode(): Invalid arguments passed in /home/housecredi/domains/houseandcredit.es/public_html/modules/node/node.module on line 728.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /home/housecredi/domains/houseandcredit.es/public_html/modules/node/node.module on line 755.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') && field_cert_energ_calificacion_value is not null ORDER BY field_cert_ener' at line 2 query: SELECT field_cert_energ_calificacion_value c FROM content_type_certificado_energetico WHERE field_cert_energ_nodo_asociado_nid IN (26499, ) && field_cert_energ_calificacion_value is not null ORDER BY field_cert_energ_fecha_value desc LIMIT 0,1 in /home/housecredi/domains/houseandcredit.es/public_html/sites/all/modules/inmueble/inmueble_functions_2.php on line 887.

-

Referencia: O 496
En venta

¿Te gusta? Propón un precio.

Deja tus datos y te llamamos.

¿No te convence, buscas otra cosa? Dinos lo que buscas.

Compartir en facebook

**Datos relativos a la finca**

Antigüedad	53 años
Plantas en el edificio	9
Portero físico	Sí
Ascensor	Sí
Urbanización	No
Piscina	No
Zonas deportivas	No

**Datos relativos al inmueble**

Tipo de inmueble	fotocasa_houseType: Tipo de vivienda no definido-> :
Altura	idealista_floor: Piso no definido->
Plantas
Exterior	No
Orientación
Metros útiles	idealista_livingAreaSqm Superficie adoptada útil->0m²
Metros construidos	idealista_underRoofSqm Superficie adoptada construida->0m²

**Datos relativos a la oferta**

Dormitorios	3
Baños	2
Terraza abierta	1
Terraza cerrada	1
Trastero	No
Plaza de garaje	0
Tendedero	No
Otras estancias	No
Estado	Reforma de lujo
Calificación energética
Calefacción	Central
Climatización	Split
Puerta principal	Blindada
Puerta interiores	Cerezo
Ventanas	Correderas Aluminio Blanco con Climalit
Suelos	Parquet
Paredes	Liso
Techos	Liso
Armarios empotrados	3
Molduras de escayola	Sí
Cuota de comunidad	98€

Los precios de venta no incluyen honorarios de intermediación inmobiliaria del comprador (3% precio final de venta + IVA), impuestos que gravan la vivienda (ITP y IVA), ni gastos notariales y registrales

Próximo a Metro / Renfe, Muy Luminoso, Amplias Estancias, Reforma Primeras Calidades, +Solicite Estudio Financiero Gratuito y Sin Compromiso+

Otros inmuebles recomendados

Información no disponible.


Oficina Madrid C/ Poeta Joan Maragall, 9, Esc. Sur, 3ºIzq 28020 Madrid Tfno: 91 112 45 00		Oficina Alcorcón C/ Fuenlabrada, 39 - LOCAL 3 28922 Alcorcón (Madrid) Tfno: 91 644 92 55
Aviso legal