|
|
Clarens Activities
SELECT categories.*
FROM categories, listings, category_to_listing , regions, towns, subregions
WHERE listings.published=1
AND listings.trashed IS NULL
AND ( category_to_listing.listing_id = listings.id
AND category_to_listing.category_id = categories.id
AND categories.top_section_id=4
AND regions.id = subregions.region_id
AND regions.friendly='freestate'
AND towns.friendly='clarens'
AND subregions.id = towns.subregion_id
AND towns.id = listings.towns_id
)
GROUP BY categories.id
ORDER BY categories.id ASC
Listings
|
|
Come home to The Clarens Golf Estate and leave behind the rush of the commercial world. Nestled in the foothills of the Maluti Mountains on the edge of the dramatic Golden Gate nature reserve in the Eastern Free State, Clarens is fast becoming the perfect place to escape to for peace, tranquility an...
|
|
|
We do most of our teambuilding, abseiling, whitewater river rafting and kayaking in South Africa on the Vaal river near Parys, the Ash river near Clarens, and in KwaZulu-Natal. In KwaZulu-Natal there are some awesome rivers, the Mkomazi (the old Umkomaas), the Umzimkulu and yes, the mighty Tugela ri...
|
|
|
Overlooking the whole of Clarens Valley surrounded
by spectacular views of the Red Mountains.
A place for the adventure\'s!
* Horse riding s our forte.
* Hiking and Mountain Bike Trails
* 8 Rustic Chalets with fire places.
* Camping site with 10 powerpoints
* Dorms with 16...
|
|
|
Join us for white-water rafting in SA any time of the year. We cater for corporate, school and leisure groups to your everyday adventure seeker. We also offer abseiling, archery, quad bikes, paintball and enduro trails in Clarens.
|
|
|
The most beautiful sandstone lodge near Clarens in the Eastern Free State.
It is a place of peace and tranquillity with wide open spaces and a homey atmosphere. Ideally located half-way between Bethlehem and Clarens in the picturesque Eastern Free State, it offers accommodation on a bed and breakfa...
|
|
|
Nestled in the rolling foothills of the Maluti Mountains of the north eastern Free State lies the Golden Gate Highlands National Park.
The park derives its name from the brilliant shades of gold cast by the sun on the parks sandstone cliffs, especially the imposing Brandwag rock, keeping vigil ov...
|
|
|
Overlooking the whole of Clarens Valley surrounded
by spectacular views of the Red Mountains.
A place for the adventures!
* Horse riding s our forte.
* Hiking and Mountain Bike Trails
* 8 Rustic Chalets with fire places.
* Camping site with 10 powerpoints
* Dorms with 16 b...
|
showing 1 - 7 of 7 listings
|
| 1 ZAR (South African Rand) | | = | EUR 0.09214
GBP 0.07884
JPY 9.77224
USD 0.12665
| more... |
|
