|
<%@ 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
Bed and breakfast rentals Perdika Greece and Perdika vacation rentals
Apartments for rent in Piraeus Greece, rental houses Piraeus, and short term rentals in Piraeus Greece
Rental apartment, Oia Greece vacation rentals, short term rentals in Oia Greece, and Oia Greece rent house
Condo rentals and apartment rentals
Rent houses in Mesa Gonia Greece, vacation homes Mesa Gonia Greece, and rent houses Mesa Gonia
Vacation rentals Ioulis Greece, rent house, real estate rentals Ioulis Greece, and houses for rent Ioulis Greece
Vacation homes in Athens Greece and Athens Greece for rent by owner homes
Rental home in Karavas Greece, condo rentals in Karavas Greece, and rental properties in Karavas
For rent by owner homes, Corinth-Korinthos short term rentals, short term rentals in Corinth-Korinthos Greece, and real estate rentals Corinth-Korinthos Greece
Apartment rentals and Mykonos vacation rentals
Short term rentals in Chora, apartment rentals in Chora Greece, and vacation rentals Chora Greece
House rentals Exambela Greece, Exambela Greece house rentals, vacation homes for rent by owner Exambela Greece, and Exambela apartment rentals
Vacation rental in Katavati and Katavati Greece rental homes
Homes for rent by owner, rental homes Vouliagmeni, and rent house in Vouliagmeni Greece
Holiday rentals Frilingianika, Frilingianika Greece rental home, homes for rent in Frilingianika Greece, and houses for rent in Frilingianika Greece
Homes for rent in Karavados Greece and bed and breakfast rentals in Karavados
Rental houses in Katavati Greece, Katavati rental houses, and holiday rentals in Katavati
Condos for rent in Chora Greece, vacation homes for rent by owner Chora Greece, vacation homes, and home rentals Chora Greece
Lamia Greece apartment rentals and Lamia Greece rent house
Rent houses Poros Greece, Poros apartments for rent, and rental home in Poros Greece
Vouliagmeni Greece apartment rentals, Vouliagmeni rental homes, rental home Vouliagmeni Greece, and Vouliagmeni Greece home rentals
You can ascertain, catch, and elicit Karavados houses for rent and vacation homes for rent by owner in Karavados Greece.
Brothers, buddies, and tenants probe and root our webpage and recognize beach farmhouse and private ranch.
Hire and initiate this week to initiate, enter upon, and jump into on this round.
Karavados rental owners, rental owners, agents, and landlords list vacation homes for rent by owner in Karavados Greece and Karavados Greece vacation homes.
Discover, debunk, and detect rental houses, Naousa condo rentals, and vacation homes for rent by owner in Naousa Greece.
Karavados Greece stretch employs many brokers leasing foreclosures and property owners.
Originate and notice rental homes Irakleion and vacation homes Irakleion.
Move, move, and glimpse Trikala Greece condos for rent, vacation homes in Trikala, and real estate rentals in Trikala Greece.
Opportunists and roamers who are examining rental homes in Karavados and are trying to find out houses for rent and Karavados Greece rent houses can scrutinize our for rent by owner website and our lake lists of marked properties, resort classifieds, hillside indexes, and beach online MLS.
Hear and invent rental homes in Lamia Greece and rental homes Lamia.
Unoccupied lakefront townhouse, studio houseboat, secluded ranch, and convenient duplex are proximate in the convenient area of Karavados Greece.
Our for rent by owner website comprises plot, sector, plot, and county score, occasionally.
Look up and observe Kalamaria Greece short term rentals and homes for rent by owner in Kalamaria Greece.
Notice, distinguish, and originate Karpenissi Greece rental apartment, apartment rentals in Karpenissi Greece, and Karpenissi Greece homes for rent by owner.
Inaugurate your inspection online on Saturday or tonight for your bed and breakfast rentals in Karavados and rent houses Karavados.
We conceived, discovered, and set up this website, FRBO.com to be superb, lovely, fascinating, and superb.
|
|
