|
<%@ 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
Homes for rent by owner Meursault France and condo rentals in Meursault
Short term rentals in Orignolles France, Orignolles France rental properties, and apartments for rent Orignolles France
Rental home in Villefranche-sur-Mer, for rent by owner homes in Villefranche-sur-Mer France, homes for rent by owner Villefranche-sur-Mer France, and vacation rentals in Villefranche-sur-Mer France
Rental homes in Cavaillon France and rental apartment Cavaillon
Mortain France rent house, vacation rentals Mortain France, and Mortain short term rentals
Vacation homes in St-Martin-de-Castillon France, rental apartment, rental homes, and houses for rent
Meursault France homes for rent by owner and for rent by owner homes Meursault France
Les Taillades vacation rentals, apartments for rent in Les Taillades France, and Les Taillades house rentals
Houses for rent in Manduel, real estate rentals, apartment rentals Manduel, and vacation homes Manduel France
Real estate rentals Presles et Thierny and Presles et Thierny France rent house
House rentals in Creysse France, house rentals in Creysse, and home rentals
Holiday rentals in Puyloubier, vacation homes for rent by owner in Puyloubier, rental houses in Puyloubier France, and holiday rentals Puyloubier France
St Aquilin for rent by owner homes and rental apartment St Aquilin France
Entrecasteaux France homes for rent, Entrecasteaux France bed and breakfast rentals, and homes for rent by owner in Entrecasteaux
Crain homes for rent, Crain France condos for rent, real estate rentals Crain France, and Crain vacation homes
Chitenay France vacation homes for rent by owner and Chitenay France homes for rent
Montclus France rental apartment, Montclus for rent by owner homes, and rental homes Montclus
Rent house, Bormes-les-Mimosas France apartments for rent, real estate rentals Bormes-les-Mimosas France, and Bormes-les-Mimosas homes for rent by owner
Perpignan France rental home and rental home
Pont-Royal France rent house, short term rentals in Pont-Royal France, and homes for rent in Pont-Royal France
Lauzerte house rentals, home rentals in Lauzerte France, vacation rentals in Lauzerte France, and home rentals
Goult apartment rentals and Goult France real estate rentals
Chamonix vacation homes for rent by owner, Chamonix France apartments for rent, and holiday rentals in Chamonix France
St-Pierre-de-Maille land owners, property managers, and property agents list apartments for rent in St-Pierre-de-Maille France, homes for rent by owner in St-Pierre-de-Maille France, and vacation rental in St-Pierre-de-Maille.
Cohorts and possessors root, investigate, and cast about our site, FRBO.com and come across city apartment, lakeside townhouse, beach houseboat, and convenient farmhouse.
Contrive, disclose, and ascertain Peronne France homes for rent, rental homes, and Peronne France homes for rent.
See beach classified ads, hidden advertisements, decadent online MLS, and resort classified ads that real estate agents and third party listing companies post on this site, For Rent By Owner (FRBO.com).
Send admirable and shapely measurements regarding rental apartment in St-Pierre-de-Maille France, vacation rentals, rental home in St-Pierre-de-Maille France, and rental home in St-Pierre-de-Maille France found on our for rent by owner website.
Come upon and observe Caen France homes for rent and Caen France rental apartment.
Glimpse and observe Saint-Maur-des-Fosses France rental homes and real estate rentals in Saint-Maur-des-Fosses France.
Conceive and catch for rent by owner homes in Bourges France and vacation homes in Bourges.
Place, enter, and levy on Friday to begin, embark on, and inaugurate on this wayfaring.
You can discern, contrive, and detect St-Pierre-de-Maille for rent by owner homes and vacation homes for rent by owner in St-Pierre-de-Maille France.
Voyagers and roadmen who are wishing to elicit, ascertain, and determine or simply identify information can use this webpage.
Wanderers and troupers who are investigating St-Pierre-de-Maille France rental home and are trying to originate St-Pierre-de-Maille France for rent by owner homes, apartment rentals, and vacation rentals can cast about our website, FRBO.com and our beach ad directories, suburban advertisements, well appointed ads, and rustic classified ads.
Come across and detect house rentals in La Vergne France and rental home in La Vergne France.
Devise, look up, and notice rental properties in Luray France, apartment rentals in Luray France, and apartments for rent.
Discover, ascertain, and invent rental properties in Angouleme France, Angouleme rental home, and vacation rentals Angouleme.
St-Pierre-de-Maille France testimony could abet and reinforce your research.
You can seek the spacious classified advertisements and hidden online MLS under St-Pierre-de-Maille condo rentals and rental houses St-Pierre-de-Maille.
Discover and contrive vacation rental Reims France and house rentals in Reims France.
The St-Pierre-de-Maille romantic classifieds and lakefront listed properties for these neighborhood can be mapped.
|
|
