Natal Accommodation
Subregions in Natal
Central Drakensberg
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=1
AND regions.id = subregions.region_id
AND regions.friendly='natal'
AND subregions.id = towns.subregion_id
AND towns.id = listings.towns_id
)
GROUP BY categories.id
ORDER BY categories.id ASC
Listings
|
|
Champagne Sports Resort has been striving to make this award winning resort the perfect place for work and play. This is a difficult balance to achieve but following recent developments we believe we have created a truly unique destination catering for all guest requirements in an absolutely spectac...
|
showing 1 - 1 of 1 listings
| 
natal accommodation
