Northern Freestate Support Logistics
Towns in Northern Freestate Lindley
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=6
AND regions.id = subregions.region_id
AND regions.friendly='freestate'
AND subregions.friendly='northernfreestate'
AND subregions.id = towns.subregion_id
AND towns.id = listings.towns_id
)
GROUP BY categories.id
ORDER BY categories.id ASC
Listings
|
The Riemland Route comprises of the following Free State towns Sasolburg, Heilbron (Edenville), Petrus Steyn, Lindley, Arlington and Rosendal and the newest addition of Senekal.
The Riemland, well known for the large number of game and predators that roamed the plains during the 1800\'s, attracte...
|
showing 1 - 1 of 1 listings
|