= 40000 AND annual_rent <= 100000 AND "; }elseif($fldprice_to ==2){ $searchquery .= " annual_rent >= 100000 AND annual_rent <= 150000 AND "; }elseif($fldprice_to ==3){ $searchquery .= " annual_rent >= 150000 AND annual_rent <= 200000 AND "; }else{ //$searchquery .= " annual_rent >= 200000 AND "; $searchquery .= " annual_rent <= $fldprice_to AND "; //rahas } } if($fldpropcity !="") { $searchquery .= " city = '$fldpropcity' AND"; } $searchquery .= " is_active = 'Y' AND is_pending = 'N' AND is_rejected = 'N' ORDER BY modified_on DESC"; } else if(isset($_REQUEST["allhot"])) { $searchquery = "SELECT * FROM property_master WHERE is_active = 'Y' AND is_hot = 'Y' AND is_pending = 'N' AND is_rejected = 'N' ORDER BY modified_on DESC"; } else if(isset($_REQUEST["allbyagent"])) { $fldagentid = $_REQUEST["allbyagent"]; $searchquery = "SELECT * FROM property_master WHERE is_pending = 'N' AND is_active = 'Y' AND is_hot = 'N' AND is_rejected = 'N' AND prop_agent_id = $fldagentid ORDER BY modified_on DESC"; } else if(isset($_POST["btnTopRightSearch_x"])) // Top Right search { $fldsearchterm = trim($_POST["txtkeyterm"]); $searchquery = "SELECT * FROM property_master WHERE prop_name like '%$fldsearchterm%' OR prop_facilities like '%$fldsearchterm%' OR prop_desc like '%$fldsearchterm%' AND is_active = 'Y' AND is_pending = 'N' AND is_rejected = 'N' AND 1 = 1"; } else if(isset($_POST["btnAdvSearch_x"])) // Advance Search { $searchquery = "SELECT * FROM property_master WHERE prop_for_id = '$fldpropertyfor' AND type_ref_id = '$fldprop_type' AND location_ref_id = '$fldlocation' AND development_ref_id = '$flddevelopment' AND no_beds = '$fldselbedrooms' AND prop_price >= '$fldprice_from' AND prop_price <= '$fldprice_to' AND is_active = 'Y' AND is_pending = 'N' AND is_rejected = 'N' AND 1 = 1"; } else if(isset($_POST["btnBuySearch_x"])) // Search Buy prop page { $searchquery = "SELECT * FROM property_master WHERE prop_for_id = 'buy' AND type_ref_id = '$fldprop_type' AND "; if($fldlocation != "") { $searchquery .= " location_ref_id = '$fldlocation' AND"; } $searchquery .= "development_ref_id = '$flddevelopment' AND no_beds = '$fldselbedrooms' AND"; if($fldprice_from != "") { $searchquery .= " prop_price <= '$fldprice_from' AND"; } if($fldprice_to != "") { $searchquery .= " prop_price <= '$fldprice_to' AND"; } $searchquery .= " is_active = 'Y' AND is_pending = 'N' AND is_rejected = 'N' AND 1 = 1"; } else if(isset($_POST["btnRentSearch_x"])) // Search Rent prop page { $searchquery = "SELECT * FROM property_master WHERE prop_for_id = 'rent' AND type_ref_id = '$fldprop_type' AND "; if($fldlocation != "") { $searchquery .= " location_ref_id = '$fldlocation' AND"; } $searchquery .= " development_ref_id = '$flddevelopment' AND no_beds = '$fldselbedrooms' AND "; if($fldprice_from != "") { $searchquery .= " prop_price <= '$fldprice_from' AND"; } if($fldprice_to != "") { $searchquery .= " prop_price <= '$fldprice_to' AND"; } $searchquery .= " is_active = 'Y' AND is_pending = 'N' AND is_rejected = 'N' AND 1 = 1"; } else if($flddevelopment != "") // Search Rent prop page { $searchquery = "SELECT * FROM property_master WHERE development_ref_id = '$flddevelopment' AND is_active = 'Y' AND is_pending = 'N' AND is_rejected = 'N' AND 1 = 1 ORDER BY modified_on DESC"; } else { //echo "BINGO!!!!!!!!"; $searchquery = "SELECT * FROM property_master WHERE is_active = 'Y' AND is_pending = 'N' AND is_rejected = 'N' AND 1 = 1 ORDER BY modified_on DESC "; } //echo "Testing....".$searchquery; $searchresult = mysql_query($searchquery) or die($searchquery.mysql_error()); $searchtot = mysql_num_rows($searchresult); // Paging code $querycount = $searchtot; include_once("include/universal_paging.php"); if($querycount > 0) { //$searchquery = $searchquery." LIMIT $offset,$pages->items_per_page"; $searchquery = $searchquery." LIMIT $offset,20"; } $searchresult = mysql_query($searchquery) or die($searchquery.mysql_error()); $searchtot = mysql_num_rows($searchresult); ?> Dubai Properties | Dubai Real Estate | Dubai Property Agents | Dubai Consultants
    Home > Dubai Rentals
