Unknown column 'ycode' in 'where clause'
select c.fname as country, c.code as coucode, concat( left( d.descr, 300 - locate( " ", reverse( left( d.descr, 300 ) ) ) ) ) AS intro, a.suburb_code, count(a.suburb_code) as cnt, d.fname as suburb, d.code as suburbcode, r.fname as region, r.code as regioncode, e.fname as area, f.fname as city, f.code as cicode, g.fname as town, g.code as towncode, e.code as areacode from va_suburb d left join va_venue a on (a.suburb_code = d.code) left join va_country c on (c.code = d.country_code) left join va_region r on (r.code = d.region_code) left join va_area e on (e.code = d.area_code) left join va_city f on (f.code = d.city_code) left join va_town g on (g.code = d.town_code) where d.code = ycode and a.active = 1 group by d.code LIMIT 100 offset 0

Error Text:
Unknown column 'ycode' in 'where clause' ....
Query Text:
select c.fname as country, c.code as coucode, concat( left( d.descr, 300 - locate( " ", reverse( left( d.descr, 300 ) ) ) ) ) AS intro, a.suburb_code, count(a.suburb_code) as cnt, d.fname as suburb, d.code as suburbcode, r.fname as region, r.code as regioncode, e.fname as area, f.fname as city, f.code as cicode, g.fname as town, g.code as towncode, e.code as areacode from va_suburb d left join va_venue a on (a.suburb_code = d.code) left join va_country c on (c.code = d.country_code) left join va_region r on (r.code = d.region_code) left join va_area e on (e.code = d.area_code) left join va_city f on (f.code = d.city_code) left join va_town g on (g.code = d.town_code) where d.code = ycode and a.active = 1 group by d.code LIMIT 100 offset 0

ACCOMMODATION SEARCH
Enter first 3 letters of a location or venue name & wait for suggestions:
or try our new
Accommodation Search LIVE AVAILABILITY SEARCH

Map of Fourways

Google Map of Fourways

Fourways Car Hire

Car Hire</div>Car Hire

Fourways Accommodation

Find the ideal Fourways Accommodation at a guesthouse, self-catering establishment, a bed & breakfast or safari lodge.

Please contact us on +27 021 683 6444 or email us at for all your Fourways Accommodation needs.

Book the perfect Fourways vacation accommodation online with www.Venues4Africa.com




Amber Rose Country Estate

Amber Rose Country Estate

Graded 4 Star

Guest House Accommodation in Fourways
Discover this gracious country retreat, Amber Rose, in the Chartwell Valley, minutes from the Fourways shopping and business centre where a warm welcome and luxury accommodation awaits you, our guest.

Enjoy the More about Amber Rose Country Estate
Price Per Person Per Night from R370 to R740
CHECK AVAILABILITY

Fourways Gardens Guest Estate

Fourways Gardens Guest Estate

Graded 4 Star

Guest House Accommodation in Fourways

Traditional hospitality. Set in a relaxed, peaceful 6 acres estate in Johannesburg’s elite northern suburbs, minutes away from Fourways Mall, Monte Casino, Fourways Life Hospital, Major Highways and Business More about Fourways Gardens Guest Estate
Price Per Person Per Night from R249 to R595
Price Per Unit Per Night from R695 to R1450

Old Umtali Guest House

Old Umtali Guest House

Graded 4 Star

Guest House Accommodation in Fourways
Our rooms offer all the comforts you would expect from quality accommodation, with a relaxed B & B style. We also offer a 24-hour Internet connection in all rooms. After a peaceful nights sleep, you will be able More about Old Umtali Guest House
Price Per Person Per Night from R300 to R450
CHECK AVAILABILITY

Das Landhaus

Das Landhaus

Graded 4 Star

Guest House Accommodation in Fourways
Conveniently sited near fourways, close to Johannesburg, Gauteng, South Africa. Das Landhaus is set around a sparkling pool in a spacious garden. Indigenous aloes, thorn trees and some game give it that african More about Das Landhaus

Idle Winds

Idle Winds

Graded

Guest House Accommodation in Fourways
The Ultimate Rendezvous in the country, Idle Winds is comfortably settled in lush gardens and highveld scenery.

The perfect venue to ensure that your conferences, product launches, corporate functions, weddings and More about Idle Winds
Price Per Person Per Night from R380 to R600

Guest House Oaktree

Guest House Oaktree

Graded 4 Star

Guest House Accommodation in Fourways
Guest House Oaktree welcomes you to their charming guest house on a secure estate. It is ideal for business and leisure travellers, a perfect home away from home. All units are very spacious and private, with own More about Guest House Oaktree
Price Per Person Per Night from R550 to R550
Price Per Unit Per Night from R660 to R660

Norscot Manor Guest Lodge

Norscot Manor Guest Lodge

Graded 5 Star

Guest House Accommodation in Fourways
Situated in the garden suburb of Sandton in close proximity to the business areas of Johannesburg, Sandton, Randburg and Midrand, Norscot Manor Guest Lodge offers friendly service and personal attention with five-star More about Norscot Manor Guest Lodge
Price Per Person Per Night from R450 to R660

Lourie Lodge

Lourie Lodge

Graded 4 Star

Guest House Accommodation in Fourways
Exclusive Guest House in South Africa

Nestled just off the main thoroughfare that runs through the heart of Johannesburg is a private gated slice of paradise we simply call "Lourie Lodge."

We have spacious, More about Lourie Lodge
Price Per Person Per Night from R875.00 to R1000.00
Price Per Unit Per Night from R1100.00 to R1300.00
CHECK AVAILABILITY


PAGE: 1