Accommodation Guest houses & B&Bs Melvin Residence Guest House

Melvin Residence Guest House

0.0 (0)

0 12 0 0

Location

Gauteng

Pretoria

184 Pine Street

Entry info

Check availability | Book online

Price range - complete one of the options

Rates/person

R350 - R600

Combining old world charm with modern luxury. Melvin Residence Guest House is ideally located for doing business in Pretoria, but that is just part of this perfectly preserved Victorian manor house's charm. A warm welcome awaits visitors who wish to experience the glamour of yesteryear, but who also do not want to compromise on modern amenities.

The perfect location
Situated in jacaranda-lined Pine Street in Arcadia, one of Pretoria's oldest suburbs, Melvin Residence Guest House is within walking distance of the Union Buildings and the famous embassy row of the capital city.

The fact that the guest house is just ten minutes' drive away from the commercial hub of the city, Loftus Versfeld rugby and football stadium, the University of Pretoria and specialist hospitals in the area, does not detract from the air of tranquillity that surrounds Melvin Residence.

Many restaurants and coffee shops in the area offer the visitor a selection of dining experiences.

Modern amenitiesAlthough the original Victorian house, with its quaint steeple, wrap-around veranda, moulded ceilings, stained glass work and wooden floors, doors and windows has been perfectly preserved, the visitor will find luxury rooms and en suite bathrooms, total connectivity (the entire guest house is a Wi-Fi hotspot), adequate desk space in the rooms and the entire range of business support.

Map

Move Map

Swap Start/End Start Address

End

User reviews

There are no user reviews for this listing.

S2Framework Debug Console

Database Queries (13)

SELECT id, language FROM sdxbv_menu WHERE link LIKE "%com_comprofiler&view=userprofile" AND published = 1 AND type = "component"

SELECT id, language FROM sdxbv_menu WHERE link LIKE "%com_comprofiler&view=registers" AND published = 1 AND type = "component"

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

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

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` 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 IN (2910) )

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 images FROM sdxbv_content WHERE id = 2910

SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `Review.user_id`, User.id AS `User.user_id`, CASE WHEN CHAR_LENGTH(User. name) THEN User. name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User. username) THEN User.username ELSE Review.username END AS `User.username`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, Rank.rank AS `User.review_rank`, Rank.reviews AS `User.review_count`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, Review.listing_type_id AS `Review.listing_type_id`, IF(Review.rating=0,"na",Review.rating) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Review.owner_reply_created AS `Review.owner_reply_created`, Review.media_count AS `Review.media_count`, Review.video_count AS `Review.video_count`, Review.photo_count AS `Review.photo_count`, Review.audio_count AS `Review.audio_count`, Review.attachment_count AS `Review.attachment_count`, Review.owner_reply_approved As `Review.owner_reply_approved`, Review.owner_reply_text As `Review.owner_reply_text` FROM sdxbv_jreviews_comments AS Review LEFT JOIN sdxbv_users AS User ON Review.userid = User.id LEFT JOIN sdxbv_jreviews_reviewer_ranks AS Rank ON Review.userid = Rank.user_id LEFT JOIN sdxbv_content AS Listing ON Listing.id = Review.pid LEFT JOIN sdxbv_jreviews_listing_totals AS Totals ON Totals.listing_id = Review.pid AND Totals.extension = 'com_content' LEFT JOIN sdxbv_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' WHERE 1 = 1 AND ( Review.pid = 2910 AND Review.mode = 'com_content' AND Review.published = 1 AND Review.author = 0 AND JreviewsCategory.option = 'com_content' ) ORDER BY `Review.created` DESC LIMIT 5

SELECT FieldValue.optionid, FieldValue.fieldid, FieldValue.text, FieldValue.value, FieldValue.image, FieldValue.ordering FROM sdxbv_jreviews_fieldoptions AS FieldValue WHERE FieldValue.fieldid IN (87) ORDER BY FieldValue.text ASC

SELECT FieldValue.optionid, FieldValue.fieldid, FieldValue.text, FieldValue.value, FieldValue.image, FieldValue.ordering FROM sdxbv_jreviews_fieldoptions AS FieldValue WHERE Fiel