SELECT wpbu_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpbu_postmeta price_meta2 WHERE price_meta2.post_id=wpbu_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-09-17:2026-09-17' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpbu_postmeta price_meta3 WHERE price_meta3.post_id=wpbu_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpbu_posts INNER JOIN wpbu_postmeta ON ( wpbu_posts.ID = wpbu_postmeta.post_id )
WHERE 1=1 AND (
( wpbu_postmeta.meta_key = 'accommodation_location_post_id' AND wpbu_postmeta.meta_value IN ('4711') )
) AND wpbu_posts.post_type = 'accommodation' AND ((wpbu_posts.post_status = 'publish'))
GROUP BY wpbu_posts.ID HAVING 1=1
ORDER BY wpbu_posts.post_title ASC
La Cuzan Beach House
Plettenburg Bay , Cape Town
From
$
6 EN SUITE BEDROOMS (SLEEPS 14) Ultra-modern, luxury 2-level house approx. 400m to blue flag Lookout beach with breath-taking views of the ever changing Tsitsikamma Mountains, Keurbooms Lagoon Bahia Formosa (or beautiful bay) and Lookout Beach. On street level is a double inter-leading garage opening into expansive glass enclosed living room with lounge (fire-place), kitchen with inter-leading scullery, dining area and TV lounge (fire-place). Living area leads out onto covered verandah with entertainment/braai facilities enjoying views views views. Stairs leading down onto pool deck and well maintained gardens. Also on this top level is the main en suite bedroom and a separate guest toilet. Downstairs are bedrooms 2, 3, 4 and 5, a TV lounge and laundry. From this level you have direct access onto the pool deck and gardens. Leading down from the pool deck is bedroom 6.
Sandy Sunrise Beach House
Plettenburg Bay
From
$
6 BEDROOMS / 4 BATHROOMS (SLEEPS 12)
Spacious, fenced-in double storey house with a pool enjoying sea, lagoon and mountain views.
LOCATION: Upper town, approx 10 minute walk from town centre and approx 15 minute walk from Lookout Beach.
VIEW: Sea, Mountains and Lagoon.
Unfortunately no tours were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.