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-10-23:2028-10-23' 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 ('6161') )
) 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
HOT PROPERTY
25 on First
Shelley Point, St Helena Bay
From
$
Discover this spacious 6-bedroom self-catering holiday villa in the secure Shelley Point Golf & Security Estate, St Helena Bay. Perfect for family holidays and group getaways, this beautiful coastal retreat features an 8-metre swimming pool, KolKol wood-fired hot tub, entertainment deck, braai facilities, two fully equipped kitchens and stunning ocean views. Sleeps up to 10 adults and 6 children, or 12 adults without children. Smaller groups welcome.
HOT PROPERTY
9.onthebeach
9, 7th Street Golden Mile Boulevard, Shelley Point Estate, St Helena Bay, 7282, Western Cape
From
$
Experience beachfront luxury at 9 on the Beach, an exclusive 4-bedroom, 4-bathroom villa accommodating up to 9 guests. Situated within the prestigious Shelley Point Golf Estate, this beautiful holiday home offers breathtaking ocean views, a private boardwalk to the beach, a heated swimming pool and elegant indoor and outdoor living spaces. Perfect for unforgettable family holidays and relaxing coastal getaways.
Unfortunately no tours were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.