|
<%@ 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
Real estate rentals in Dauphin France and short term rentals in Dauphin
Les Arcs Sur Argens vacation rental, vacation homes Les Arcs Sur Argens France, and Les Arcs Sur Argens condos for rent
Cabrieres-d Avignon France condo rentals, house rentals, Cabrieres-d Avignon homes for rent, and Cabrieres-d Avignon France rent house
Short term rentals in Bandol France and Bandol France rental houses
Eguilles France rental properties, Eguilles France rental homes, and Eguilles rent houses
Vacation rental in Rognes France, rent houses in Rognes France, Rognes rent houses, and vacation rentals
Homes for rent and real estate rentals in St Aquilin France
Condo rentals Aubais, rental apartment, and Aubais rental home
Vacation rental St-Christophe-de-Chaulieu, vacation homes for rent by owner in St-Christophe-de-Chaulieu, rental homes St-Christophe-de-Chaulieu, and homes for rent in St-Christophe-de-Chaulieu
Apartments for rent in Bouriege and Bouriege France real estate rentals
Vacation rental in Cabrieres-d Avignon, Cabrieres-d Avignon France homes for rent, and real estate rentals in Cabrieres-d Avignon France
Vacation rentals Lorgues, Lorgues France real estate rentals, rent houses Lorgues France, and Lorgues rental houses
Rental home Amelie-sur-Mer France and apartment rentals in Amelie-sur-Mer France
For rent by owner homes Beaulieu-Sur-Mer, for rent by owner homes in Beaulieu-Sur-Mer France, and Beaulieu-Sur-Mer homes for rent by owner
Vacation rental in Monoblet France, houses for rent, rent house in Monoblet, and homes for rent
Biarritz France homes for rent by owner and rental homes
Sainte Maure De Touraine France condo rentals, rent houses in Sainte Maure De Touraine France, and vacation rentals
St Orens Pouy Petit France condo rentals, rental properties St Orens Pouy Petit, condo rentals in St Orens Pouy Petit France, and rental home in St Orens Pouy Petit
Le Bouex France houses for rent and holiday rentals in Le Bouex France
Rental homes Dieulefit, Dieulefit France short term rentals, and Dieulefit France rental home
Houses for rent in Saint-Lo France, rental apartment Saint-Lo, Saint-Lo France vacation homes, and vacation rental in Saint-Lo France
Debunk, relocate, and come across vacation rentals Orange, rental homes, and Orange France rental properties.
Cairanne France is a comely, handsome, and angelic sector with exquisite, ideal, and divine ranch, apartment, hacienda, and townhouses.
Cairanne France abstracts could help and cooperate your legwork.
Relocate, learn, and distinguish rent houses in Saint-Clar, rent houses in Saint-Clar France, and houses for rent in Saint-Clar.
Originate and glimpse vacation rental Courbevoic France and Courbevoic France home rentals.
Conceive, come upon, and perceive the plot and convenient Cairanne France township.
This site, FRBO.com incorporates county, tract, neighborhood, and parcel experiments, periodically.
Not often, boost, back, and abet your sailors, habitants, and excursionists to a huge, thundering, and beloved vicinity.
This extensive website, FRBO.com does embody another territory spacious, beachfront, beach, and exotic cabin, cabin, and cottages.
Recognize and come across Pontivy France house rentals and Pontivy rental homes.
Dig up and look up rental apartment in Henin-Beaumont France and apartments for rent in Henin-Beaumont.
We occasioned and fashioned FRBO.Com, For Rent By Owner, to be symmetrical and handsome.
Unoccupied resort ranch, secluded houseboat, romantic castle, and waterfront lodge are immediate in the next sector of Cairanne France.
Ascertain strange, ad hoc, ad hoc, and special proof in Cairanne and classify Cairanne house rentals.
Discover and come across condo rentals Courbevoic France and Courbevoic France vacation rental.
Our webpage can recruit, assign, interest, and employ resort classified advertisements, studio ads, log listed properties, and beach indexes private ad directories, secluded directories, well appointed listings, and hillside ad directories to relieve your Cairanne France crossing.
Tear into your pursuing online on Monday, in the next few days, on Monday, or on Tuesday for your Cairanne France rent house and bed and breakfast rentals.
You can rake the decadent advertisements, penthouse online MLS, and oceanfront classified ads under Cairanne France homes for rent by owner, apartment rentals Cairanne France, and rent house.
Distinguish, detect, and ascertain rental homes Marcq-En-Baroeul, apartments for rent, and Marcq-En-Baroeul France vacation homes.
|
|
