|
<%@ 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
For rent by owner homes in Zakynthos Greece and rent houses Zakynthos
House rentals Halkidiki Greece, rental apartment in Halkidiki Greece, and apartments for rent in Halkidiki
Chora rental home, Chora Greece vacation rental, condo rentals Chora Greece, and holiday rentals in Chora
Vacation homes in Aghia and Aghia Greece condos for rent
Homes for rent Zakynthos, Zakynthos rental home, and Zakynthos Greece rental home
Rental home Lamia Greece, homes for rent by owner in Lamia Greece, vacation rentals in Lamia Greece, and Lamia Greece holiday rentals
Rent house in Livadi Greece and Livadi Greece homes for rent by owner
Holiday rentals in Exambela Greece, vacation homes Exambela, and condos for rent
Vacation homes in Lavrio Greece, real estate rentals Lavrio Greece, rental properties, and Lavrio apartments for rent
Chora Greece rental houses and Chora Greece rental apartment
Vacation rentals in Lamia Greece, Lamia Greece apartments for rent, and Lamia Greece real estate rentals
Corinth-Korinthos Greece rent houses, rental apartment Corinth-Korinthos Greece, home rentals, and rental homes
Apartment rentals in Zakynthos and Zakynthos Greece rent house
Mesa Gonia Greece bed and breakfast rentals, rental home, and rental home in Mesa Gonia Greece
Aghia Greece vacation homes for rent by owner, condo rentals in Aghia Greece, Aghia Greece holiday rentals, and rental properties Aghia
Condos for rent and rental apartment
Vacation homes for rent by owner Lamia Greece, rental home in Lamia Greece, and Lamia Greece real estate rentals
Rental properties Hydra Greece, vacation homes in Hydra Greece, Hydra Greece rent house, and vacation homes in Hydra Greece
Rental homes and homes for rent by owner in Lefkas Greece
Short term rentals in Perdika, Perdika Greece rental home, and Perdika Greece holiday rentals
Piraeus Greece rent house, Piraeus rent houses, Piraeus Greece for rent by owner homes, and Piraeus homes for rent by owner
Apollonia Greece rent house and Apollonia Greece vacation homes for rent by owner
Real estate rentals Komitata, holiday rentals Komitata, and for rent by owner homes in Komitata Greece
Traveling saleswomen and locals frisk and inquire our webpage and find studio vacation home, resort home, and city hacienda.
Skiathos Greece tract employs many brokers leasing foreclosures, third party listing companies, property managers, and rental agents.
Migrants and honeymooners who are wishing to ferret out and invent or simply move information can use our for rent by owner website.
See romantic classified ads, beach listings, romantic ad directories, and rustic lists of marked properties that rental owners and property brokers post on our site, FRBO.com.
The Skiathos Greece lists of marked properties inventoried and classified on our online website, FRBO.com comprehend lakeside hacienda, resort bungalow, private townhouse, and convenient house.
Invent and disclose Katerini Greece vacation rentals and vacation rentals Katerini Greece.
Using this site, For Rent By Owner (FRBO.com), property brokers itemize chalet and duplex ads.
Join our beachfront listings, secluded listed properties, oceanfront online MLS, and resort online MLS mailing list for houses for rent in Skiathos Greece and Skiathos Greece vacation homes for rent by owner.
Espy and discover Agria Greece homes for rent by owner and Agria real estate rentals.
Learn, detect, and design bed and breakfast rentals in Athens Greece, Athens holiday rentals, and Athens bed and breakfast rentals.
Light upon, move, and find out holiday rentals in Tripolis Greece, condo rentals, and homes for rent in Tripolis Greece.
Skiathos Greece input could collaborate and facilitate your wild-goose chase.
This site, FRBO.com does accommodate some tract secluded, loft, waterfront, and beach timeshare, timeshare, and vacation homes.
Send ravishing, superb, and splendid results regarding rental home in Skiathos Greece, real estate rentals in Skiathos Greece, rental homes in Skiathos Greece, and Skiathos Greece rent houses found on our page.
Identify, recognize, and uncover Serres Greece rent houses, for rent by owner homes in Serres Greece, and apartment rentals Serres Greece.
Espy and light upon homes for rent by owner Patras and apartments for rent.
Disclose and hear Souda Greece homes for rent and homes for rent.
|
|
