Category:   
Keywords:   
Country:   
Province:   
Region:   
Town:   
Suburb:   
Music - clubs & pubs

Music - clubs & pubs

 
 
 
 
 
 

What are you looking for today?

For advanced searches (price, amenities, etc) please click here.
Category:   
Keywords:   
Country:   
Province:   
Region:   
Town:   
Suburb:   

Special offers

The longer you stay, the less you pay.
Discount %
15
Town: Franschhoek
Book your stay at Rickety Bridge Winery and receive 15% off your stay. Don't forget to inquire about our amazing...
The Carraighs
Discount %
10
Discount of 10% for stays of 2 days or more at The Carraighs, The Crags, Plettenberg Bay. Close...
Winter Discount
Discount %
20
Town: Cape Town
Sea Cottage House is a comfortably and elegantly furnished, fully equipped, holiday home, just outside the quaint, village...
2 day break @ A Hilltop Country Retreat
Discount %
20
Town: Swellendam
Need a break away from the city life? We have the perfect solution..
Quay West holiday home Velddrif Winter Special
Discount %
20
Town: Velddrif
Winter Madness at Quay West holiday home in “Bokkom Republic” Velddrif, stay 3 nights and get 60% discount off first...
Your winter break
Discount %
50
If you are into the outdoors, surfing , hiking or golf look no further than Cape St Francis Resort. Our...
De Hoop 50% off Winter Special
Discount %
50
Town: Bredasdorp
The De Hoop Reserve is situated just 3 hours’ drive from Cape Town on the world renowned Garden and...
Stay 3 nights, pay for 2 at Val du Charron
Discount %
33
Town: Wellington
Take a trip to experience the best of Wellington Winelands and sip on the fruits of the valley. Everything great...
3 for 2 at La Galiniere
Discount %
33
Town: Franschhoek
Stay for 3 nights at La Galiniere Guest Cottages between April and September and pay for only 2.
Winter Special
Discount %
20
Town: Cape Town
20% off! Affordable Luxury Self-Catering, secure parking, centrally located with easy access to the city and wine lands.
Overberg Explore - 10% off 4 nights or more
Discount %
10
Town: Gansbaai
10% off luxury oceanfront whale coast villa when you stay 4 nights or more this autumn and winter. Explore the...
get newsletters

Latest directory entries

d.aa stairs.jpg
Category: Self-catering
Town: Gordons Bay
La Vue Parfaite - the perfect view ...
Town: George
Your home away from home
Hermanus FynArts
Town: Hermanus
The line-up for Hermanus Fynarts 2016 is elegant, eclectic, extensive...
Kumbagana Game lodge
Category: Self-catering
Town: Magaliesburg
Thank you for your inquiry. See detailed sum below: ...
French doors leading out to the courtyard
Category: Self-catering
Town: Hermanus
Upmarket, centrally located cottage in Hermanus, Western Cape, South Africa....
Hermitage Huisies
Category: Self-catering
Town: Swellendam
Nestled in the picturesque Hermitage Valley, and situated just...
The Links Corporate Guest House
Town: Pretoria
A links is the oldest style of golf course, first...
Villa the Cherry
Category: Self-catering
Town: Gansbaai
Villa the Cherry is a luxury seafront retreat on a...
Affordable and comfortable accommodation in a quiet suburb yet close...
Category: Self-catering
Town: Cape Town
AA highly recommended (4*), in upmarket Constantia, 2 self-catering safe...
defined variable: public_menu_id on line 93 in file /usr/www/users/capeixwyks/templates/jreviews_overrides/views/themes/capeinfo/modules/advanced_search.thtml

