|
<%@ 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" %>
|
Germany Rental Links
Bayerisch Eisenstein apartment rentals and Bayerisch Eisenstein Germany vacation homes
Short term rentals in Gengenbach Germany, bed and breakfast rentals Gengenbach Germany, and holiday rentals in Gengenbach
Short term rentals in Cologne, home rentals in Cologne Germany, condo rentals Cologne, and Cologne Germany vacation homes for rent by owner
Condo rentals in Gengenbach and condos for rent in Gengenbach Germany
Vacation rentals Gengenbach Germany, Gengenbach Germany vacation rentals, and Gengenbach Germany rent houses
Rental apartment in Hamburg, vacation rental, vacation rentals in Hamburg, and vacation rental Hamburg Germany
For rent by owner homes in Munich Germany and Munich Germany vacation homes for rent by owner
Rental homes Munich Germany, Munich Germany rental home, and rent house Munich
Vacation homes for rent by owner, houses for rent Cologne Germany, Cologne Germany real estate rentals, and apartment rentals Cologne
Our for rent by owner website can reserve and recruit penthouse classified advertisements, suburban indexes, exclusive listings, and decadent classified ads log classified advertisements, lake indexes, well appointed listings, and mountain classified advertisements to open doors your Dresden peregrination.
The Dresden Germany resort ad directories, loft listings, and beach directories for these locality can be mapped.
Intermittently, ride shotgun and sustain your co-workers, householders, and traveling agents to a accepted, lovely, jumbo, and trendy domain.
You can smell around the mountain classified advertisements, suburban classifieds, private classified ads, and penthouse listed properties under holiday rentals in Dresden Germany and Dresden real estate rentals.
Disclose and dig up condos for rent in Schwieberdingen Germany and for rent by owner homes Schwieberdingen.
Find, light upon, and devise vacation rental Darmstadt Germany, apartment rentals, and Darmstadt Germany vacation rentals.
Design and ferret out vacation rentals Essen Germany and Essen vacation rentals.
Our website, FRBO.com consist ofs turf, quarter, and parcel evidence, oftentimes.
Kick off your investigation online this weekend, this week, on Sunday, or on Saturday for your rent house in Dresden Germany, rental houses Dresden, and condo rentals Dresden Germany.
Adventurers and commuters who are looking over Dresden Germany condos for rent and are trying to debunk real estate rentals in Dresden Germany, houses for rent in Dresden Germany, and Dresden Germany vacation homes can look for this extensive website, FRBO.com and our city online MLS and secluded lists of marked properties.
Explore, notice, and originate vacation rentals in Rathenow Germany, homes for rent by owner in Rathenow Germany, and Rathenow Germany rental houses.
You can debunk, design, and notice Dresden vacation homes for rent by owner and Dresden Germany vacation rental.
Debunk, detect, and devise Gross-Zimmern Germany for rent by owner homes, Gross-Zimmern homes for rent by owner, and apartments for rent in Gross-Zimmern Germany.
|
|
