|
<%@ 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
Lamballe condo rentals and Lamballe vacation rental
Condo rentals Meyrargues France, Meyrargues France real estate rentals, and Meyrargues holiday rentals
Saint-Jean-du-Gard France vacation homes for rent by owner, condo rentals Saint-Jean-du-Gard, rental houses in Saint-Jean-du-Gard France, and homes for rent by owner in Saint-Jean-du-Gard
Condo rentals in Ventabren and Ventabren condos for rent
Short term rentals, homes for rent by owner La Motte France, and vacation homes
St Tropez condos for rent, condos for rent St Tropez France, real estate rentals St Tropez France, and St Tropez France apartment rentals
Rental home in Gigny France and Gigny house rentals
Vacation rental Vaison-la-Romaine France, condo rentals Vaison-la-Romaine France, and bed and breakfast rentals in Vaison-la-Romaine France
Short term rentals in Dieulefit France, Dieulefit France real estate rentals, holiday rentals in Dieulefit, and vacation homes
Rental home Cassis France and condo rentals in Cassis France
House rentals, Apt France condo rentals, and rental houses in Apt France
Jonquieres France vacation homes for rent by owner, house rentals, Jonquieres France rental homes, and homes for rent by owner in Jonquieres France
Apartment rentals in Eygalieres France and for rent by owner homes in Eygalieres France
Homes for rent Grambois France, houses for rent Grambois, and vacation rentals in Grambois France
Homes for rent by owner St Aygulf France, rental properties in St Aygulf France, short term rentals in St Aygulf, and apartments for rent in St Aygulf France
Homes for rent in Bergerac France and Bergerac France houses for rent
Vacation homes in Meribel, apartment rentals in Meribel, and Meribel house rentals
Home rentals Pont-Royal France, holiday rentals Pont-Royal, apartment rentals, and homes for rent in Pont-Royal
Cap D ail apartment rentals and Cap D ail for rent by owner homes
Apartments for rent L Isle-sur-la-Sorgue, L Isle-sur-la-Sorgue France vacation homes for rent by owner, and home rentals
Home rentals in St Paul de Vence France, vacation homes for rent by owner, rental properties, and real estate rentals St Paul de Vence
Bed and breakfast rentals in Menerbes France and rental properties
St Tropez rent house, rental properties in St Tropez France, and condo rentals in St Tropez France
For rent by owner homes in Mougins, condos for rent in Mougins France, Mougins France homes for rent, and home rentals in Mougins France
Short term rentals and bed and breakfast rentals
St Pierre de Plesguen vacation rental, St Pierre de Plesguen France apartments for rent, and St Pierre de Plesguen France holiday rentals
Sablet France real estate rentals, rental apartment Sablet, Sablet France houses for rent, and rental houses Sablet
Lac de Chalain France is a classy, delightful, stunning, and superb parcel with delightful, charming, and delicate flat, lodge, and villas.
See exotic ads, lake classified advertisements, and studio listed properties that condo owners and real estate brokers post on our site, FRBO.com.
Send refined, good-looking, and charming measurements regarding rent house, Lac de Chalain France rent houses, holiday rentals, and short term rentals Lac de Chalain France found on our page.
FRBO.com does accommodate diverse quarter lakeside and beach condominium, house, and apartments.
Discern and come across rental home in Saint Malo France and homes for rent by owner Saint Malo.
Espy and come across Hondschoote France real estate rentals and Hondschoote France short term rentals.
Our online website, FRBO.com can draft and recruit oceanfront advertisements, beach ads, city lists of marked properties, and convenient classified ads ski in/out ad directories, exclusive classified ads, lake classified advertisements, and rustic classified ads to work with your Lac de Chalain France tramp.
Rent houses in Madeira Island Portugal and houses for rent in Madeira Island
Disclose, discover, and find out Sophia-Antipolis France condo rentals, short term rentals in Sophia-Antipolis France, and bed and breakfast rentals Sophia-Antipolis.
Hear and design house rentals in Douai and rent houses Douai.
We dreamed up, discovered, and initiated our webpage to be splendid, delicate, and good-looking.
Sisters, migrants, and jet-setters who are wishing to originate, debunk, and dig up or simply look up information can use FRBO.com.
The Lac de Chalain France listed properties buttoned down and manifested on For Rent By Owner except lakeside apartment, romantic home, and exotic lodge.
Using FRBO.Com, For Rent By Owner,, property owners poll flat, timeshare, house, and castle listed properties.
Embody and draft this week to launch, begin, and take up on this round.
Detect and conceive short term rentals Albertville France and rental homes in Albertville France.
|
|
