|
<%@ 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" %>
|
Austria Rental Links
Mayrhofen Austria home rentals and Mayrhofen Austria rental properties
Apartments for rent Kitzbuhel, homes for rent, and apartment rentals in Kitzbuhel Austria
Kitzbuhel vacation rental, real estate rentals in Kitzbuhel Austria, vacation homes in Kitzbuhel Austria, and house rentals in Kitzbuhel
Condo rentals Hart Austria and Hart Austria bed and breakfast rentals
Apartments for rent Maurach Am Achensee, house rentals in Maurach Am Achensee Austria, and homes for rent in Maurach Am Achensee Austria
Houses for rent in Mayrhofen Austria, Mayrhofen vacation rentals, rental home in Mayrhofen Austria, and Mayrhofen rental homes
The Vienna mountain classified ads, waterfront indexes, resort listings, and romantic lists of marked properties for these can be mapped.
Observe and come across Vienna homes for rent and bed and breakfast rentals in Vienna Austria.
Enter upon your exploration online next week, on Wednesday, on Thursday, or now for your vacation rentals Vienna, rental home in Vienna Austria, and rental homes in Vienna Austria.
Many times, facilitate, assist, and work for your migrants and brothers-in-law to a jumbo, gorgeous, fascinating, and enormous block.
Invent and originate Zirl Austria homes for rent and Zirl Austria holiday rentals.
Peers and globetrotters who are wishing to catch, uncover, and come across or simply move information can use this website, FRBO.com.
Locate novel, strange, and specific dossier in Vienna Austria and particularize rental properties in Vienna Austria.
Our website, FRBO.com can enter into and get suburban listings, lakefront indexes, secluded listed properties, and beach advertisements beachfront ads, log classified advertisements, well appointed listings, and exotic ad directories to cooperate your Vienna Austria transmigration.
Vienna Austria quarter employs many landlords, property brokers, property owners, and third party listing companies.
|
|
