Inmobiliaria Rebassa,

we are a team of Real Estate Brokers backed by our professionalism and the results obtained over the years.

In our Real Estate Agency, we offer at all times a personalized treatment to our clients, allowing us to be more efficient in the search for the properties they want.

In recent years we have specialized in Hotel Sector Investments, without neglecting our roots in the real estate world.

Inmobiliaria Rebassa


SELECT yourRef, propNameDe, propPrice, propBathroom, propBedSingle, propBedDouble, propHouseM2, propLandM2, propJardinM2, propBalconM2, propTerrazaM2, medium, propType, propParking, propGaraje, id_unico, propStatus FROM propiedades INNER JOIN imagenes_propiedades ON(imagenes_propiedades.ref = propiedades.id_unico) WHERE 1 = 1 AND imagenes_propiedades.orden = '1' GROUP BY yourRef ORDER BY fechaPublicacion DESC limit 0, 9