<%@ include file="header.jsp"%> Properties in Pune|Pune Real_Estate|Flat in Pune|Pune Real_Estate|Property Sale|Property Rent <%@ page import="java.sql.*" %> <%@ page errorPage="showerror.jsp" %>
<%! Connection con=null; PreparedStatement pst=null; ResultSet rs=null; %> <% try { Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://203.124.98.175:3306/newschema","root","aryantechpropdb"); } catch(Exception ex) { out.println("Connection problem is"+ex.getMessage()); } try { String city1="pune"; String city2="Pune"; String qry="select p1.postproperty_id,p1.propertytype_id,p1.nameOf_project,p1.descrip,p1.tra_type,p1.tot_price,p1.per_unit_price,p1.unit_pup,p1.city,p1.locality,b1.compnay_name,b1.user_id from tbl_post_basic p1,tbl_agent_builder b1 where p1.city='chennai' and p1.user_id=b1.user_id and b1.user_type='Builder' "; pst=con.prepareStatement(qry); ResultSet rs=pst.executeQuery(); if(!rs.next()) { %>
Property Report
Sorry!..No Property Listed in this city..
Regards Prochilli.com
<% } else { do { //String qry1="select tbl_agent_builder p1.user_id=b1.user_id"; int id=rs.getInt("user_id"); // out.println("user id"+id); %>
" width=110px height="45px"> <%=rs.getString("compnay_name")%>   

<%=rs.getString("nameOf_project")%>  <%=rs.getString("city")%>  <%=rs.getString("locality")%>
Project Name:<%=rs.getString("nameOf_project")%> By <%=rs.getString("compnay_name") %>
Starting Price:  <%=rs.getString("tot_price")%>  
price per sqft range:
  <%=rs.getInt("per_unit_price")%>. <%=rs.getString("unit_pup") %>.
Property Type:<%=rs.getString("propertytype_id") %>     

Get Detail's...

<% }while(rs.next()); } } catch(Exception e) { out.println("reeor"+e.getMessage()); } finally { if(con!=null) { con.close(); } if(rs!=null) { rs.close(); } if(pst!=null) { pst.close(); } } %>
Designed & Maintain by AryanTech India Pvt Ltd All Rights Reserved.