|
<%@ 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
St Saturnin les Apt apartments for rent and St Saturnin les Apt France house rentals
Holiday rentals, short term rentals in Chamonix France, and Chamonix France homes for rent by owner
St Raphael France rental home, holiday rentals St Raphael France, real estate rentals, and St Raphael France vacation homes
Bed and breakfast rentals Neuvic France and rental properties
Rent houses, short term rentals St Saveur de Carrouges, and St Saveur de Carrouges rental houses
Vacation homes, homes for rent Bouriege France, rental home in Bouriege France, and Bouriege France rental houses
Apartments for rent in Ventabren and Ventabren France rental homes
Homes for rent in Chitenay France, Chitenay France rental properties, and homes for rent in Chitenay
Apartment rentals in Pezenas, short term rentals Pezenas France, Pezenas rental houses, and Pezenas apartment rentals
Maubec France vacation rental and Maubec France house rentals
Cabrieres-d Avignon France apartment rentals, holiday rentals Cabrieres-d Avignon France, and apartments for rent in Cabrieres-d Avignon France
Rent house in Montfort-sur-Argens France, Montfort-sur-Argens France bed and breakfast rentals, rental apartment in Montfort-sur-Argens France, and rent houses in Montfort-sur-Argens
Apartment rentals in Orignolles France and Orignolles France vacation homes
Home rentals Clerac, Clerac condos for rent, and Clerac France homes for rent by owner
Palaminy France house rentals, house rentals in Palaminy, houses for rent in Palaminy France, and for rent by owner homes Palaminy
Selles-sur-cher condo rentals and vacation rentals
Vacation homes for rent by owner in Trouville, rental homes in Trouville France, and holiday rentals
Rental home in Anduze France, vacation homes Anduze, rental homes in Anduze France, and rental properties in Anduze France
Houses for rent Neuvic and rent house in Neuvic France
Apartments for rent in Chamonix-Mont-Blanc France, rental homes in Chamonix-Mont-Blanc, and homes for rent in Chamonix-Mont-Blanc France
House rentals Pommard, Pommard France short term rentals, vacation rental Pommard France, and Pommard rental houses
Homes for rent by owner in Arles and homes for rent by owner in Arles France
Vacation rentals Amboise France, Amboise France rent house, and homes for rent by owner in Amboise
Bonnieux France holiday rentals, rental houses in Bonnieux France, holiday rentals in Bonnieux France, and Bonnieux homes for rent
For rent by owner homes in Sourdeval and condos for rent in Sourdeval
Rousset France bed and breakfast rentals, Rousset France real estate rentals, and vacation rental Rousset
Identify, catch, and explore house rentals in Granville, home rentals Granville France, and Granville France rental home.
Catch startling, special, and extraordinary proof in Soreze France and numerate vacation rental in Soreze France.
You can hunt for the resort ad directories, convenient online MLS, and beachfront classifieds under vacation rentals Soreze, rent house Soreze, and apartment rentals in Soreze France.
Soreze France is a pleasing, cute, and alluring turf with grand, wonderful, nice, and ideal chalet, ranch, cottage, and duplexs.
Soreze France picture could hype and further your inquest.
At times, root for, aid, aid, and plug your excursionists, road warriors, and seafarers to a now and stunning patch.
Traveling women and entrepreneurs who are wishing to notice and observe or simply elicit information can use our for rent by owner website.
Salesmen, confidants, and possessors forage and scan this site, For Rent By Owner (FRBO.com) and discern suburban flat, lakeside chalet, and convenient houseboat.
Florence vacation rentals, vacation rentals in Florence, home rentals Florence, and vacation homes
Enroll and join on Friday to enter upon, get cracking, take up, and tear into on this vagabondage.
Find and notice Noisy-le-Grand France home rentals and rental houses in Noisy-le-Grand.
Detect, learn, and debunk rental apartment Saint-Germain-en-Laye, Saint-Germain-en-Laye France rent houses, and Saint-Germain-en-Laye homes for rent.
Soreze real estate brokers and rental agents list Soreze France bed and breakfast rentals and bed and breakfast rentals Soreze.
Originate, ascertain, and devise Cognac France homes for rent, Cognac short term rentals, and rent houses in Cognac.
Hear, uncover, and hear Arcachon vacation rental, Arcachon condos for rent, and home rentals.
|
|
