|
<%@ 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" %>
|
Greece Rental Links
Rent houses in Perdika and real estate rentals Perdika Greece
Mykonos Greece vacation rentals, houses for rent in Mykonos Greece, and rental houses in Mykonos
Ioulis Greece rental homes, home rentals in Ioulis Greece, Ioulis Greece vacation rental, and vacation rentals Ioulis Greece
Exambela Greece vacation rental and apartments for rent in Exambela Greece
Vacation homes for rent by owner in Chora Greece, for rent by owner homes Chora Greece, and condo rentals in Chora
Apartments for rent in Schinias Greece, Schinias house rentals, bed and breakfast rentals in Schinias Greece, and Schinias Greece vacation rental
Condos for rent and real estate rentals in Exambela Greece
Halkidiki Greece rent house, Halkidiki rental apartment, and Halkidiki Greece rental properties
Rent house, Poros homes for rent, Poros Greece rental apartment, and condo rentals in Poros
Home rentals in Attica Greece and Attica Greece houses for rent
Condo rentals, Schinias rental properties, and rental apartment in Schinias Greece
Rent houses Lavrio Greece, real estate rentals in Lavrio Greece, Lavrio Greece rental homes, and vacation homes Lavrio
Hydra vacation homes for rent by owner and homes for rent by owner in Hydra Greece
Pirates and pioneers inquire, go through, and smell around our for rent by owner website and find suburban farmhouse and penthouse condominium.
Lead off your examination online on Thursday or next weekend for your Schinias rent houses, house rentals in Schinias, and Schinias Greece homes for rent by owner.
We constructed, forged, and procreated our page to be marvelous and pleasing.
Come across, find, and come upon for rent by owner homes Serres, Serres Greece rental apartment, and rental properties in Serres Greece.
Generally, cooperate and work for your suburbanites and fortune-hunters to a mod, gorgeous, fair, and leading area.
Elicit and originate Chania bed and breakfast rentals and Chania houses for rent.
Light upon, light upon, and espy vacation rental in Kozani Greece, rental properties in Kozani, and Kozani Greece house rentals.
Conceive and relocate rental apartment and Kavala rental properties.
Devise and notice condo rentals Peristérion and Peristérion rental apartment.
Schinias Greece is a wonderful and fine zone with good-looking, statuesque, ideal, and superb farmhouse and chalets.
Adventurers, passengers, and renters who are frisking homes for rent by owner in Schinias and are trying to identify Schinias Greece apartments for rent, Schinias Greece apartments for rent, and Schinias rental homes can scout our site, FRBO.com and our city ad directories, lake ad directories, hidden directories, and resort classified ads.
Ferret out, detect, and espy condo rentals Kerkira, Kerkira Greece condo rentals, and apartments for rent in Kerkira.
Elicit, distinguish, and distinguish homes for rent in Kozani Greece, vacation homes for rent by owner in Kozani, and rent house Kozani Greece.
Join our spacious lists of marked properties and mountain ads mailing list for Schinias Greece rental properties and real estate rentals Schinias Greece.
|
|
