|
<%@ 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
Rental apartment and rental homes in Skiathos Greece
Bed and breakfast rentals Chora, Chora Greece condos for rent, and rent houses
Skopelos Greece houses for rent, Skopelos condos for rent, rent house, and homes for rent Skopelos
Skiathos Greece rental homes and house rentals
Vacation homes, Corfu home rentals, and short term rentals Corfu Greece
Oia condos for rent, rental properties in Oia, bed and breakfast rentals Oia Greece, and Oia vacation rentals
Ioulis Greece for rent by owner homes and short term rentals
Vacation rentals in Vouliagmeni Greece, Vouliagmeni Greece rent houses, and Vouliagmeni Greece vacation rentals
Homes for rent by owner, Apollonia vacation homes for rent by owner, Apollonia Greece bed and breakfast rentals, and apartments for rent in Apollonia Greece
Rental houses and rent house
Perdika rental home, rental houses Perdika, and Perdika Greece houses for rent
Vacation homes Mykonos Greece, condo rentals in Mykonos, houses for rent Mykonos, and Mykonos Greece short term rentals
Rental properties and holiday rentals in Skiathos Greece
Vacation homes for rent by owner in Skopelos Greece, rent house in Skopelos, and Skopelos Greece homes for rent
House rentals in Chora, houses for rent, rental home in Chora Greece, and bed and breakfast rentals in Chora Greece
Mesa Gonia property brokers, rental agents, condo owners, and agents list Mesa Gonia Greece rental apartment and Mesa Gonia rental apartment.
Mesa Gonia Greece is a admirable, beauteous, refined, and comely field with exquisite and splendid house, ranch, cottage, and townhouses.
See city listings, romantic classified ads, convenient indexes, and mountain lists of marked properties that town home owners and condo owners post on this site, For Rent By Owner (FRBO.com).
Discern and move rental houses in Kissamos and bed and breakfast rentals Kissamos.
Come upon and originate bed and breakfast rentals Piraeus Greece and Piraeus Greece bed and breakfast rentals.
Roamers and colleagues who are running down Mesa Gonia Greece rent houses and are trying to learn Mesa Gonia Greece rental properties and real estate rentals Mesa Gonia Greece can root this extensive website, FRBO.com and our lakeside indexes, exotic classifieds, lakefront listings, and exotic online MLS.
Find, identify, and determine rent house in Navplion, rental homes in Navplion, and rental home in Navplion Greece.
Move, look up, and elicit holiday rentals Kerkira Greece, real estate rentals Kerkira, and homes for rent in Kerkira Greece.
You can forage the studio ads, resort ads, and lakefront directories under Mesa Gonia bed and breakfast rentals and real estate rentals Mesa Gonia.
You can identify, elicit, and uncover apartment rentals in Mesa Gonia Greece and condo rentals in Mesa Gonia Greece.
This extensive website, FRBO.com can enroll, enroll, and enroll hidden classifieds and exotic advertisements convenient listings and mountain classified advertisements to ballyhoo your Mesa Gonia Greece tramp.
Conceive, explore, and uncover real estate rentals in Naousa Greece, rental apartment in Naousa Greece, and real estate rentals in Naousa.
|
|
