Accommodation Guest houses & B&Bs Outeniqua Moon Percheron Stud and Guest Farm

Outeniqua Moon Percheron Stud and Guest Farm New

0.0 (0)

0 6 0 0

Outeniqua Moon Percheron Stud and Guest Farm

Location

Western Cape

Mossel Bay

Kleinbrak road from the R328

Entry info

Check availability | Book online

Price range - complete one of the options

Rates/person

R600 - R1000

About the establishment

General facilities

Activities offered

Getting there

This magical 100 hectare mountain farm is guaranteed to take away all those inner city blues and delight the whole family, young and old. Step out of your door and into a beautiful world of mountains, birds and horses.

Outeniqua Moon is a working Percheron Horse Farm offering Self-Catering and Bed & Breakfast, and Dinner, Bed and Breakfast accommodation near Ruiterbos, between Mossel Bay & Oudtshoorn.

This 100 hectare privately owned and managed estate is surrounded by beautiful scenery with views of the Outeniqua mountain range and paddocks.

It’s a great Garden Route holiday destination at which to enjoy various outdoor activities including horse riding, hiking, mountain biking and unique carriage drives.

Outeniqua Moon offers farm-style colonial accommodation consisting of 3 suites and 1 cottage, all self-contained. Children and pets are welcome.

Ideal for couples, families and group of friends.

ACCOMMODATION:

There are 3 suites and 1 cottage, all with their own entrances:

Blue Suite: Downstairs unit, sleeps 3. Bedroom with King size or Twin beds. Kitchenette, small dining area and lounge with sleeper couch. Paddock views.

Family Suite: Downstairs unit, sleeps 6. Main bedroom with King size or Twin beds. Second bedroom with a single and bunk bed. Kitchenette, dining counter-top with bar chairs and lounge with sleeper couch. Mountain views. More spacious than the Cottage.

Honeymoon Suite: Upstairs unit, sleeps 2. Bedroom with romantic four poster Queen size bed. Open plan kitchenette and lounge with sleeper couch. Mountain views.

Cottage: Separate unit, sleeps 4. Two bedrooms with 4 single beds pushed together. Open plan full kitchen with dining table. Lounge with sleeper couch. Garden views.

Each Room offers:

·                     Overhead ceiling fans

·                     Lounge with flat screen TV, DVD player and DStv

·                     Kitchen equipped with ovens with two plate hobs, microwaves, fridges, kettles, toasters

·                     En-suite bathroom with Victorian style bath and separate shower

·                     Private entrances

·                     Private undercover verandas with table, chairs and BBQ facilities

Bed & Breakfast rates include traditional style breakfast. Excellent home-made dinners upon request at additional charge

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

Hippoview Guesthouse 25% midweek discount for the month of February

Discount %

Town: Bela Bela

Hippoview Guesthouse 25% midweek discount for the month of February

Weekend Special at The Crown Guesthouse

Discount %

Town: Bethlehem

For your next weekend in Clarens, make use of the Weekend Special at The Crown Guesthouse, merely 28 km enroute...

Latest directory entries

110 On Westcliff

Category: Guest houses & B&Bs

Town: Hermanus

110 on Westcliff offers quiet peaceful accommodation within the confines...

Zuikerkop Country Game Lodge

Category: Lodges & Country Houses

Town: Clocolan

Zuikerkop is situated between Ladybrand and Ficksburg, only 10km’s from...

Silverstone Guesthouse

Category: Guest houses & B&Bs

Town: Randburg

Silverstone Guest House and Conference Venue consists of eleven en-suite...

Fly me to the Moon Guesthouse

Category: Guest houses & B&Bs

Town: Mossel Bay

Fly me to the Moon Guesthouse is located just outside...

Sak 'n Pak Luxury Guest House

Category: Guest houses & B&Bs

Town: Ballito

Sak 'n Pak Luxury Guest House is situated in the...

Forest Bird Lodge

Category: Self-catering

Town: Magoebaskloof

Self catering accommodation Magoebaskloof Haenertsburg Birding Forest walks secluded romantic...

The Blue Moon Guesthouse and Restaurant

Category: Guest houses & B&Bs

Town: Sutherland

When you visit Sutherland you will enjoy the cleanest air...

West Coast Luxury Tents

Category: Self-catering

Town: Between Elands bay and Dwarskersbos

Luxury west coast beach, self-catering tent. Private, access to the...

Torburnlea B&B

Category: Guest houses & B&Bs

Torburnlea Luxury Bed and Breakfast in a restful environment near...

Lake St Lucia Villas & King's Palace

Category: Self-catering

Town: St Lucia

Welcome to Lake St Lucia Villa's & King's Palace...

S2Framework Debug Console

PHP Errors

[8] Undefined 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 (46)

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

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

SELECT * FROM sdxbv_jreviews_fieldoptions WHERE fieldid IN ( '1','2','3','4','68','69','70','71') AND value IN ( 'south-africa','western-cape','garden-route','mossel-bay','upper','airconditioning','braai','childfriendly','gayfriendly','laundry-facilities','petfriendly','secure-parking','selfcatering-facilities','tv-in-rooms','wireless-internet','birdwatching','hiking','swimming-pool','wilderness-environment','farmstays') 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 = 6427 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 (6427) GROUP BY listing_id

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

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

SELECT images FROM sdxbv_content WHERE id = 6427

SELECT Listing.catid FROM sdxbv_content AS Listing RIGHT JOIN sdxbv_jreviews_categories AS Category ON Listing.catid = Category.id AND Category.option = 'com_content' WHERE Listing.id = 6427

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

