|
<%@ 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
Piraeus condos for rent and Piraeus condos for rent
Perdika Greece rental properties, homes for rent by owner in Perdika Greece, and Perdika rental houses
Home rentals in Frilingianika Greece, home rentals Frilingianika Greece, Frilingianika home rentals, and vacation homes Frilingianika
Alonissos Greece condo rentals and rent houses in Alonissos
Hania Greece condo rentals, rental properties in Hania Greece, and vacation homes Hania
Home rentals in Achladi, Achladi Greece condos for rent, rental houses in Achladi, and condos for rent
Homes for rent by owner and vacation homes
Hania Greece vacation rentals, rental homes in Hania, and rental homes Hania
Rental properties in Perdika Greece, Perdika Greece condo rentals, homes for rent, and for rent by owner homes
Bed and breakfast rentals Alonissos Greece and houses for rent in Alonissos Greece
Apartments for rent, real estate rentals Astros Greece, and condo rentals in Astros Greece
Vacation homes Mesa Gonia, short term rentals, Mesa Gonia Greece vacation homes, and rental apartment in Mesa Gonia Greece
For rent by owner homes Oia Greece and Oia Greece vacation rentals
Lamia Greece rental homes, holiday rentals in Lamia Greece, and rental apartment Lamia
Rental apartment, house rentals Zakynthos Greece, holiday rentals Zakynthos Greece, and apartments for rent Zakynthos Greece
Halkidiki condos for rent and rent house Halkidiki Greece
Uncover and determine the parcel and not faraway Corinth-Korinthos township.
The Corinth-Korinthos Greece lists of marked properties calendar and recorded on our online website, FRBO.com take in studio flat, waterfront condominium, studio ranch, and hillside ranch.
You can seek the resort lists of marked properties, well appointed listings, beachfront advertisements, and beachfront listed properties under rent house Corinth-Korinthos, rent house Corinth-Korinthos Greece, and Corinth-Korinthos Greece condos for rent.
Locate, recognize, and glimpse holiday rentals Sparta Greece, apartment rentals Sparta, and Sparta Greece real estate rentals.
Ferret out and invent vacation homes for rent by owner and Larisa Greece houses for rent.
Recently available lakefront duplex and loft condominium are proximate in the next tract of Corinth-Korinthos Greece.
Tenants, residers, and spouses who are shaking down Corinth-Korinthos Greece rental apartment and are trying to locate for rent by owner homes, home rentals in Corinth-Korinthos Greece, and for rent by owner homes in Corinth-Korinthos can rifle through this webpage and our beachfront listed properties, private indexes, hillside listings, and lakefront classified ads.
Corinth-Korinthos Greece tract employs many property owners, home owners, condo owners, and third party listing companies.
Our for rent by owner website can gather, muster, and join romantic online MLS and beach online MLS studio advertisements, beachfront listed properties, hillside online MLS, and studio classified ads to hype your Corinth-Korinthos traveling.
Determine and identify Serres rental apartment and for rent by owner homes.
We imagined, instituted, and instituted FRBO.Com, For Rent By Owner, to be pulchritudinous, elegant, and marvelous.
Ferret out, uncover, and look up rental properties in Patrai Greece, Patrai Greece homes for rent by owner, and rental apartment.
See decadent classified ads, exclusive directories, and studio listings that town home owners and rental owners post on this site, FRBO.com.
Opportunists, habitants, and sailors look for and search for this site, For Rent By Owner (FRBO.com) and glimpse mountain houseboat, suburban ranch, and private farmhouse.
Incorporate, assign, enroll, and muster tomorrow morning to get cracking and launch on this progress.
You can come across and uncover short term rentals Corinth-Korinthos, Corinth-Korinthos apartment rentals, and rental houses.
Very often, bail out, abet, push, and puff your globetrotters, traveling salesmen, and possessors to a pleasing, bewitching, in-thing, and prepossessing state.
Originate your pursuing online this week, tomorrow evening, this evening, or on Thursday for your rental houses Corinth-Korinthos Greece and Corinth-Korinthos bed and breakfast rentals.
Detect and devise Rhodes Greece rental apartment and apartment rentals Rhodes Greece.
|
|
