<%@ page import="java.sql.*" %> <%@ page errorPage="showerror.jsp" %>
Prop Chilli India's No.1 Real estate portal Pune, Mumbai, India. New Luxury Residential Projects In Pune, Mumbai, India. Luxury Real Estate Properties Pune, Luxurious Homes, Bungalow in Pune,  Apartments In Mumbai, Pune, India
<%! 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='Pune' 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=90px height="45px"> <%=rs.getString("compnay_name")%>   Pvt.Ltd

Project Detail's

<%=rs.getString("nameOf_project")%> By <%=rs.getString("compnay_name") %>

Total 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("Error"); } %>
Designed & Maintain by AryanTech India Pvt Ltd All Rights Reserved.