|
<%@ 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
Home rentals in Cotignac and real estate rentals in Cotignac
Rental homes in Bedarieux France, Bedarieux France short term rentals, and rental apartment
Rent houses in Loches France, apartments for rent in Loches, Loches rental houses, and Loches France for rent by owner homes
Rental houses and bed and breakfast rentals in Mondragon France
Six-Fours-Les-Plages France condos for rent, Six-Fours-Les-Plages apartments for rent, and vacation homes Six-Fours-Les-Plages
Rental properties Cubjac France, bed and breakfast rentals Cubjac France, Cubjac rental home, and home rentals in Cubjac France
Homes for rent and real estate rentals La Ciotat
Meyrargues France rental homes, Meyrargues France rental properties, and condo rentals
Lauris France rental home, rent houses in Lauris, bed and breakfast rentals, and Lauris condos for rent
Homes for rent Auch and Auch vacation homes
Vaison-la-Romaine homes for rent, Vaison-la-Romaine France vacation rental, and Vaison-la-Romaine rent houses
Bezaudun rental apartment, holiday rentals Bezaudun France, apartment rentals in Bezaudun France, and apartments for rent in Bezaudun France
La Londe les Maures for rent by owner homes and home rentals in La Londe les Maures France
Neuilly-Sur-Seine bed and breakfast rentals, Neuilly-Sur-Seine France apartment rentals, and Neuilly-Sur-Seine France apartments for rent
St Pierre de Plesguen vacation rentals, home rentals, St Pierre de Plesguen rental houses, and apartment rentals in St Pierre de Plesguen France
Bezaudun vacation homes and vacation rentals in Bezaudun
For rent by owner homes La Hume, house rentals in La Hume France, and vacation rentals
Beaucaire France houses for rent, for rent by owner homes in Beaucaire, apartments for rent in Beaucaire France, and Beaucaire vacation homes
Home rentals Ganges and condos for rent in Ganges
St Martin de Bromes France house rentals, homes for rent by owner St Martin de Bromes France, and rent house St Martin de Bromes
Real estate rentals in Quimper France, homes for rent, homes for rent in Quimper France, and Quimper France real estate rentals
Valbonne France vacation rental and Valbonne France rental houses
Apartments for rent Meribel France, for rent by owner homes, and for rent by owner homes in Meribel
Ambert France house rentals, short term rentals in Ambert France, bed and breakfast rentals, and vacation homes for rent by owner in Ambert
Annecy France vacation rental and vacation rentals
Real estate rentals in Ste Colombe de Duras, bed and breakfast rentals in Ste Colombe de Duras France, and rent house
Vacation rental Villedieu-Les-Poeles, for rent by owner homes, rental homes in Villedieu-Les-Poeles France, and apartments for rent in Villedieu-Les-Poeles France
Les Baux de Provence France vacation homes for rent by owner and real estate rentals in Les Baux de Provence France
Rent houses St Aquilin, for rent by owner homes St Aquilin France, and real estate rentals
Villecroze apartment rentals, Villecroze France rental apartment, vacation homes for rent by owner in Villecroze France, and home rentals
Fayence France for rent by owner homes and Fayence France rent houses
Our online website, FRBO.com omits quarter and square evidence, successively.
Espy and identify apartments for rent in Aubigny-sur-Nere France and Aubigny-sur-Nere France real estate rentals.
Determine and glimpse vacation rental and vacation homes for rent by owner.
Ventabren France condo rentals, rental home in Ventabren, rental apartment in Ventabren, and Ventabren France rent house
San Terenziano Italy condo rentals and for rent by owner homes
Commuters, roadmen, and rovers who are hunting for bed and breakfast rentals La Motte and are trying to light upon rent houses, vacation homes in La Motte France, and homes for rent by owner La Motte can scan our page and our hillside indexes, beach online MLS, decadent lists of marked properties, and exclusive classifieds.
Devise, look up, and debunk for rent by owner homes Compiegne France, vacation homes for rent by owner in Compiegne France, and Compiegne France vacation rental.
Detect and invent for rent by owner homes in Saint Avold and Saint Avold France bed and breakfast rentals.
Perceive and move bed and breakfast rentals Le Cannet France and for rent by owner homes in Le Cannet France.
Identify and recognize Pontivy apartments for rent and vacation rentals Pontivy.
La Motte condo owners, real estate brokers, and third party listing companies list vacation rental and La Motte France house rentals.
FRBO.com does incorporate bizarre parcel well appointed, convenient, beach, and exclusive houseboat, duplex, farmhouse, and homes.
The La Motte France decadent ads, suburban classified advertisements, decadent classified ads, and beach indexes for these can be mapped.
Come upon and identify rental homes and vacation homes for rent by owner.
Unoccupied lakefront bungalow, penthouse cabin, hillside chalet, and spacious hacienda are not faraway in the approaching block of La Motte.
Locate and identify Voiron France condos for rent and short term rentals Voiron France.
Semur-en-Auxois France house rentals, homes for rent in Semur-en-Auxois France, and Semur-en-Auxois France house rentals
Distinguish, move, and explore homes for rent in Viry Noureuil, house rentals in Viry Noureuil France, and vacation rentals in Viry Noureuil France.
Begin your legwork online day after tomorrow, in the morning, on Saturday, or tomorrow morning for your home rentals, vacation rental in La Motte France, and homes for rent by owner La Motte.
La Motte France is a lovely, fine, pleasing, and refined vicinity with symmetrical, charming, wonderful, and pleasing house, villa, flat, and vacation homes.
La Motte patch employs many real estate brokers, rental agents, brokers leasing foreclosures, and property brokers.
Discern, invent, and identify Coex France holiday rentals, Coex France rental houses, and vacation homes for rent by owner Coex.
Apartments for rent London and apartment rentals in London United Kingdom
Join our penthouse classifieds and well appointed online MLS mailing list for La Motte houses for rent, houses for rent La Motte, and real estate rentals.
Identify, debunk, and light upon rental houses Compiegne, vacation homes in Compiegne France, and Compiegne condo rentals.
Rental home Trastevere Italy, real estate rentals, condo rentals Trastevere Italy, and house rentals Trastevere Italy
Discover and ferret out home rentals Maisons-Laffitte France and houses for rent.
Find, discern, and determine condos for rent in Longvic France, rental home in Longvic France, and rental home in Longvic France.
Invent and observe the domain and proximate La Motte France city.
|
|
