|
<%@ 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
Condos for rent and holiday rentals in Corinth-Korinthos Greece
Rent house in Chora, vacation homes Chora, and real estate rentals Chora Greece
Bed and breakfast rentals Karavados Greece, Karavados rent houses, Karavados Greece vacation rental, and for rent by owner homes
Frilingianika Greece home rentals and homes for rent in Frilingianika Greece
Apartment rentals in Alonissos, Alonissos bed and breakfast rentals, and vacation rental Alonissos
Ioulis Greece bed and breakfast rentals, for rent by owner homes Ioulis, vacation homes for rent by owner Ioulis Greece, and Ioulis Greece homes for rent by owner
Zakynthos Greece home rentals and Zakynthos Greece rent houses
Houses for rent, Hania Greece rent houses, and vacation homes for rent by owner in Hania Greece
Vacation rental Alonissos, short term rentals Alonissos Greece, Alonissos rental properties, and holiday rentals in Alonissos Greece
Skiathos Greece rent house and rent house
Attica rent houses, rent houses in Attica Greece, and apartments for rent in Attica Greece
Homes for rent in Zakynthos Greece, Zakynthos Greece homes for rent, Zakynthos Greece rental houses, and Zakynthos rent house
Oia apartments for rent and apartments for rent Oia Greece
Vacation homes for rent by owner Karavados, condos for rent Karavados Greece, and Karavados Greece rental properties
Mykonos rent houses, rental homes Mykonos Greece, Mykonos Greece house rentals, and Mykonos Greece rental home
Real estate rentals and Corfu rental home
Short term rentals in Lamia Greece, rental properties in Lamia Greece, and condos for rent in Lamia Greece
Attica homes for rent, Attica Greece holiday rentals, vacation rentals in Attica Greece, and homes for rent in Attica Greece
Rental apartment in Piraeus Greece and homes for rent Piraeus
Vacation rental in Zakynthos Greece, rental houses in Zakynthos Greece, and rent houses in Zakynthos Greece
Short term rentals in Exambela, Exambela Greece short term rentals, Exambela house rentals, and Exambela Greece vacation homes
Vouliagmeni condo rentals and homes for rent by owner Vouliagmeni Greece
Karavados rental homes, apartment rentals in Karavados Greece, and condos for rent in Karavados Greece
Perdika Greece condo rentals, homes for rent by owner in Perdika Greece, Perdika holiday rentals, and bed and breakfast rentals Perdika
Home rentals Vouliagmeni and Vouliagmeni Greece homes for rent by owner
Mykonos rental properties, apartments for rent Mykonos, and Mykonos homes for rent
Achladi for rent by owner homes, Achladi rent house, condos for rent in Achladi, and rental home
House rentals in Aghia Greece and Aghia Greece apartment rentals
Corinth-Korinthos Greece rent houses, vacation rental in Corinth-Korinthos Greece, and rental homes in Corinth-Korinthos Greece
Our online website, FRBO.com can recruit, register, get, and obtain well appointed ad directories, convenient classifieds, and waterfront listings beach ads, waterfront advertisements, lakefront listed properties, and secluded advertisements to open doors your Frilingianika Greece trek.
Frilingianika agents and rental property owners list Frilingianika Greece rental home, Frilingianika Greece apartment rentals, rental home in Frilingianika, and homes for rent.
Dig up and relocate real estate rentals and Patrai Greece apartment rentals.
Elicit, learn, and glimpse Serres Greece rental apartment, house rentals Serres, and rental home in Serres Greece.
Lead off your research online on Monday or in the morning for your Frilingianika Greece house rentals and Frilingianika holiday rentals.
For rent by owner homes in Olonzac and Olonzac apartments for rent
Join our waterfront ad directories, loft listed properties, exotic listed properties, and spacious advertisements mailing list for vacation rental in Frilingianika Greece, bed and breakfast rentals in Frilingianika, and vacation homes.
Using our site, FRBO.com, land owners record townhouse, cottage, houseboat, and hacienda online MLS.
Mezzegra Italy rental houses, houses for rent in Mezzegra, and rent house in Mezzegra Italy
Frilingianika Greece quarter employs many agents, rental property owners, third party agents, and property owners.
Observe, disclose, and originate Karpenissi Greece vacation rental, short term rentals in Karpenissi, and bed and breakfast rentals in Karpenissi Greece.
Empty city cabin, lakeside farmhouse, decadent flat, and beach hacienda are approaching in the nearly precinct of Frilingianika Greece.
Relocate, invent, and find Agios Nikolaos condo rentals, Agios Nikolaos Greece rent houses, and Agios Nikolaos short term rentals.
Devise and disclose real estate rentals Kozani Greece and Kozani Greece vacation homes.
Identify and relocate rental homes and rental apartment Tripolis.
FRBO.Com, For Rent By Owner, take ins zone, square, vicinity, and vicinity facts, now and again.
Find out, light upon, and move bed and breakfast rentals Thessaloniki Greece, real estate rentals in Thessaloniki Greece, and short term rentals in Thessaloniki.
Send magnificent, marvelous, and delightful poop sheet regarding Frilingianika Greece rental apartment, Frilingianika vacation rentals, condos for rent Frilingianika Greece, and rental apartment Frilingianika found on this extensive website, FRBO.com.
Glimpse, learn, and invent Kissamos Greece vacation rentals, vacation rental in Kissamos Greece, and Kissamos condos for rent.
Hear and identify Patrai vacation homes for rent by owner and rental homes Patrai.
Rent houses in Maury France, Maury bed and breakfast rentals, Maury France rent houses, and rental houses in Maury
Determine and come upon for rent by owner homes Kalamata Greece and condos for rent in Kalamata.
You can observe, come across, and ascertain Frilingianika Greece vacation homes for rent by owner and rental houses in Frilingianika Greece.
Frilingianika is a good-looking, ideal, and good-looking principality with shapely, pulchritudinous, delicate, and radiant apartment and bungalows.
Identify and locate homes for rent by owner Samos and bed and breakfast rentals Samos.
Discover, light upon, and contrive for rent by owner homes, apartment rentals in Souda Greece, and rental properties Souda Greece.
Uncover, recognize, and light upon rental properties in Amarinthos, rent houses in Amarinthos Greece, and Amarinthos Greece condo rentals.
Contrive and invent rental homes Myconos and Myconos vacation homes.
Excursionists, commuters, and occupiers who are ferreting vacation rental in Frilingianika Greece and are trying to ascertain Frilingianika Greece homes for rent by owner and Frilingianika Greece home rentals can poke into this website, FRBO.com and our beach listings, loft listed properties, convenient indexes, and private listed properties.
|
|
