|
|
|
 |
| |
|
 |
Where an idea becomes a reality..
Amazing Spaces pioneered the locations industry in South Africa. In every aspect of our business we strive to stay ahead – whilst offering value at every level. Our stock of locations offers a diverse library of shoots locations ranging from ultra modern homes to beach houses; rustic farms, bars and nightclubs to outdoor spaces. If it's out there it's in here... and if you can't find what you're looking for, contact us and we'll send you a presentation to suit your brief.
string(294) "SELECT distinct l.LocationID as id, l.LocationName as name, l.shortdescription, l.red_flag, tl.seq
FROM tbllocations as l JOIN toplocations_typ as tl ON (l.locationid=tl.locationid and 3 = tl.type_id)
WHERE l.NotToShoot = 0
AND l.IsActive = 1
AND l.CountryCode = 'ZA'
ORDER BY tl.seq ASC"
string(294) "SELECT distinct l.LocationID as id, l.LocationName as name, l.shortdescription, l.red_flag, tl.seq
FROM tbllocations as l JOIN toplocations_typ as tl ON (l.locationid=tl.locationid and 3 = tl.type_id)
WHERE l.NotToShoot = 0
AND l.IsActive = 1
AND l.CountryCode = 'ZA'
ORDER BY tl.seq ASC"
 |
 |
 |
 |
| Apollo |
49a |
Strawberries and Cream |
Pearl Bay |
 |
 |
 |
 |
| Oasis |
Launch Pad |
Maison |
One World |
 |
 |
 |
 |
| Eagles |
Land Bank |
Full Cream |
Natte Valleij |
|
|
|
 |
|
|