here
Thursday, 22 December 2016
Spacer

The Irish Riviera arrow Book Now arrow Accommodation
Main Menu
The Irish Riviera
Resort Towns
We are here !
Lots to do and see
Where to Stay
Where to eat
Book Now
           -:-
Photo Gallery
Just for fun
           -:-
Search site
About us
Contact Us
Recommended
Amazing views
* The Penthouse - 2 bedrooms
2006_0709Image0048.JPG
* 3 Clifton - 5 Star - 4 bedroom luxury seafront house
 


Property Listing
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 9 SQL=CREATE TABLE jos_hp_temp (\n id INT(11) NOT NULL, \nname MEDIUMTEXT NOT NULL, \ntype MEDIUMTEXT NOT NULL, \nsuburb MEDIUMTEXT NOT NULL, \nSCMax MEDIUMTEXT NOT NULL, \nNo_Bedrooms MEDIUMTEXT NOT NULL, \nPRIMARY KEY (id)\n) TYPE=MyISAM ;Table \'irish_joomla.jos_hp_temp\' doesn\'t exist SQL=INSERT INTO jos_hp_temp (`id`, `name`, `type`, `suburb`) \n SELECT p.id, p.name, p.type, p.suburb\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 \'irish_joomla.jos_hp_temp\' doesn\'t exist SQL=DELETE FROM jos_hp_temp WHERE type <> \'2\'Table \'irish_joomla.jos_hp_temp\' doesn\'t exist SQL=DELETE FROM jos_hp_temp WHERE suburb NOT LIKE \'%Cobh%\'Table \'irish_joomla.jos_hp_temp\' doesn\'t exist SQL=DELETE FROM jos_hp_temp WHERE No_Bedrooms = \'\'Table \'irish_joomla.jos_hp_temp\' doesn\'t exist SQL=DELETE FROM jos_hp_temp WHERE No_Bedrooms < 3
Main > Advanced Search

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

Try again