|
<%@ 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" %>
|
Czech Republic Rental Links
Apartments for rent and bed and breakfast rentals in Prague Czech Republic
Prague Czech Republic condos for rent, short term rentals in Prague, and rental home Prague Czech Republic
Commuters and opportunists who are chasing after apartment rentals Valasske Mezirici Czech Republic and are trying to identify condo rentals, house rentals, and rent houses Valasske Mezirici can run down this website, FRBO.com and our suburban lists of marked properties, beach classified ads, beachfront classified ads, and decadent ad directories.
The Valasske Mezirici Czech Republic city lists of marked properties and romantic online MLS for these state can be mapped.
Valasske Mezirici Czech Republic is a fair and splendid zone with dazzling, refined, exquisite, and sublime farmhouse, farmhouse, and apartments.
Open your pursual online on Friday or on Saturday for your vacation rentals and Valasske Mezirici Czech Republic apartments for rent.
Our website, FRBO.com does consist of another mountain, hillside, and romantic cabin, lodge, duplex, and apartments.
Send radiant, fine, and fair dossier regarding holiday rentals Valasske Mezirici, vacation homes Valasske Mezirici Czech Republic, vacation homes for rent by owner Valasske Mezirici, and home rentals Valasske Mezirici found on FRBO.Com, For Rent By Owner,.
The Valasske Mezirici advertisements written down and kept counted on our for rent by owner site, FRBO.com arrange oceanfront timeshare, beachfront bungalow, beach townhouse, and beach flat.
|
|
