Greeka.com: Greece Travel, Greek Islands, Hotels

Spetses Traditional House Prices


Choose a destination in Greece



Spetses Traditional House Prices, Greece: Traditional House on Spetses, Greece, Saronic
Discover our section of Traditional House on Spetses sorted by prices.

Greeka proposes many Spetses Traditional House sorted by prices. The Traditional House have many photos, descriptions and rates and for some, a virtual animation ia also offered.
The Traditional House have links to their personal webpages or a booking form and avaiulablities can be found in our presentations. To find the information about Traditional House just click on the picture.

You can also choose to see the Spetses Traditional House organised by category, by location, by facilities, by villages and beaches. resorts. You can also see other type of hotels and accommodations on Spetses, Saronic, Greece.
 
Accommodations in Spetses
Hotels
Apartments
Maisonettes
Rooms
Studios
Suites
Traditional Houses


Search for accommodations in Spetses





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 a.hotel_id=b.hotel_id AND b.greeka_site NOT LIKE '' AND

SELECT b.* FROM hotel b , hotel_propertytype a WHERE a.type_id= AND a.hotel_id=b.hotel_id AND b.greeka_site NOT LIKE '' AND b.greeka_site NOT LIKE 'BAN' AND b.killed_english NOT LIKE 'Y' AND b.published=1 AND b.island_id=28 AND b.hotel_type LIKE '%greeka%' AND ( (b.price_from BETWEEN '0' AND '30euro') OR (b.price_from>='0' AND b.price_from<='30euro') OR (b.price_to BETWEEN '0' AND '30euro') OR (b.price_to>='0' AND b.price_to<='30euro') OR (b.price_from<='0' AND b.price_to>='30euro') ) AND b.confirm_hide_all NOT LIKE 'Y' ORDER BY b.price_from , hotel_name