Accommodation Guest houses & B&Bs Big Five accommodation

Big Five accommodation

0.0 (0)

0 0 0 0

Location

Gauteng

Edenvale

89 2nd Avenue

Entry info

Check availability | Book online

Affordable, queen, single or twin rooms african themed. En-suit bath/shower fridge tv/ Mnet & dstv. Rates include a full breakfast.

Map

Move Map

Swap Start/End Start Address

End

User reviews

There are no user reviews for this listing.

What are you looking for today?

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

Special offers

The longer you stay, the less you pay.

Discount %

Town: Franschhoek

Book your stay at Rickety Bridge Winery and receive 15% off your stay. Don't forget to inquire about our amazing...

Low Season Special

Discount %

Town: Wellington

Stay with us between 06 April 2016- 05 June 2016 and save 15% on your booking.Enjoy peaceful nights surrounded by...

The Carraighs

Discount %

Town: Plettenberg Bay

Discount of 10% for stays of 2 days or more at The Carraighs, The Crags, Plettenberg Bay. Close...

Winter Discount

Discount %

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 %

Town: Swellendam

Need a break away from the city life? We have the perfect solution..

Quay West holiday home Velddrif Winter Special

Discount %

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

Discount %

Town: Paternoster

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

Cape St Francis Resort

Discount %

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

Discount %

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 %

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 %

Town: Franschhoek

Stay for 3 nights at La Galiniere Guest Cottages between April and September and pay for only 2.

Winter Special

Discount %

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 %

Town: Gansbaai

10% off luxury oceanfront whale coast villa when you stay 4 nights or more this autumn and winter. Explore the...

Latest directory entries

The longer you stay, the less you pay.

Discount %

Category: Special offers

Town: Franschhoek

Book your stay at Rickety Bridge Winery and receive 15%...

Low Season Special

Discount %

Category: Special offers

Town: Wellington

Stay with us between 06 April 2016- 05 June 2016...

Amanzi Country Manor

Category: Guest houses & B&Bs

Town: Fort Nottingham

Amanzi Country Manor is a luxury self-catering home located...

Amanzi Beach House

Category: Guest houses & B&Bs

Town: Port Shepstone

Amanzi Beach House is a lovely double level, 5 bedroom...

Foraging and Cooking with the Chefs

Category: Food & Wine

Town: Stanford

Foraging at 9am with the Michelin-starred Chef Jurgen, get the...

Camp Jabulani

Category: Lodges & Country Houses

Town: Hoedspruit

Camp Jabulani is a family-owned and managed private luxury safari...

Santa Fé Beach House, Bloubergstrand

Category: Self-catering

Town: Blouberg

Self-catering accommodation, 3-bedroom villa in La Paloma Estate, Big Bay/Cape...

De Linden Boutique Guest House

Category: Guest houses & B&Bs

Town: Paternoster

De Linden Boutique Guest House is ideal for guests seeking...

Villa Simonne

Category: Guest houses & B&Bs

Town: Johannesburg

16 Themed Suites - From Marrakesh to Moulin Rouge......

Elsje's Country Inn

Category: Guest houses & B&Bs

Town: Kempton Park

Tranquil, quiet country setting, situated in Bredell, Kemptonpark, 9km from...

National Guide

Public holidays & school terms

Radio stations in South Africa

Road distances in South Africa

South African Flag & Anthem

SELECT count(*) FROM sdxbv_jreviews_categories AS JreviewCategory WHERE JreviewCategory.id = 163 AND JreviewCategory.option = 'com_content' AND JreviewCategory.criteriaid > 0

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_latitude AS `Geomaps.lat`, Field.jr_longitude AS `Geomaps.lon`, JreviewsCategory.marker_icon AS `Geomaps.marker_icon` FROM sdxbv_content AS Listing LEFT JOIN sdxbv_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN sdxbv_jreviews_content AS Field ON Field.contentid = Listing.id 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.id = 2858 )

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 ('8') )

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 IN (8) ) ORDER BY CriteriaRating.ordering

SELECT groupid FROM sdxbv_jreviews_groups WHERE groupid IN (5,10,3,1,4,15,13) AND type = 'content'

SELECT Field.fieldid AS `Field.field_id`, Field.groupid AS `Field.group_id`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`, Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`, Field.contentview AS `Field.contentView`, Field.listview AS `Field.listView`, Field.compareview AS `Field.compareView`, Field.listsort AS `Field.listSort`, Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`, Field.published As `Field.published`, Field.ordering AS `Field.ordering`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle`, `Group`.ordering AS `Group.ordering` FROM sdxbv_jreviews_fields AS Field LEFT JOIN sdxbv_jreviews_groups AS `Group` ON `Group`.groupid = Field.groupid WHERE Field.published = 1 AND Field.location = 'content' AND Field.groupid IN ( 1,3,4,5,10)

SELECT Listing.contentid AS element_id,jr_country,jr_province,jr_region,jr_town,jr_suburb,jr_postalcode,jr_streetaddress,jr_latitude,jr_longitude,jr_venue,jr_nightsbridgebbid,jr_tgcsagrading,jr_telephone,jr_mobile,jr_fax,jr_contact,jr_email,jr_website,jr_facebook,jr_twitter,jr_rates,jr_ratesunit,jr_generalfacilities,jr_activitiesoffered,jr_gettingthere,jr_languagesspoken FROM sdxbv_jreviews_content AS Listing WHERE Listing.contentid IN (2858)

SELECT * FROM sdxbv_jreviews_fieldoptions WHERE fieldid IN ( '1','2','3','4') AND value IN ( 'south-africa','gauteng','ekurhuleni-metro','edenvale') ORDER BY ordering ASC ,optionid ASC

SELECT rating_range, count(*) AS count FROM (SELECT CASE WHEN ROUND(rating,1) > 0 AND rating < 1.5 THEN 1 WHEN ROUND(rating,1) >= 1.5 AND ROUND(rating,1) < 2.5 THEN 2 WHEN ROUND(rating,1) >= 2.5 AND ROUND(rating,1) < 3.5 THEN 3 WHEN ROUND(rating,1) >= 3.5 AND ROUND(rating,1) < 4.5 THEN 4 WHEN ROUND(rating,1) >= 4.5 THEN 5 END as rating_range FROM sdxbv_jreviews_comments WHERE pid = 2858 AND published = 1 AND mode = 'com_content' AND rating > 0 AND author = 0 ) AS ReviewRange GROUP BY rating_range

SELECT content_id AS listing_id, count(*) AS favored FROM sdxbv_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (2858) GROUP BY listing_id

SELECT * FROM sdxbv_comprofiler AS Community WHERE 1 = 1 AND ( user_id IN (62) )

SELECT PaidOrder.*, User.id AS `User.user_id`, User. name AS `User.name` FROM sdxbv_jreviews_paid_orders AS `PaidOrder` LEFT JOIN sdxbv_users AS User ON PaidOrder.user_id = User.id WHERE 1 = 1 AND ( `PaidOrder`.listing_id IN (2858) AND `PaidOrder`.order_status IN ('Complete') AND `PaidOrder`.order_active = 1 ) ORDER BY `PaidOrder`.order_created ASC

SELECT PaidCountry.id, PaidCountry.country_code, PaidCountry.country_name FROM sdxbv_jreviews_paid_countries AS `PaidCountry` ORDER BY PaidCountry.country_name ASC