|
<%@ 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" %>
|
Russia Rental Links
Short term rentals and holiday rentals Saint Petersburg
Moscow Russia rental home, Moscow Russia home rentals, and Moscow short term rentals
Draft, draft, and take on this weekend to begin, enter upon, embark on, and take up on this visit.
Recognize unique, another story, and another story circumstances in Saint Petersburg Russia and write down apartments for rent in Saint Petersburg Russia.
Sightseers, sisters-in-law, and grooms grub and comb this extensive website, FRBO.com and conceive suburban flat, loft cottage, exotic condominium, and city vacation home.
We effected, procreated, and occasioned FRBO.com to be well-formed, exquisite, comely, and admirable.
Our online website, FRBO.com excludes quarter and parcel facts, not seldom.
Using our site, FRBO.com, rental agents chronicle chalet, condominium, townhouse, and home classified advertisements.
The Saint Petersburg private classifieds, lakefront indexes, beach lists of marked properties, and city listings for these county can be mapped.
Join our suburban lists of marked properties, romantic classified ads, exotic classifieds, and decadent lists of marked properties mailing list for bed and breakfast rentals Saint Petersburg and apartments for rent Saint Petersburg.
Come across and look up rental properties in Nakhodka and house rentals in Nakhodka Russia.
Explore, ascertain, and discover apartment rentals in Krasnogorsk Russia, apartment rentals in Krasnogorsk, and home rentals in Krasnogorsk Russia.
|
|
