Gauteng Johannesburg

Johannesburg

Filters Move Map

Adding markers to the map ...

4 results - showing 1 - 4

Ordering

Details

Soweto

0 0 0 0

Infused with the history of the struggle against apartheid and abuzz with the energy of the city of gold, Soweto is a must-see for tourists who are looking for...

Read more Read reviews Write review

Read more Read reviews Write review

Randburg & Roodepoort

0 0 0 0

Read more Read reviews Write review

Read more Read reviews Write review

Central Johannesburg & suburbs

0 0 0 0

This largely encompasses the old Johannesburg - the CBD with Newtown and Braamfontein, and Joburg's more established suburbs. It encompasses Parktown, Houghton, Melrose, Rosebank, Parkhurst, Craighall Park, Melville,...

Read more Read reviews Write review

Read more Read reviews Write review

Sandton, Fourways & Midrand

0 0 0 0

Sandton is an affluent area situated within the metro of Johannesburg. The name comes from the combination of two of its suburbs, Sandown and Bryanston. In 1969 Sandton was...

Read more Read reviews Write review

Read more Read reviews Write review

4 results - showing 1 - 4

What are you looking for today?

For advanced searches (price, amenities, etc) please click here.

Special offers

Quay West holiday home Velddrif Winter Special

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...

Farr Out May Madness with Hot Tub

Farr Out May Madness with Hot Tub

Discount %

15

Town: Paternoster

FREE use of wood-fired HOT TUB on one evening at Farr Out Guesthouse in Paternoster if you book 3 nights...

Your winter break

Cape St Francis Resort

Discount %

50

Town: Cape St Francis

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

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

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...

20% off B&B accommodation

20% off B&B accommodation

Discount %

20

Town: Cape Town

Get 20% Off B&B Accommodation when you stay 1 night or more as a couple in our guesthouse. ...

3 for 2 at La Galiniere

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

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

MENTOR GUEST HOUSE

MENTOR GUEST HOUSE

Category: Guest houses & B&Bs

Town: Queenstown

MENOTR GUEST HOUSE ITS A NICE PLACE TO BE HOME...

Glen Eden Farm, Fish Eagle Cottage

Glen Eden Farm, Fish Eagle Cottage

Category: Self-catering

Town: Montagu

Glen Eden Farm located 14km out of the historic town...

Glen Eden Farm, Honeybee Cottage

Glen Eden Farm, Honeybee Cottage

Category: Self-catering

Town: Montagu

Glen Eden Farm located 14KM out of the historic town...

Glen Eden Farm, Sugarbird Cottage

Glen Eden Farm, Sugarbird Cottage

Category: Self-catering

Town: Montagu

Glen Eden Farm located 14KM out of the historic town...

Dining area with spectucular sea view

82 De Bakke Terrace

Category: Self-catering

Town: Mossel Bay

82 De Bakke Terrace is a fully furnished self-catering holiday...

Stay Gordon's Bay Apartments

Stay Gordon's Bay Apartments

Category: Self-catering

Town: Gordon's Bay

Located in the picturesque harbour town of Gordon’s Bay,...

Eland Holiday Home

Category: Self-catering

Town: Hazyview

Eland Holiday Home is strategically placed midway between spectacular scenery...

Leadwood House

Category: Self-catering

Town: Marloth Park

Leadwood House is a privately owned Holiday Home located in...

Mananga Private Bush Retreat

Category: Self-catering

Town: Hazyview

Set apart from the renowned Protea Hotel Kruger Gate in...

Get your happy on at Taste the Helderberg 2016

Category: Food & Wine

Town: Stellenbosch

Local food and wine affair to banish the winter blues...

National Guide

Public holidays & school terms

Radio stations in South Africa

Road distances in South Africa

South African Flag & Anthem

sdxbv_categories AS ParentCategory, sdxbv_content AS Listing WHERE Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND Category.id IN (SELECT id FROM sdxbv_jreviews_categories WHERE `option` = "com_content") AND Category.id = Listing.catid AND Category.extension = "com_content" AND Category.level > 0 AND (Category.path = "gauteng/johannesburg" OR Category.path LIKE "gauteng/johannesburg/%") AND Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2016-04-25 22:00:00" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2016-04-24 22:00:00" ) GROUP BY ParentCategory.id ) AS CategoryListingCount ON CategoryListingCount.id = Category.id INNER JOIN sdxbv_jreviews_categories AS JreviewsCategory ON Category.id = JreviewsCategory.id AND JreviewsCategory.option = "com_content" LEFT JOIN sdxbv_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN sdxbv_jreviews_criteria AS ListingType ON JreviewsCategory.criteriaid = ListingType.id WHERE 1 = 1 AND ( Category.published = 1 AND Category.extension = "com_content" AND (Category.path = "gauteng/johannesburg" OR Category.path LIKE "gauteng/johannesburg/%") AND Category.level <= 3 ) ORDER BY Category.lft # Removed directory from order by because it makes the query SLOW # Instead we run a much faster query below to re-order the output array

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 = 10 )

SELECT count(DISTINCT groupid) FROM sdxbv_jreviews_criteria WHERE groupid != ''

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 (10) )

SELECT groupid FROM sdxbv_jreviews_groups WHERE groupid IN (15,13,19) AND type = 'content'

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" )

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 (289) AND Listing.state = 1 AND Listing.access IN ( 1) AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2016-04-25 22:00:00" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2016-04-24 22:00:00" ) ) ORDER BY Field.jr_startdate ASC,Field.contentid DESC LIMIT 10

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`,