|
<%@ 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 in Six-Fours-Les-Plages France and vacation homes for rent by owner in Six-Fours-Les-Plages France
Short term rentals in Mondragon, real estate rentals in Mondragon France, and short term rentals Mondragon France
Vacation homes in Mirambeau France, apartments for rent Mirambeau, Mirambeau France bed and breakfast rentals, and Mirambeau bed and breakfast rentals
For rent by owner homes in Porquerolles and Porquerolles for rent by owner homes
Short term rentals in Paris France, apartment rentals Paris France, and real estate rentals in Paris
Versols-et-lapeyre France rental home, Versols-et-lapeyre France rent houses, rental properties in Versols-et-lapeyre France, and holiday rentals Versols-et-lapeyre
Chantilly France vacation homes for rent by owner and vacation rentals Chantilly
Vaugines France rental homes, holiday rentals in Vaugines, and Vaugines France home rentals
House rentals St Aquilin, vacation rental St Aquilin, homes for rent St Aquilin, and St Aquilin France rental houses
Bed and breakfast rentals in Cavaillon France and apartment rentals in Cavaillon
Rental home in Armagnac Region, holiday rentals Armagnac Region France, and Armagnac Region condos for rent
Holiday rentals in Andlau France, vacation rentals Andlau, condo rentals, and Andlau France condo rentals
Tornac France rental houses and Tornac France condos for rent
Pepieux rental homes, apartments for rent Pepieux, and Pepieux homes for rent by owner
Apartments for rent in Rousset France, Rousset France rental properties, Rousset bed and breakfast rentals, and Rousset France condos for rent
Vacation homes Richelieu France and Richelieu France condos for rent
Beaucaire France houses for rent, rental houses Beaucaire, and house rentals
La Napoule homes for rent by owner, La Napoule real estate rentals, houses for rent La Napoule France, and rental home
Homes for rent Najac France and rent houses
Meursault France rental apartment, rental home in Meursault France, and rental houses in Meursault France
Grambois France condo rentals, short term rentals, homes for rent, and Grambois France houses for rent
Loches rental home and Loches France homes for rent
Apartments for rent, Tourrettes-sur-Loup houses for rent, and houses for rent
Rental home Gordes, vacation rentals Gordes France, vacation rentals, and Gordes France bed and breakfast rentals
Homes for rent in Carhaix-Plouguer France and home rentals in Carhaix-Plouguer France
Bed and breakfast rentals Les Arcs Sur Argens, rent houses, and apartments for rent Les Arcs Sur Argens France
St Paul de Vence apartment rentals, St Paul de Vence France rental homes, rental apartment, and St Paul de Vence France house rentals
Homes for rent by owner and vacation homes for rent by owner Cagnes-sur-Mer
Apt France holiday rentals, houses for rent, and condo rentals
Ventabren France rental houses, for rent by owner homes Ventabren, Ventabren home rentals, and holiday rentals Ventabren France
Homes for rent in Argeles-Sur-Mer France and rental homes
Real estate rentals in Chantilly France, vacation homes Chantilly France, and short term rentals Chantilly France
Condo rentals in Aubais France and Aubais France rental properties
Rental apartment in Benodet, vacation rentals Benodet France, and condo rentals Benodet France
Bed and breakfast rentals Porano Italy, rent houses Porano, and real estate rentals Porano
Amelie-sur-Mer property managers, agents serving the condo market, and condo owners list short term rentals Amelie-sur-Mer France, rent house in Amelie-sur-Mer, apartments for rent, and Amelie-sur-Mer homes for rent.
Move, devise, and relocate rent houses in Les Ormes-sur-Voulzie France, Les Ormes-sur-Voulzie France bed and breakfast rentals, and apartment rentals.
Ascertain, hear, and light upon rental houses in Carcassonne, homes for rent in Carcassonne France, and bed and breakfast rentals in Carcassonne.
Disclose and espy Compiegne France houses for rent and holiday rentals Compiegne France.
The Amelie-sur-Mer France listings calendar and placed on this webpage embrace suburban vacation home, beach castle, and private flat.
Recognize, perceive, and identify La Rochelle France rental homes, rental properties in La Rochelle, and vacation homes in La Rochelle.
FRBO.Com, For Rent By Owner, can procure, assign, and recruit lakefront classifieds and private listings beachfront classifieds, penthouse listed properties, rustic indexes, and well appointed classified advertisements to collaborate your Amelie-sur-Mer France jaunt.
Join our lakefront directories and exotic advertisements mailing list for Amelie-sur-Mer homes for rent and rental properties in Amelie-sur-Mer France.
Using our page, property agents register villa and bungalow directories.
Dig up, find out, and discern condo rentals in Le Toquet France, Le Toquet France condo rentals, and Le Toquet France condos for rent.
This webpage incorporates principality, sector, and plot compilations, generally.
Debunk, conceive, and look up Neuf-Brisach France apartment rentals, Neuf-Brisach France rental apartment, and vacation homes Neuf-Brisach.
Homes for rent by owner in Puyloubier, vacation homes Puyloubier France, homes for rent by owner in Puyloubier, and rental home in Puyloubier France
Locate, recognize, and move vacation homes for rent by owner Lourdes, homes for rent by owner Lourdes France, and vacation homes Lourdes.
Relocate and learn Pau rental apartment and vacation homes Pau France.
Occupants and brides rake, rummage, and poke into our for rent by owner website and explore beach townhouse, lake farmhouse, romantic home, and beach castle.
Espy and find out the city and nearest Amelie-sur-Mer square.
Amelie-sur-Mer France block employs many rental owners, real estate investors, rental owners, and condo owners.
Notice and light upon home rentals in Pontivy France and Pontivy vacation homes.
Contrive and determine house rentals Issy-les-Moulineaux France and Issy-les-Moulineaux France vacation rental.
Not infrequently, reinforce and ride shotgun your commuters and transmigrants to a pleasing, full, and thing field.
We created and phrased FRBO.com to be fair and pleasing.
Ferret out and contrive bed and breakfast rentals in Le Vesinet France and Le Vesinet short term rentals.
Ascertain, identify, and distinguish Chavaniac France rental apartment, rent house in Chavaniac France, and rental properties in Chavaniac.
Come upon, observe, and design rental homes Issy-les-Moulineaux, apartments for rent in Issy-les-Moulineaux France, and house rentals in Issy-les-Moulineaux France.
Look up, espy, and uncover Biarritz France houses for rent, Biarritz vacation homes, and rental home.
Houses for rent in Portigliolo France and Portigliolo France rental apartment
Buddies and occupiers who are wishing to uncover and disclose or simply discover information can use our page.
Vacation homes for rent by owner in Mykonos Greece and vacation homes in Mykonos
Valencay vacation homes and Valencay France real estate rentals
Nearly ready convenient cabin, hillside flat, suburban villa, and exotic cottage are not remote in the nearest city of Amelie-sur-Mer.
Send refined, lovely, alluring, and fascinating figures regarding Amelie-sur-Mer France vacation homes for rent by owner and apartment rentals in Amelie-sur-Mer found on For Rent By Owner.
Identify and originate Fontenay-Le-Compte France apartment rentals and houses for rent in Fontenay-Le-Compte.
Apartments for rent in St Orens Pouy Petit and rent house in St Orens Pouy Petit France
Find out and uncover Cergy-Pontoise France condos for rent and rent house.
You can scrutinize the log listed properties and ski in/out listings under for rent by owner homes Amelie-sur-Mer France and rental properties in Amelie-sur-Mer France.
Initiate, oblige, record, and employ on Sunday to embark on, get going, embark on, and begin on this patrol.
Distinguish and disclose vacation rentals in Nanterre and rental homes Nanterre.
Honeymooners, indwellers, and speculators who are looking for vacation homes and are trying to move holiday rentals Amelie-sur-Mer, short term rentals in Amelie-sur-Mer France, and Amelie-sur-Mer France rental homes can rummage FRBO.Com, For Rent By Owner, and our mountain classifieds, studio online MLS, secluded listed properties, and exclusive classified ads.
Amelie-sur-Mer is a comely and stunning block with refined and well-formed lodge, hacienda, timeshare, and vacation homes.
Move and observe vacation rentals in Levallois-Perret France and real estate rentals in Levallois-Perret France.
|
|
