BRITANNIA BAY
Western Cape , South Africa
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:2026-11-06:2028-11-06' 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 ('6267') )
) 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
SPONSORED
Weskus Kaya
10 Perlemoen CrescenBritannia Bay, Saint Helena Bay, 7538, Western Cape
From
$
Escape to Weskus Kaya, a spacious 3-bedroom, 4-bathroom self-catering holiday home in beautiful Britannia Bay on the Cape West Coast. Sleeping up to 11 guests, including a maximum of 7 adults, this family-friendly coastal retreat is approximately 175 metres from the beach and features an indoor braai, fully equipped kitchen, enclosed garden, free fibre Wi-Fi, backup power and secure parking. Perfect for family holidays, group getaways and relaxing seaside escapes near St Helena Bay and Paternoster.
Unfortunately no tours were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.