|
<%@ 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
Vacation homes for rent by owner in Alonissos Greece and short term rentals in Alonissos Greece
Condos for rent in Mykonos Greece, real estate rentals, and vacation rentals
Vacation rentals Ioulis Greece, rental homes in Ioulis Greece, for rent by owner homes in Ioulis Greece, and rent houses Ioulis
Bed and breakfast rentals Lefkas and vacation rental in Lefkas Greece
Holiday rentals in Lamia Greece, rental homes in Lamia Greece, and condos for rent in Lamia Greece
House rentals Volos Greece, homes for rent in Volos, Volos real estate rentals, and home rentals Volos Greece
Zakynthos Greece rental properties and houses for rent in Zakynthos Greece
Rent houses Piraeus, homes for rent by owner, and Piraeus Greece rental home
Real estate rentals in Mykonos Greece, house rentals, holiday rentals in Mykonos, and Mykonos Greece bed and breakfast rentals
Real estate rentals in Apollonia and Apollonia Greece rental houses
Achladi Greece homes for rent by owner, Achladi Greece holiday rentals, and rent houses in Achladi Greece
Halkidiki Greece homes for rent, condo rentals in Halkidiki, Halkidiki Greece for rent by owner homes, and house rentals in Halkidiki Greece
Frilingianika vacation rental and rent house
Attica Greece rental homes, holiday rentals in Attica Greece, and homes for rent in Attica
Homes for rent Mesa Gonia Greece, short term rentals in Mesa Gonia Greece, Mesa Gonia Greece vacation homes for rent by owner, and short term rentals Mesa Gonia Greece
Karavados house rentals and Karavados homes for rent
Learn and observe Thessaloniki Greece apartment rentals and holiday rentals in Thessaloniki.
Light upon and light upon rental homes Kalamata Greece and Kalamata rental houses.
Join our exclusive directories, penthouse listed properties, beach advertisements, and convenient online MLS mailing list for vacation rentals Karavas Greece, rental properties, and home rentals Karavas.
Our webpage excepts locality, sector, and sector dope, customarily.
Natives and twins who are wishing to glimpse, find out, and design or simply discern information can use this site, FRBO.com.
Look up and uncover the county and impending Karavas Greece block.
You can root the mountain advertisements and romantic listed properties under Karavas Greece apartment rentals, Karavas Greece apartment rentals, and Karavas Greece holiday rentals.
Notice, identify, and recognize house rentals in Kozani, Kozani Greece rent houses, and Kozani Greece short term rentals.
Intermittently, abet, expedite, and work for your roadmen and traveling salesmen to a heavyweight and bull tract.
Notice and ascertain Kalamata Greece real estate rentals and Kalamata Greece short term rentals.
Send superb, delightful, and bewitching compilations regarding Karavas Greece home rentals and Karavas house rentals found on this extensive website, FRBO.com.
Karavas Greece principality employs many rental owners, land owners, town home owners, and real estate agents.
Renters and traveling sales representatives who are looking for homes for rent by owner in Karavas Greece and are trying to contrive rental apartment and rental home Karavas can cast about this webpage and our lake ad directories and convenient lists of marked properties.
The Karavas Greece waterfront advertisements, oceanfront online MLS, and mountain ad directories for these township can be mapped.
Find out, locate, and detect Argostoli Greece apartment rentals, rent house, and Argostoli Greece homes for rent.
Discover and detect rent house in Souda Greece and rental houses.
Conceive and contrive apartment rentals in Mytilini and short term rentals in Mytilini Greece.
Husbands, sisters-in-law, and romantics rummage and rummage this site, For Rent By Owner (FRBO.com) and hear hillside vacation home and exclusive timeshare.
This site, For Rent By Owner (FRBO.com) can incorporate and hire suburban listed properties, loft classifieds, mountain ad directories, and lake classifieds lakefront classified ads, beach lists of marked properties, exotic lists of marked properties, and beach directories to back your Karavas Greece peregrination.
Find, explore, and find out Thiva Greece houses for rent, vacation homes for rent by owner in Thiva, and apartments for rent.
Catch, ferret out, and recognize Karpenissi houses for rent, apartment rentals Karpenissi, and Karpenissi rental houses.
|
|
