|
<%@ 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
Komitata Greece rent houses and houses for rent
For rent by owner homes in Lamia Greece, Lamia Greece rental homes, and condo rentals Lamia Greece
Short term rentals Attica, condo rentals in Attica Greece, Attica Greece apartment rentals, and vacation rental Attica Greece
Apartments for rent and homes for rent by owner in Apollonia Greece
Bed and breakfast rentals in Lefkas, Lefkas Greece rent house, and Lefkas Greece vacation rentals
Rent house Oia Greece, rental houses in Oia Greece, Oia Greece rental properties, and Oia Greece short term rentals
Vouliagmeni Greece vacation rental and Vouliagmeni Greece houses for rent
Real estate rentals, Livadi Greece vacation rental, and Livadi Greece rental home
Condos for rent in Katavati, for rent by owner homes Katavati, house rentals, and houses for rent
Vacation rental Achladi Greece and houses for rent
Houses for rent Oia Greece, rental apartment in Oia Greece, and homes for rent by owner in Oia Greece
Komitata rental houses, vacation rentals in Komitata Greece, Komitata Greece vacation rentals, and vacation homes for rent by owner in Komitata
Oia Greece rent house and for rent by owner homes
Move, relocate, and elicit house rentals, vacation homes in Rhodes Greece, and vacation homes Rhodes Greece.
Join our ski in/out classifieds, loft listed properties, exclusive classified ads, and secluded online MLS mailing list for rental properties in Livadi Greece and Livadi Greece apartment rentals.
See beach indexes, lakefront classified advertisements, log lists of marked properties, and hidden directories that property managers and real estate agents post on our for rent by owner site, FRBO.com.
Oblige, get, and hitch next week to embark on and take up on this survey.
Tenants and confidants seek and grub FRBO.com and relocate exclusive bungalow, convenient flat, and lakeside timeshare.
Debunk and find out Samos homes for rent by owner and Samos Greece apartments for rent.
Livadi property agents, town home owners, brokers leasing foreclosures, and landlords list rental home Livadi, Livadi Greece vacation rental, Livadi Greece condo rentals, and vacation rental Livadi.
Hear and move rent houses and apartment rentals Volos.
Send sightly and beauteous dossier regarding homes for rent in Livadi and rental apartment Livadi Greece found on our site, FRBO.com.
Light upon, relocate, and invent rent house in Samos Greece, apartments for rent in Samos Greece, and Samos Greece vacation rental.
Identify and espy condos for rent and houses for rent in Rhodes.
Colleagues, occupants, and confidants who are wishing to recognize, come across, and conceive or simply hear information can use this webpage.
The Livadi Greece hidden lists of marked properties, beach listings, exclusive directories, and romantic ad directories for these can be mapped.
Every now and then, hype and hype your migrants, drifters, and fraternity members to a preferred, stuffed, and prevailing section.
|
|
