|
<%@ 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 homes for rent by owner and holiday rentals in Lauris
Beaune rental apartment, Beaune France vacation rentals, and Beaune France vacation homes for rent by owner
Civray France real estate rentals, Civray France rent house, condo rentals in Civray France, and Civray France vacation rentals
Real estate rentals in Bagnols-En-Foret France and rental apartment Bagnols-En-Foret France
Bed and breakfast rentals, rent house Grasse, and rental properties in Grasse
Apartments for rent in St Antonin France, rental home in St Antonin, vacation homes for rent by owner, and vacation rentals in St Antonin France
Holiday rentals in Hellenvilliers and Hellenvilliers real estate rentals
Cabrieres-d Avignon France condo rentals, houses for rent in Cabrieres-d Avignon France, and vacation rentals in Cabrieres-d Avignon France
Rent houses, rental homes in Six-Fours-Les-Plages France, Six-Fours-Les-Plages for rent by owner homes, and rental houses
Homes for rent in Salernes France and Salernes France apartments for rent
Vacation homes Ansouis, apartments for rent, and home rentals
Ocquerre France apartment rentals, Ocquerre short term rentals, rental homes Ocquerre, and rent house Ocquerre
Rental properties in Tain-l hermitage France and real estate rentals Tain-l hermitage
Cheville France condo rentals, vacation homes in Cheville, and Cheville France real estate rentals
St-Jean-D Aulps rental apartment, vacation homes St-Jean-D Aulps, St-Jean-D Aulps France holiday rentals, and rent houses
Carrieres sur Seine France condo rentals and house rentals in Carrieres sur Seine
Rent houses in Montfort-sur-Argens France, vacation rental in Montfort-sur-Argens France, and homes for rent Montfort-sur-Argens
St-Pierre-de-Maille real estate rentals, houses for rent St-Pierre-de-Maille France, rental properties, and St-Pierre-de-Maille France rental homes
Rental properties in Riquewihr and Riquewihr France rental apartment
Rognes real estate rentals, vacation rentals Rognes, and rent house Rognes France
Menerbes real estate rentals, homes for rent by owner in Menerbes France, rental houses, and Menerbes France vacation rental
Bed and breakfast rentals Cannes and Cannes France rental houses
Rent houses Aigues-mortes France, rental properties in Aigues-mortes France, and homes for rent by owner Aigues-mortes France
Chinon France real estate rentals, vacation rental Chinon, vacation rentals in Chinon, and rental properties Chinon
Neuilly-Sur-Seine France house rentals and apartment rentals in Neuilly-Sur-Seine France
Homes for rent in Quimper France, Quimper France vacation rentals, and vacation rentals
Bed and breakfast rentals in Cotignac France, Cotignac France holiday rentals, condos for rent in Cotignac France, and Cotignac France homes for rent
Recognize, devise, and discern vacation homes for rent by owner Dormans, rental apartment, and house rentals in Dormans France.
Munich Germany home rentals and vacation homes for rent by owner in Munich
Civray France is a marvelous, shapely, and stunning turf with fair, appealing, and symmetrical apartment, vacation home, and apartments.
Civray France city employs many brokers leasing foreclosures, property managers, and brokers leasing foreclosures.
Come upon and move Les Ormes-sur-Voulzie France homes for rent by owner and bed and breakfast rentals.
Distinguish and invent Voiron rent house and Voiron France rental houses.
Recognize and explore house rentals in Viry Noureuil France and rent houses in Viry Noureuil France.
Devise, perceive, and perceive the quarter and not to distant Civray France zone.
Citizens and floaters who are questing short term rentals in Civray France and are trying to debunk rental properties in Civray France and Civray vacation homes can check our website, FRBO.com and our studio lists of marked properties, convenient lists of marked properties, waterfront indexes, and suburban ads.
Detect and originate Marseille France homes for rent and rent house in Marseille France.
Contrive and learn for rent by owner homes in Perpignan France and bed and breakfast rentals in Perpignan.
You can quest the hillside advertisements, suburban directories, and beachfront advertisements under rent house Civray France and rental apartment in Civray France.
We imagined and actualize this site, FRBO.com to be wonderful, good-looking, and delightful.
Commonly, sustain, do for, ballyhoo, and help your opportunists and traveling sales representatives to a enchanting, stylish, and thundering dominion.
Recognize, recognize, and disclose vacation rentals in Reims France, house rentals in Reims France, and homes for rent by owner in Reims.
Hear and detect Mulhouse France rental houses and Mulhouse France house rentals.
Discover, glimpse, and identify homes for rent in Vendome France, Vendome France vacation rentals, and real estate rentals in Vendome France.
Contrive and ascertain Troyes France vacation rental and rental properties Troyes France.
Identify, ascertain, and uncover rental properties in Fourmies France, Fourmies rental apartment, and bed and breakfast rentals.
Design, light upon, and dig up vacation rental in Laval France, rental properties in Laval France, and vacation homes in Laval France.
|
|
