Please contact us when you have a property for sale or rent. We have many clients in our books. Favor de nos contactar, quando entende vender ou arrendar a sua propriedade.Smile

 
header_1.jpg

Welcome to Rentavila

Property Listings
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 \'TYPE=MyISAM\' at line 13 SQL=CREATE TABLE jos_hp_temp (\n id INT(11) NOT NULL, \nname MEDIUMTEXT NOT NULL, \ntype MEDIUMTEXT NOT NULL, \nprice MEDIUMTEXT NOT NULL, \nreference MEDIUMTEXT NOT NULL, \ncontracttype MEDIUMTEXT NOT NULL, \nmarketstatus MEDIUMTEXT NOT NULL, \nbedrooms MEDIUMTEXT NOT NULL, \nbathrooms MEDIUMTEXT NOT NULL, \nFacilities SET(\'Garage\', \'Garden\', \'Air Conditioning\', \'Pool\', \'Central Heating\', \'Patio\', \'Terrace\') NOT NULL, \nPRIMARY KEY (id)\n) TYPE=MyISAM ;Table \'rentavil_joom1.jos_hp_temp\' doesn\'t exist SQL=INSERT INTO jos_hp_temp (`id`, `name`, `type`, `price`) \n SELECT p.id, p.name, p.type, p.price\n FROM (jos_hp_properties AS p, jos_hp_companies AS c)\n LEFT JOIN jos_hp_prop_types AS t ON p.type = t.id\n LEFT JOIN jos_hp_agents AS a ON p.agent = a.id\n WHERE p.published=\'1\' AND p.approved=\'1\' AND t.published=\'1\'\n AND a.company=c.id\n AND (publish_up = \'0000-00-00 00:00:00\' OR publish_up <= NOW())\n AND (publish_down = \'0000-00-00 00:00:00\' OR publish_down >= NOW())Table \'rentavil_joom1.jos_hp_temp\' doesn\'t exist SQL=DELETE FROM jos_hp_temp WHERE marketstatus <> \'Sold\'
Main > Advanced Search

Your search did not match any property. Please try again.

Try again

BUY,compra,comprar,SELL,venda,vender, RENT,aluga,alugar, VILLA,vila, HOUSE,casa, APARTMENT,apartamento, RESTAURANT, HOTEL, OFFICE, LAND PLOT,terreno, BUSINESS, PORTUGAL, CASCAIS, LISBON, ESTORIL, ALGARVE, PORTIMAO, LAGOS
Visitors: 1286024
This month 's Top 5
 76 % United States (564)
 16 % Russian Federation (118)
 2 % Portugal (14)
 < 1.0 % Netherlands (7)
 < 1.0 % France (6)