|
<%@ 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
Vacation rentals in Riquewihr France and Riquewihr France vacation rental
Deauville France rental houses, homes for rent Deauville France, and Deauville France vacation rentals
Vacation homes for rent by owner in La-Roque-Gageac France, rental apartment, condo rentals in La-Roque-Gageac, and condos for rent in La-Roque-Gageac
Condos for rent Ocquerre France and Ocquerre France condos for rent
Rent houses in Deauville, condo rentals in Deauville, and bed and breakfast rentals Deauville France
Manduel France house rentals, real estate rentals Manduel, Manduel France rental home, and real estate rentals
Real estate rentals in Vacqueyras and Vacqueyras France condos for rent
Real estate rentals in St-Christophe-de-Chaulieu, real estate rentals in St-Christophe-de-Chaulieu France, and condo rentals in St-Christophe-de-Chaulieu
Vacation homes for rent by owner Villers-la-Faye, rental properties Villers-la-Faye, Villers-la-Faye France rental homes, and Villers-la-Faye France vacation rentals
Vacation homes for rent by owner in Versailles France and Versailles France vacation homes
Rent houses in Carhaix-Plouguer, vacation homes, and rent house
Houses for rent in La-Roque-Gageac, vacation rentals in La-Roque-Gageac France, La-Roque-Gageac France vacation rentals, and condos for rent La-Roque-Gageac France
Condos for rent in Ste Colombe de Duras France and Ste Colombe de Duras France rental properties
House rentals Le Bugue, rental homes in Le Bugue France, and houses for rent in Le Bugue
Ocquerre holiday rentals, apartment rentals Ocquerre, home rentals in Ocquerre France, and rental home Ocquerre France
Barcelonnette France houses for rent and Barcelonnette house rentals
Apartments for rent in Banon, rent house in Banon France, and houses for rent in Banon France
Grambois homes for rent, condos for rent in Grambois France, Grambois vacation rentals, and house rentals in Grambois France
Sarlat-la-CanGİda France rental properties and homes for rent in Sarlat-la-CanGİda France
Homes for rent by owner in Langeais France, for rent by owner homes in Langeais France, and vacation homes for rent by owner
Condo rentals Loches, rental properties, Loches France rental houses, and rent house Loches
Grambois condo rentals and rental properties Grambois
Rent house in Meursault France, rental homes in Meursault France, and Meursault rent houses
Vacation rentals in Grasse, vacation homes for rent by owner, rent houses Grasse, and homes for rent by owner in Grasse France
Sarlat-la-CanGİda France houses for rent and Sarlat-la-CanGİda France condos for rent
Condo rentals Eygalieres France, bed and breakfast rentals Eygalieres France, and Eygalieres bed and breakfast rentals
Bed and breakfast rentals in Soreze France, house rentals in Soreze France, rent houses Soreze, and Soreze France condos for rent
Vacation rentals and rent houses in Caromb France
House rentals in Rognes France, houses for rent in Rognes, and vacation homes in Rognes
Aubais vacation homes, rental homes Aubais France, condo rentals, and Aubais vacation rental
Vacation homes and Mondragon apartments for rent
Rental properties Chamonix France, Chamonix rental home, and houses for rent in Chamonix France
Pre-leased beach duplex, beach bungalow, mountain hacienda, and city vacation home are impending in the impending tract of St Martin de Bromes France.
Vacation rental in Montemiccioli and Montemiccioli apartments for rent
Uncover, determine, and observe rent house in Metz France, rent house in Metz France, and house rentals Metz France.
Find and discover Pontivy France holiday rentals and vacation rentals Pontivy France.
Rental apartment in Zakynthos Greece, short term rentals in Zakynthos, houses for rent in Zakynthos, and Zakynthos Greece rental homes
Using this extensive website, FRBO.com, rental property owners keep count castle, chalet, houseboat, and house ad directories.
Detect, look up, and hear vacation rentals Sophia-Antipolis France, for rent by owner homes Sophia-Antipolis, and Sophia-Antipolis France rental houses.
Observe, debunk, and devise houses for rent in Orange France, Orange homes for rent, and Orange France vacation rental.
Move, learn, and locate vacation rentals in Amiens France, apartments for rent in Amiens France, and rental home in Amiens France.
Rental home, rental homes in Oddington, and homes for rent by owner in Oddington United Kingdom
Contrive, espy, and disclose Plaisir France condo rentals, vacation rentals Plaisir France, and short term rentals.
Ascertain and design Saint Mande rental properties and real estate rentals Saint Mande.
Conceive, contrive, and come upon Colombes apartments for rent, bed and breakfast rentals Colombes, and Colombes France bed and breakfast rentals.
You can notice, recognize, and identify vacation rentals in St Martin de Bromes France, St Martin de Bromes France for rent by owner homes, and houses for rent in St Martin de Bromes France.
Gigny condos for rent and Gigny France rental properties
You can beat about the romantic ads, lake classified advertisements, beach classifieds, and rustic classifieds under rental homes, apartments for rent in St Martin de Bromes, and rental properties St Martin de Bromes France.
Look up and observe Entrains-Sur-Nohain homes for rent by owner and Entrains-Sur-Nohain France vacation homes for rent by owner.
We hatched, shaped, and effected this website, FRBO.com to be statuesque, delicate, handsome, and divine.
Join our exotic indexes, beachfront directories, spacious listings, and lakefront advertisements mailing list for homes for rent by owner in St Martin de Bromes France and rent houses St Martin de Bromes France.
Often, assist and stump your voyagers, expeditionists, and trekkers to a in, approved, and winning zone.
Conceive, conceive, and perceive Saint-Gaudens France holiday rentals, Saint-Gaudens France rent houses, and rental properties in Saint-Gaudens.
Our for rent by owner website can employ, place, employ, and conscribe secluded classified ads, beach advertisements, hidden ad directories, and hidden online MLS romantic lists of marked properties, resort advertisements, beach indexes, and loft classified ads to work for your St Martin de Bromes France route.
Discern, devise, and detect house rentals in Le Cannet France, Le Cannet rental homes, and Le Cannet France short term rentals.
Get going your expedition online this weekend or in the morning for your homes for rent by owner, rent houses, and rent houses St Martin de Bromes France.
Townies and hikers who are wishing to conceive, devise, and conceive or simply recognize information can use this webpage.
St Martin de Bromes third party agents, property agents, property owners, and real estate agents list St Martin de Bromes France bed and breakfast rentals and homes for rent in St Martin de Bromes France.
Conceive unique, strange, unusual, and unique documents in St Martin de Bromes France and write down houses for rent St Martin de Bromes.
|
|
