Kroonstad Function Venues
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=8
AND regions.id = subregions.region_id
AND regions.friendly='freestate'
AND towns.friendly='kroonstad'
AND subregions.id = towns.subregion_id
AND towns.id = listings.towns_id
)
GROUP BY categories.id
ORDER BY categories.id ASC
Listings
|
|
Escape the city bedlam and experience the tranquility of nature. Barn Guesthouse originated from a sheepkraal on the farm Smaldeel, situated on the N1, 24 km south of Kroonstad. The agricultural activities on the farm include the cultivation of maize, sunflower and wheat as well as the production of...
|
|
|
The Elizabeth Guest House is situated in the heart of the Free State in Kroonstad, just off the N1 and halfway between Johannesburg and Bloemfontein. Kroonstad is situated on the banks of the Vals River, and offers visitors a range of activities and attractions ranging from the famous Jukskei Park t...
|
|
|
Lamon is an up-market guesthouse and conveniently situated near the N1 off ramp. We offer you a safe and secure environment in a peaceful quiet area with tranquil surroundings. We cater for all types of stays, whether it being for business, events, tourists or conferences. We invite you to experienc...
|
|
|
Zoutspruit offers luxury and comfortable accommodation on the N1 halfway between Limpopo/Mpumalanga and Gauteng/Bloemfontein. No lights or noise from the traffic and trucks through the night guaranteed as we are 2 km from the N1.
Our rates includes a Buffet breakfast. Room serviced offered on re...
|
showing 1 - 4 of 4 listings
| 
