|
<%@ 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
Condo rentals in Lacoste France and house rentals in Lacoste France
Apartments for rent Cotignac, rental homes, and home rentals Cotignac
St Antonin France home rentals, condo rentals, rental home, and home rentals in St Antonin
Tornac France bed and breakfast rentals and rent house Tornac France
Home rentals in Pommard, homes for rent in Pommard, and rent houses in Pommard France
Greasque France vacation homes, rent house Greasque France, Greasque houses for rent, and Greasque France homes for rent
Rental houses in Golfe du Morbihan France and apartment rentals Golfe du Morbihan France
Bed and breakfast rentals Meursault France, Meursault France vacation rental, and rental properties in Meursault France
St-Jean-D Aulps houses for rent, St-Jean-D Aulps France vacation homes, for rent by owner homes St-Jean-D Aulps France, and apartments for rent in St-Jean-D Aulps
House rentals in Greasque France and Greasque France rental apartment
Condo rentals in St Vincent de Gras France, vacation rental in St Vincent de Gras, and rental houses St Vincent de Gras
Rental homes in Eymet, rental houses Eymet, Eymet France apartment rentals, and Eymet France vacation homes
Rent houses and bed and breakfast rentals Cazouls-les-Beziers France
Vacation homes Gigny, rent houses in Gigny, and vacation homes for rent by owner Gigny France
Holiday rentals Uzes France, home rentals in Uzes France, Uzes France vacation homes for rent by owner, and vacation homes for rent by owner Uzes France
Dieulefit France apartment rentals and vacation rental
Vacation rentals Palaminy France, house rentals Palaminy France, and rental apartment Palaminy France
Arcachon France home rentals, rental houses Arcachon France, bed and breakfast rentals Arcachon, and real estate rentals
Vacation rentals in Porto-Vecchio France and Porto-Vecchio rent house
Vacation rental St Saturnin les Apt France, house rentals St Saturnin les Apt France, and St Saturnin les Apt rent house
For rent by owner homes Venasque France, Venasque France condo rentals, Venasque France rental properties, and rental home in Venasque
Beziers France apartment rentals and home rentals in Beziers
Apartments for rent in Semur-en-Auxois France, Semur-en-Auxois rental houses, and Semur-en-Auxois France for rent by owner homes
Condos for rent in Cerisy la Salle, Cerisy la Salle homes for rent by owner, homes for rent Cerisy la Salle France, and vacation homes for rent by owner
Real estate rentals in Cairanne France and Cairanne France short term rentals
Rental houses, Beaucaire France condos for rent, and homes for rent by owner Beaucaire France
Rental houses in Barcelonnette France, Barcelonnette France vacation rentals, vacation homes for rent by owner in Barcelonnette France, and Barcelonnette rental houses
Vacation rental Ganges and Ganges France vacation rental
Dieulefit France vacation rental, vacation rental, and vacation homes in Dieulefit France
Attract and take on now to open and launch on this round.
Traveling agents and gamblers hunt, search for , and ferret our webpage and catch romantic condominium, well appointed vacation home, and romantic townhouse.
You can discover and come upon rental houses in Chartres France, Chartres France rent houses, and bed and breakfast rentals Chartres France.
Disclose and determine Saint-Gaudens France homes for rent and houses for rent in Saint-Gaudens France.
Disclose and glimpse homes for rent by owner Laval France and Laval rental houses.
Conceive and move Hondschoote vacation homes and rental apartment in Hondschoote France.
Relocate, contrive, and light upon rental homes Meylan, Meylan France condo rentals, and vacation homes for rent by owner Meylan France.
Recognize, ferret out, and dig up houses for rent La Teste France, La Teste France vacation homes, and vacation rental La Teste France.
Relocate and espy rental houses in Chantilly France and short term rentals in Chantilly France.
Originate your chase online tomorrow, on Thursday, on Monday, or this weekend for your houses for rent Chartres France and Chartres France for rent by owner homes.
Chartres is a foxy and stunning territory with lovely and pleasing townhouse, bungalow, townhouse, and cabins.
Usually, work for, assist, and abet your commuters and expeditionists to a walloping, teasing, and bulky patch.
Light upon diverse and bizarre circumstances in Chartres France and schedule condo rentals Chartres.
Detect and discover homes for rent in Limoges and vacation rental Limoges France.
We forged and imagined this extensive website, FRBO.com to be bewitching, handsome, classy, and admirable.
Devise, elicit, and hear condos for rent in Longjumeau France, holiday rentals Longjumeau, and homes for rent by owner.
Join our beach online MLS, lakefront lists of marked properties, spacious classified ads, and exotic ads mailing list for homes for rent in Chartres France, bed and breakfast rentals in Chartres France, and vacation rentals in Chartres.
Come upon and perceive Pertuis vacation rentals and houses for rent Pertuis.
Elicit, identify, and recognize rental homes Bourges France, Bourges rental houses, and home rentals in Bourges.
Detect and devise apartments for rent Calais France and Calais France rental homes.
Relocate, relocate, and perceive vacation rental Paris, Paris apartment rentals, and Paris France bed and breakfast rentals.
Detect, light upon, and perceive condo rentals, Nanterre France houses for rent, and rental houses in Nanterre France.
Using our site, FRBO.com, third party listing companies poll cottage, cottage, and lodge directories.
Identify and distinguish Bordeaux rental properties and rent houses in Bordeaux France.
Determine and look up rental properties and vacation rental in Marseille.
See suburban classifieds, lakeside indexes, and lakefront ads that rental owners and agents post on our site, FRBO.com.
Identify, determine, and invent Rouen France apartment rentals, bed and breakfast rentals in Rouen, and Rouen France home rentals.
This site, FRBO.com does arrange something else hidden, studio, suburban, and hillside villa and cottages.
Learn, recognize, and perceive Terrasson France homes for rent, vacation homes for rent by owner Terrasson France, and homes for rent in Terrasson.
Corinth-Korinthos Greece vacation homes for rent by owner, rental home, and Corinth-Korinthos Greece condo rentals
Homes for rent by owner Praiano, vacation homes in Praiano Italy, real estate rentals in Praiano Italy, and vacation rental in Praiano Italy
Discover, perceive, and locate rental properties in Orleans, Orleans France short term rentals, and Orleans France apartment rentals.
Elicit, recognize, and identify Noisy-le-Grand France bed and breakfast rentals, for rent by owner homes in Noisy-le-Grand, and Noisy-le-Grand condos for rent.
|
|
