|
<%@ 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" %>
|
France Rental Links
Rent houses in Artannes and rental apartment in Artannes France
Rental apartment Barcelonnette, Barcelonnette bed and breakfast rentals, and condos for rent Barcelonnette France
Rental properties St Saturnin les Apt France, rent house, apartment rentals in St Saturnin les Apt France, and rental homes in St Saturnin les Apt France
Holiday rentals Fayence France and apartments for rent
Vacation homes, Plougasnou France for rent by owner homes, and Plougasnou France apartments for rent
Rental apartment in Perpignan, vacation homes, rent house in Perpignan France, and rental apartment in Perpignan
Fayence rent house and real estate rentals in Fayence France
Condos for rent, Mirabeau France rental apartment, and Mirabeau vacation homes
Violes France vacation rental, short term rentals Violes, apartments for rent Violes, and holiday rentals Violes France
Valbonne France home rentals and condo rentals in Valbonne
Rental homes St Aquilin France, vacation rentals in St Aquilin, and rent house St Aquilin
Apartments for rent Chantilly France, Chantilly vacation rental, vacation rental, and Chantilly France homes for rent
Short term rentals in Chanterac France and Chanterac condos for rent
Rent house in La Napoule France, rent houses La Napoule France, and short term rentals in La Napoule France
Rental apartment in Chartres France, short term rentals Chartres, real estate rentals, and homes for rent
Real estate rentals Golfe du Morbihan and Golfe du Morbihan France bed and breakfast rentals
Home rentals in Meribel France, houses for rent Meribel France, and for rent by owner homes
Vacation homes for rent by owner in Cadenet France, bed and breakfast rentals in Cadenet, vacation homes for rent by owner, and rental houses Cadenet
Join our convenient advertisements, lake ad directories, and beach ad directories mailing list for L Isle-sur-la-Sorgue holiday rentals and L Isle-sur-la-Sorgue France homes for rent by owner.
Gypsies and companions scout and quest our for rent by owner site, FRBO.com and move hillside duplex, spacious farmhouse, exotic home, and hillside lodge.
Using this site, For Rent By Owner (FRBO.com), agents serving the condo market enumerate lodge, farmhouse, houseboat, and apartment directories.
Discern singular, unusual, express, and various evidence in L Isle-sur-la-Sorgue France and tick off short term rentals.
Roadmen and occupants who are wishing to light upon and distinguish or simply find out information can use FRBO.com.
Our webpage haves neighborhood, state, and principality info, periodically.
L Isle-sur-la-Sorgue France info could further, sustain, and bail out your perquisition.
You can debunk and explore L Isle-sur-la-Sorgue France condos for rent, real estate rentals L Isle-sur-la-Sorgue, and L Isle-sur-la-Sorgue France homes for rent by owner.
Dig up and light upon homes for rent by owner in Marseille France and for rent by owner homes in Marseille.
Learn, identify, and identify houses for rent, homes for rent Saint-Gaudens France, and real estate rentals in Saint-Gaudens France.
L Isle-sur-la-Sorgue France state employs many property owners, rental owners, brokers leasing foreclosures, and real estate investors.
Explore and disclose real estate rentals and vacation rental in Cannes France.
Send well-formed, splendid, and fascinating reports regarding vacation rentals in L Isle-sur-la-Sorgue, L Isle-sur-la-Sorgue France condos for rent, and L Isle-sur-la-Sorgue France rental properties found on this site, FRBO.com.
Espy, distinguish, and discern real estate rentals, vacation rental in Billom France, and Billom France rental houses.
Observe and distinguish Macon France condos for rent and apartment rentals in Macon.
Dig up and recognize vacation homes for rent by owner in Montigny-le-Bretonneux and houses for rent Montigny-le-Bretonneux.
Identify and conceive Mérignac France rent houses and Mérignac condo rentals.
Launch your frisking online this weekend, on Monday, in the next few days, or this weekend for your vacation rental, rental home in L Isle-sur-la-Sorgue, and L Isle-sur-la-Sorgue France vacation homes for rent by owner.
|
|
