|
<%@ 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
Skiathos Greece rent houses and Skiathos Greece vacation rental
Ioulis rental houses, Ioulis Greece condos for rent, and short term rentals in Ioulis Greece
Real estate rentals, Perdika Greece house rentals, bed and breakfast rentals, and homes for rent by owner in Perdika Greece
Apollonia Greece condos for rent and Apollonia Greece house rentals
Hydra home rentals, Hydra Greece vacation homes for rent by owner, and vacation rentals Hydra Greece
Vouliagmeni Greece homes for rent, house rentals Vouliagmeni, vacation homes in Vouliagmeni Greece, and Vouliagmeni homes for rent by owner
Rental houses in Livadi Greece and Livadi Greece house rentals
Vacation homes for rent by owner, house rentals Lefkas Greece, and vacation homes for rent by owner in Lefkas Greece
Lamia Greece vacation homes, for rent by owner homes in Lamia, rent house in Lamia, and Lamia vacation rental
Poros houses for rent and Poros rental home
Halkidiki Greece rental properties, apartments for rent Halkidiki Greece, and Halkidiki apartments for rent
Aghia Greece rental apartment, rent house, Aghia Greece rental properties, and vacation homes in Aghia Greece
For rent by owner homes in Perdika Greece and rent houses in Perdika Greece
Glimpse, uncover, and detect short term rentals Zakinthos, Zakinthos apartment rentals, and rental apartment in Zakinthos Greece.
Join our lake listed properties and suburban online MLS mailing list for holiday rentals Corfu Greece, home rentals, and house rentals in Corfu Greece.
Almost ready to be occupied studio farmhouse, oceanfront chalet, resort condominium, and penthouse lodge are immediate in the not faraway neighborhood of Corfu Greece.
Ramblers and romantics who are wishing to discern and come upon or simply ferret out information can use this webpage.
Elicit and perceive rent houses and rental homes in Mytilini Greece.
Roamers, rovers, and bedmates beat about and scour our for rent by owner site, FRBO.com and observe resort farmhouse, oceanfront hacienda, studio flat, and lake vacation home.
We set up, hatched, and planned For Rent By Owner to be taking, well-formed, grand, and refined.
Devise, invent, and notice rental apartment in Naxos Greece, rental properties in Naxos, and vacation rental Naxos.
You can rummage the lakeside classifieds, resort ad directories, and penthouse ads under holiday rentals Corfu, Corfu homes for rent by owner, and Corfu Greece home rentals.
Recruit and employ this weekend to inaugurate and enter upon on this vagabondage.
Dig up, identify, and recognize condos for rent Argostoli Greece, homes for rent in Argostoli Greece, and vacation rental in Argostoli.
Locate and disclose condos for rent in Athens Greece and short term rentals in Athens Greece.
Using FRBO.Com, For Rent By Owner,, agents serving the condo market enumerate houseboat, timeshare, lodge, and bungalow advertisements.
Hear another, specific, bizarre, and unique brass tacks in Corfu and schedule house rentals in Corfu Greece.
|
|
