SELECT `u`.`id`, `u`.`detail`, `u`.`status`, `u`.`category`, `u`.`pricevar`, `u`.`dateupdated`, `u`.`dateadded`, `c`.`group_id`, `u`.`agentid`, `u`.`agent_name`,
IF(`u`.`reference`, `u`.`reference`, `u`.`id`) AS `reference`,
`c`.`name` as `client`,
`a`.`name` as `agent`,
`o`.`style` as `currency`,
`o`.`area` as `country`,
`r`.`area` as `region`,
`i`.`area` as `city`,
`s`.`area` as `area`,
(SELECT `prop_type` FROM `types` WHERE `id` = `u`.`type`) AS `prop_type`
FROM `properties` `u`
LEFT JOIN `clients` `c` ON `c`.`id`=`u`.`agentid`
LEFT JOIN `areas` `o` ON `o`.`id`=`u`.`country`
LEFT JOIN `areas` `r` ON `r`.`id`=`u`.`regionid`
LEFT JOIN `areas` `i` ON `i`.`id`=`u`.`cityid`
LEFT JOIN `areas` `s` ON `s`.`id`=`u`.`areaid`
LEFT JOIN `agents` `a` ON `a`.`id`=`u`.`agent_name`
WHERE
( `u`.`status` = 'Featured' OR `u`.`status` = 'For Sale' )
AND ( `o`.`area` LIKE '%Columbus%' OR `o`.`code` LIKE '%Columbus%' OR `r`.`area` LIKE '%Columbus%' OR `r`.`code` LIKE '%Columbus%' OR `i`.`area` LIKE '%Columbus%' OR `i`.`code` LIKE '%Columbus%' OR `s`.`area` LIKE '%Columbus%' OR `s`.`code` LIKE '%Columbus%' ) AND `u`.`category` = 'Sale'
AND `u`.`dateupdated` > NOW() - INTERVAL 1 WEEK
ORDER BY RAND() DESC LIMIT 0,4
FEATURED PROPERTIES
Featured listings throughout South Africa.
ENGLISH