PROPERTY SEARCH RESULT
0) { ?>
0) { for($p=0;$p<$searchtot;$p++) { $searchrow = mysql_fetch_object($searchresult); $fldpropid = trim(stripslashes($searchrow->prop_id)); $fldrefno = trim(stripslashes($searchrow->prop_ref_no)); $fldpropname = trim(stripslashes($searchrow->prop_name)); $flddeveloper = trim(stripslashes($searchrow->developer)); $flddevelopment = trim(stripslashes($searchrow->development)); $fldlocation2 = trim(stripslashes($searchrow->location)); $fldprop_condition = trim(stripslashes($searchrow->prop_condition)); $fldprop_type = trim(stripslashes($searchrow->type_ref_id)); $fldprop_for = trim(stripslashes($searchrow->prop_for_id)); $fldprop_sub_type = trim(stripslashes($searchrow->sub_type)); $fldbedrooms = trim(stripslashes($searchrow->no_beds)); $fldtotalarea = number_format(trim(stripslashes($searchrow->total_area))); $fldview = trim(stripslashes($searchrow->view)); $fldstatus = trim(stripslashes($searchrow->prop_status)); $fldprop_ready_date = trim(stripslashes($searchrow->prop_ready_date)); $fldsellingprice = $searchrow->selling_price; $fldannual_rent = $searchrow->annual_rent; $fldagentid = trim(stripslashes($searchrow->prop_agent_id)); $fldperiod = trim(stripslashes($searchrow->period)); $fldfacilities = trim(stripslashes($searchrow->prop_facilities)); $flddesc = substr(trim(stripslashes($searchrow->prop_desc)),0,250); //$flddesc = trim(stripslashes($searchrow->prop_desc)); $fldmodified = trim(stripslashes($searchrow->modified_on)); $fldlocationname = FindOtherValue("property_location","locid",$fldlocation2,"location_name",$db); $fldprop_type = FindOtherValue("property_type_master","typeid",$fldprop_type,"typename",$db); // Get Agent information $agentquery = "SELECT * FROM agents_master WHERE id = '$fldagentid' LIMIT 0,1"; $agentresult = mysql_query($agentquery) or die($agentquery.mysql_error()); $agenttot = mysql_num_rows($agentresult); if($agenttot > 0) { $agentrow = mysql_fetch_array($agentresult); $fldlagent_name = trim(stripslashes($agentrow["name"])); $fldagent_email = trim(stripslashes($agentrow["email"])); $fldagent_mobile = trim(stripslashes($agentrow["mobile"])); $fldagent_phone = trim(stripslashes($agentrow["phone"])); $fldbrokerid = trim(stripslashes($agentrow["broker_id"])); //if($fldagent_mobile !="") $fldagent_phone = $fldagent_mobile; } else{ // pull admin agent details $agentquery = "SELECT * FROM agents_master WHERE id = 0 LIMIT 0,1"; $agentresult = mysql_query($agentquery) or die($agentquery.mysql_error()); $agenttot = mysql_num_rows($agentresult); if($agenttot > 0) { $agentrow = mysql_fetch_array($agentresult); $fldlagent_name = trim(stripslashes($agentrow["name"])); $fldagent_email = trim(stripslashes($agentrow["email"])); $fldagent_mobile = trim(stripslashes($agentrow["mobile"])); $fldagent_phone = trim(stripslashes($agentrow["phone"])); $fldbrokerid = trim(stripslashes($agentrow["broker_id"])); //if($fldagent_mobile !="") $fldagent_phone = $fldagent_mobile; } } $usd = FindOtherValue("currency","symbol","USD","value",$db); $gbp = FindOtherValue("currency","symbol","GBP","value",$db); $eur = FindOtherValue("currency","symbol","EUR","value",$db); $usdsellingprice = $fldsellingprice * $usd; $usdsellingprice = number_format($usdsellingprice); $gbpsellingprice = $fldsellingprice * $gbp; $gbpsellingprice = number_format($gbpsellingprice); $eursellingprice = $fldsellingprice * $eur; $eursellingprice = number_format($eursellingprice); $usd_annualrent = $fldannual_rent* $usd; $usd_annualrent = number_format($usd_annualrent); $gbp_annualrent = $fldannual_rent * $gbp; $gbp_annualrent = number_format($gbp_annualrent); $eur_annualrent = $fldannual_rent * $eur; $eur_annualrent = number_format($eur_annualrent); $fldsellingprice = number_format($fldsellingprice); $fldannual_rent = number_format($fldannual_rent); //Get Total number of images $num_images = getRecdCount("property_image_master"," WHERE prop_ref_id = '$fldpropid' AND image_for = '$fldprop_for' AND image_type='prop_img'",$db); // Get image $imgquery = "SELECT image_name FROM property_image_master WHERE prop_ref_id = '$fldpropid' AND image_for = '$fldprop_for' LIMIT 0,1"; $imgresult = mysql_query($imgquery) or die($imgquery.mysql_error()); $imgtot = mysql_num_rows($imgresult); if($imgtot > 0) { $fldimagename = mysql_result($imgresult,0,"image_name"); $fldimgpath = $FRONT_PROP_IMGPATH."thumb/".$fldimagename; } ?>
0) { ?>Images:
Ref. No:
[ Date: ]
Property Type: Total Area: Sq. Ft
Location/Area: Bedrooms:
       
Price: AED
USD
GBP
EUR AED
USD
GBP
EUR
   
More Details    Enquire Now
 
No results found!!!
Goto Page:
display_jump_menu();?>
Pages: display_pages();?>