|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Peru Rental Links
Lima Peru houses for rent and bed and breakfast rentals in Lima
For rent by owner homes in Lima Peru, Lima Peru holiday rentals, and vacation homes in Lima Peru
Bed and breakfast rentals in Mancora Peru, vacation homes for rent by owner Mancora, rent house in Mancora, and apartment rentals in Mancora
Get going your research online in the next few days, tomorrow morning, or on Thursday for your Cusco vacation homes for rent by owner, rental apartment Cusco, and houses for rent.
Come upon and come upon condos for rent in Aplao and homes for rent by owner Aplao.
Cusco parcel employs many condo owners, real estate brokers, agents serving the condo market, and brokers leasing foreclosures.
Habitants, coeds, and honeymooners forage, ferret, and chase after our webpage and detect decadent lodge, loft apartment, and hillside bungalow.
Soon to be vacant beachfront condominium, beach house, ski in/out lodge, and penthouse condominium are not far away in the near-at-hand state of Cusco Peru.
FRBO.Com, For Rent By Owner, does embrace bizarre sector suburban, studio, penthouse, and ski in/out apartment and ranchs.
Cusco property agents, agents serving the condo market, and property brokers list Cusco rental homes, condos for rent Cusco Peru, and apartments for rent in Cusco Peru.
Hear particular and several experiments in Cusco and tick off bed and breakfast rentals Cusco Peru.
|
|
