EAAP

'0') { while($a2 = mysql_fetch_array($r2)) { $listcat.=" $a2[SubcategoryName] "; }} $SelectCategory = "\n"; $Selectarea = "\n"; $CityMenu = "\n"; $news=""; $q1 = "select * from re2_news where active='Y' order by newsid desc "; $r1 = mysql_query($q1) or die(mysql_error()); if(mysql_num_rows($r1) >0) { while($a1 = mysql_fetch_array($r1)) { $news.="".$a1[newstitle].""."
".$a1[description]."

"; } } $q1 = "select * from re2_listings order by ListingID DESC limit 0, 10 "; $qnav = "select * from re2_listings, re2_agents where re2_listings.AgentID = re2_agents.AgentID $MyQuery"; $r1 = mysql_query($q1) or die(mysql_error()); $lrows = mysql_num_rows($r1); if($lrows > '0') { $ListingTable .= "\n"; while($a1 = mysql_fetch_array($r1)) { //echo "

";
	//print_r($a1);
	$q2 = "select * from re2_area where areaid = '$a1[areaid]' ";
$r2 = mysql_query($q2) or die(mysql_error());
$a2 = mysql_fetch_array($r2);
		$ListingTable .= "

";
		
		
		
		if($a1[CategoryID]=='3')
		{
			$catnm = "For Sale";
		}
		if($a1[CategoryID]=='4')
		{
			$catnm = "For Rent";
		}
		if($a1[CategoryID]=='5')
		{
			$catnm = "Both";
		}
		if($a1[PriorityLevel] > '1')
		{
			$sub = "$a1[PriorityName]";
		}

		$ListingTable .= "

";

		$ListingTable .= "

";
		//$ListingTable .= "

\n\t";
		//$ListingTable .= "

";
		$ListingTable .= "

";

	}

	$ListingTable .= "

"; if(!empty($a1[image])) { //$ListingTable .= "

"; } $ListingTable .= "

$a2[areaname]$sub

$catnm

$a1[rooms] br, $a1[bathrooms] ba"; $MyPrice = number_format($a1[Price], 2, ".", ","); $ListingTable .= "

$MyPrice INR

";
}
		
$submsg="";	
if($_REQUEST['Submit']=="Subscribe Me"){
	if($_REQUEST['subscribemail']!=""){
	$mail=$_REQUEST['subscribemail'];
	
	 $qsubmail = "select * from re2_subscribe where mail = '$mail'";
	$rsubmail = mysql_query($qsubmail) or die(mysql_error());

	if(mysql_num_rows($rsubmail) == '1')
	{
		$submsg="You have already subscribe.";
	}else{
	
		$todays=date("Y-m-d");
		$subinsert="insert into re2_subscribe values ('','$mail','$todays')";
		mysql_query($subinsert)or die(mysql_error());
		$submsg="Subscribe Successfully! ";
	}
}

}
	
	$qpath = "select * from featuredagaentpath  where status='Active'";
	$rpath = mysql_query($qpath) or die(mysql_error());
$flg=0;
if(mysql_num_rows($rpath) == '1')
{
	$apath = mysql_fetch_array($rpath);	
	$path=$apath['path'];
	$flg=1;
}else{
	$flg=0;
}	
?>










EAAP






	










  
  
      
      
    
    
      
      
      
      
      
      
      
      
      
      
    
      
        
         
          
            
              
             
               
Welcome!
			
			
			
            
    
	
    
  
  
    
      
        Username:
        
           
      
      
        Password:
        
      
      
        

		
          
        
      
         
        
    
  
  
     Forgot Password 
  
  
    
  
	
             
              
            
			
			
  
            
			
			  
			    Subscribe for Newsletter
				
				
				
				
				 

			    
            
            

              
              
                
                  
                  
    
          
             
              Property Search
                    I want to*: 
                     For Sell  For Rent  Both 
                    Search Property by Id 
Search Agent by Area 
Advanced Search
                    
                   
                    Area:
                              
                  
                   
                    Budget Between Rs:
                      To    
                    
                  
                   
                     
                    
                    
                  
                  
            
          
        
      
  
				 
                
              
              
            
              
                  Newly Added Projects

Developed, Designed & Programmed by Mangesh & Vidya for Skymac Technologies