Greeka.com: Greece Travel, Greek Islands, Hotels

0-30Euros Spetses Traditional House


Choose a destination in Greece


Spetses Traditional House, Greece: 0-30Euros Traditional House in Spetses

Discover our section of 0-30Euros Traditional House on Spetses Greece

This section proposes a large choice of Spetses Traditional House from 0-30Euros
All the Traditional House of Spetses are well presented with many pictures, descriptions and rates. The Traditional House on Spetses have direct links to their websites or a booking/availabilities form is proposed in the presentation.
Many of the Spetses Traditional House also proposes a Virtual Animation with 360 degrees pictures.
You can also choose to see Traditional House in with other prices as well as other hotels and accommodations.		  
Accommodations in Spetses
Hotels (1)
Apartments (3)
Maisonettes 0
Studios (2)
Suites (2)
Use the Hotel Search Engine with specific criteria.
Select available categories: 0-30 € : 31-60 € : 61-100 € : 101-1000 €
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 b.greeka' at line 6

SELECT b.hotel_id 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 '30') OR (b.price_from>='0' AND b.price_from<='30') OR (b.price_to BETWEEN '0' AND '30') OR (b.price_to>='0' AND b.price_to<='30') OR (b.price_from<='0' AND b.price_to>='30') ) AND b.price_from NOT LIKE 0 AND b.price_to NOT LIKE 0 AND b.confirm_hide_all NOT LIKE 'Y' ORDER BY b.price_from , hotel_name