Database Queries (12)

  1. SELECT id, language FROM sdxbv_menu WHERE link LIKE "%com_comprofiler&view=userprofile" AND published = 1 AND type = "component"
  2. SELECT id, language FROM sdxbv_menu WHERE link LIKE "%com_comprofiler&view=registers" AND published = 1 AND type = "component"
  3. SELECT CriteriaRating.criteria_id AS `CriteriaRating.criteria_id`, CriteriaRating.title AS `CriteriaRating.title`, CriteriaRating.required AS `CriteriaRating.required`, CriteriaRating.weight AS `CriteriaRating.weight`, CriteriaRating.description AS `CriteriaRating.description`, CriteriaRating.listing_type_id AS `CriteriaRating.listing_type_id`, CriteriaRating.ordering AS `CriteriaRating.ordering`, ListingType.state AS `CriteriaRating.listing_type_state` FROM sdxbv_jreviews_criteria_ratings AS CriteriaRating LEFT JOIN sdxbv_jreviews_criteria AS ListingType ON ListingType.id = CriteriaRating.listing_type_id WHERE 1 = 1 AND ( CriteriaRating.listing_type_id = 2 )
  4. SELECT count(DISTINCT groupid) FROM sdxbv_jreviews_criteria WHERE groupid != ''
  5. SELECT Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.groupid AS `Criteria.group_id`, Criteria.state AS `Criteria.state`, Criteria.search AS `Criteria.search`, Criteria.config AS `ListingType.config` FROM sdxbv_jreviews_criteria AS Criteria WHERE 1 = 1 AND ( Criteria.id IN (2) )
  6. SELECT groupid FROM sdxbv_jreviews_groups WHERE groupid IN (9,2,1) AND type = 'content'
  7. SELECT Field.fieldid, Field.title AS text, Field.name AS value, Field.access_view AS access FROM sdxbv_jreviews_fields AS Field WHERE Field.location = 'content' AND Field.listsort = 1 AND Field.groupid IN (1,2,9)
  8. SELECT Field.fieldid AS `Field.fieldid`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.type AS `Field.type`, Field.required AS `Field.required`, Field.access AS `Field.access`, Field.access_view AS `Field.access_view`, Field.options AS `Field.options`, Field.showtitle AS `Field.showtitle`, Field.description AS `Field.description`, Field.groupid AS `Field.groupid`, Field.location AS `Field.location`, Field.size AS `Field.size`, Field.maxlength AS `Field.maxlength`, Field.cols AS `Field.cols`, Field.rows AS `Field.rows`, Field.contentview AS `Field.contentview`, Field.ordering AS `Field.ordering`, Field.listview AS `Field.listview`, Field.compareview AS `Field.compareview`, Field.listsort AS `Field.listsort`, Field.search AS `Field.search`, Field.published AS `Field.published`, Field.control_field AS `Field.control_field`, Field.control_value AS `Field.control_value`, Field.fieldid AS `Field.field_id` FROM sdxbv_jreviews_fields AS `Field` WHERE 1 = 1 AND ( Field.name = "jr_startdate" )
  9. SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Field.featured AS `Listing.featured`, JreviewsCategory.criteriaid AS `Listing.listing_type_id`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.slug`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, Claim.approved AS `Claim.approved`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Totals.media_count AS `Listing.media_count`, Totals.video_count AS `Listing.video_count`, Totals.photo_count AS `Listing.photo_count`, Totals.audio_count AS `Listing.audio_count`, Totals.attachment_count AS `Listing.attachment_count`, (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`, (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`, (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`, (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`, (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`, Totals.media_count_user AS `Listing.media_count_user`, Totals.video_count_user AS `Listing.video_count_user`, Totals.photo_count_user AS `Listing.photo_count_user`, Totals.audio_count_user AS `Listing.audio_count_user`, Totals.attachment_count_user AS `Listing.attachment_count_user`, Field.jr_startdate AS `Field.jr_startdate`, JreviewsCategory.marker_icon AS `Geomaps.marker_icon`, Field.jr_latitude AS `Geomaps.lat`, Field.jr_longitude AS `Geomaps.lon` FROM sdxbv_jreviews_content AS Field LEFT JOIN sdxbv_content AS Listing ON Field.contentid = Listing.id LEFT JOIN sdxbv_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN sdxbv_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' LEFT JOIN sdxbv_categories AS Category ON Category.id = Listing.catid AND Category.extension = 'com_content' LEFT JOIN sdxbv_jreviews_directories AS Directory ON Directory.id = JreviewsCategory.dirid LEFT JOIN sdxbv_users AS User ON User.id = Listing.created_by LEFT JOIN sdxbv_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.user_id = Listing.created_by AND Claim.approved = 1 WHERE 1 = 1 AND ( Listing.catid IN (191) AND Listing.state = 1 AND Listing.access IN ( 1) AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2016-06-12 22:00:00" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2016-06-11 22:00:00" ) ) ORDER BY Field.jr_startdate ASC,Field.contentid DESC LIMIT 10
  10. SELECT Directory.id AS `Directory.dir_id`, Directory.desc AS `Directory.title`, Directory.title AS `Directory.name`, Directory.tmpl_suffix AS `Directory.tmpl_suffix`, Directory.title AS `Directory.slug` FROM sdxbv_jreviews_directories AS Directory WHERE 1 = 1 AND ( Directory.id = 2 )
  11. SELECT Category.id AS value,Category.level AS level,Category.parent_id AS parent_id,JreviewsCategory.criteriaid,CONCAT(REPEAT('- ', IF(Category.level>0,Category.level - 1,1)), Category.title) AS text FROM sdxbv_categories AS Category RIGHT JOIN sdxbv_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Category.id AND JreviewsCategory.`option` = 'com_content' WHERE Category.published = 1 AND Category.access IN ( 1 ) AND Category.level > 0 AND Category.extension = 'com_content' AND (Category.id IN ( SELECT id FROM sdxbv_jreviews_categories WHERE `option` = "com_content" AND dirid IN (2) )) ORDER BY Category.lft
  12. SELECT Category.id AS value,Category.level AS level,Category.parent_id AS parent_id,JreviewsCategory.criteriaid,CONCAT(REPEAT('- ', IF(Category.level>0,Category.level - 1,1)), Category.title) AS text FROM sdxbv_categories AS Category RIGHT JOIN sdxbv_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Category.id AND JreviewsCategory.`option` = 'com_content' WHERE Category.published = 1 AND Category.access IN ( 1 ) AND Category.level > 0 AND Category.extension = 'com_content' AND (Category.id IN ( SELECT id FROM sdxbv_jreviews_categories WHERE `option` = "com_content" AND dirid IN (1) )) ORDER BY Category.lft