SELECT Category.id FROM sdxbv_categories AS Category, sdxbv_categories AS ParentCategory WHERE Category.published = 1 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 244

SELECT id FROM sdxbv_jreviews_categories WHERE `option` = "com_content"

SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, 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`, '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`, 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`, JreviewsCategory.marker_icon AS `Geomaps.marker_icon`, Field.jr_latitude AS `Geomaps.lat`, Field.jr_longitude AS `Geomaps.lon` FROM sdxbv_content AS Listing USE KEY (jr_created) 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.catid IN (244) AND Listing.state = 1 AND Listing.access IN ( 1) AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2016-02-17 22:00:00" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2016-02-16 22:00:00" ) ) ORDER BY Listing.created DESC LIMIT 100

SELECT groupid FROM sdxbv_jreviews_groups WHERE groupid IN (9,1,16) AND type = 'content'

SELECT * FROM sdxbv_jreviews_fieldoptions WHERE fieldid IN ( '1','2','4','3') AND value IN ( 'south-africa','free-state','bethlehem','limpopo','waterberg','bela-bela') ORDER BY ordering ASC ,optionid 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 (6354,6332) )

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

SELECT * FROM sdxbv_comprofiler AS Community WHERE 1 = 1 AND ( user_id IN (16898,16911) )

SELECT media.media_id, media.media_type, media.media_function, media.likes_rank, media.likes_up, media.likes_total, media.created, media.main_media, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension FROM sdxbv_jreviews_media AS media WHERE listing_id IN (6402,6377) AND published = 1 AND approved = 1 AND access IN (1) AND main_media = 1

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 (6402,6377) AND `PaidOrder`.order_status IN ('Complete') AND `PaidOrder`.order_active = 1 ) ORDER BY `PaidOrder`.order_created ASC

SELECT JreviewsCategory.id FROM sdxbv_jreviews_categories AS JreviewsCategory LEFT JOIN sdxbv_categories AS Category On JreviewsCategory.id = Category.id WHERE JreviewsCategory.dirid IN (1,2) AND JreviewsCategory.`option`= "com_content" AND Category.published = 1 AND Category.access IN ( 1)

SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, 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`, '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`, 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`, JreviewsCategory.marker_icon AS `Geomaps.marker_icon`, Field.jr_latitude AS `Geomaps.lat`, Field.jr_longitude AS `Geomaps.lon` FROM sdxbv_content AS Listing USE KEY (jr_created) 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.catid IN (161,162,163,164,165,166,177,180,178,179,188,181,182,184,183,185,186,202,189,191,190,193,195,196,197,167,168,170,200,201,171,198,172,203,173,175,207,208,213,214,244,169,204,199,264,265,267,266,269,268,270,271,272) AND Listing.state = 1 AND Listing.access IN ( 1) AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2016-02-17 22:00:00" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down > "2016-02-16 22:00:00" ) ) ORDER BY Listing.created DESC LIMIT 10

SELECT * FROM sdxbv_jreviews_fieldoptions WHERE fieldid IN ( '1','2','3','4','68','69','92','70','71','21') AND value IN ( 'south-africa','kwazulu-natal','elephant-coast','st-lucia','midrange','airconditioning','braai','credit-cards-accepted','restaurantbar','secure-parking','selfcatering-facilities','western-cape','west-coast','between-elands-bay-and-dwarskersbos','upper','childfriendly','fireplace','gayfriendly','petfriendly','birdwatching','fishing','hiking','beach-nearby','farmstays','northern-cape','sutherland','baby-sitting','disabilityfriendly','laundry-facilities','wireless-internet','shopping-nearby','heritage-environment','limpopo','mopani','magoebaskloof','north-coast','ballito','5-stars','conference-facilities','tv-in-rooms','swimming-pool','airport-transfers','garden-route','mossel-bay','gauteng','johannesburg-metro','randburg','free-state','clocolan','wedding-specialists','game-watchinghunting','overberg','hermanus') ORDER BY ordering ASC ,optionid ASC

SELECT content_id AS listing_id, count(*) AS favored FROM sdxbv_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (6449,6447,6446,6445,6444,6443,6442,6441,6440,6439) GROUP BY listing_id

SELECT * FROM sdxbv_comprofiler AS Community WHERE 1 = 1 AND ( user_id IN (16968,16967,16986,16984,16954,16949,16982,16975,16978,16943) )

SELECT media.media_id, media.media_type, media.media_function, media.likes_rank, media.likes_up, media.likes_total, media.created, media.main_media, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension FROM sdxbv_jreviews_media AS media WHERE listing_id IN (6447,6446,6445,6443,6442,6439) AND published = 1 AND approved = 1 AND access IN (1) AND main_media = 1

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 (6449,6447,6446,6445,6444,6443,6442,6441,6440,6439) AND `PaidOrder`.order_status IN ('Complete') AND `PaidOrder`.order_active = 1 ) ORDER BY `PaidOrder`.order_created 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 (6439,6441,6442,6443,6444,6445,6446,6447,6449) )

SELECT * FROM sdxbv_comprofiler AS Community WHERE 1 = 1 AND ( user_id IN (16943,16975,16982,16949,16954,16984,16986,16967,16968) )

Outeniqua Moon Percheron Stud and Guest Farm New

Location

Entry info

Price range - complete one of the options

About the establishment

This magical 100 hectare mountain farm is guaranteed to take away all those inner city blues and delight the whole family, young and old. Step out of your door and into a beautiful world of mountains, birds and horses.

Map

User reviews

Special offers

Latest directory entries

National Guide

S2Framework Debug Console

PHP Errors

Database Queries (46)