SELECT wpxv_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpxv_postmeta price_meta2 WHERE price_meta2.post_id=wpxv_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-09-09:2026-09-09' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpxv_postmeta price_meta3 WHERE price_meta3.post_id=wpxv_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpxv_posts INNER JOIN wpxv_postmeta ON ( wpxv_posts.ID = wpxv_postmeta.post_id )
WHERE 1=1 AND (
( wpxv_postmeta.meta_key = 'accommodation_location_post_id' AND wpxv_postmeta.meta_value IN ('916') )
) AND wpxv_posts.post_type = 'accommodation' AND ((wpxv_posts.post_status = 'publish'))
GROUP BY wpxv_posts.ID HAVING 1=1
ORDER BY wpxv_posts.post_title ASC
101 – Deluxe Pool Level Apartment
Apartment • 1 BR • 1 BA • Sleeps 4 • 280 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
102 – Pool Level Condo
Condo • 1 BR • 1 BA • Sleeps 2 • 171 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
103 – Pool Level Apartment
Apartment • 1 BR • 1 BA • Sleeps 4 • 250 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
104 – Pool Level Apartment
Apartment • 1 BR • 1 BA • Sleeps 4 • 250 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
105 – Pool Level Apartment
Apartment • 1 BR • 1 BA • Sleeps 4 • 250 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
201 – Studio Seaview
Studio • 1 BR • 1 BA • Sleeps 3 • 109 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
202 – Studio Seaview
Studio • 1 BR • 1 BA • Sleeps 3 • 109 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
203 – Studio Seaview
Studio • 1 BR • 1 BA • Sleeps 3 • 109 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
204 – Studio Seaview
Studio • 1 BR • 1 BA • Sleeps 3 • 109 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
205 – Studio Seaview
Studio • 1 BR • 1 BA • Sleeps 3 • 109 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
206 – Studio Seaview
Studio • 1 BR • 1 BA • Sleeps 3 • 109 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
207 – Studio Side Seaview
Studio • 1 BR • 1 BA • Sleeps 3 • 109 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
208 – Studio Side Seaview
Studio • 1 BR • 1 BA • Sleeps 3 • 109 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
209 – Studio Side Seaview
Studio • 1 BR • 1 BA • Sleeps 3 • 109 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
210 – Studio Side Seaview
Studio • 1 BR • 1 BA • Sleeps 3 • 109 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
211 – Studio Side Seaview
Studio • 1 BR • 1 BA • Sleeps 3 • 109 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
212 – Studio Side Seaview
Studio • 1 BR • 1 BA • Sleeps 3 • 109 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
214 – Deluxe Suite Beach Front
Condo • 1 BR • 1 BA • Sleeps 2 • 348 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
215 – Deluxe Suite Beach Front
Condo • 1 BR • 1 BA • Sleeps 2 • 348 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
301 – Wabisabi Seaview Apartment – Type F
Condo • 1 BR • 1 BA • Sleeps 2 • 171 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
302 – Wabisabi Seaview Apartment – Type E
Condo • 1 BR • 1 BA • Sleeps 2 • 171 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
303 – Wabisabi Seaview Apartment – Type D
Condo • 1 BR • 1 BA • Sleeps 2 • 171 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
304 – Wabisabi Seaview Apartment – Type E
Condo • 1 BR • 1 BA • Sleeps 2 • 171 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
305 – Wabisabi Seaview Apartment – Type D
Condo • 1 BR • 1 BA • Sleeps 3 • 171 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
306 – Wabisabi Suite Pool & Seaview – Type G
Suite • 1 BR • 1 BA • Sleeps 3 • 214 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
307 – Suite Side Seaview – Type G
Suite • 1 BR • 1 BA • Sleeps 3 • 197 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
308 – Side seaview Apartment – Type D
Condo • 1 BR • 1 BA • Sleeps 3 • 171 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
309 – Side Seaview Apartment – Type E
Condo • 1 BR • 1 BA • Sleeps 3 • 171 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
310 – Side seaview Apartment – Type D
Condo • 1 BR • 1 BA • Sleeps 3 • 170 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
311 – Side Seaview Apartment – Type E
Condo • 1 BR • 1 BA • Sleeps 3 • 171 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
312 – Side Seaview Apartment – Type F
Condo • 1 BR • 1 BA • Sleeps 3 • 171 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
313 – Beach Front Suite
Condo • 1 BR • 1 BA • Sleeps 2 • 181 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
406 – Suite Pool & Seaview – Type G
Suite • 1 BR • 1 BA • Sleeps 3 • 214 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
506 – Suite Pool & Seaview – Type G
Suite • 1 BR • 1 BA • Sleeps 3 • 214 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
601 – Pool & Seaview Apartment – Type F
Condo • 1 BR • 1 BA • Sleeps 2 • 171 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
602 – Pool & Seaview Apartment – Type E
Condo • 1 BR • 1 BA • Sleeps 2 • 171 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
603 – Pool & Seaview Apartment – Type D
Condo • 1 BR • 1 BA • Sleeps 2 • 171 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
604 – Pool & Seaview Apartment – Type E
Condo • 1 BR • 1 BA • Sleeps 2 • 171 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
605 – Pool & Seaview Apartment – Type D
Condo • 1 BR • 1 BA • Sleeps 2 • 560 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
606 – Suite Pool & Seaview – Level 6
Suite • 1 BR • 1 BA • Sleeps 3 • 214 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
A501/502 – Mainbuilding Apartment – seaview
Apartment • 2 BR • 2 BA • Sleeps 4 • 312 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
A503 – Studio Seaview in Mainbuilding
Studio • 1 BR • 1 BA • Sleeps 2 • 142 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.
A504 – Studio Seaview in Mainbuilding
Studio • 1 BR • 1 BA • Sleeps 2 • 142 Sq. Ft.
From
EGP
Refundable damage deposit. A damage deposit of 10000 EGP is required on Arrival. This will be collected by credit card (or cash) . you should be reimbursed on check-out. Your deposit will be refunded in full via credit card (or cash) , subject to an inspection of the property.