Accommodation Guest houses & B&Bs Red Rose Bed & Breakfast

Red Rose Bed & Breakfast

0.0 (0)

0 12 0 0

Location

Gauteng

Sandton

4 Kildare Rd, Glenadrienne

Entry info

Check availability | Book online

Price range - complete one of the options

Rates/person

R350 - R600

Red Rose Bed and Breakfast situated in a quiet boomed suburb, entrance guarded 24 hrs.

Internet, computer and Fax facilities available.

We offer a spacious 60 sqm room, looking out onto private garden, stunning

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

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

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

Riverside self catering cottages

Category: Self-catering

Town: Cape Town

AA highly recommended (4*), in upmarket Constantia, 2 self-catering safe...

HarbourView Lodge

Category: Guest houses & B&Bs

Town: Gordon's Bay

HarbourView is situated approximately 45 minutes drive from all...

Indie Karoo Film Festival

Category: Film

Town: Prince Albert

The Indie Karoo Film Festival creates a platform for independent...

Napier Patatfees

Category: Festivals & Fairs

Town: Napier

Napier that glittering jewel in the Overberg’s crown is...

Hout Bay Manor

Category: Hotels

Town: Hout Bay

WELCOME TO HOUT BAY MANOR The 5-star...

Karen Zoid & Francois van Coke: Toe vind ek jou

Category: Music - jazz & popular

Town: Cape Town

In April 2015 Francois van Coke and Karen Zoid released...

Plett Food Film Festival

Category: Film

Town: Plettenberg Bay

The third edition of the Plett Food Film Festival offers...

Plett MAD Festival (music.arts.drama)

Category: Festivals & Fairs

Town: Plettenberg Bay

Calling all music fundies, lovers of art, movie zealots, drama...

Heritage Day Food Garden Tour

Category: Food & Wine

Town: Franschhoek

Explore the lush Werf Vegetable Garden

Pasta Making Weekend Workshop

Category: Food & Wine

Town: Franschhoek

Unlock your cooking skills at Boschendal's Pasta Making Workshop...

National Guide

Public holidays & school terms

Radio stations in South Africa

Road distances in South Africa

South African Flag & Anthem

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

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

SELECT * FROM sdxbv_jreviews_fieldoptions WHERE fieldid IN ( '1','2','3','4','68') AND value IN ( 'south-africa','gauteng','johannesburg-metro','sandton','midrange') 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 = 2946 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 (2946) GROUP BY listing_id

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

SELECT tmp.media_id, tmp.listing_id, tmp.review_id, tmp.media_type, tmp.media_function, tmp.likes_rank, tmp.main_media, media.likes_up, media.likes_total, media.created, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.duration, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension FROM ( SELECT media_id, listing_id, review_id, media_type, media_function, main_media, views, likes_rank, created, ordering, CASE WHEN @id != listing_id AND media_type = 'photo' THEN @photo := 1 ELSE IF(media_type = 'photo' ,@photo := @photo + 1,NULL) END AS photo_rank, CASE WHEN @id != listing_id AND media_type = 'video' THEN @video := 1 ELSE IF(media_type = 'video' ,@video := @video + 1,NULL) END AS video_rank, CASE WHEN @id != listing_id AND media_type = 'attachment' THEN @attachment := 1 ELSE IF(media_type = 'attachment',@attachment := @attachment + 1,NULL) END AS attachment_rank, CASE WHEN @id != listing_id AND media_type = 'audio' THEN @audio := 1 ELSE IF(media_type = 'audio',@audio := @audio + 1,NULL) END AS audio_rank, @id := listing_id FROM ( SELECT media_id, review_id, listing_id, user_id, media_type, media_function, likes_rank, likes_up, likes_total, created, main_media, ordering, views FROM sdxbv_jreviews_media WHERE listing_id IN (2946) AND published = 1 AND approved = 1 AND access IN (1) AND extension = 'com_content' ) mtmp JOIN (SELECT @id := NULL, @photo := 0, @video := 0, @attachment := 0, @audio := 0) r ORDER BY main_media DESC, listing_id, media_type, ordering ) tmp JOIN sdxbv_jreviews_media AS media ON media.media_id = tmp.media_id WHERE (tmp.photo_rank >= 0) OR (tmp.video_rank BETWEEN 1 AND 7) OR (tmp.attachment_rank > 0) OR (tmp.audio_rank > 0) ORDER BY tmp.main_media DESC, tmp.listing_id, tmp.media_type, tmp.ordering

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