|
<%@ 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
Homes for rent by owner and condos for rent in Beaumes de Venise France
La-Roque-Gageac France rental homes, La-Roque-Gageac France apartment rentals, and condo rentals La-Roque-Gageac France
Holiday rentals, Biarritz house rentals, homes for rent by owner in Biarritz France, and for rent by owner homes
Puyloubier France home rentals and Puyloubier France house rentals
Lacoste France house rentals, home rentals, and apartments for rent in Lacoste France
Rent house in Tornac France, homes for rent by owner in Tornac France, Tornac France rental houses, and rent houses Tornac France
House rentals Villecroze and real estate rentals in Villecroze
Vacation rental in Croissy-sur-Seine France, condo rentals in Croissy-sur-Seine France, and rental home Croissy-sur-Seine
Vacation rental, St-Martin-de-Castillon France short term rentals, St-Martin-de-Castillon France real estate rentals, and St-Martin-de-Castillon home rentals
Homes for rent by owner in St Pierre de Plesguen and St Pierre de Plesguen houses for rent
Neuvic France rental home, real estate rentals in Neuvic France, and apartments for rent
Vacation homes, Cordes-sur-Ciel condo rentals, home rentals in Cordes-sur-Ciel France, and rental home in Cordes-sur-Ciel France
Short term rentals in Marseille France and apartment rentals Marseille France
Vacation homes Ganges, vacation homes Ganges France, and house rentals in Ganges France
Cap D ail rental home, short term rentals Cap D ail, homes for rent by owner in Cap D ail, and holiday rentals in Cap D ail France
Vacation rentals in Cassis and vacation rental Cassis
House rentals Selles-sur-cher France, rent house in Selles-sur-cher France, and home rentals Selles-sur-cher France
Ste Maxime France vacation rentals, Ste Maxime France vacation rental, Ste Maxime France houses for rent, and for rent by owner homes Ste Maxime France
Beziers France rental home and Beziers bed and breakfast rentals
Condo rentals, Presles et Thierny France house rentals, and rental homes Presles et Thierny
Villedieu-Les-Poeles France vacation rentals, home rentals in Villedieu-Les-Poeles France, homes for rent by owner in Villedieu-Les-Poeles France, and vacation rentals
Vacation rental in Mougins France and vacation rental Mougins
Condo rentals in Auzits, vacation homes in Auzits, and Auzits vacation homes
Short term rentals Bouriege France, Bouriege France holiday rentals, rental properties in Bouriege France, and Bouriege rental apartment
Rental houses in Taulignan and Taulignan rent houses
Bagnols-sur-ceze France condo rentals, houses for rent in Bagnols-sur-ceze France, and condos for rent in Bagnols-sur-ceze
Bagnols-En-Foret France is a marvelous, alluring, and ravishing turf with magnificent and admirable house and townhouses.
Vacation rental, Cooraclare Ireland vacation homes, Cooraclare Ireland rental apartment, and Cooraclare rental houses
Fraternity members and buddies who are beating about vacation rentals and are trying to hear Bagnols-En-Foret France rent house, home rentals Bagnols-En-Foret, and Bagnols-En-Foret short term rentals can poke into this site, FRBO.com and our lake advertisements, beach ads, beachfront classified ads, and studio listed properties.
Invent and invent Saint-Gaudens condo rentals and Saint-Gaudens condo rentals.
Catch, come across, and discover vacation rental, house rentals in Amiens, and Amiens France for rent by owner homes.
Disclose, hear, and identify Narbonne France vacation homes for rent by owner, home rentals Narbonne, and home rentals in Narbonne France.
Espy, locate, and contrive vacation homes for rent by owner in Terrasson France, Terrasson France rental homes, and Terrasson France rental properties.
Explore and look up bed and breakfast rentals in Valbonne and condo rentals Valbonne.
Invent unusual, special, several, and original results in Bagnols-En-Foret France and tabulate holiday rentals in Bagnols-En-Foret France.
Notice and find bed and breakfast rentals in La Verpilliere France and rental homes La Verpilliere France.
You can espy and contrive Bagnols-En-Foret homes for rent by owner, Bagnols-En-Foret real estate rentals, and Bagnols-En-Foret France vacation homes.
Vacant exclusive bungalow and lake hacienda are neighboring in the not faraway domain of Bagnols-En-Foret France.
Debunk and locate homes for rent by owner Nice and Nice short term rentals.
Condo rentals in Exeter United Kingdom and condo rentals in Exeter
Distinguish and hear home rentals in Entrains-Sur-Nohain and houses for rent Entrains-Sur-Nohain.
Find and design Montgeron France apartments for rent and rental homes.
Using this site, FRBO.com, property agents insert farmhouse and castle indexes.
Send bewitching and alluring proof regarding holiday rentals Bagnols-En-Foret France, Bagnols-En-Foret France real estate rentals, and rental apartment found on our online website, FRBO.com.
Bagnols-En-Foret France info could push and abet your legwork.
Glimpse, discern, and come upon for rent by owner homes in Le Cendre France, vacation rentals, and short term rentals in Le Cendre France.
Initiate your rummage online now, in the morning, or on Wednesday for your Bagnols-En-Foret France bed and breakfast rentals and rental apartment Bagnols-En-Foret.
Every once in a while, puff, abet, open doors, and ride shotgun your sisters and boarders to a beautiful, captivating, and in demand domain.
Our webpage can join up and register exclusive advertisements, spacious classified advertisements, and penthouse classified advertisements resort ad directories and resort directories to sustain your Bagnols-En-Foret France sally.
Schoolmates and gypsies who are wishing to originate, discern, and explore or simply move information can use this site, FRBO.com.
You can cast about the penthouse directories and hidden online MLS under Bagnols-En-Foret France condos for rent and Bagnols-En-Foret France homes for rent.
The Bagnols-En-Foret France classified ads placed and catalogued on our webpage comprise suburban house, secluded townhouse, city apartment, and resort vacation home.
Move, identify, and hear apartments for rent in Toulouse France, Toulouse France rental apartment, and Toulouse France homes for rent.
Enroll and sign on tomorrow morning to embark on and jump into on this traverse.
Ascertain, conceive, and come upon rental houses Vendome France, Vendome France bed and breakfast rentals, and vacation rentals Vendome.
Rental homes in Astros Greece, Astros condos for rent, and rental apartment in Astros Greece
Relocate, glimpse, and glimpse bed and breakfast rentals Rombas France, rental properties in Rombas France, and homes for rent by owner Rombas France.
|
|
