='".date("Y-m-d")."'"; if($l_type!="any" and $l_type!=""){ $sql.=" and p.l_type='$l_type'"; } if($id_p_type!="any" and $id_p_type!=""){ $sql.=" and p.id_p_type='$id_p_type'"; } if($is_sold!="any" and $is_sold!=""){ $sql.=" and is_sold='$is_sold'"; } if($price_from>0 and $price_from!=""){ $sql.=" and p.price>='$price_from'"; } if($price_to>0 and $price_to!=""){ $sql.=" and p.price<='$price_to'"; } if($bed!="any" and $bed!=""){ $sql.=" and p.bed>='$bed'"; } if($bath!="any" and $bath!=""){ $sql.=" and p.bath>='$bath'"; } if(isset($id_prov) and $id_prov!="any"){ $sql.=" and p.id_prov='$id_prov'"; } if(isset($id_area) and $id_area!="any"){ $sql.=" and p.id_area='$id_area'"; } if(isset($town_suburb) and $id_town!="any"){ $id_t_s = explode("_", $town_suburb); $id = $id_t_s[1]; $t_s = $id_t_s[0]; switch($t_s){ case "town": $sql.=" and p.id_town='$id'"; break; case "suburb": $sql.=" and p.id_suburb='$id'"; break; } } if(isset($id_town) and $id_town!="any"){ $sql.=" and p.id_town='$id_town'"; } if(isset($id_suburb) and $id_suburb!="any"){ $sql.=" and p.id_suburb='$id_suburb'"; } if(!isset($order_ord) or $order_ord==""){ $order_ord="ASC"; } if(!isset($order) or $order==""){ $order="p.price"; } $sql.=" order by p.is_premium desc, ".$order." ".$order_ord; session_register('session_search_sql'); $_SESSION['session_search_sql']=$sql; session_register('session_display_nr'); $_SESSION['session_display_nr']=$display_nr; $sql_search=$sql; include("listing_list.php"); include($dir."fsearch.php"); exit; }elseif(isset($page) && $_SESSION['session_search_sql']!=""){ $sql_search=$_SESSION['session_search_sql']; $display_nr=$_SESSION['session_display_nr']; include($dir."listing_list.php"); include($dir."fsearch.php"); exit; }elseif(isset($ref_nr) and $ref_nr!=""){ include($dir."listing_list.php"); include($dir."fsearch.php"); exit; } ?>
0){ $sqla = "select * from prov where id_prov='$id_prov'"; $rsa = mysql_query($sqla); if($rowa = mysql_fetch_array($rsa)){ if(trim($rowa["jcode"])!=""){ $jcode = $rowa["jcode"];} if(trim($rowa["jcodev"])!=""){ $jcodev = $rowa["jcodev"];} if(trim($rowa["jcodeh"])!=""){ $jcodeh = $rowa["jcodeh"];} } } //select banners for area if(isset($id_area) and $id_area>0){ $sqla = "select * from area where id_area='$id_area'"; $rsa = mysql_query($sqla); if($rowa = mysql_fetch_array($rsa)){ if(trim($rowa["jcode"])!=""){ $jcode = $rowa["jcode"];} if(trim($rowa["jcodev"])!=""){ $jcodev = $rowa["jcodev"];} if(trim($rowa["jcodeh"])!=""){ $jcodeh = $rowa["jcodeh"];} } } if(isset($jcode) and trim($jcode)!=""){ ?>


Search Property for Sale in South Africa at Private Sale

Select one or more property search options to narrow your classified house ad search. By entering specific property search criteria we can direct you to the classified ads that will meet your desired specifications.