SELECT SQL_CALC_FOUND_ROWS 9J5auxg3_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM 9J5auxg3_postmeta price_meta2 WHERE price_meta2.post_id=9J5auxg3_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2023-11-30:2025-11-30' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM 9J5auxg3_postmeta price_meta3 WHERE price_meta3.post_id=9J5auxg3_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM 9J5auxg3_posts LEFT JOIN 9J5auxg3_term_relationships ON (9J5auxg3_posts.ID = 9J5auxg3_term_relationships.object_id) INNER JOIN 9J5auxg3_postmeta ON ( 9J5auxg3_posts.ID = 9J5auxg3_postmeta.post_id )
WHERE 1=1 AND (
9J5auxg3_term_relationships.term_taxonomy_id IN (77)
) AND (
( 9J5auxg3_postmeta.meta_key = 'accommodation_is_featured' AND CAST(9J5auxg3_postmeta.meta_value AS SIGNED) = '1' )
) AND 9J5auxg3_posts.post_type = 'accommodation' AND ((9J5auxg3_posts.post_status = 'publish'))
GROUP BY 9J5auxg3_posts.ID HAVING 1=1
ORDER BY 9J5auxg3_posts.ID ASC
LIMIT 0, 12
Holiday Rental Greece fulfil strict selection criteria. Each accommodation is chosen individually and inclusion cannot be bought.
Detailed Descriptions
To give you an accurate impression of the accomodation, we endeavor to publish transparent, balanced and precise hotel and villa descriptions.
Exclusive Knowledge
We’ve done our research. Our scouts are always busy finding out more about our hotels, the surroundings and activities on offer nearby.
Passionate Service
Holiday Rentals Greece team will cater to your special requests. We offer expert and passionate advice for finding the right accomodation.
Best Price Guarantee
We offer the best hotels and villas at the best prices. No secret fees.
Secure Booking
Holiday Rental Greece reservation system is secure and your personal information is encrypted. We work to high standards and guarantee your privacy.
Benefits for Owners
We provide a cost-effective model and a personalised account management service to help you optimise your revenue.
Any Questions?
Call us on +30 2841027504 or +30 6948304378 - 79 for individual, tailored advice for your perfect stay or send us a message with your hotel booking query.
12 
5 
5
